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(9214744,9214745,7076097,10870440,10988859,10861517,7068284,7076307,7068343,7068364,7068366,7068782,3229254,3229256,3229257,3229264,3229266,3229269,3229271,3229272,3229273,10976586,10868435,7066166,10849473,10849474,10849494,10849495,7074284,7074290,8631981,8632003,8632044,8632046,10844721,8573352,8573353,10961928,10961929,10962020,8620449,10962467,10962468,10962469,4430522,10842811,7072128,10960047,10858861,10858877,10858878,10973338,8595308,7072753,10960624,10960625,10960626,10960627,10960628,10960629,10960630,10960631,10960632,10960633,10960634,10960635,10960636,10960637,10960638,10960639,10960640,10960641,10960642,10960643,10960644,10960645,10960646,10960647,10960648,10960695,8066165,8066189,7073140,7073277,7065582,10844461,10844548,8557800,7071150,8558413,10943316,10943321,10943322,10943324,10943327,10943365,10985414,10985415,10985416,10985417,10985418,3925425,3925437,10864191,8834122,8626400,8626404,7196189,7196190,7196191,7196192,7196193,10928632,11045765,11045766,11045767,11045768,11045769,11045788,11045789,11045790,11045797,11045804,11045805,11045806,11045816,11045823,11045824,11045825,11045826,11045827,11045828,11045830,11045835,11045841,11045842,11045847,11045848,11045862,11006904,11006905,8613262,8613276,8554399,8554409,8554410,8554417,8554419,8613454,11007305,11007306,11007307,8613530,8613531,8613557,8613558,11046647,3924417,11007773,11007821,11007822,11007831,11007948,11007949,10839110,10839111,10839112,10839113,8555549,8555576,8907731,8907736,8907737,8907798,8907799,8907800,8907801,8541785,8542145,10622877,10622906,8632548,8632555,9216581,8576164,8576165,8576166,8576167,8576168,8576171,8632821,8632831,11004112,10620637,10620649,3231149,10991473,10978540,8540376,8540604,8540605,10952787,10952789,10952797,10952798,10952799,10952800,10952801,10952802,10952803,8540632,10426638,3231703,10921956,8540851,8540852,3232020,3232021,3232022,3232067,3232074,3232075,8541208,8611541,8611543,8611548,3232169,3232170,8853313,8853314,8853315,9213596,7059796,10611448,10611449,10611450,10611451,7019466,7019467,7019468,7019469,7019470,7019471,7019472,7019473,7019474,7019475,7019476,7019477,7019478,7019567,7019568,7019569,7019570,7019571,7019572,7019573,7019574,7019575,7019576,7019577,7019578,7019579,10120077,10120078,10120321,9172211,9172212,9196219,9212257,9212337,9212338,9212339,9212340,9212342,9212348,9212361,9212364,9212365,9196507,9196517,10613367,6676924,9204741,10558618,10558679,9196881,9196891,9196910,6677243,6677244,6677245,6677285,9915449,9915464,9915476,9177311,9177315,10515171,10515173,10515174,10515175,10513335,10513336,10513337,8592763,8592850,10126023,10126024,10126025,10126026,10126027,10126028,10126029,10126030,10126031,10126032,10126036,10126040,10126048,7056284,10513985,9170257,9170258,9170259,9170260,9170261,9170311,9170322,9170323,9170324,9170326,9170415,9170416,9170417,9170418,10118703,7024533,7024534,7024535,7024536,7024537,7024538,7024539,7024540,7024541,7024542,7024543,7024544,7024545,10512760,10512761,7024621,7024622,7024623,7024624,7024625,7024626,7024627,7024628,7024629,7024630,7024631,7024632,7024633,8850818,8850819,8850820,8850821,8850822,8850823,8850824,8850825,8850826,8850827,8850828,8850829,8850830,8850831,8850832,8850833,8850834,7057413,7057416,10515078,10515079,10515080,10415410,9184524,4973684,4973696,4973755,4973756,4973757,4973758,4973759,9192937,9185091,9182435,10467338,6679008,4971751,4971753,8854853,4972030,10123549,9207489,8917185,4972503,8550821,9175780,10462406,10462407,10462408,10462409,10462410,10462411,10462412,10462413,10462414,10462415,10462416,10462417,10462418,10462419,10462420,10462421,10462422,10462423,10462424,10462425,10628226,10628229,10628230,10159949,10159950,10159951,10159952,10175096,10170225,10170226,10170227,10170228,10170328,10170329,10170330,10170331,10170332,10170333,10170334,10170335,10170643,10170680,10170681,10170682,10170683,10170684,10170685,10170698,10170700,10170701,10910089,10910090,10910091,10910092,10910129,10910249,10910304,10885339,10890388,10632171,10903144,10161602,10161948,10905979,10172216,10172217,10891316,10896464,10896492,10896493,10896494,10896522,10896523,10167633,10167649,10167677,10167678,10896678,10162767,10896984,10897043,10168079,10168083,10168111,10897113,10897237,10601267,10649524,10649525,10590973,10604146,10579690,10579691,10579692,10588705,10523190,10523191,10523192,10523227,10523235,10525389,10525390,10531483,10541663,10523680,10523697,10531804,10531805,10532192,10530560,10530561,10530562,10532688,10532689,10532719,10538750,10538751,10538752,10523066,10529107,10509466,10509467,10509468,10509469,10509470,10509471,10509472,10509473,10509474,10509475,10509476,10509477,10509478,10509479,10509480,10509481,10509482,10509483,10509484,10509485,10509486,10509487,10509488,10509489,10509490,10509491,10509492,10509493,10509494,10509495,10509496,10509497,10509498,10509499,10509500,10509501,10509502,10509588,10509589,10510646,10510685,10510686,10510687,10510688,10510689,10510721,10510722,10510723,10510724,10510725,10510726,10510727,10510728,10510729,10510730,10510731,10510732,10510733,10510734,10509734,10510735,10509735,10509736,10509737,10509738,10509739,10509740,10509741,10509742,10509743,10509744,10510745,10509745,10510746,10509746,10510747,10510748,10510749,10510750,10510751,10510752,10510753,10510754,10510755,10510756,10510757,10510758,10510759,10510760,10510761,10510762,10510763,10510764,10510765,10510766,10510767,10510768,10510769,10510770,10510771,10510772,10510773,10510774,10510775,10510776,10510777,10510778,10509917,10509918,10509919,10509920,10509921,10509922,10509923,10509924,10509925,10509926,10509927,10509928,10509929,10509930,10509931,10509932,10509933,10509934,10509935,10509936,10509937,10509938,10509939,10509940,10509941,10509942,10509943,10509944,10509945,10509946,10509982,10509987,10509988,10509989,10509990,10509991,10509992,10509993,10509994,10509995,10509996,10509997,10509998,10509999,10510000,10510001,10510002,10510003,10510004,10510005,10510006,10510007,10510008,10510009,10510010,10510011,10510012,10510013,10510014,10510015,10510016,10510017,10510018,10510019,10510020,10413394,10413408,10413409,10488188,10488229,10488236,10479343,10479344,10479345,10479346,10407060,10407061) 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'