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(10861458,10861459,10861460,10861461,10861462,10989094,8631061,10861830,10861831,10861834,10870888,10870889,10870891,10846511,10846512,8631533,8631564,8631601,8631602,8575167,8583489,10849506,10871534,10871548,8631917,8631918,7074294,8631951,8631952,7074360,8632146,8632147,8632186,3229962,8632191,10849858,10871870,10871875,8632308,8632309,8632310,8632311,10850061,10850147,10850173,10860323,8837543,10860373,7067102,7067134,8629780,8629818,8629819,8629820,10860472,8629892,8561242,7067298,7075578,10860914,10860915,10860916,10860917,10860918,10860919,10860920,10860921,7075776,7067895,7075913,7201220,7201221,7071983,10842925,10842926,10842927,8627840,8627845,8627851,8627861,8627870,7201683,10866804,10866812,8628170,10866834,10866836,10866853,10867011,8628395,8628396,7202079,8628491,10104032,10104034,10859195,10104071,7202211,7202212,7202213,7202214,8628656,10859597,10932804,10932825,10859893,10859936,10859937,10859954,10859964,10859974,7065750,3237391,11036765,10857633,7200731,7071514,10865848,7200817,10857893,10866031,10858155,10858159,10858189,10858190,7071911,8624716,8624736,7198386,7198387,7198394,8624850,8624851,8624852,8624857,7198464,10855512,8624871,10855513,8624872,8624873,8624896,10863538,8624919,8624920,10863612,10863613,10863644,10863645,10863646,7198683,8908517,7198727,7198744,7198745,7198757,7198760,7198764,7198766,8625262,8625265,10996311,7069719,8626052,8565240,8565241,8565243,8626260,8626422,7200127,10853335,10618209,10853485,10853486,10853657,8554369,10623507,10838516,10838520,10838534,10838535,10838536,10838540,10838542,10838553,8906890,8906914,7197130,10838801,10838969,10838971,10838985,10838986,10838987,10838988,10838989,7197608,7197609,7197611,7197613,7197640,7197643,7197644,7197645,7197646,7197649,7197650,8907494,7197687,7197688,7197689,7197690,7197720,7197770,3234966,3234971,10855046,10855047,10855136,10619900,10619904,8634679,8634680,8634681,3232454,3232455,3232456,3232457,8634685,3232458,8634686,3232459,3232460,3232461,3232462,3232463,3232464,3232465,3232466,3232467,3232468,3232469,3232470,8541598,8905206,8905208,8905209,10617383,10617456,3922838,8905773,8542254,8632606,10425351,8632801,8632803,8632804,10848007,10615338,10850696,10850697,8633270,8633271,10952307,10952309,7154412,8904236,8904292,8904302,3231785,3231786,3231794,3231797,3231798,3231799,3231800,8611258,8611259,3232037,3232038,10922261,10922262,10922263,10922265,10922266,10922268,10922288,10922289,10922291,10922292,3232176,8634410,3232183,8634501,8634502,8634503,8634525,8634526,8634527,8634528,8634533,8634534,8634535,8634536,10613998,10613999,10614000,10614001,10614002,10614003,10614004,10614005,8853216,10614064,8853227,8853230,8853235,9173741,10614497,6666259,10611933,9211921,8851787,8862558,10557973,10557975,10557976,10612937,9212324,10613113,10610126,10558320,10613208,10610247,10610248,10610249,9188640,10613341,10610429,10613740,6673523,8592648,8849335,8849336,8849349,8849350,8849366,8849367,8849373,8849374,8849376,8849379,8849523,8849524,10513565,8849700,8849701,8849702,10515704,10515705,10515710,9912193,9178725,10518653,10518673,10518693,9171040,8848130,8848170,9176363,6672661,9192464,9192466,6672833,6672874,9168709,9168710,10419668,10415675,10419676,10415678,10419703,10419705,10419725,10419739,10419889,8848889,8848890,9169069,6673279,10117293,10117301,10417071,10417128,10417129,10417130,10417145,10417146,10417147,8568863,10463013,10467142,10469372,10469373,8916476,10467443,10463738,10463747,10465765,10465767,10465780,976358,8847586,10466384,10462401,10462450,10462453,6668126,10462726,10466845,10883630,10884068,10894380,10161868,10162092,10162093,10949013,10886638,10886639,10886640,10886641,10886642,10886643,10886644,10886645,10886646,10886647,10886648,10886649,10886650,10886651,10886652,10886653,10886654,10631239,10631240,10631242,10882009,10887464,10602164,10580323,10580324,10602194,10602198,10602694,10583862,10590274,10590307,10647380,10603683,10603694,10601437,10579795,10539120,10539121,10539122,10539123,10539124,10539125,10539126,10539127,10539128,10529402,10529405,10529406,10529414,10529415,10546510,10546511,10546512,10522612,10522613,10522621,10539088,10539089,10539090,10539091,10539092,10539093,10539100,10533104,10539109,10499118,10508123,10499124,10508157,10498250,10498251,10498252,10422526,10422527,10422529,10423000,10423014,10425045,10425046,10425053,10423154,10423160,10507068,10508105,10507105,10407495,10409501,10407552,10407559,10409676,10407956,10407957,10412023,10473715,10477785,10412246,10410260,10410261,10496938,10496939,10496942,10496943,10414289,10496985,10496990,10410336,10414342,10414346,10414347,10414359,10478016,10482021,10478021,10478022,10414369,10414382,10497041,10497043,10414471,10412476,10493302,10414661,10410678,10410679,10412725,10412728,10412736,10497407,10412760,10412761,10407090) 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'