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(8631018,8631022,8631023,8631026,8631044,8631067,3228994,3229095,3229096,3229097,3229098,3229103,10849024,10849025,10868261,10868262,10849324,10849325,10849326,10849327,10849328,10849367,8631868,8631870,8631872,8631890,10871554,10871781,10849801,8632210,8632363,8632376,8632377,8609755,8629644,8629769,8630091,8630096,8630101,8630105,8630156,8630157,8630158,8630159,8630160,8630161,8630162,8630163,8630164,8630165,8630166,8630167,8630168,8630169,8630435,7201355,7201356,7201357,8627775,8627776,8627777,10866439,10866440,10985948,8594993,8594994,8594995,8835862,8835878,8628058,7201682,10858891,10858896,8628291,8628295,8628296,8628301,8628307,8628320,10960363,8628330,8628331,8595379,10960497,10960498,10960499,10960500,8628517,8628518,7202360,7202361,7202362,7202363,11000060,8629108,8629109,8629110,8629111,8629112,8629113,8629117,8629118,8629119,8629121,8629122,8629123,8629124,8629125,8629126,8629127,8629128,8629129,8629130,8629131,8629132,8629133,8629134,8629135,8629136,8629137,8629138,8629139,10104666,8629189,8629190,8629191,8629193,8629194,8629195,8629196,8629197,8629198,8629199,8629200,8629201,8629204,8629208,8629209,8629210,8629211,8629212,8629213,8629214,8629215,8629216,8629217,3227102,8629460,7065890,7065891,7065892,10959112,10842299,8627348,8627356,8627363,8627382,8627389,8908197,10863450,8625083,8625085,8625094,8625096,8625098,8625100,3236297,8626064,8626065,8626068,8626465,8626466,11006720,11006721,11006722,11006723,11006724,11006725,11006726,11006727,11006728,11006729,11006730,11006731,11006732,11006733,11006734,11006735,11006736,11006737,11006738,11006739,11006740,11006741,11006742,11006743,11006744,11006745,11006746,11006747,11006748,11006749,11006750,11006751,11006752,11006753,11006754,11006755,11006756,11006757,11006758,11006759,11006760,11006761,11006762,11006763,11006764,11006765,11006766,11006767,11006768,11006769,11006770,11006771,11006772,11006773,11006774,11006775,11006776,11006777,11006778,11006779,11006780,11006781,11006782,11006783,11006784,10853387,11006785,10853388,11006786,10853389,11006787,10853390,11006788,10853391,11006789,11006790,11006791,11006792,11006793,11006794,11006795,11006796,11006797,11006798,11006799,11006800,11006801,11006802,11006803,11006804,11006805,11006806,11006807,11006808,11006809,11006810,11006811,11006812,11006813,11006814,11006815,11006816,11006817,11006818,11006819,11006820,11006821,11006822,11006823,11006824,11006825,11006826,11006827,11006828,11006829,11006830,11006831,11006832,11006833,11006834,11006835,11006836,11006837,11006838,11006839,11006840,11006841,11006842,11006843,11006844,11006845,11006846,11006847,11006848,11006849,11006850,11006851,11006852,11006853,11006854,11006855,11006856,11006857,11006858,11006859,11006860,11006861,11006862,11006863,11006864,11006865,11006866,11006867,11006868,10968263,7197052,7197053,7197054,7197055,7197056,7197068,8554867,8554879,10838691,10838692,10838693,8554887,7197234,8614163,7197627,8614235,7197678,7197679,7197703,7197704,3924979,10854972,8614533,11044623,11044690,11044691,11044692,8541520,10622523,10622524,10622525,10622526,10622527,10622528,10622529,10617803,10620036,10620037,10620038,10620039,10620040,10620041,10620042,8632701,10850480,10850481,10848064,10848065,8633217,8633233,8633575,8610852,3231439,8540585,8540586,8540587,8540648,10992075,10992076,10992077,10992078,10992079,10992080,10992081,10992082,10992083,10992084,10992085,10992086,10992087,10992088,10992089,10992090,10992091,10992092,8611253,8611255,8611256,8634170,8634303,10922207,3232292,3232293,3232339,3232340,9915548,8864215,7059863,8864330,10614790,10614815,10614816,10614817,6666247,6666248,6666249,6666250,6666251,6666252,10119601,9211520,10609204,10609316,10609724,10120368,10120380,3653404,8852059,10610001,10610002,10610003,10610004,8852302,10613154,10120775,10120776,10120800,9196605,9196869,9911539,9911540,9911541,9911542,9911543,10117612,10117615,9169448,8849379,10118085,10118086,10118087,9170134,8850033,9170828,10512968,9192480,10419419,10419420,9208577,10416991,10117403,10122699,10467146,10467147,10467148,10467149,10467150,10467151,10467152,10467153,10467154,10467155,10467156,10467157,10467158,10467159,10467160,6678816,6678817,6678818,6678819,6678820,6678821,6678822,6678823,6678824,6678825,6678826,6678827,6678828,6678829,6678830,6678831,6678832,6678833,6678834,6678835,6678836,6678837,6678838,6678839,6678840,6678841,6678842,6678843,6678844,6678845,6678846,6678847,6678848,6678849,6678850,6678851,6678852,6678853,6678854,6678855,6678856,6678857,6678858,6678859,6678860,6678861,6678862,6678863,6678864,6678865,6678866,6678867,6678868,6678869,6678870,6678871,6678872,6678873,6678874,6678875,6678876,6678877,6678878,6678879,6678880,6678881,6678882,6678883,6678884,6678885,6678886,6678887,6678888,6678889,6678890,6678891,6678892,6678893,6678894,6678895,6678896,6678897,6678898,6678899,6678900,6678901,6678902,6678903,6678904,6678905,6678906,6678907,6678908,6678909,6678910,6678911,6678912,6678913,6678914,6678915,6678916,6678917,6678918,6678919,6678920,6678921,6678922,6678923,6678924,6678925,6678926,6678927,6678928,6678929,6678930,6678931,6678932,6678933,6678934,6678935,6678936,6678937,6678938,10467476,10467627,8916767,8916768,10467998,10468013,10468037,10468061,9167510,8855366,9167591,9167592,9167593,9167594,9167595,9167596,9167597,9167598,9167599,9167600,10893498,10893513,10893526,10893527,10893528,10893529,10883691,10628402,10899877,10899902,10627779,10627789,10627885,10627896,10161742,10161748,10161749,10161750,10906013,10906014,10906015,10906016,10906017,10626125,10172793,10172794,10172795,10163098,10882340,10882341,10590230,10604610,10604611,10524497,10524833,10524843,10508281,10508282,10507507,10507508,10507509,10507510,10420858,10420859,10420860,10423021,10423105,10407357,10413419,10413422,10409543,10409544,10409545,10409546,10409547,10409548,8562841,10481568,10481677,10481748,10481749,10481750,10481751,10481752,10481753,10481754,10481807,10481808,10481836,10482023,10497453,8562185) 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'