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(8573994,10447885,8630686,8630758,8631249,8583090,10940402,8631587,8575133,8631610,8575146,8575147,8575148,11041660,11041671,11041672,8575165,10849376,10950747,10950748,7066178,8067292,10437271,9215979,8575665,10951195,8632337,3230230,8629483,8067931,10844943,10860578,8561243,10860599,10962438,10939495,8630445,6000119,3238282,10959549,10959550,6000194,6000195,6000196,6000197,6000198,6000199,11011612,11011613,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,8627683,8627684,8627685,8627686,8627689,8627690,8627691,8627692,7201431,8559173,8559174,10866535,10866650,10866652,10866653,10866654,10931826,10931836,8559380,8559384,10999127,10999128,10999130,8595114,8595117,10858908,10843430,10843431,10843432,10843433,10843434,10843435,10843438,10103845,8836320,10859192,10104051,8628724,10999797,10999798,10999799,10999809,5654606,7073317,5654651,5654683,10987095,7065457,10859865,10857141,10865236,3237393,3237394,3237395,8616849,10102163,10997857,10997858,10997860,8626822,8626823,8626824,8626825,8626826,7200456,7071260,7071261,7200508,7071264,7071297,7071298,7071299,7071300,7071301,7071303,8910444,7200779,8910599,10102686,10102687,11011306,11011307,11011308,8558643,8558646,8558647,10866011,10866012,10866013,10866014,10866015,10866016,10866017,10866018,10866019,10866020,11011430,11011431,11011432,10102911,10102924,10102925,10995524,10995525,10995526,10995527,10995528,10995529,10995530,10995531,10863168,10863169,10839637,8624558,8907971,8555917,8555918,8908064,10940741,10940742,7198376,10855451,8624810,8624811,10863546,10863547,10863548,7198678,7198681,7198684,7198702,7198703,7198713,7198720,7198724,7198727,7198730,7198733,7198736,7198737,7198738,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198751,7198759,7198760,7198762,7198765,7198766,7198772,10941278,8556596,8556597,8615509,8625320,8625321,8625322,3926114,8625372,10856248,10856250,3236445,8557306,8557308,10101497,8557331,8557332,8557335,8557336,3236848,10101564,10101565,10101566,8860363,8542390,8542391,10837649,11045724,10623258,10623259,10623260,10853409,10853410,8613011,11007125,10623768,10623769,10623770,3234046,3234095,3234096,3234097,3234098,3234099,3234100,3234101,3234102,3234103,3234104,3234105,3234125,10838501,8554707,10838516,10838519,10838520,10838522,10838523,10838524,10838525,10838527,10838528,10838529,10838537,10838545,10838546,8906892,3234356,3234361,3234362,3234363,10838924,7197433,10838965,10838966,10838967,10838968,10838969,10838974,10838975,10838976,10838978,10838979,10838980,10838981,10838982,10838984,10838985,3234740,10624632,10624633,8907592,7197791,7197792,7197795,7197796,11008235,7197806,7197807,7197813,7197814,7197815,7197817,7197818,7197819,10995299,10995300,10995301,10995302,10995303,10855091,8634478,8634479,8634485,8634486,8634487,8634488,8634489,8634490,8634491,8634492,8634493,8634539,8634540,10427274,8552881,8541578,8541597,10836849,11044795,11044796,11044797,11044798,11044799,11044800,11044801,11044802,11044805,11044806,8541653,8541654,10617325,10617332,8905259,8905261,8905262,8905263,10617356,10617379,10954113,3232901,3922879,8905862,10425358,10425388,10615229,8570101,8570112,3230564,3230565,3230566,10620303,10425554,10615339,10425580,10425582,10425583,10848001,10848002,10848003,3230733,3230844,3581900,3581901,8633170,3581902,3581904,3581911,10848386,10991322,10965428,10615896,10930731,3582191,10848580,10848581,7154409,10851158,10851159,10851160,7154416,7154430,10952582,10952686,8904210,10616332,8904266,8904330,10616426,8633970,8633975,8904405,3231786,3232020,3232021,3232022,3232026,3232047,3232074,3232075,3232076,8552640,8552641,8552642,8552643,3232141,10427112,3232167,10616905,10610995,10610996,10610997,8853169,8853170,8853171,10614009,8853172,8853173,8853174,8853175,10562174,9915684,9915700,8568058,10614260,10614261,6669818,9197671,9197672,9197673,9197674,9197675,6669913,10611377,10611378,3654923,10611381,8864244,8864248,8864249,10559609,9197810,9197811,9197812,9197813,10614497,10614503,6670068,8864497,6670189,8864631,9214236,9214238,10612060,10612134,9211551,9211552,9211553,9211558,9211559,9211560,10612381,8851657,9211871,8566587,10612959,10612961,9212312,9212316,9212317,9212323,9188329,9188330,9188331,9188415,9188416,9188417,9188418,9188419,9188420,9188421,9188422,9188423,9188424,9188425,9188431,9196440,7058620,10120713,8567073,10558442,10558443,10558444,10558445,10558446,10558447,10558448,10558449,10558450,10558451,10558452,9204769,10613527,10613531,10561747,10561748,10561749,10561750,10561751,10561752,10561753,10561754,10610697,10613736,10613737,9197141,9197144,9197145,8567770,9169305,9161356,6673563,8849316,8849319,8849329,8592648,10513386,9193594,10117806,10117807,10117817,8592897,10517670,9161895,9912235,9170074,10513994,10513997,10513998,10513999,10514015,10514028,10514031,10514032,10514033,10516129,10118606,9912938,9912966,8552226,9913354,8552447,10514964,10514965,9913361,9913364,8848137,9160319,9160334,9160335,6672683,6672768,6672769,10419524,10419525,10419526,10419527,10418543,6672829,6672831,9910845,9910846,6672871,6672872,6672886,6672887,6672893,9168710,10416718,10416719,6673100,8848725,8848726,8848727,8848728,8848729,8848730,8848731,8848735,8848740,8848755,8848761,8848765,8848769,8848770,8848790,8848810,8848843,8848866,4973894,8848885,10419983,8848889,6681280,6673281,6673282,8848903,6673301,10417079,10417080,10417081,10419166,10419167,10419168,10419169,10419170,10419171,10419172,10419173,10419174,10419175,10419176,10419177,7055456,7055458,10122528,10122548,10122549,10122550,10122551,9190700,8550097,10115555,9199390,8847267,8847268,9191562,9191567,9207639,8847469,8847470,8847471,8847472,10123846,10123847,10123848,8847511,8550898,10468324,10468327,10468411,10468412,9167965,9167966,9192132,8848001,8848002,8848003,8848014,8848024,8848027,9192202,9192203,9192204,8848065,8848068,9184257,9184258,9160290,10627985,10627986,10883559,10883560,10883561,10883572,10883589,10883590,10883624,10883627,10883659,10883664,10893990,10884077,10884085,10904089,10904090,10894377,10884513,10155751,10874954,10890143,10890144,10905160,10890164,10890169,10905218,10905219,10176322,10887480,10887483,10153863,10882916,10887999,10883042,10883408,10883409,10883421,10883432,10630189,10162239,10162240,10162241,10162243,10162244,10886250,10172410,10172425,10172426,10172427,10172428,10172429,10172430,10172431,10172432,10625935,10625936,10896467,10901507,10949392,10173113,10173114,10173115,10173116,10173117,10173120,10173121,10887120,10887121,10887132,10887223,10887228,10887231,10882356,10882357,10882358,10892373,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568126,10568127,10568128,10568129,10568130,10601284,10601285,10601292,10601293,10568296,10568297,10568298,10568299,10568300,10568301,10568306,10568307,10568308,10601308,10568309,10601309,10602160,10601310,10601311,10602162,10601312,10602163,10568313,10601313,10602164,10568314,10601314,10568315,10601315,10602166,10601316,10601317,10601318,10602169,10601319,10602172,10602177,10602178,10602180,10643470,10583441,10643545,10643548,10583764,10583766,10583767,10583768,10583770,10583771,10583774,10583775,10583776,10583777,10583779,10583780,10583781,10583787,10583788,10583793,10583800,10583801,10583802,10583806,10583807,10583809,10583810,10583811,10602691,10602693,10602698,10602701,10602703,10602705,10602706,10602708,10602710,10602727,10602728,10602729,10602731,10584224,10590269,10590270,10590281,10590282,10590283,10590284,10590285,10590286,10590287,10590288,10590289,10590307,10590309,10644404,10599386,10584522,10584523,10584524,10584525,10603684,10603685,10603697,10604146,10604181,10601436,10601437,10651651,10651652,10567625,10601689,10601690,10601692,10601693,10601694,10601695,10601696,10601698,10601699,10601706,10601707,10568110,10568111,10524418,10524419,10524420,10544477,10520815,10520817,10520909,10421377,10498372,10498375,10423486,10498378,10498379,10498380,10423503,10421570,10424610,10424656,10421674,10422766,10421900,10507920,10425029,10507921,10425031,10425032,10425033,10424046,10425054,10411336,10411338,10413429,10477099,10486100,10486101,10486102,10486103,10409564,10409565,10407738,10486442,10486443,10408185,10408186,10496901,10496902,10496903,10496904,10496906,10496907,10496911,10408259,10486951,10486952,10486953,10486954,10478003,10497032,10493046,10487109,10487110,10487111,10487112,10412532,10493251,10493252,10493253,10493254,10493255,10408619,10410627,10493296,10493297,10493298,10497430,10406982,10409170) 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'