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(10447885,8630686,7076041,9214719,8630758,8574478,10848608,10848610,10848682,10848683,8631249,8583090,10940402,8631587,8631610,11041660,11041671,11041672,8583521,10849374,10849376,10950747,10950748,8583657,10849594,8067292,9215979,10437271,8575665,3229962,10951195,8632337,8632557,8632558,8629600,8067931,10844943,8561311,10962438,10939495,10103110,8627636,8627637,8627638,8627639,8627641,8627642,8627643,8627644,8627645,8627646,8627647,8627648,8627649,8627650,8627652,8627653,8627654,8627655,8627656,8627683,8627684,8627685,8627686,8627689,8627690,8627691,8627692,8594729,7201431,8627904,7201590,7064386,10999127,10999128,10999130,10931826,10931836,7201790,7201791,7201826,10960308,10843405,10843430,10843431,10843432,10843433,10843434,10843435,10843438,8836320,10104051,8065932,8065933,10843715,10843716,10843717,10843723,10843726,10999659,10999660,10999661,10999662,10999663,10999664,10999797,10999798,10999799,10999809,8628803,5654578,5654579,7073317,5654651,5654657,5654661,5654683,10987095,5654777,5654778,7065457,10961233,8629483,8629560,8626591,3237395,8616849,10102163,10942710,10942715,7071093,10997834,8626822,8626823,8626824,8626825,8626826,8626847,8626848,8626855,7200456,8626856,8626857,8626858,8626859,8626860,8626861,8626862,8626863,8626864,8626865,8626866,8626867,8626868,8626869,8626870,8626871,8626872,8626873,8626874,8626875,8626876,8626877,8626878,8626879,8626880,8626881,8626882,8626883,8626884,8626885,8626886,8626887,8626888,8626889,8626890,8626891,7071260,7071261,7071264,7071297,7071298,7071299,7071300,7071301,7071303,8910444,8627062,8627063,8627064,8627065,8627066,10959188,10959189,8910571,10102686,10102687,11011306,11011307,11011308,7200925,10943304,8835189,8835196,11011430,11011431,11011432,10102911,10102924,10102925,3238282,10959549,10959550,10100080,10100081,8624609,8555917,8555918,8908064,10839777,10940741,10940742,8624810,8624811,7198463,8625172,8556596,8556597,10941278,8615509,8625320,8625321,8625322,3926114,8625372,3926205,3926206,8615671,8615694,3236445,10941688,10996791,10996792,10996793,10941913,3926732,10941979,8557306,8557308,10101497,8557331,8557332,8616224,8557335,8557336,8626054,8626055,8626056,8626057,8626058,8626062,8626064,8626066,8626068,3236848,11048405,11010506,8557803,11010597,11010605,3233422,11045724,3923448,8613011,8613064,10623258,10623259,10623260,10618274,11045973,11045989,11007125,3233955,3234095,3234096,3234097,3234098,3234099,3234100,3234101,3234102,3234103,3234104,3234105,10623768,10623769,10623770,11046638,11046813,10838924,7197433,11046938,11046939,11046970,11046971,11046972,11046976,11047002,11047003,11047009,11047010,11047050,11047082,11047112,11047113,11047114,11047115,11047116,11047117,11047127,3234898,3234901,3234902,3234903,3234904,3234905,3234906,3234908,3234909,8907592,8907601,8907602,11008235,10995299,10995300,10995301,10995302,10995303,3925033,10995524,10995525,10995526,10995527,10995528,10995529,10995530,10995531,10619891,10619892,10619903,10839637,8624558,8907971,8552881,11044768,11044769,11044770,10836849,11044795,11044796,11044797,11044798,11044799,11044800,11044801,11044802,11044805,11044806,8541653,8541654,10992871,10992872,11045038,10922896,10927985,10993170,3922879,10993173,10993292,8905862,8542390,8542391,10425358,10615036,8570101,8570112,3230564,3230565,3230566,10620201,10620202,10615229,10847967,10848001,10848002,10848003,10615339,3230733,10615352,3230844,11043196,8633170,10991322,10965428,10930731,10991459,10991461,10991462,10930735,10991463,10930736,10991464,10991465,10991466,10991467,10848580,10848581,3231293,10991606,10991664,10991665,10991666,10991667,10991671,10991672,10991673,10991674,10991675,10991676,10991677,10991678,3231437,10952686,8540593,8540613,10991786,8540614,8904210,8904266,8904271,8904330,8540798,8540799,8540800,8633970,8633975,8904405,3231786,8540989,8540990,8540991,8540992,8540993,8541096,8552640,8552641,8552642,8552643,3232141,3232143,3232144,3232145,3232146,3232160,10427112,8634437,3232242,3232256,3232257,3232258,3232259,3232260,3232261,3232262,3232284,3232326,10427274,10610995,10610996,10610997,10614009,10562174,8568058,10614260,10614261,9197671,9197672,9197673,9197674,9197675,10611377,10611378,10611381,8864244,8864248,9189727,8864249,9189728,10559585,9197810,9197811,9197812,9197813,6670068,8864497,6670189,9213993,10122209,8864631,9214236,9214238,10612013,10612060,10612086,10612134,9211551,9211552,9211558,9211559,9211560,9913846,10609375,8851657,9914068,9211871,9914269,9914270,8851922,9188228,9188329,9188330,9188331,8566848,10610075,9188415,9188416,9188417,9188418,9188419,9188420,9188421,9188422,9188423,9188424,9188425,9188431,9196440,9196484,9172490,9172493,8567066,10558442,10558443,10558444,10558445,10558446,10558447,10558448,10558449,10558450,10558451,10558452,10561523,10561524,9204769,10558592,10613527,10613531,10561747,10561748,10561749,10561750,10561751,10561752,10561753,10561754,8852959,9197141,9197144,9197145,8852988,8567770,9169305,9161356,6673563,10117608,8849316,8849317,8849318,8849378,10513386,9185576,9185577,9185578,4974438,10117784,4974442,9193594,10117806,10117807,10117817,4974522,4974543,10125966,4974643,7056038,9161895,10126152,9912235,9170074,10513994,10513997,10513998,10513999,10514028,10514031,10514032,10514033,10118449,9162415,9912711,9912712,9912713,9186564,10118825,9912918,9912920,9912921,9912938,9912939,10119041,9171077,9171078,8552447,10417396,10417397,6672683,9184492,10418543,9910845,9910846,10419564,10419565,10419566,10419567,10416718,10416719,6673100,8848725,8848726,8848727,8848728,8848729,8848730,8848731,8848752,8848755,8848756,8848757,8848758,4973894,10419983,6681280,10419166,10419167,10419168,10419169,10419170,10419171,10419172,10419173,10419174,10419175,10419176,10419177,7055447,10122528,10122548,10122549,10122550,10122551,8854231,9190669,9206743,8854614,8854684,8854735,8550097,9198985,9199063,10123546,10115555,9199390,8847267,8847268,8847273,8847274,9175466,9191562,9191567,9207639,8847469,8847470,8847471,8847472,8847485,8847487,8847488,6671917,10462292,10462293,976495,10462294,10462295,10462296,10462297,10462298,10462299,10462300,10462301,9175754,10468411,10468412,9167965,9167966,9167987,9192122,9192123,9192124,9192125,9192126,9192127,9192129,9192130,9192132,8848001,8848002,8848003,8848020,8848021,8848024,8848025,8848026,8848027,9192202,8848028,9192203,9192204,9184257,9184258,9160290,10627985,10627986,10883627,10883665,10883668,10908682,10908683,10628178,10893983,10893984,10893985,10893986,10893987,10893988,10893990,10904089,10904090,10884513,10889711,10889718,10155751,10874954,10889997,10890101,10905160,10905218,10905219,10880304,10880305,10176322,10882916,10887999,10908256,10908257,10908258,10883408,10883409,10883421,10883432,10630189,10166966,10167021,10167127,10167128,10167130,10167141,10167142,10167166,10167167,10167180,10167181,10167182,10167183,10167184,10167185,10167206,10167207,10167209,10162239,10162240,10886250,10167339,10167340,10167341,10172410,10172425,10172426,10172427,10172428,10172429,10172430,10172431,10172432,10625935,10625936,10896467,10901507,10949392,10891617,10891632,10626343,10882007,10173113,10173114,10173115,10173116,10173117,10887120,10887121,10887132,10887195,10887200,10882353,10882354,10882356,10882357,10882358,10892373,10601284,10601285,10601292,10601293,10601308,10601309,10601310,10601311,10601312,10601313,10601314,10601315,10601316,10601317,10601318,10601319,10583441,10568558,10583764,10583766,10583767,10583768,10583770,10583771,10583774,10583775,10583776,10583777,10583779,10583780,10583781,10583787,10583788,10583793,10583800,10583801,10583802,10583806,10583807,10583809,10583810,10583811,10602705,10602746,10590269,10590270,10590281,10590282,10590283,10590284,10590285,10590286,10590287,10590288,10584522,10584523,10584524,10584525,10600599,10600600,10600601,10600602,10600603,10600604,10600605,10600621,10600622,10600623,10601503,10591828,10591829,10591830,10522256,10522257,10544477,10520815,10520817,10522818,10520909,10527020,10539036,10539037,10421377,10508326,10498372,10498375,10423486,10498378,10498379,10498380,10423503,10422520,10422523,10422524,10422526,10422527,10422529,10423551,10423566,10421570,10424610,10507511,10507512,10424656,10421674,10422766,10507670,10507671,10421900,10424046,10411336,10411338,10486100,10486101,10486102,10486103,10483141,10407738,10486442,10486443,10407944,10407946,10496910,10408259,10410262,10410263,10410264,10410265,10410266,10410267,10486951,10486952,10486953,10486954,10412500,10412501,10412532,10476267,10408619,10476281,10476282,10476283,10476284,10497430,10406948,10406949,10406981,10406982,10407163,10407167,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'