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(10939642,10939643,8574513,9215282,10870924,10870925,10861944,8574968,8574970,8574972,8574991,8574992,8575004,8066948,8066949,11041784,10976791,8583854,11042115,10868844,10868864,10868893,10951330,10977440,10977441,10929565,10962093,10962106,10962107,10962108,10845460,10962458,10962460,10962461,10962462,10962463,10962464,10962465,10962466,10985665,8835765,8835766,8835805,8835853,8835872,8835874,10986443,10104561,10961214,3227184,3227186,7070891,10984655,10984660,10984665,10984752,10984754,11010768,10841846,10841850,8910164,10841860,10841863,10102308,10102310,10102314,10102320,10841950,10841969,10841970,10841971,10842009,10842029,10958963,10958964,10958965,3927718,3927719,10102505,7071394,10102527,10943247,7071632,7071635,7071672,7071686,8907901,8907919,8907952,10839669,10839670,10839672,7068937,10940718,8908089,8908090,8908091,8908096,3925452,8908131,8908143,7069252,8615113,10983036,10983066,10983068,10983069,10983094,10983106,10855709,10983107,10983522,10983595,10983596,10983597,10983598,10983599,10983668,10983670,10983701,10983702,10983745,10996812,10996984,10996999,10997000,10841261,10841262,10841333,10984420,10984421,10984436,10984439,10993768,10993811,10993832,10993835,10993836,10993837,10993838,10993839,10993840,10993841,10993842,10993843,10967998,10967999,10968001,3924349,8613927,8613948,8614003,8614032,8614162,8614163,3924763,3924764,10839144,10839145,3924793,3924819,8907583,10982243,10982390,10982439,10982440,8614600,11044508,8611694,10927534,10622029,10622031,10927544,10622080,10927620,10927621,10927750,8905157,7155688,7155694,7155717,7155721,7155726,10927853,8541717,10622699,10847621,10847645,8569903,10847766,10847770,10425385,10847794,10847804,10847806,10847811,10847824,10847841,10847846,10425487,10847875,10847876,10847882,10425910,3581935,3581936,10426012,10426018,10426019,10926373,10926381,10926386,10926466,10426196,10621051,10621052,10926564,10926604,11043660,8540746,8540747,11043920,11043923,11043939,11043941,11044008,9218013,9218015,9218016,10426764,9218058,9218068,9218072,9218074,9218086,9218107,9218114,8611308,11044164,11044167,11044177,11044202,11044205,10616669,11044217,11044241,11044255,11044259,8611447,8611451,11044334,11044365,11044413,10427108,10427112,11044445,11044480,9181304,9181323,9181333,9213478,7059652,7059656,9181495,7059665,9181502,9181504,9181507,9181509,9181511,9181512,8853497,8853498,8853505,8853506,8853517,8853520,9189802,9181807,9181812,9189880,9181929,9181930,9189940,9189955,9189956,9189957,7057681,7057682,8542776,9171702,9171704,9171705,9172207,9172262,6676653,10120728,9172543,9172544,9914763,9914764,9914795,9914799,9180889,8567411,8567412,9180911,8567416,9180919,9180972,9180974,3654241,3654257,3654258,3654284,9181088,9181089,9181090,9181091,9181157,9181158,9181162,9181247,10511184,10511197,10511224,10511225,10511226,10511227,10511236,10660241,10125830,10125837,10125841,10511568,10511569,10511614,10511615,10511616,10511617,10511618,10511665,10511666,10511667,10511668,10511743,9178076,9178078,9178079,9178080,9178081,9210100,9210178,9210179,9210194,7056360,9210195,9210206,10514037,10514038,9210255,9210260,9210261,10514090,10514091,10514092,10514093,9186297,9210298,9210315,9210325,10516157,10516158,10516165,9210361,9210367,4975224,10514248,9178474,9210489,10512311,10514364,10514366,10514367,10514368,10514369,10514373,10514374,9210583,10514408,10514409,10514410,10514411,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,9210610,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,9210621,10514434,9210622,9210625,9210626,9170648,9170649,9170650,9170651,9170652,9170653,9170654,9170655,9170656,9170657,9170658,9170659,9210721,9210722,9178725,9210750,9210751,9210752,9210789,9210790,9178790,9210795,9210796,9210798,9210799,9210809,9210833,9210839,9210840,9210844,7057014,9178848,9178851,9210853,9210854,9178858,9210865,9210866,9210871,9210901,9186923,9210971,9210974,9211013,9211014,9211037,9187043,9187046,9187047,9187061,9187062,9187063,9187064,9211066,9211067,9211069,9211071,9211078,9211079,9211080,9211088,9211089,9211106,9211115,9211117,9211120,9211125,9211157,9211171,9211172,9211173,9211184,9211185,9211187,9211190,9211192,9211193,10515067,10515069,10427885,9208851,9208860,9208864,9193112,9193114,9193116,9182312,9182313,9182314,10463047,10463048,10463053,10463054,10463055,10463056,10467137,10467138,10467139,10467152,10467153,10467154,10467156,9166807,10463435,10463438,10467442,10467458,10467459,9199097,6667115,10465694,10465695,8916796,8916797,10463760,10463761,8916858,10463810,10463814,10463815,10463816,10463817,10463818,10465835,10465836,10465892,10465893,10465894,10463915,10463916,10463917,10467952,10467962,9175498,4972472,10468205,10466329,10466380,10466381,10466382,10466383,10466441,10462449,10462450,10468494,10462525,10462526,10462527,10462528,10470671,9208197,10466861,9168284,10466862,10466863,10466864,10466865,8594141,8594147,10899453,10899457,10899481,10899482,10899483,10899536,10899540,10899548,10899606,10899607,10899608,10899609,10899613,10899614,10899624,10899625,10899637,10899746,10899747,10899748,10899759,10899862,10899908,10627080,10627081,10627082,10903130,10906110,10896877,10897159,10897161,10897162,10631773,10586718,10649954,10649956,10649996,10649997,10588048,10588079,10588127,10588154,10588179,10654305,10654309,10654312,10654313,10654317,10654318,10654319,10588423,10588435,10588461,10588471,10588490,10588491,10588568,10588583,10588598,10588602,10588603,10529143,10529146,10531314,10531316,10527406,10539407,10523408,10533461,10527463,10537490,10537491,10537492,10539494,10539495,10539496,10539497,10539498,10539499,10539500,10539501,10539502,10539503,10539504,10539505,10539506,10539507,10539508,10539509,10539510,10539511,10539512,10549586,10549607,10533623,10533624,10533625,10533626,10529855,10529856,10524392,10524459,10524468,10524472,10524476,10524710,10524711,10524712,10546759,10532812,10528973,10525077,10508159,10508160,10508210,10508212,10508213,10508214,10508215,10508216,10508242,10508243,10509291,10509292,10509293,10507778,10510780,10506819,10506824,10507927,10509983,10509984,10509985,10509986,10480964,10480986,10485988,10486018,10481029,10481059,10481060,10481114,10483138,10481154,10481155,10483165,10483166,10481166,10483181,10481184,10483192,10481216,10481289,10481290,10481291,10481318,10481340,10496352,10496357,10481367,10496367,10496371,10496380,10481383,10481384,10481385,10481386,10496391,10481399,10496405,10496408,10496411,10496416,10481417,10496423,10496454,10481542,10481549,10481716,10481727,10481728,10481729,10481730,10481731,10481751,10481994,10715273) 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'