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(8630977,8631044,8631053,10861951,3229144,3229145,3229146,3229147,3229148,3229149,3229175,8583486,10849411,10849412,10849413,8631995,8632187,8632198,10863025,10863041,10860278,10860281,8629716,8629837,8629838,8629867,8629868,8629872,8629875,8629885,8629899,8629900,8629901,8629902,8629903,8629909,8629910,8629912,8629914,8629915,8629919,8629921,8629924,8629925,8629928,8629929,8629930,8629935,8629936,8629937,8629938,8629939,8629947,8629949,8629956,8629957,8627584,8627586,8627587,8627588,8627589,8627591,8627593,8627594,8627595,8627597,8627598,8627599,8627600,8627601,8627602,8627603,7201205,8627606,8627607,8627608,8627609,8627610,8627611,8627612,8627613,8627614,8627615,8627616,8627704,8627705,8627831,8627867,8627871,10858714,8595074,8595091,10858960,7201975,8065817,8628577,8628592,8628593,8628636,8629241,10860128,8629553,10857284,8626701,8626834,7200532,8627008,7200827,7200828,8627343,7200949,7200950,8627353,8627369,8627370,8627371,8627372,8627374,8627375,8627376,8627382,8627398,8627401,8627406,8627408,8627412,8627413,7201015,7201016,8627417,8627419,8627420,8627422,8627425,8627426,8627427,8627428,8627429,8627430,8627431,8627432,8627433,8627434,8627435,8627436,8627437,8627438,8627439,8627440,8627441,8627442,8627443,8627444,8627448,8627449,8627450,8627451,8627452,8627453,8627454,8627455,8627456,8627457,8627458,8627459,8627521,8627522,8627523,8627524,8627531,8627532,8627533,8627534,8627535,8627536,8627537,8627538,8627539,8627540,8627541,8627542,8627543,8627544,8627545,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,8627554,8627555,8627556,8627557,8627558,8627559,8627560,8627561,8627562,8627563,8627564,8627565,8627566,8627567,8627568,8627569,8627570,8627571,8627572,8627573,7198677,7198678,7198682,7198684,7198729,8625150,8615630,8625533,8625538,8625550,8625551,8625555,8625556,8625557,8625558,8625559,8625582,8625583,8625596,7199253,8625690,8625691,8625736,8625770,8625771,8625772,8625779,8625834,8625835,8625836,8625837,8625838,8625839,8625840,8625844,8625845,8625846,8625847,8625848,8625849,8625850,8625851,8625852,8625853,8625854,8625855,8625856,8625857,8625858,8625859,8625860,8625861,8625862,8625863,8625864,8625865,8625885,8625886,8625887,8625994,8625995,8625996,7199620,8626054,7196238,3923474,7197885,10617162,10617163,10852512,8905290,8905291,8905886,8905887,10425386,10425391,10620119,10620120,8632829,8632833,8632840,10615371,10615372,10850666,10615439,8633126,8633128,8633130,8633131,8633132,8633133,8633136,8633138,8633139,8633144,8633422,8633425,8633429,8633430,10615971,10615972,10616014,8633793,8633797,8633831,8633837,8633865,8633871,8904312,8904313,8904314,10616417,10616454,10616473,10616476,8611398,8634288,10852028,10616895,6669884,10611381,10611392,10611461,10611472,10614475,10614489,10611498,10611499,10611511,10611512,10611513,10611514,10611515,10611516,10611517,10611578,10614661,10611670,10611671,10614677,10614678,10614679,10614680,10614681,10614682,10611772,10611774,8851137,8851138,8851150,8851151,8851185,8851186,8851187,8851188,8851215,8851216,8851223,8851246,8851249,8851259,8851288,8851304,8851305,8851309,8851310,8851311,8851312,10612178,8851363,8851364,8851368,8851381,8851394,8851398,8851431,8851440,8851442,8851444,8851447,8851448,8851457,8851488,8851489,8851490,8851491,8851492,8851493,8851500,8851502,8851513,8851551,8851556,8851563,8851564,10612507,10612508,10612509,10612510,10612513,10612517,10612577,10612578,10612587,10612588,10612599,10612622,10612638,10612652,10612659,10612678,10612681,10612682,10612683,10612702,10612703,10612746,10612747,10612752,10609826,10612934,8852213,10610301,10613342,10610497,10610773,10610834,9169332,10117801,10117805,6673838,6673870,6673926,6674091,10118259,10118433,10118541,10118542,8850623,8850624,8850653,8850664,8850670,8850703,8850704,8850731,8850737,8850758,8850771,8850776,8850777,8850778,8850783,8850784,8850789,8850836,8850842,8850844,8850846,8850847,8850858,8850859,8850860,8850861,8850862,8850863,8850873,8850876,8850879,8850885,8850902,8850905,8850913,8850946,8850947,8850949,8850950,8850955,8850957,8850998,8850999,8851041,8851043,8851044,8851045,8851046,8851047,8851048,8851049,8851050,8851051,8851052,8851053,8851054,8851055,8851056,8851057,8851058,8851059,8851060,8851061,8851062,8851063,8851064,8851065,8851066,8851067,8851068,8851069,8851070,8851071,8851072,8851073,8851074,8851075,8851076,8851077,8851078,8851079,8851080,8851081,8851082,8851083,8851084,8851085,8851086,8851087,8851088,8851089,8851090,8851091,8851092,8851093,8851094,8851095,8851096,8851097,8851099,8851101,8851103,8851104,8851111,8851112,8851119,9168349,9168382,9168383,10416599,8848646,8848647,10415750,6673045,6673129,9161148,10117397,10117399,10471182,10470094,10468487,9167993,10888543,10888547,10884194,10889544,10889607,10875065,10875066,10875067,10875068,10880325,10877480,10877483,10877484,10877485,10887533,10632108,10887631,10883309,10883415,10885523,10630055,10881564,10881565,10167992,10897014,10897016,10897123,10887171,10643475,10602269,10602270,10602271,10602272,10599317,10599332,10599333,10647616,10604198,10604441,10604493,10604496,10604555,10604681,10604682,10508503,10507589,10507665,10507796,10507861,10507867,10507868,10507869,10507870,10507871,10507872,10507873,10507874,10507875,10507893,10413256,10407930,10486665,10412047,10408977,10407010,10407011,10407012) 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'