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(7075914,10939935,4970736,8569636,10963508,10963509,10963510,10963511,10963512,10963513,10963514,10963515,10963516,10963517,10963518,10963524,10963525,7065981,10963735,7074558,10964361,10964362,7066787,7066909,10987640,10987641,10987642,10987643,10987644,10987645,10987646,10987647,10987648,10987649,10987650,10987651,10987652,10987653,10987654,10987655,10987656,10987657,10987658,10987659,10987660,10987661,10987662,10987663,10987664,10987665,10987666,10987667,10987668,10987669,10987670,10987671,10987672,10987673,10987674,10987675,10987676,10987677,10987678,10987679,10987680,10987681,10987682,10987683,10987684,10987685,10987686,10987687,10987688,10987689,10987690,10987691,10987692,10987693,10987694,10987695,10987696,10987697,10987698,10987699,10987700,10987701,10987702,10987703,10987704,10987705,10987706,10987707,10987708,10987709,10987710,10987711,10987712,10987713,10987714,10987715,10987716,10987717,10987718,10987719,10987720,10987721,10987722,10987723,10987724,10987725,10987726,10987727,10987728,10987729,10987730,10987731,10987732,10987733,10987734,10987735,10987736,10987737,10987738,10987739,10987740,10987741,10987742,10987743,10987744,10987745,10987746,10987747,10987748,10987749,10987750,10987751,10987752,10987753,10987754,10987755,10987756,10987757,10987758,10987759,10987760,10987761,10987762,10987763,10987764,10987765,10987766,10987767,10987768,10987769,10987770,10987771,10987772,10987773,10987774,10987775,10987776,10987777,10987778,10987779,10987780,10987781,10987782,10987783,10987784,10987785,10987786,10987787,10987788,10987789,10987790,10987791,10987792,10987793,10987794,10987795,10987796,10987797,10987798,10987799,10987800,10987801,10987802,10987803,10987804,10987805,10987806,10987807,10987808,10987809,10987810,10987811,10987812,10987813,10987814,10987815,10987816,10987817,10987818,10987819,10987820,10987821,10987822,10987823,10987824,10987825,10987826,10987827,10987828,10987829,10962058,7075490,10962235,7067563,7075597,7067724,10939465,10962436,7072231,10986681,10958633,10997841,10997842,10997843,10997844,10997845,10997867,10997868,10998385,11011437,10944495,7069409,7069410,7069411,7069412,7069413,7069421,7069422,10941321,10941322,10941323,10941324,10941325,10941326,10941327,10941339,10941340,10941342,10941343,10941344,10941345,10941346,10941347,10941348,10941349,10941350,10941351,7070075,7070076,7070077,7070078,7070079,7070080,7070081,7070082,7070083,7070084,7070085,7070086,7070087,7070088,7070089,7070090,7070091,7070092,7070093,7070095,7070096,7070097,7070098,7070099,7070100,7070101,7070102,7070103,7070104,7070105,11010364,11010365,11010366,11010367,11010368,10954510,10618265,10618271,10967901,11006902,11006925,10623658,10968506,10968507,10968508,10968509,10968510,10968511,10968512,10968513,10968514,10968515,10968516,10968517,10968518,10968519,10968520,10968521,10968522,10968523,10968524,10968525,10968526,10968527,10968528,10968529,10968530,10968531,10968532,10968533,10968534,10968535,10968536,10968537,10968538,10968539,10619889,10617107,10922625,10922626,10922627,10922628,10622190,10622191,10622192,10622193,10622194,10622195,10622197,10617211,10622217,10622224,10622225,10928002,10928003,10928004,10915517,10915564,10915632,10915727,8570446,10916176,8570524,10916307,10916308,10916327,10916437,10916498,10916545,10930884,10916639,10916723,10917382,10565187,10565188,10562270,10562271,10562272,10562273,10562274,10562275,10562276,10562277,10559314,10559315,10565319,9173555,7059724,7059725,7059726,7059727,10611680,10611681,6666016,6666017,6666025,6666043,6666044,6666045,6666046,6666047,6666048,6666049,6666050,6666051,6666059,6666078,6666079,6666081,6666083,6666155,6666203,6666204,6666205,6666207,6666208,6666210,6666211,6666212,6666213,6666214,6666215,6666222,6666223,10563347,10563348,10609344,10609345,7057855,10557617,10557863,10557864,10609714,10609782,10613034,7058840,7058841,10613520,10613521,9172892,9172893,9172894,9172895,9172896,9172897,9172898,9172899,9172900,9172914,10564864,10610842,10515132,10513406,10515420,10515633,10515634,10515635,10515636,10515637,10515638,10515639,10515640,10515641,10515642,10515643,4974756,4974757,4974758,10513952,10513961,10513994,10513997,10513998,10513999,10514028,10514031,10514032,10514033,4975226,10518606,10518607,10518608,10518609,10518610,10518611,10512636,10512637,10512638,10512639,10512640,10512641,10512642,10512643,10512644,10512645,10512646,10512647,10512648,10512649,10512650,10512651,10512652,10512653,10512654,10512655,10512656,10512657,10512658,10512659,10512660,7057160,7057161,10512903,10516964,10516965,10516966,10516967,10516968,10516969,10516970,10516971,10516972,10516973,10516974,10516975,10516976,10516977,10516978,10516979,10516980,10516981,10516982,10516983,10516984,10516985,10516986,9184299,9184300,9184301,9184302,9184303,9184304,9184305,9184306,9184307,9184308,9184309,9184310,9184311,9184312,9184313,9184314,9184315,9184316,9184317,9184318,9184319,9184320,9184321,9184322,9184323,9184324,9184325,9184326,9184327,9184328,9184329,9184330,9184331,9184332,9184333,9184334,9184335,9184336,9184337,9184338,9184339,9184340,9184343,9184344,9184345,9184346,9184347,9184348,9184349,9184350,9184351,9184352,9184353,9184354,9184355,9184356,9184357,9184358,9184359,9184360,9184361,9184362,9184363,9184364,9184365,9184366,9184367,9184368,9184369,9184370,9184371,9184372,9184373,9184374,10419297,9184375,9184376,9184377,9184378,9184379,9184380,9184381,9176395,4973425,6666512,6666687,6666755,8916871,6667299,8917091,6667606,6667607,6667608,6667609,6667610,6667611,6667612,6667613,6667614,6667615,6667616,6667617,6667618,6667619,6667620,6667621,6667622,6667623,6667624,6667625,6667626,6667628,6667629,6667630,6667631,6667632,6667633,6667640,6667641,6667642,6667643,6667644,6667645,8563547,6667648,6667649,6667650,6667777,6667778,6667779,6667780,6667781,6667782,6668242,6668243,6668244,6668245,6668246,10630140,10630163,10630164,10630165,10630166,10630167,10630284,10630285,10630286,10630287,10625641,10626199,10626200,10626201,10626202,10626203,10631247,10631248,10631249,10631623,10631624,10631844,10631845,10631846,10626952,10568554,10568558,10580664,10580665,10580666,10567647,10567648,10567649,10521150,10527407,10527408,10527409,10525568,10521914,10521915,10528069,10522196,10522197,10522198,10522199,10522200,10522201,10522202,10522203,10522204,10522205,10528616,10528693,10528694,10528695,10528696,10528697,10528698,10528699,10528700,10528701,10528702,10528703,10528704,10528705,10528706,10528707,10528708,10528709,10528710,10528711,10528712,10528713,10528714,10528715,10528716,10528717,10528718,10528719,10528720,10528721,10528722,10528723,10528724,10528725,10528726,10528727,10528728,10528729,10528730,10528731,10528732,10528733,10528734,10528735,10528736,10528737,10528738,10528739,10528740,10528741,10528742,10528743,10528744,10528745,10528746,10528747,10528748,10528749,10528750,10528751,10528752,10528753,10528754,10528755,10528756,10528757,10528758,10528759,10528760,10528761,10528762,10528763,10528764,10528765,10528766,10528767,10528768,10528769,10528770,10528771,10528772,10528773,10528774,10528775,10528776,10528777,10528778,10528779,10528780,10528781,10528782,10528783,10528784,10528785,10528786,10528787,10528788,10528793,10528794,10528795,10528796,10528797,10528798,10528799,10528800,10528801,10528802,10528803,10528804,10528805,10528806,10528807,10528808,10528809,10528810,10528811,10520811,10528812,10528813,10528814,10528815,10520815,10528816,10528817,10520817,10528818,10528819,10528820,10528821,10528822,10528823,10528824,10528825,10528826,10528827,10528828,10528829,10528830,10528831,10528832,10528833,10528834,10528835,10528836,10528837,10528838,10528839,10528840,10528841,10528842,10528843,10528844,10528845,10528846,10528847,10528848,10528849,10528850,10528851,10528852,10528853,10528854,10528855,10528856,10528857,10528858,10528859,10528860,10528861,10528862,10528863,10528864,10528865,10528866,10528867,10528868,10528869,10528870,10524870,10528871,10524871,10528872,10524872,10528873,10524873,10528874,10524874,10528875,10524875,10528876,10524876,10528877,10524877,10528878,10524878,10528879,10524879,10528880,10524880,10528881,10524881,10528882,10524882,10528883,10524883,10528884,10524884,10524885,10524886,10524887,10524888,10524889,10528890,10524890,10528891,10524891,10528892,10524892,10528893,10528894,10528895,10528896,10528897,10528898,10528899,10528900,10528901,10520901,10528902,10528903,10528904,10520904,10528905,10520905,10528906,10528907,10528908,10528909,10520909,10527028,10527029,10421550,10422588,10423696,10420708,10420770,10420771,10420772,10420773,10420774,10420775,10420776,10420777,10420778,10420779,10420780,10420781,10420782,10420783,10420784,10420785,10420786,10420787,10420788,10420789,10420790,10420791,10420792,10420793,10420794,10420795,10420796,10420797,10477380) 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'