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(10848723,10848793,10848806,10848834,10848875,10848908,10848954,10848979,10849032,10849102,10849140,8575166,10849332,10849341,8583656,8583746,8583849,10860254,10860255,10860256,8630436,10939425,10939432,8594637,8594647,10866616,10866617,10866693,10866732,10866733,10866734,10866735,10866736,10866737,10866738,10866739,10866740,10866741,10866742,10866743,10866744,10858797,7201983,7202108,5654535,10859667,10859668,10859670,10859672,10859675,10859676,10859678,8629325,3227179,8910076,10857404,8558282,10959115,10959116,7200735,7200736,7200737,7200738,7200739,7200741,7200742,7200743,7200744,7200745,7200746,10857802,10857803,10857804,10857805,10857806,10857811,10857812,10857813,10857814,8910628,10865947,8624647,8624648,8624649,8624653,8624654,7198706,7198707,7198709,7198717,10856745,10856750,10864828,10857001,3233371,3233372,3233373,7196266,7196267,8554290,8906568,7197598,7197851,7198126,10852288,10617116,10617117,10622258,10622264,10622265,10622267,10622268,10622360,3232801,10617454,10617573,8542219,10614975,10615036,10615183,10615184,10615185,10615186,10615187,10615188,10615189,10615190,10615191,10615192,10615193,10615194,10425553,10425555,10425577,10850521,10620301,10620302,10620303,10620306,3581917,10615818,10615833,10426448,10991775,10616237,10616238,8904348,10616428,8611319,10852001,10852002,10616870,8853147,8853166,8853177,8853216,8853219,8853220,8853221,8853222,8853223,8853224,8853225,8853226,8853227,10714024,10611387,10611395,10611396,10611397,10611402,10611406,10611407,10611408,10611415,10611426,10611432,10611438,10611439,10611450,10611451,10611457,10614466,10611972,10612267,10119814,8851468,10612431,10612432,10612517,10612545,10609886,10613577,10613741,10610904,10610905,9169405,8849317,8849319,8849329,6673740,8849378,8592703,6673773,6673802,6673814,9185788,10126077,9178427,9912788,9912982,8850646,8850652,8850655,8850661,8850663,8850665,8850669,8850681,8850691,8850692,8850696,8850700,8850701,8850705,8850708,8850715,8850717,8850723,8850728,8850734,8850739,8850742,8850746,8850749,8850752,8850753,8850759,8850762,8850772,8850775,8850787,8850791,8850805,8850813,8850815,8850863,8850865,8850872,8850877,8850886,8850904,8850906,10416262,10419497,10419498,6672782,6672783,6672784,6672794,6672795,6672796,6672797,6672798,6672799,6672800,6672804,6672810,10419568,6672911,9168795,8848716,8848725,8848726,8848727,8848728,8848733,8848740,8848745,8848755,8848756,8848760,8848761,8848765,8848769,8848770,8848778,8848781,8848782,8848790,9168970,9168972,9168974,9168977,9168979,9168981,9168984,8848810,8848820,8848828,8848843,8848848,8848849,8848866,8848885,8848889,8848892,8848903,8848918,10419116,10418151,10471175,8549926,8550003,8550142,8550157,3963375,8847268,8847273,8847274,9167533,976367,10470217,9167664,9167666,8847511,8847514,10470271,8847529,8847533,10470311,976559,8847998,8848003,8848021,8848024,8848028,8848050,8848059,8848062,8848064,9168241,9168242,8848067,9168244,9168246,9168247,9168249,9168250,9168251,9168253,9168255,9168258,10888539,10883622,10883624,10883625,10883659,10884001,10894377,10894380,10884651,10889717,10884793,10890171,10887561,10632106,10632107,10887867,10888038,10888066,10888148,10888149,10888150,10888151,10888152,10888172,10888207,10627771,10883460,10885482,10885512,10885899,10161977,10630822,10630823,10630853,10630856,10876807,10876809,10876816,10876819,10876821,10876823,10876825,10897137,10897179,10887191,10602010,10602185,10602506,10602510,10602635,10602642,10602658,10602690,10602691,10602692,10602693,10602696,10602697,10602704,10602705,10602707,10602708,10602722,10602726,10602736,10603684,10603692,10603693,10603703,10603878,10606942,10606951,10604199,10604212,10601493,10607538,10607539,10591726,10601643,10601693,10601695,10601954,10521187,10521188,10508256,10508327,10508328,10508492,10508494,10508495,10413356,10411662,10411666,10411857,10414097,10414098,10414100,10414101,10414102,10414105,10414106,10414108,10412145,10478007,10478008,10478009,10478010,10478011,10478012,10478013,10497037,10497038,10497039,10497040,10412394,10412395,10412396,10412397,10412398,10412399,10714785,10408675,10408676,10476345,10408832) 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'