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(4970255,4970256,4970257,4970258,4970259,7075935,10943532,10943533,10943534,10943535,10943536,10943537,10943538,10943539,10943540,10943541,10943542,10198663,8569402,8569403,10198760,4970920,10198849,10944176,7068707,7068708,7068709,7068710,7068711,7068712,7068713,7068714,7068715,7068716,7068717,7068718,7068719,10199371,10199445,4968635,4968668,4968669,8067846,8067847,8067848,8067849,7075214,7075269,7075514,7075541,7075543,7067620,10197875,7075728,7067731,7067732,7067747,6000157,6000158,7064241,7064242,7064243,7064244,7064245,7064246,7064247,7064248,7064249,7064250,7064251,7064252,7064253,7064254,7064305,10931926,10931927,10931928,10931929,10931930,10931931,10931932,10931933,10931934,10931935,10931936,10931937,10931938,10931939,10931940,10931941,10931942,10931943,10931944,10931945,10931946,10931947,10931948,10931949,10931950,10931951,10931952,10931953,10931954,10931955,10931956,10931957,10931958,10931959,10931960,10195909,10932282,10932283,10932284,10932289,10196161,4967461,4967462,4967463,4967464,4967465,4967466,4967467,4967468,4967469,4967470,4967471,4967472,4967473,4967474,4967475,4967476,4967477,4967478,4967479,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967497,4967498,4967499,4967500,4967501,4967502,4967503,4967504,4967505,4967506,4967507,4967508,4967509,10196529,10196535,10932877,10932878,10932879,10932880,10932881,10932882,10932883,10932884,10932885,10932886,10932887,10932888,10932889,10932890,10932891,10932892,10932893,10932894,10932895,10932896,10932897,10932898,10932899,10932900,10932901,10932902,10932903,7065492,10222908,7070854,8861150,10207672,10943150,10207673,10207674,10943151,10207675,10207676,10207677,10207678,10207679,10943156,10207680,10207681,10207682,10207683,10207684,10207685,10207686,10207687,10207688,10207689,10207690,10207691,10207692,10207693,10207694,10207695,10207696,10207697,10207698,10207699,10207700,10207701,10207702,10207703,10207704,10207705,10207706,10207707,10207708,10207709,10207710,10207771,10207772,10207817,10194896,10194897,10194898,6000065,6000066,6000067,6000068,10944648,10944649,10944650,10944651,10944652,10944653,10944654,10944655,10944656,8072434,8072436,8072447,8072459,8859524,8859525,8072527,10941851,8073029,8073030,8073031,8073032,8073033,8073034,8073035,8860296,10942306,8860521,10193863,10193865,8860615,7070730,8860651,7070770,10942521,10942522,10623347,10623441,10618848,10618966,10618967,8070852,8070853,10204281,10619220,8070948,8070949,8070950,8070951,8070952,8070953,8070954,8070955,8070956,8070957,8070958,8070959,10217404,10217405,10217406,10217407,10624467,10624468,10205050,10927501,10927502,10927503,10927577,10927578,10923085,10923086,10923087,10620079,10620082,10213499,10213500,10213501,10213502,10213503,10213504,10213505,10213506,10213507,10213508,10213509,10213510,10213511,10213512,10213513,10213514,10213517,10213518,10213519,10213520,10213521,10213522,10213523,10926158,10926163,10926164,10926165,10926166,10926169,10926202,10926206,10615926,10921560,10921561,10921562,10921563,10921564,10921565,10921566,10921567,10921568,10921569,10921570,10921571,10921572,10921573,10921574,10921575,10921576,10921577,10921578,10921579,10921580,10921581,10921582,10921583,10201206,10930948,10926891,10926892,10926893,10927064,10927070,10188904,10188905,10188906,10188907,10188908,10188909,10188910,10188911,10188912,10188913,10188914,10188915,10922334,10188916,10922335,10188917,10922336,10188918,10922337,10188919,10922338,10188920,10922339,10188921,10922340,10188922,10922341,10188923,10188924,10922342,10922343,10188925,10922344,10188926,10922369,10922370,10922371,10922372,10922373,10922374,10922375,10922376,10922377,10922378,10922379,10922380,10922381,10922382,10922383,10922384,10922385,10922386,10922387,10922388,10922389,10922390,10922391,10922392,10922393,10922394,10922395,10922396,10922397,10922398,10922399,10922400,10922401,10922402,10922403,10922404,10922405,10922406,10922407,10922408,10922409,10922410,10922411,10922412,10922413,10922414,10922415,10922416,10922417,10922418,10922419,10922420,10922421,10922422,10922423,10922424,10922425,10922426,10922427,10922428,10922429,10614238,10559718,10559719,10559720,10559721,10559745,8864476,8864477,8864478,10559789,8861969,10560393,10560394,10560395,10560396,10560397,10560398,10560399,10560400,10560401,10560402,10560403,10560404,10560405,10560406,10560407,10560408,10560409,10560410,10560411,10560412,10560413,10560414,10560415,10560416,10560417,10560418,10560419,10560420,10560421,10560422,10560423,10560424,10560425,10560426,10560427,10560428,10560429,10560430,10560431,10560432,10560433,10612283,10560434,10560435,10560436,10560437,10560438,10560439,10560440,10560441,10560442,10560443,10560444,10560445,10560446,10560447,10560448,10560449,10560450,10560451,10560452,10560453,10560454,10560455,10560456,10560457,10560458,10560459,10560460,10560461,10560462,10560463,10560464,10560465,10560466,10560467,10560468,10563468,10560469,10563469,10560470,10563470,10560471,10563471,10560472,10563472,10560473,10560474,10560475,10560476,10560477,10560478,10560479,10560480,10560481,10560482,10560483,10560484,10560485,10560486,8862262,8862263,8862264,8862265,10612486,10612637,10612660,10612666,10612667,10612668,10612673,10612704,10612707,10612740,7058273,7058274,10612862,10612868,10612869,8862867,7058651,10561597,10561599,10561600,10561601,10561606,10561648,10561649,10561656,10561657,10561668,10561707,10561708,10561709,7056160,7056170,7056367,7056368,7056369,7056370,7056371,7056372,7056373,7056374,7056375,7056376,7056377,7056378,7056379,7056380,7056381,7056382,7056383,4975113,4975114,4975117,10516183,2809112,2809113,2809114,2809257,10516655,10516656,10516657,10516658,10516659,10516660,10516661,10516662,10512839,10512840,8861660,8861661,8861662,8861663,8861664,8861665,8861666,8861667,8861668,8861669,8861670,8861671,8861672,8861673,8861674,8861675,8861676,8861677,8861678,8861679,8861680,8861681,8861682,8861683,4973243,4973421,4973422,10418529,7054898,7054930,7054936,4973636,4973729,4973818,4973819,10419019,7055336,8864900,8864905,8864907,8864908,8864909,8864911,8864912,8864934,8864942,8864953,8864957,8864960,8864971,4971387,4971388,8916393,8916394,8916395,8916396,8916397,8916398,8916399,4971931,10469763,8916984,10470071,8917175,8917176,8917177,8917178,8917179,8917180,8917241,8917362,8917485,8917498,8917646,10466765,10466766,10466767,10466768,10466769,10466770,10466771,10466772,10154484,10154485,10154486,10154487,10154488,10154489,10154490,10154491,10154492,10154493,10154494,10154495,10154496,10154497,10154498,10154499,10154500,10154501,10154502,10154503,10154504,10154505,10154506,10154507,10154508,10154509,10154510,10154511,10154512,10154513,10154514,10154515,10154516,10154517,10154518,10154519,10154520,10154521,10154522,10154523,10154524,10154525,10154526,10154527,10154528,10154529,10154530,10154531,10154532,10154533,10154534,10154535,10154536,10154537,10154538,10154539,10154540,10154541,10154542,10154543,10154544,10154545,10154546,10154547,10154548,10154549,10154550,10154551,10154552,10154553,10154554,10154555,10154556,10154557,10154558,10154559,10154560,10154561,10154562,10154563,10154564,10154565,10154566,10154567,10154568,10154569,10154570,10154571,10154572,10154573,10154574,10154575,10628185,10628186,10628187,10628830,10629816,10629817,10632082,10632083,10627562,10627563,10627719,10154427,10154428,10154429,10154430,10154431,10154432,10154433,10154434,10154435,10154436,10154437,10154438,10154439,10154440,10154441,10154442,10154443,10154444,10154445,10154446,10154447,10154448,10154449,10154450,10154451,10154452,10154453,10154454,10154455,10154456,10154457,10154458,10154459,10154460,10154461,10154462,10154463,10154464,10154465,10154466,10154467,10154468,10154469,10154470,10154471,10154472,10154473,10154474,10154475,10154476,10154477,10154478,10154479,10154480,10154481,10154482,10154483,10630081,10630104,10630266,10626102,10626103,10626104,10631289,10626822,10631825,10631826,10571544,10571545,10571546,10571547,10568768,10566369,10566370,10569383,10569384,10569385,10569386,10569387,10569388,10569389,10569390,10569391,10569392,10569610,10569986,10569987,10569988,10569989,10567660,10567661,10570796,10570797,10570798,10570799,10570800,10570801,10567919,10567920,10567921,10567922,10567923,10567924,10567925,10567926,10567927,10567928,10567929,10567930,10567931,10567932,10567933,10567934,10567935,10567936,10522095,10522913,10522914,10522915,10522916,10522917,10522918,10522919,10421711,10421931,10421066,10472885,10472886,10472887,10472911,10472912,10473067,10473068,10473069,10473070,10473071,10473072,10473073,10473882,10473883,10473884,10473885,10473886,10473887,10473888,10473889,10473890,10473891,10472756,10472757,10472758,10472759,10472760) 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'