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(10939617,10939618,10939619,10939620,8620846,8620847,8620848,10962750,10962751,10962752,10962753,10962754,10962755,10962756,10962757,10962758,10962759,10962760,10962761,10962762,10962763,10962764,10962765,10962766,10962767,10962768,10962769,10870652,8621449,8569653,11041534,7073972,7074002,8631810,8631838,10437280,10437281,10437282,10437283,10437284,8632202,8632203,8632204,8632205,7066846,7066848,11013724,10929312,11013725,11013726,11013727,11013728,11013729,7075168,7075169,7075170,7075171,7075172,8573422,8573423,10447568,8630398,8630399,10931633,8627997,8627998,8628241,8628242,8628243,8628244,10843486,10843487,10843488,10843489,10843490,10843491,11038488,8836342,10867553,10867554,8560256,8836867,7070995,7070996,7070997,7070998,8910109,3927455,11048985,10102223,7071245,7071246,8834915,8834916,8834917,8834918,8834919,8834920,10972181,10972190,10102952,10102953,10839739,10839740,10839741,10839742,10839743,10839744,10839745,10944639,10944640,10944641,10944642,10944643,10995920,10995921,10995922,10995923,10995924,10995925,10995926,10995927,10995928,10863709,10863710,10863711,10863712,10863713,8625194,8615546,8615547,8615548,8615549,8615550,8615551,8615552,8909114,8909115,11022795,10971173,10971174,10942113,10971175,10971176,10971177,10971178,10971179,10971180,10971181,10971182,10971183,10971184,10971185,3926993,8565325,11048542,7070867,7070868,7070881,7156705,3923729,3233770,3233771,10618393,10618394,10618395,10618396,10618397,10618398,10618399,10618400,10618401,10618402,10618403,10618404,10618405,10618406,10618407,10618408,10618409,10618410,10618411,10618412,10618413,10618414,10618415,10618416,10618417,10618418,10618419,10618420,10618421,10618422,10618423,10618424,10618425,7157280,8554752,3924206,7157890,3234862,8614522,10922637,8612039,8612122,8612123,8612124,10953989,11045237,9216830,8632897,11004082,10926030,10926031,10926032,3581941,8634098,8634099,7155350,7155351,10611423,10611582,10566063,9206289,9206290,9206291,9206292,9206293,9206294,9206295,9206296,8851220,8851221,8851247,8851248,8851290,7057686,7057687,7057922,9171979,9220325,3653595,9172561,9172562,9172563,9188566,9188704,9188705,9188706,9188707,9188708,9188709,9188710,9188711,9188712,7059117,8567515,8852936,8852937,8852938,8852939,8852940,8852941,6677339,8852960,8567790,8567791,8567792,10517317,10517318,7055853,7055854,7023703,7023704,7023705,7023706,7023707,7023708,7023709,7023710,7023711,7023712,7023713,7023714,7023715,3285808,6674475,10516194,10516195,10516196,10516197,9912907,9912908,9912909,8850687,10119121,10119122,10119123,10119124,8850792,8850880,8850903,8850904,8851055,8851117,9913500,9913501,4973373,4973374,4973375,4973376,4973377,4973378,10417473,9176786,9176787,9176788,9176789,9176790,10125032,10125033,10125034,10125336,10125337,10125338,10125339,10125340,10125341,10125342,10125343,10125344,10122595,9917100,9182929,9182930,9182931,9182932,10123304,9207559,9207560,976011,9200250,9200295,8593552,8593553,8593554,10905420,10905421,10905422,10905423,10905424,10905425,10905426,7000884,7001091,10913251,10913252,10630864,10630865,10891456,10891457,10891458,10891459,10891460,10891461,10891462,10891463,10891464,10891465,10891466,10891467,10172523,10172524,10172525,10172526,10172527,10172528,10172529,10172530,10172531,10172532,10172533,10172534,10172535,10172536,10172537,10172538,10172539,10949810,10949811,10626756,10583685,10568943,10568944,10568945,10568946,10568947,10568948,10568949,10568950,10568951,10568952,10568953,10568954,10568955,10568956,10568957,10568958,10568959,10568960,10568961,10568962,10568963,10568964,10568965,10568966,10568967,10568968,10568969,10568970,10599386,10648063,10648064,10651610,10537609,10537610,10537611,10537612,10537613,10537614,10537615,10537616,10537617,10537618,10537619,10537620,10537621,10537622,10537623,10537624,10537625,10537626,10537627,10537628,10537629,10537630,10537631,10537632,10537633,10537634,10537635,10538337,10522618,10536771,10536772,10536773,10536774,10536775,10420327,10420328,10509406,10509407,10509408,10509409,10509410,10509411,10509586,10485972,10485973,10485974,10486029,10486030,10486031,10486032,10411657,10476169,10476170,10476171,10476172,10476173,10476174,10412529,10489322,10489323,10489324,10489325,10489326,10489327,10489328,10489329,10489330,10489331,10489332,10489333,10489334) 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'