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(9214868,8583105,8583106,10459415,10459416,8575161,8575162,8575163,8575164,8575165,8575166,8575167,8574001,8594669,8594670,8594671,8594672,8594673,8594674,8594675,8594676,8594677,8594678,8594679,8594680,8594681,8594682,7202228,7202229,7202230,7202231,7202232,7202233,5654661,10100077,3926606,8906302,8906303,8906304,8906305,8906306,8906307,8906308,8906309,8906310,8906311,8906312,8906313,8906314,8906315,8906316,8906317,8906318,8906319,8906320,8906321,8906322,8906323,8906324,8906325,8906326,8906327,8906328,8906329,8906330,8906331,8906332,8906333,8906334,8906335,8906336,8906337,8906338,8906339,8906340,8906341,8906342,8906343,8906344,8906345,8906346,8906347,8906348,8906349,8906350,8906351,8906352,8906353,8906354,8906355,8906356,8906357,8906358,8906359,8906360,8906361,8906362,8906363,8906364,8906365,8906366,8906367,8906368,8906369,8906370,8906371,8906372,8906373,8906374,8906375,8906376,8906377,8906378,8906379,8906380,8906381,8906382,8906383,8906384,8906385,8906386,8906387,8906388,8906389,8906390,8906391,8906392,8906393,8906394,8906395,8906396,8906397,8906398,8906399,8906400,8906401,8906402,8906403,8906404,8906405,8906406,8906407,8906408,8906409,8906410,8906411,8906412,8906413,8906414,8906415,8906416,8906417,8906418,8906419,8906420,8906421,8906422,8906423,8906424,8906425,8906426,8906427,8906428,8906429,8906430,8906431,8906432,8906433,8906434,8906435,8906436,8906437,8906438,8906439,8906440,8906441,8906442,8906443,8906444,8906445,8906446,8906447,8906448,8906449,8906450,8906451,8906452,8906453,8906454,8906455,8906456,8906457,8906458,8906459,8906460,8906461,8906462,8906463,8906464,8906465,8906466,8906467,8906468,8906469,8906470,8906471,8906472,8906473,8906474,8906475,8906476,8906477,8906478,8906479,8906480,8906481,8906482,8906483,8906484,8906485,8906486,8906487,8906488,8906489,8906490,8906491,8906492,8906493,8906494,8906495,8906496,8906497,8906498,8906499,8906500,8906501,8906502,7157889,7157890,7157891,7157892,7157893,7157894,7157895,7157896,7157897,7157898,7157899,7157900,7157901,7157902,7157903,7157904,7157905,7157906,7157907,7157908,7157909,7157910,7157911,7157912,7157913,7157914,7157915,7157916,7157917,7157918,7157919,7157920,7157921,7157922,7157923,7157924,7157925,7157926,7157927,7157928,7157929,7157930,7157931,7157932,7157933,7157934,7157935,7157936,7157937,7157938,7157939,7157940,7157941,7157942,7157943,7157944,7157945,7157946,7157947,7157948,7157949,7157950,7157951,7157952,7157953,7157954,7157955,7157956,7157957,7157958,7157959,7157960,7157961,7157962,7157963,7157964,7157965,7157966,7157967,7157968,7157969,7157970,7157971,7157972,7157973,7157974,7157975,7157976,7157977,7157978,7157979,7157980,7157981,7157982,7157983,7157984,7157985,7157986,7157987,7157988,7157989,7157990,7157991,7157992,7157993,7157994,7157995,7157996,7157997,7157998,7157999,7158000,7158001,7158002,7158003,7158004,7158005,7158006,7158007,7158008,7158009,7158010,7158011,7158012,7158013,7158014,7158015,7158016,7158017,7158018,7158019,7158020,7158021,7158022,7158023,7158024,7158025,7158026,7158027,7158028,7158029,7158030,7158031,7158032,7158033,7158034,7158035,7158036,7158037,7158038,7158039,7158040,7158041,7158042,7158043,7158044,7158045,7158046,7158047,7158048,7158049,7158050,7158051,7158052,7158053,7158054,7158055,7158056,7158057,7158058,7158059,7158060,7158061,7158062,7158063,7158064,7158065,7158066,7158067,7158068,7158069,7158070,7158071,7158072,7158073,7158074,7158075,3925033,8905361,8905362,8905363,8905364,10615036,10425384,10620303,10925879,7154429,7154430,7154431,7154432,8904329,8904330,8904331,8904332,8904333,8904334,8904335,8904336,8904337,8904338,8904339,8904340,8904341,8904342,8904343,8904344,8904345,8904346,8904347,8904348,8904349,8904350,8904351,8904352,8904353,8904354,8904355,8904356,8904357,8904358,8904359,8904360,8904361,8904362,8904363,8904364,8904365,8904366,8904367,8904368,8904369,8904370,8904371,8904372,8904373,8904374,8904375,8904376,8904377,8904378,8904379,8904380,8904381,8904382,8904383,8904384,8904385,8904386,8904387,8904388,8904389,8904390,8904391,8904392,8904393,8904394,8904395,8904396,8904397,8904398,8904399,8904400,8904401,8904402,8904403,8904404,8853178,8853195,8853201,8853204,8853218,8853226,10714022,10714023,6670037,6670038,6670039,3962375,3962376,10611994,8851682,8851683,8851684,8851685,8851686,8851687,8851688,10610041,10613577,10613578,10613579,8852775,10610953,8849124,8849125,8849126,8849127,8849128,8849129,8849130,8849131,8849132,8849133,8849134,8849135,8849136,8849137,8849138,8849139,8849140,8849141,8849142,8849143,8849144,8849145,8849146,8849147,8849148,8849149,8849150,8849151,8849152,8849153,8849154,8849155,8849156,8849157,8849158,8849159,8849160,8849161,8849162,8849163,8849164,8849165,8849166,8849167,8849168,8849169,8849170,8849171,8849172,8849173,8849174,8849175,8849176,8849177,8849178,8849179,8849180,8849181,8849182,8849183,8849184,8849185,8849186,8849187,8849188,8849189,8849190,8849191,8849192,8849193,8849194,8849195,8849196,8849197,8849198,8849199,8849200,8849201,8849202,8849203,8849204,8849205,8849206,8849207,8849208,8849209,8849210,8849211,8849212,8849213,8849214,8849215,8849216,8849217,8849218,8849219,8849220,8849221,8849222,8849223,8849224,8849225,8849226,8849227,8849228,8849229,8849230,8849231,8849232,8849233,8849234,8849235,8849236,8849237,8849238,8849239,8849240,8849241,8849242,8849243,8849244,8849245,8849246,8849247,8849248,8849249,8849250,8849251,8849252,8849253,8849254,8849255,8849256,8849257,8849258,8849259,8849260,8849261,8849262,8849263,8849264,6674088,6674093,10118448,10118449,6672784,6672785,6672786,6672787,6672788,6673300,8549465,9207297,10115670,10115671,10115672,10115673,10115674,10115675,10115676,10115677,10115678,10115679,10115680,10115681,10115682,10115683,9168005,10883604,10883605,10883606,10883607,10883608,10883609,10883610,10883611,10883612,10883613,10883614,10883615,10883616,10883617,10883618,10883619,10883620,10883621,10883622,10883623,10883624,10883625,10883626,10883627,10883628,10883629,10883630,10883631,10883632,10883633,10883634,10883635,10883636,10883637,10883638,10883639,10883640,10883641,10883642,10883643,10883644,10883645,10883646,10883647,10883648,10883649,10883650,10883651,10883652,10883653,10883654,10883655,10884059,10884060,10884061,10884062,10884063,10884064,10884065,10154011,10154012,10888153,10888154,10888155,10888156,10888157,10888158,10888159,10888160,10888161,10888162,10888163,10888164,10888165,10888166,10888167,10888168,10888169,10888170,10888171,10888172,10888173,10888174,10888175,10888176,10888177,10888178,10888179,10888180,10888181,10888182,10888183,10888184,10888185,10888186,10888187,10888188,10888189,10888190,10888191,10888192,10888193,10888194,10888195,10888196,10888197,10888198,10888199,10888200,10888201,10888202,10888203,10888204,10888205,10888206,10888207,10888208,10888209,10888210,10888211,10888212,10888213,10888214,10888215,10888216,10888217,10888218,10888219,10888220,10888221,10888222,10888223,10888224,10888225,10888226,10888227,10888228,10888229,10888230,10888231,10888232,10888233,10888234,10888235,10888236,10888237,10888238,10888239,10888240,10888241,10888242,10888243,10888244,10888245,10888246,10888247,10888248,10167072,10167082,10167087,10167092,10167095,10167102,10167109,10167179,10167188,10167201,10643542,10643543,10643544,10643545,10643546,10643547,10643548,10643549,10643550,10497013,10497014,10497015,10497016,10497017,10497018,10497019,10497020,10497021,10497022,10497023,10497024,10497025,10497026,10497027,10497028,10497029,10497030,10497031,10497032,10497033,10497034,10497035,10497036,10497037,10497038,10497039,10497040,10497041,10497042,10497043,10497044,10497045,10497046,10497047,10497048,10497049,10497050,10497051,10497052,10497053,10497054,10497307,10497308,10497309,10497310,10497311,10497312,10497313,10497314,10497315,10497316,10497317,10497318,10497319,10497320,10497321,10497322,10497323,10497324,10497325,10497326,10497327,10497328,10497329,10497330,10497331,10497332,10497333,10497334,10497335,10497336,10497337,10497338,10497339,10497340,10497341,10497342,10497343,10497344,10497345,10497346,10497347,10497348,10497349,10497350,10497351,10497352,10497353,10497354,10497355,10497356,10497357,10497358,10497359,10497360,10497361,10497362,10497363,10497364,10497365,10497366,10497367,10497368,10497369,10497370,10497371,10497372,10497373,10497374,10497375,10497376,10497377,10497378,10497379,10497380) 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'