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(8068817,8068818,8068819,8068821,8068885,8068886,8068887,10943433,7076009,7068053,7076061,7076081,7076094,10943622,10943625,7076141,10198400,10198401,10198402,10198403,10198404,10943775,10198516,7076310,7076311,7076324,7076325,10943859,10943933,10198750,10198751,10198766,10198767,10198768,10198769,10198770,10198771,10198774,10198775,10198784,10198798,10198799,10198800,10198801,10198802,10944083,7068652,7068653,7068657,7068679,7068681,7068686,7068687,7068700,7068701,7068705,7068712,8569736,7073829,7073832,7073833,7073834,7073838,7073839,7073843,7073844,7065867,7073868,7073874,7073877,7073878,7073880,7073882,7073883,7073884,7073885,7073886,7073888,7073889,7073890,7073892,7073893,7073895,7073896,7073897,7073921,7073922,7073943,7073944,7073950,7073969,7073982,7073993,7073995,7074056,10199372,7066174,7074178,10437244,7074306,10199613,7074383,10199763,10199764,7066593,10437556,7066650,7066651,7066659,7066660,7066665,10437626,10437627,10437628,10437629,7066699,7066700,7066701,7066704,7066705,7066706,7066707,7066745,7066753,7066754,7066755,10200005,7066823,7066876,7074899,7074900,7074901,10197141,10197142,10197143,10197144,10197145,10197146,10197147,10197148,10197149,10197150,10197151,10197152,4969252,4969253,4969254,4969255,4969256,4969257,4969258,4969259,4969260,4969261,4969262,4969263,4969264,4969265,4969266,4969267,4969268,4969269,8067931,10197290,4969547,4969570,7075445,7075446,7067454,7075454,7075455,7075456,7075457,7075458,7075459,7075461,7075497,7075551,7067563,7067578,7067579,7067592,7067593,7067594,8068597,7067647,7067649,7067660,7067708,7067713,7067721,7067722,7067724,7067783,10198053,6000110,6000118,6000119,6000194,6000196,6000198,6000250,6000280,6000284,6000296,7064055,7072083,7072163,7072196,7072197,7072202,7072204,7064251,7064367,7064370,7064371,7072450,7072451,7072453,7064460,7064461,7064462,8075324,7064516,7064600,10195888,7064682,4967055,10195973,10195974,10196120,7064951,10196344,10196379,10196380,10196382,10196383,7073169,10932729,7073317,7073318,7073321,7073324,7065328,7065329,7065330,7065331,7065332,7065357,10932949,10932950,7073526,7073615,7073616,10196875,10196876,10196877,10196878,10196879,7073676,4968029,4968030,4968031,4968032,7073701,7073703,7073707,7073708,10933176,7073756,10197023,7073805,7070816,10194091,10194092,10194093,10194094,10194095,10194096,10194097,10942575,10194098,10194099,10194100,10194101,10194102,10194103,7070865,10194104,7070866,10194105,10194106,10194107,10194108,10942585,10194109,10194110,10194111,10194112,10194113,10194114,10194115,10942593,10194116,10194117,10194118,10194119,10194120,10194121,10194122,10194123,10194124,10194125,10194126,10194127,10194128,10194129,10194130,10194131,10194132,10194133,10194134,10194135,10194136,10194137,10194138,10194139,10942629,10942630,10942631,10942642,7070944,7070961,10942700,10942702,10942706,7070994,10942715,10194238,10942727,8860921,7071027,7071028,7071029,7071030,7071031,7071032,7071033,7071034,7071035,7071036,7071050,7071053,7071062,7071068,7071094,7071148,7071149,7071150,7071360,8861264,8861282,8861283,8861287,7071384,7071396,10943153,10943154,7071453,10943271,10943272,7071579,7071585,10943304,7071591,7071595,7071605,7071606,10194875,7071638,10943376,5999944,5999945,5999946,7071676,5999979,8970207,6000069,6000072,10944415,10944421,10944422,10944423,10944424,10944429,7068982,10944508,10940743,7069051,7069067,7069186,7069202,7069242,7069243,7069268,7069274,7069285,7069295,7069299,7069303,10944822,10944829,7069318,10944831,7069324,7069325,10944841,10944842,7069332,10944843,7069333,7069334,10944848,10944849,10944850,10944851,10944873,7069367,10944878,7069373,7069383,7069384,7069390,7069395,7069398,7069399,7069402,7069410,7069415,10941176,7069645,8072644,8072649,8072654,8072659,8072664,8072669,8072674,8072679,8072684,8072689,8072694,8072699,8072704,8072709,8072714,8072719,8072724,8072729,8072734,8072739,8072744,8072749,8072754,8072759,8072764,8072769,8072774,8072779,8072784,8072789,8072797,8072805,8072813,8072821,8072829,8072837,10941706,8072849,8072857,8072869,8072877,8072887,8072893,8072905,8072913,8072921,10941786,7070074,8072928,8072939,8072946,8072954,10941819,8072962,8072970,8072978,10941884,10941909,10941958,10941979,7070298,8860257,8860258,8860259,8860260,8860261,7070367,10942184,10942185,10942186,10942187,10942308,8073473,8073482,8073484,8073486,7070661,10942403,10942404,7070720,8860651,7070756,7070766,8860680,7070789,10190058,10928558,10928595,10928602,10928609,10623102,10623103,10928649,10928652,10928653,10618147,10623198,10928734,10618231,10618234,10928792,10618316,10618328,10618389,10623502,10623582,10618855,10618856,10619146,10619587,10619891,10619892,10619903,10621990,10621991,10622016,10622017,10622021,10622022,10622027,10622053,10622058,10622098,10622103,10617182,10189437,10189438,10189439,10189440,10189441,10189442,10189443,10189444,10189445,10189446,10189447,10189448,10189449,10189450,10189451,10927890,10927958,10927959,10927980,10927985,10928060,10617573,10928095,10928096,10928102,10928154,10928186,10928200,10189810,10189811,10928234,10189816,10189817,10189818,10189819,10189820,10189821,10189822,10189823,10189824,10189825,10189826,10189827,10189828,10189829,10622881,10622882,10622883,10622884,10622902,10622903,10622904,10622905,10615013,10615036,10920687,10920689,10920690,10615180,10920716,10920736,10920737,10620237,10615339,10615352,10615355,10620395,10620396,10926028,10926094,10926129,10926254,10615833,10615842,10615859,10615860,10616060,10921621,10616208,10921736,10921763,10921767,10921768,10926800,10926801,10926802,10926803,10926804,10926805,10926806,10926807,10926818,10926819,10926820,10926821,10921879,10921880,10921904,10921923,10921965,10921973,10621510,10621535,10621536,10922064,10927078,10927079,10616572,10616704,10927437,10922456,10922457,10922458,10922459,10565129,10565130,10565171,10559201,10559202,10559203,10559210,10559316,10559317,10565329,10565330,10562413,10562414,10614272,10614279,10614282,10614283,10559466,10559477,10559478,10614383,10559565,10559566,10559567,10559568,10559569,10559570,10559571,10559572,10559573,10559574,10559575,10559576,10559577,10559578,10559579,10559580,10559581,10559582,10559583,10559584,10559585,10559594,10559595,10559596,10559597,10559598,10559599,10559600,10559601,10559603,10559604,10559605,10559606,10559607,10559608,10559609,10559731,10559732,10559733,10559734,10559735,10559736,10559737,10614821,10614822,10566100,10566101,10611968,10612037,10612086,10563450,10563452,10563453,10563454,10563457,10563459,10563460,10563461,10563462,10563463,10563464,10563465,10563466,10563467,10612344,10563542,10557969,10612961,10613119,10558442,10558443,10558444,10558445,10558446,10558447,10558448,10558449,10558452,10558459,10558460,10558461,10558462,10558463,10558464,10558465,10558478,10558479,10558480,10558481,10558482,10558483,10558484,10558485,10558486,10558487,10558488,10558489,10558490,10558491,10558492,10558493,10558494,10558495,10558496,10613356,10613357,10561523,10561524,10558540,10558578,10558580,10558581,10558582,10613440,10613442,10558592,10613778,10613779,10613780,10564991,10564995,10517287,10517288,10513403,10517552,10517650,10517651,10517652,10517653,10517656,10517660,10517661,10517662,10517663,10517664,10517665,10517666,10517667,10517668,10515726,10515765,10515766,10515767,10515776,10515777,10515778,10515779,10515780,10515837,10515838,10515839,10515840,10515844,10515845,10515846,10515847,10515848,10515849,10515850,10515851,10515852,10515853,10515854,10515855,10515856,10515857,10515858,10515859,10515860,10515861,10515862,10515863,10515864,10515865,10515866,10515867,10515868,10515869,10515870,10515871,10515872,10515873,10515874,10515875,10515876,10515877,10515878,10515879,10515880,10515881,10515882,10515883,10515884,10515885,10515886,10515887,10515888,10515889,10515890,10515891,10515892,10515893,10515894,10515895,10515896,10515897,10515898,10515899,10515900,10513900,10515901,10513901,10515902,10513902,10515903,10515904,10515905,10515906,10515909,10515910,10515911,10515912,10515913,10515914,10515915,10515916,10515917,10513977,10513978,10513979,10514041,10516056,10516057,10516062,10516063,10516064,10516067,10516069,10512582,10513043,10513044,10513045,10417286,10416302,10417396,10417397,10417429,10417430,10416444,10416445,10416446,10416448,10416453,10416466,10416467,10416468,10416485,10416495,10417502,10417503,10417504,10418533,10418543,10416648,10416671,10417805,10418905,10418915,10416932,10467075,10467076,10471229,10471460,10469488,10465713,10465714,10465715,10465716,10465717,10465718,10465719,10465720,10465721,10465722,10465723,10465724,10465725,10465726,10465727,10465728,10465729,10469855,10467890,10467957,10467958,10467959,10468114,10468184,10468198) 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'