QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(10871775,10871776,10871777,10871778,10871779,10871780,10871781,7201366,7201367,5654644,10855245,10856221,10864538,10864539,10864540,10864541,10864542,10864543,10864544,10864545,10864546,10864547,10864548,10864549,10864550,10864551,10864552,10864553,10864554,10864555,10864556,10864557,10864558,10864559,10864560,10864561,10864562,10864563,10864564,10864565,10864566,10864567,10864568,10864569,10864570,10864571,10864572,10864573,10864574,10864575,10864576,10864577,10864578,10864579,10864580,10864581,10864582,10864583,10864584,10864585,10864586,10864618,10864619,10864620,10864621,10864622,10864623,10864624,10864625,10864626,10864627,10864638,10864639,10864721,10864722,10864723,10864724,10864725,10864726,10864727,10864728,8554376,10611013,10611014,10611015,7017443,7017444,7017449,7017450,7017455,7017456,7017461,7017462,7017467,7017468,7017473,7017474,7017479,7017480,7017485,7017486,7017491,7017492,7017497,7017498,7017503,7017504,7017509,7017510,10117619,9912308,10118625,7016164,7013953,7013954,7013959,7013960,9168753,10417850,10417851,10417852,10417853,10417854,10417855,10417856,10417857,10417858,10417859,10417860,10417861,10417862,10417863,10417864,10417865,10417866,10417867,10417868,10417869,10417870,10417871,10417872,10417873,10417874,10417875,10417876,10417877,10417878,10417879,10417880,10417881,10417882,10417883,10417884,10417885,10417886,10417887,10417888,10417889,10417890,10417891,10417892,10417893,10417894,10417895,10417896,10417897,10417898,10417899,10417900,10417901,10417929,10417930,10417931,10417932,10417933,10417934,10417935,10417936,10417945,10117334,976411,7013881,7013882,7013887,7013888,7013893,7013894,7013899,7013900,7013905,7013906,7013911,7013912,7013917,7013918,7013923,7013924,7013929,7013930,7013935,7013936,7013941,7013942,7013947,7013948,10890078,10890079,10882420,10591755,10591763,10591765,10591766,10591767,10591768,10591769,10591772,10591780,10591781,10591782,10591783,10591800,10591802,10529335,10541447,10541448,10508228,10508229,10508230,10508231,10507929,10423100,10423101,10423102,10423103,10423104,10423105,10411312,10410430) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'