2024-03-28 10:56:50 MySQL error:
Unknown column 'option_new' in 'order clause'

Query:



                    (
                       SELECT id,
                              ro_title,
                              ro_alias,
                              ru_title,
                              ru_alias,
                              image,
                              price,
                              price_sale,
                              category,
                              concept_id,
                              room_id,
                              views,
                              'product' as pr_type,
                              display_price,
                              stock,
                              '0' as sale

                       FROM `catalog_list` WHERE `public` = '1' AND `price_sale` > '0.00' AND `category` = '19' AND id NOT IN (SELECT catalog_id FROM catalog_options WHERE `option` = 5)
                    )
                       UNION

                    (SELECT id,
                            ro_title,
                            ro_alias,
                            ru_title,
                            ru_alias,
                            image,
                            price,
                            '0' as price_sale,
                            '0' as category,
                            concept_id,
                            room_id,
                            views,
                            'garniture' as pr_type,
                            price as display_price,
                            '1' as stock,
                            sale
                       FROM `catalog_garniture` WHERE `public` = '1' AND `sale` > '0' AND id > 10000
                    )

                     ORDER BY option_new DESC, id DESC

                    LIMIT 0, 36



                  


File: /home2/bellonam/public_html/modules/engine.php
Line: 11718