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(8574010,10848640,4970689,10848641,4970690,4970691,10848642,10848643,10848644,10848647,10848648,10848649,10848650,10848651,10848652,10848653,10848654,10848656,10848657,10848658,10848659,10848742,10848781,10848789,10989240,10989241,10848869,10848912,10848935,10848937,10848939,10848943,10848960,10848994,10849127,10849136,10849166,10849206,10849230,10849232,10849234,10849236,10849293,10950737,7066142,8594638,8594648,7201367,8595136,10858800,7201984,7201988,7202232,10859294,10859295,10859296,10859297,10859298,10859299,10859300,10859301,10859302,10859303,10859304,10859305,10859306,10859307,10859308,10859309,10859682,7200740,8910623,8910624,10863153,7198185,7198186,7198187,7198188,7198189,7198190,7198191,7198192,7198193,7198194,7198195,7198196,7198197,7198198,7198199,7198200,7198201,7198202,7198203,7198204,7198205,7198706,7198707,7198709,7198712,7198737,7199200,7199202,7199205,7199213,7199546,7199666,8905955,8906814,8906817,8906818,8906822,3235104,10616996,10617091,10617308,10622429,8905469,8905470,8905471,8905472,8905473,8905474,8905475,10615000,10615219,10615220,3581790,10426281,10426308,10426327,10616366,10616416,8904405,10616608,10852003,8853153,8853163,8853178,8853179,8853228,8853229,8853230,10614153,10614167,8853336,8853337,8853339,10614177,10614228,10714139,10714201,10614400,10614411,10611462,10611464,10611469,10611472,10611475,10611488,10611497,10611498,10611506,10611508,10611509,10611510,10614589,10611670,9166051,10612018,10612042,10609150,10612262,10609265,8851440,10612345,8851564,10612433,10612434,10612435,10612436,10612437,10612438,10612439,10612440,10612441,10612442,10612443,10612444,10612445,10612446,10612447,10612448,10612449,10612450,10612451,10612452,10612453,10612454,10612455,10612456,10612457,10612458,10612459,10612460,10612461,10609505,10612613,10612617,8851824,8851825,8851826,7017673,7017674,7017675,7017676,7017677,7017678,10612841,10610044,10613085,10613087,10613088,10613091,10613157,10613470,10613471,10613540,10613578,10610773,10610906,8853101,8853114,9911669,8849319,8849320,8849324,8849325,8849329,8849331,9169551,9911849,10117995,10117996,7015486,7015487,7015488,7015489,7015490,7015491,7015492,7015493,7015494,7015495,7015496,7015497,10118231,3285787,9912359,9912360,9912361,9912362,9912363,10118665,8850516,8850615,8850616,8850719,9913168,8850846,8850847,8850909,8850911,8850912,8850915,8850916,8850917,8850920,8850923,8850924,8850926,8850927,8850929,8850930,8850931,8850932,8850934,8850935,8850940,8850941,8850945,8850953,8850954,8850960,8850968,8850970,8850976,8850978,8850980,8850986,8850991,8850992,8850993,8850997,8851003,8851014,8851018,8851029,8851032,8851034,8851039,8851042,8851049,8851056,8851060,8851063,8851067,8851071,8851083,8851087,8851099,8851103,8851105,8851111,8851112,8851120,8848124,6672811,9168670,6672973,10416702,7014456,7014457,8848707,8848717,8848728,8848734,8848746,8848756,8848761,8848775,9168951,8848779,8848782,8848797,8848821,6673206,8848829,8848830,8848835,8848836,8848843,8848845,8848875,8848913,6673474,8550102,8847280,10470218,10470236,8847493,8847507,10470262,10470272,10470284,8847534,10470287,10470288,8847541,8847542,10470307,10468336,10470347,10470384,10470489,10470592,10468670,10468671,10468672,10468673,10468674,10468675,10468676,10468677,10468678,10468679,10468680,10468681,10468682,10468683,10468684,8848034,8848049,8848051,9168236,8848065,8848066,9168264,8848093,8848103,8848116,10883626,10883629,10883664,10883665,10883668,10884019,10889251,10889295,10889296,10628851,10628853,10889523,10884686,10884788,10889902,10889903,10889904,10890006,10890047,10885214,10885215,10885216,10885217,10885218,10885219,10885220,10885221,10885222,10885223,10885224,10890279,10887516,10887517,10882519,10887610,10887870,10883050,10883124,10883125,10883126,10883127,10888127,10883128,10888263,10888273,10888274,10161998,10161999,10162000,10162001,10162002,10876808,10876815,10876817,10876820,10876826,10876827,10886934,10887013,10887021,10887129,10887130,10887304,10601990,10602112,10602113,10643545,10643546,10643547,10643551,10602482,10602483,10602498,10602694,10602695,10602696,10602697,10602698,10602699,10602709,10602723,10602727,10602728,10602739,10647501,10647502,10603685,10603686,10603694,10604202,10601427,10607513,10607540,10607541,10607634,10601780,10601829,10601868,10546434,10546441,10546518,10546539,10546567,10508315,10508316,10413357,10413733,10413734,10413735,10413736,10413737,10413738,10413739,10413740,10414112,10478014,10478015,10478016,10497041,10408677,10406901,10406902,10406903,10406904,10406905,10406908,10406909,10406910,10406911,10406912,10406913,10406914,10406915,10406916,10406918,10406919,10406920,10406921,10406922) 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'