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(3228953,10861898,10861903,10861904,10861910,10861916,10862012,10862013,10862014,3229207,8631598,3229967,8632546,10860260,8629792,10860548,10860636,10860637,10860709,8630268,8630430,7201197,7201339,7201340,7201341,7201342,7201343,10866428,10866748,10866752,10866753,10866756,10866757,10866759,10866760,10866768,10866769,10866774,10866777,10866778,10866783,10866970,10866971,10866974,7201975,8628604,7202524,8629340,8629341,10857283,8626827,8626829,10865853,7200879,10865957,10865996,10863248,7198718,7198726,7198728,7198729,10855897,8909072,11048488,8626406,10854173,10854214,10854215,10854218,3234501,3234502,7198180,10617343,10954017,10954018,3922813,10954201,8632626,8632627,8632628,8632629,8632630,8632631,10615169,10426317,10616684,10616787,10616788,10614048,10614050,10611239,10611240,10611241,10611293,10614518,10614619,10614620,10612320,10612321,10609946,10613349,9169344,9169349,7055530,9169449,10117848,10118264,10118265,10118269,8850094,9912827,9912832,9912843,9168357,10419407,10419408,10419604,10419605,10419608,10419611,10419612,10419615,10419616,10419624,10419625,10419630,10419634,10419635,10419643,10419644,10415717,10415718,10415719,10415722,10415724,10415725,10416779,10419023,10419024,10117433,7055450,7055451,7055452,7055453,10469669,10116206,10116207,10116208,10116209,10116210,10116211,10116212,10116213,10116214,10116215,10116216,10116217,10116218,10116219,10116220,10116221,10116222,10116223,9168190,9168191,10903862,10884335,10884786,10890205,10890206,10887654,10887659,10887660,10887662,10887663,10887664,10885815,10886628,10886723,10886736,10631455,10631456,10409982,10409983,10409986,10410185,10414878,10414879,10414943,10411036) 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'