2024-03-29 07:55:33 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` = '37' 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