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(10861367,8630765,8630808,8630809,8630810,8630811,8630836,8630837,8630838,8630852,8630862,8630886,8630892,8630893,8630894,8630895,8630896,8630897,8630898,8630899,8630900,10848677,8631192,8569559,8583493,10950710,10950711,10868923,10863128,10863129,10863130,10863131,10863132,10863133,10863134,10863135,10863136,10863137,10863138,10863139,10863140,10863141,7201443,7201444,8628216,8628217,8628249,8628257,8628260,8628261,8628262,8628263,8628264,8628265,10858937,10858938,10858939,10858940,10858941,10858942,10858943,10858944,10858945,10858946,10858947,10858948,10858949,10858950,10858951,10858952,10858953,10858954,10858955,10858956,10858957,8628787,8626610,8627010,8627011,8627012,8627013,8627014,8627015,8627016,8627017,8627018,8627019,8627020,8627021,8627022,8627023,8627024,8627025,8627026,8627027,8627028,8627029,8627030,8627031,8627032,8627033,8627034,8627035,8627036,8627037,8627038,8627039,8627040,8627041,8627042,8627043,8627044,8627045,8627046,8627047,8627048,8627049,8627067,8910590,10857893,8627472,8908214,8908215,8908216,8625170,8626139,8626140,8626141,8626142,8626143,8626144,10865015,10865016,10865017,10865018,10865019,10857137,10854321,8624256,8624360,8624361,7198108,7198109,7198110,7198111,7198112,7198113,7198114,8634721,8634722,8634723,8634724,8634725,8634726,8634727,8905399,8905400,3922823,10848536,8540600,8611340,10616545,10616546,10714135,10614556,10614557,10614558,10614860,10614861,10612158,10612159,10612160,10612161,10612162,10612163,10612164,10612165,10612166,10612167,10612168,10612169,10612170,8851768,8862513,8851849,8566626,8567053,7055500,7055501,7055502,7055503,7055504,7055505,10117736,10117920,9912261,9913212,10415324,9168439,9168440,9168441,9168442,9168443,9168444,9168445,9168446,10416677,10416678,10416679,10416680,10416681,10416682,10416683,10416684,10416685,10416686,10416687,10416688,10416689,10416690,6673325,8550025,8550026,10469931,10468470,10468471,10468472,10889459,10889460,10884515,10884580,10884918,10884919,10884920,10884921,10884922,10884923,10884924,10884925,10884926,10884927,10884928,10884929,10884930,10884931,10884932,10884933,10884934,10884935,10884936,10884937,10884938,10884939,10884940,10884941,10884942,10884943,10884944,10884945,7000828,7000829,7000830,10162032,10876634,10647482,10603570,10645886,10413452,10413453,10413454,10413455,10413456,10413457,10413458,10413459,10413460,10413461,10413462,10413463,10413464,10411962,10412476,10406942) 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'