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(8595112,8595113,7202219,7202220,7202221,7202222,5654535,5654657,5654658,5654659,8564674,8564675,10841005,8906037,8906038,8906039,8906040,8906041,8906042,8906043,8906044,8906045,8906046,8906047,8906048,8906049,8906050,8906051,8906052,8906053,8906054,8906055,8906056,8906057,8906058,8906059,8906060,8906061,8906062,8906063,8906064,8906065,8906066,8906067,8906068,8906069,8906070,8906071,8906072,8906073,8906074,8906075,8906076,8906077,8906078,8906079,8906080,8906081,8906082,8906083,8906084,8906085,8906086,8906087,8906088,8906089,8906090,8906091,8906092,8906093,8906094,8906095,8906096,8906097,8906098,8906099,8906100,8906101,8906102,8906103,8906104,8906105,8906106,8906107,8906108,8906109,8906110,8906111,8906112,8906113,8906114,8906115,8906116,8906117,8906118,8906119,8906120,8906121,8906122,8906123,8906124,8906125,8906126,8906127,8906128,7157522,7157523,7157524,7157525,7157526,7157527,7157528,7157529,7157530,7157531,7157532,7157533,7157534,7157535,7157536,7157537,7157538,7157539,7157540,7157541,7157542,7157543,7157544,7157545,7157546,7157547,7157548,7157549,7157550,7157551,7157552,7157553,7157554,7157555,7157556,7157557,7157558,7157559,7157560,7157561,7157562,7157563,7157564,7157565,7157566,7157567,7157568,7157569,7157570,7157571,7157572,7157573,7157574,7157575,7157576,7157577,7157578,7157579,7157580,7157581,7157582,7157583,7157584,7157585,7157586,7157587,7157588,7157589,7157590,7157591,7157592,7157593,7157594,7157595,7157596,7157597,7157598,7157599,7157600,7157601,7157602,7157603,7157604,7157605,7157606,7157607,7157608,7157609,7157610,7157611,7157612,7157613,7157614,7157615,7157616,7157617,7157618,7157619,7157620,7157621,7157622,7157623,7157624,7157625,7157626,7157627,7157628,7157629,7157630,7157631,7157632,7157633,7157634,7157635,7157636,7157637,7157638,7157639,7157640,7157641,7157642,7157643,7157644,7157645,7157646,7157647,7157648,7157649,7157650,7157651,7157652,7157653,7157654,7157655,7157656,7157657,7157658,7157659,7157660,7157661,7157662,7157663,7157664,7157665,7157666,7157667,7157668,7157669,7157670,7157671,7157672,7157673,7157674,7157675,10953985,8905360,8576143,8576144,8576145,8576146,8576147,8576148,8576149,8576150,8576151,8576152,8576153,8576154,8576155,8576156,8576157,7154408,7154409,7154410,7154411,7154412,8904210,8904211,8904212,8904213,8904214,8904215,8904216,8904217,8904218,8904219,8904220,8904221,8904222,8904223,8904224,8904225,8904226,8904227,8904228,8904229,8904230,8904231,8904232,8904233,8904234,8904235,8904236,8904237,8904238,8904239,8904240,8904241,8904242,8904243,8904244,8904245,8904246,8904247,8904248,8904249,8904250,8904251,8904252,8904253,8904254,8904255,8904256,8904257,8904258,8904259,8904260,8904261,8904262,8904263,8904264,6669818,6669823,6669828,6669829,6669830,6669831,6669832,6669833,6669834,6669835,6669836,6669837,6669838,6669839,6669840,6669841,6669842,6669843,6669844,6669845,6669846,6669847,6669848,6669849,6669850,6669851,6669852,6669853,6669854,6669855,6669856,6669857,6669858,6669859,6669860,6669861,6669862,6669863,6669864,6669865,6669866,6669867,6669868,6669869,6669870,6669871,6669872,6669873,6669874,6669875,6669876,6669877,6669878,6669879,6669880,6669881,6669882,6669883,6669884,6669885,6669886,6669887,6669888,6669889,6669890,6669891,6669892,6669893,6669894,6669895,6669896,6669897,6669898,6669899,6669900,6669901,6669902,3962363,8851996,10610039,10613056,10613057,10613058,10613075,10613633,6673880,6673903,6673909,6673923,6673926,6673931,6673935,6673936,6673942,6673944,6673952,6673955,6673959,6673965,6673966,6673969,6673981,9160300,9160301,6672745,6672746,6672747,6672748,6672749,6672750,6672751,6672752,6672753,6672754,6672755,6672756,6672757,6672758,6672759,6672760,6672761,6672762,6672868,6672871,6672872,8549512,8550187,6667591,8847468,8847469,8847470,8847471,8847472,8847473,8847474,8847475,8847476,8847477,8847478,8847479,8847480,8847481,8847482,8847483,8847484,8847485,8847486,8847487,8847488,8847489,8847490,8847491,8847492,8847493,8847494,8847495,8847496,8847497,8847498,8847499,8847500,8847501,8847502,8847503,8847504,8847505,8847506,8847507,8847508,8847509,8847510,8847511,8847512,8847513,8847514,8847515,8847516,8847517,8847518,8847519,8847520,8847521,8847522,8847523,8847524,8847525,8847526,8847527,8847528,8847529,8847530,8847531,8847532,8847533,8847534,8847535,8847536,8847537,8847538,8847539,8847540,8847541,8847542,8847543,8847544,8847545,8847546,8847547,8847548,8847549,8847550,8847551,8847552,8847553,8847554,8847555,8847556,8847557,8847558,8847559,8847560,8847561,8847562,8847563,8847564,8847565,8847566,8847567,8847568,8847569,8847570,8847571,8847572,8847573,8847574,8847575,8847576,8847577,8847578,8847579,8847580,8847581,8847582,8847583,8847584,8847585,8847586,8847587,8847588,8847589,8847590,8847591,8847592,8847593,8847594,8847595,8847596,8847597,8847598,8847599,8847600,8847601,8847602,8847603,8847604,8847605,8847606,8847607,8847608,8847609,8847610,8847611,8847612,8847613,8847614,8847615,8847616,8847617,8847618,8847619,8847620,8847621,8847622,8847623,8847624,8847625,8847626,8847627,8847628,8847629,8847630,8847631,8847632,8847633,8847634,8847635,8847636,8847637,8847638,8847639,8847640,8847641,8847642,8847643,8847644,8847645,8847646,8847647,8847648,8847649,8847650,8847651,8847652,8847653,8847654,8847655,8847656,8847657,8847658,8847659,8847660,8847661,8847662,8847663,8847664,8847665,8847666,8847667,8847668,8847669,8847670,8847671,8847672,8847673,8847674,8847675,8847676,8847677,8847678,8847679,8847680,8847681,8847682,8847683,8847684,8847685,8847686,8847687,8847688,8847689,8847690,8847691,8847692,8847693,8847694,8847695,8847696,8847697,8847698,8847699,8847700,8847701,8847702,8847703,8847704,8847705,8847706,8847707,8847708,8847709,8847710,8847711,8847712,8847713,8847714,8847715,8847716,8847717,8847718,8847719,8847720,8847721,8847722,8847723,8847724,8847725,8847726,8847727,8847728,8847729,8847730,8847731,8847732,8847733,8847734,8847735,8847736,8847737,8847738,8847739,8847740,8847741,8847742,8847743,8847744,8847745,8847746,8847747,8847748,8847749,8847750,8847751,8847752,8847753,8847754,8847755,8847756,8847757,8847758,8847759,8847760,8847761,8847762,8847763,8847764,8847765,8847766,8847767,8847768,8847769,8847770,8847771,8847772,8847773,8847774,8847775,8847776,8847777,8847778,8847779,8847780,8847781,8847782,8847783,8847784,8847785,8847786,8847787,8847788,8847789,8847790,8847791,8847792,8847793,8847794,8847795,8847796,8847797,8847798,8847799,8847800,8847801,8847802,8847803,8847804,8847805,8847806,8847807,8847808,8847809,8847810,8847811,8847812,8847813,8847814,8847815,8847816,8847817,8847818,8847819,8847820,8847821,8847822,8847823,8847824,8847825,8847826,8847827,8847828,8847829,8847830,8847831,8847832,8847833,8847834,8847835,8847836,8847837,8847838,8847839,8847840,8847841,8847842,8847843,8847844,8847845,8847846,8847847,8847848,8847849,8847850,8847851,8847852,8847853,8847854,8847855,8847856,8847857,8847858,8847859,8847860,8847861,8847862,8847863,8847864,8847865,8847866,8847867,8847868,8847869,8847870,8847871,8847872,8847873,8847874,8847875,8847876,8847877,8847878,8847879,8847880,8847881,8847882,8847883,8847884,8847885,8847886,8847887,8847888,8847889,8847890,8847891,8847892,8847893,8847894,10883564,10883565,10883566,10883567,10883568,10883569,10883570,10883571,10888034,10888035,10888036,10888037,10888038,10888039,10888040,10888041,10888042,10888043,10888044,10888045,10888046,10888047,10888048,10888049,10888050,10888051,10888052,10888053,10888054,10888055,10888056,10888057,10888058,10888059,10888060,10888061,10888062,10888063,10888064,10888065,10888066,10888067,10888068,10888069,10643469,10643470,10647421,10647422,10496912,10496913,10496914,10496915,10496916,10496917,10496918,10496919,10496920,10496921,10496922,10496923,10496924,10496925,10496926,10496927,10496928,10496929,10496930,10496931,10496932,10496933,10496934,10496935,10496936,10496937,10496938,10496939,10496940,10496941,10496942,10496943,10496944,10496945,10496946,10496947,10496948,10496949,10496950,10496951,10496952,10496953,10496954,10497207,10497208,10497209,10497210,10497211,10497212,10497213,10497214,10497215,10497216,10497217,10497218,10497219,10497220,10497221,10497222,10497223,10497224) 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'