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(7076279,4970903,7068727,4970946,4970947,7068742,7068751,4970971,4970980,7068771,4970988,7068783,8569772,7068810,7068811,10940440,7068819,7068877,7068900,7068910,7068915,7068916,7068919,7074043,10976767,10990267,11001152,10962158,10962159,10962160,10962161,10962166,10962498,11014570,10972810,11012253,10960281,10960282,10960283,10960285,7072611,7072671,7072713,7072761,10986511,10986513,7072906,7073016,7073039,7073049,7073069,7073070,7073099,7073110,7073328,7073674,11013475,10984774,10984775,10984845,10984846,7071175,7071176,7071707,10943368,7071779,7071780,10943409,10970005,10970006,10970179,3656271,10941327,10941333,10941348,10970635,10970722,10970723,10970724,7070083,7070084,7070087,7070089,7070101,10941734,10941735,10941736,10941737,10941738,10941739,10941740,10941741,10941742,10941743,10941744,10941745,10941746,10941747,10941748,10941749,10941750,10941751,10941752,10941753,10941754,10941755,10941756,10941757,10941758,10941759,10941760,10941761,10941762,10941763,10941764,10941765,10941766,10941767,10941768,10941769,10941770,10941771,10941772,10941773,10941774,10941775,10941776,10941777,10941778,10941779,10941780,10941781,10941782,10941783,10970933,10941903,10971037,10971334,10971358,7070690,10971409,10971410,7070757,7070758,7070759,7070760,7070761,10942440,10942463,10942486,11019684,11019685,10618098,10928623,10928624,10918665,10918705,10967877,10967878,10918743,10618299,10618300,10618301,10618302,10618304,10918901,10918902,10994336,11007398,10968549,10968550,10968551,10968645,10968680,10968681,10968799,10968800,10969163,10617088,11018949,11006103,10993161,10993162,10993163,10993308,10920565,8570016,10920690,11016919,11016920,11016921,11016922,11016923,10620320,10615379,10615380,10920920,11004118,10615830,10965544,10965545,10930827,10921422,10921502,10921503,10921522,10921549,10921550,10921625,10921701,10991861,10991862,10991863,10991864,10991865,10991866,10991867,10991868,10991869,10991870,10991871,10991872,10991873,10991874,10991875,10991876,10991877,10991878,10991879,10991880,10991881,10991882,10991883,10991884,10991885,10991886,10991887,10991888,10991889,10991890,10991891,10991892,10991894,10991895,10991896,10991897,10991898,10991899,10991900,10991901,10991902,10991903,10991904,10991905,10991906,10991907,10991908,10991909,10991910,10991911,10991912,10991913,10991914,10991915,10991916,10991917,10991918,10991919,10991920,10991921,10991922,10991923,10991924,10991925,10991926,10991927,10991928,10991929,10991930,10991931,10991932,10991933,10991934,10991935,10991936,10991937,10991938,10991939,10991940,10991941,10991942,10991943,10991944,10991945,10991946,10991947,10991948,10991949,10991950,10991951,10991952,10991953,10991954,10991955,10991956,10991957,10991958,10991959,10991960,10991961,10991962,10991963,10991964,10991965,10991966,10991967,10991968,10991969,10991970,10991971,10991972,10991973,10991974,10991975,10991976,10991977,10991978,10991979,10991980,10991981,10991982,10991983,10991984,10991985,10991986,10991987,10991988,10991989,10991990,10991991,10991992,10991993,10991994,10991995,10991996,10991997,10991998,10991999,10992000,10992001,10992002,10992003,10992004,10992005,10992006,10616476,10922033,10992192,10992211,10992212,10992213,10992214,10917129,7059641,10559334,7059740,8864205,10559585,9189918,9189919,9190013,9190014,10611784,10562945,10562946,10560003,10560004,9190194,9182195,8861861,10557350,10557487,10557523,10557563,10557564,10557565,9187808,10560793,10560794,10560795,7058308,10560968,10560969,10557971,10557978,9172275,9172278,9172281,10613080,7058752,10561612,10561631,10561666,10561667,10561674,10561701,10561742,10515178,10515206,10515207,10515208,10515209,10515210,10515233,10515234,10515241,9169460,10555502,10555503,10555504,10555505,10555506,10555507,10555508,10555509,10555510,10555511,10555512,9169699,10555513,10555514,10555515,10555516,10555517,10555518,10555519,10555520,10555521,10555522,10555523,10555524,10555525,9185792,9185793,9185795,9185796,9185797,9185798,9185799,9185800,9185801,9185802,9185803,9185804,9185805,9185806,9185807,9185808,9185809,9185810,9185811,9185812,9185813,9185814,9185815,9185816,9185817,9185818,9185819,9185820,9185821,9185822,9185823,9185824,9185825,9185826,9185827,9185828,9185829,9185830,9185831,9185832,9185833,9185834,9185835,9185836,9185837,9185838,9185839,9185840,9185841,9185842,9185843,9185844,9185845,9185846,9185847,9185848,9185849,9185850,9185851,9185852,9185853,9185854,9185855,9185856,9185857,9185858,9185859,9185860,9185861,9185862,9185863,9185864,9185865,9185866,9185867,9185868,9185869,9185870,9185871,9185872,9185873,9185874,9185875,9185876,9185877,9185878,9185879,9185880,9185881,9185882,9185883,9185884,9185885,9185886,9185887,9185888,9185889,9185890,9185891,9185892,9185893,9185894,9185895,9185896,9185897,9185898,9185899,9185900,9185901,9185902,9185903,9185904,9185905,9185906,9185907,9185908,9185909,9185910,9185911,9185912,9185913,9185914,9185915,9185916,9185917,9185918,9185919,9185920,9185921,9185922,9185923,9169923,9185924,9185925,9185926,9185927,9185928,9185929,9185930,9185931,9185932,9185933,9185934,9185935,9185936,9185937,9185938,9185939,9185940,9185941,9185942,9185943,9185944,9185945,9185946,9185947,9185948,10516066,10556238,10556308,10556309,10556310,10556311,10556312,10556313,10556314,10556315,10556316,10556317,10556318,10556319,10556320,10556321,10556452,10556453,10556454,10556455,10556456,10556457,10556458,10556459,10516482,10516483,10512491,10512492,10512493,10512494,10556542,10556543,10556544,10556545,10556546,10556547,10556548,10556549,10556550,10556551,10556552,10556553,10556554,10556555,10556556,10556557,10556558,10556559,10556560,10556561,10514621,10514646,10556711,10556712,10556713,10556714,10556715,10556716,10556717,10556718,10556719,10556720,10556721,10556722,10556723,10556724,10556725,10556726,10556727,10556728,10556729,10556730,10556731,10556732,10556733,10556734,10556735,10556736,10556737,10556738,10556739,10556740,10512793,10512819,10556927,10516965,10516997,9171191,10557063,10557064,10557065,10557066,10557067,10557068,9171255,10557069,10557070,10557071,10557072,9171286,9160324,4973236,4973237,4973238,4973239,4973240,9176410,9176411,9176412,9176413,10416599,7054872,9176712,4973721,4973724,4973725,4973728,4973763,6666591,10467339,6666834,9174893,10463730,10463731,10463732,10463733,10463734,6667156,10463735,10463736,10463737,10463738,6667160,10463739,10463740,9167449,8917100,10468112,10468115,9175782,9175946,10164536,10628016,10628017,10164784,10165059,10165060,10165061,10165349,10165557,10165558,10165697,10165698,10165861,10165862,10165863,10165864,10629535,10629682,10629683,10629684,10629725,10629726,10629759,10629760,10166310,10629795,10629796,10629797,10166443,10166444,10629928,10164239,10164240,10627740,10166562,10166905,10167089,10167245,10167644,10626196,10626225,10626226,10626227,10626228,10626229,10626230,10626231,10626232,10626233,10626234,10626235,10626236,10626237,10626238,10626239,10626240,10626241,10626242,10626243,10626244,10626245,10626246,10626247,10626248,10631398,10577112,10577221,10571449,10571450,10571451,10571452,10571453,10571454,10571455,10571456,10577476,10577477,10577478,10577479,10577480,10577481,10577482,10577483,10577484,10577485,10577486,10577487,10577488,10577489,10577490,10577491,10577492,10577493,10568667,10568906,10577906,10577907,10577908,10577909,10577910,10568938,10568939,10568981,10578084,10578085,10578258,10578259,10578260,10578261,10578262,10578395,10575450,10569554,10575562,10578695,10578696,10578697,10578882,10578883,10578884,10578885,10578886,10578887,10578888,10578889,10578890,10578891,10578892,10576196,10576197,10570298,10576319,10576320,10579385,10579386,10579445,10579449,10576728,10576729,10576730,10576731,10576732,10579844,10579845,10579846,10579852,10579853,10579854,10576973,10576974,10576975,10571091,10577109,10577110,10577111,10525366,10525374,10525380,10525381,10525382,10519391,10525400,10525401,10519475,10523660,10523678,10527799,10524140,10522218,10522220,10522221,10522222,10522223,10524229,10524230,10524231,10524232,10524233,10524234,10524235,10524236,10522250,10522505,10522506,10522507,10522508,10524514,10522522,10524628,10524629,10524630,10524631,10528720,10528727,10528740,10528741,10528743,10528744,10528745,10528746,10528747,10528748,10528749,10528750,10528757,10528758,10524759,10528759,10524760,10528760,10528761,10528762,10528763,10528764,10528765,10528766,10528767,10528768,10528839,10528841,10528848,10528849,10528850,10528857,10528858,10528859,10528860,10421989,10421990,10421991,10421992,10421993,10421994,10421995,10421996,10421997,10421998,10421999,10422000,10422001,10424072,10422145,10425195,10425196,10425216,10425217,10479302,10477393,10481825,10481828,10481830,10481833,10481835,10481836,10481838,10477884,10477962,10478014,10478069,10478070) 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'