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(10873224,8630627,8630628,8630629,8630630,8630631,8630633,8630635,8630636,8630642,10861441,10861442,10861443,10861444,10861747,10861748,10861749,3229108,3229110,3229182,8631856,8631857,10863054,8632498,8629929,8629930,8630134,8630139,8630142,8630143,8630144,8630145,8630146,8630166,8630167,8630168,8630169,10447545,8630420,7067801,10861117,10861118,10861119,10861120,10861121,10861122,10861123,10861124,10861125,10861126,10861127,10861128,10861129,10861130,10861131,10861132,10861133,10861134,10861135,10861136,10861137,10861138,10861139,10861140,10861141,10861142,10861143,10861144,10861145,10861146,10861147,10861148,10861149,10861150,10861151,10861152,10861153,10861172,10861174,10861175,10861177,10861178,10861189,7201253,10866362,7201354,7201368,8627822,10866611,10866613,8595056,7201844,10866922,10866923,10866924,10866925,10866927,10866928,10859258,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,8628787,5654537,5654577,5654578,5654579,5654581,10859569,10857447,10857451,10958987,10958988,10958989,10857624,10857627,10857629,10857635,10857649,7200607,7200608,10857655,10857656,8910466,10857804,10857806,10857824,10857826,8910599,10857830,10857831,8627237,8910650,8627238,8627242,8627243,8627251,8627252,8627310,8627312,7201080,8627530,8627531,8627532,8627533,8627534,8627535,8627536,8627537,8627538,8627539,8627540,8627541,8627542,8627543,8627544,8627545,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,8627554,8627555,10866198,8627556,8627557,8627558,8627559,8627560,8627561,8627562,8627563,8627564,8627565,8627566,8627567,8627568,8627569,8627570,8627571,8627572,8627573,7198391,7198409,7198410,7198411,7198412,7198413,7198414,7198415,7198416,7198417,7198418,7198419,7198457,7198462,7198465,7198694,10864068,7199061,7199569,7199571,10101493,11048437,7200030,10618179,10855122,10855123,8634652,10852369,8634740,8634745,8634756,8541668,10622267,10622405,10622408,10617448,10850419,10850420,10850421,10850422,8632833,8633184,10851039,10426253,10426254,10616644,10614243,10614260,10614261,10614262,10614263,6669819,6669820,6669821,10614377,10611476,10611477,10614518,10614548,10614552,10614553,10614554,10614725,10611830,10611831,10611832,10611833,10611834,10611835,10611856,10611925,10611944,10611952,10611969,10611970,10612002,10612191,10612192,10612198,10612201,8851584,7058247,8566613,8862672,8851990,10612935,10613024,10613025,10613107,10613109,8852376,10613337,10610917,10610918,10610919,10610958,10117679,6673692,6673718,6673719,9912208,9912209,9912521,9912711,9912712,9912966,9913361,9168366,9168367,10419307,10419370,10417398,10417399,10417400,10417401,10417402,10417406,10417424,10417443,10417444,10417445,10419494,10417535,10415585,10415604,10415605,10415606,10415607,6672903,9168721,6673017,6673019,6673025,6673035,6673036,10419802,10419803,10419804,10419805,10419806,10418806,10419807,10418807,10419808,10418808,10419809,10418809,10418810,10417811,10418811,10417812,10418812,10418813,10418814,10417814,10418815,10418816,10417816,10418817,10417818,10418818,10418819,10417820,10418820,10418821,10417822,10418822,10418823,10417824,10418824,10418825,10417826,10418826,10418827,10417828,10418828,10418829,10418830,10417830,10418831,10417832,10418832,10418833,10417834,10418834,10418835,10418836,10417837,10418837,10418838,10417839,10418839,10418840,10417841,10418841,10418842,10417843,10418843,10418844,10417845,10418845,10418846,10418847,10417847,10418848,10418849,10417849,10418850,10417850,10418851,10417852,10418852,10418853,10417854,10418854,10418855,10417856,10418856,10418857,10417858,10418858,10418859,10417860,10418860,10418861,10418862,10417862,10418863,10417864,10417866,10417868,10417870,10417872,10417874,6673159,10417876,10417878,10417881,10417883,10417885,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,8550018,10469502,10468413,10468414,10468420,10893804,10628321,10884631,10884697,10884698,10889997,10632010,10632012,10632013,10632014,10632018,10632300,10632301,10632302,10627321,10888067,10888382,10883406,10900846,10881491,10887096,10887097,10887120,10887121,10887122,10887123,10887124,10887132,10887250,10601969,10601985,10601997,10602036,10602058,10602243,10585350,10582561,10579878,10579879,10601799,10601805,10601910,10521873,10522594,10522595,10507632,10423923,10423924,10423925,10507887,10507888,10507889,10413460,10413461,10407778,10407779,10407780,10407781,10414007,10408157,10412174,10412237,10412238,10412239,10412240,10412241,10412242,10412243,10412244,10412245,10412246,10412247,10412248,10410323,10410324,10410325,10410326,10410327,10410328,10412394,10412395,10412396,10412397,10412398,10412399,10412409,10412410,10412411,10412412,10412413,10412414,10412415,10412416,10412417,10412418,10412419,10412420,10412421,10412423,10412433,10412447,10412448,10412449,10412450,10412451,10412452,10412453,10412454,10412455,10412456,10412457,10412458,10412459,10412460,10412461,10412462,10412463,10412464,10412465,10412466,10412469,10414686,10414687,10414688,10414714,10414733,10414770,10414771,10408894,10415121,10415122,10415123,10415124,10415125,10415126,10415127,10415128,10415129,10415130,10415131,10415132,10415133,10415134,10415135,10415136,10415137,10415138,10415139,10415140,10415141,10415142,10415143,10415144,10415145,10415146,10415147,10415148,10415149,10415150,10415151,10415152,10415153,10415157,10415158,10415159,10415160) 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'