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(10943611,10943612,10943613,10943614,10943615,10943616,10943617,4970677,10843696,7068435,7068436,7068437,7068438,7068439,7068440,7068441,7068442,7068443,7068444,3899547,8619363,10437286,8837414,3227555,3227556,10212975,7064345,7064346,7064347,7064348,7064349,7064350,7064351,7064352,3927020,8834221,8834222,8834223,8834224,8834225,8834226,8834227,8834228,4967950,4967951,4967952,4967953,4967954,4967955,4967956,4967957,4967958,4967959,4967960,4967961,4967962,4967963,4967964,4967965,4967966,4967967,4967968,4967969,4967970,4967971,4967972,4967973,4967974,4967975,4967976,4967977,4967978,4967979,8555846,10100258,10100259,10100260,10100261,10100262,10100263,8564001,8564002,8564003,8564004,8564005,8564006,3922874,3922875,10944485,10944486,10944487,10257587,7196396,10848228,10255435,10255436,10255437,10255438,10255439,10255440,10255441,7154523,7154524,7154525,7154526,7154527,10255886,10255887,10255888,10255889,10255890,10619361,10269603,8552867,8552868,8552869,8552870,8552871,8552872,10282637,10837050,10865613,10865614,10432159,10432160,10254331,10189368,10189369,10189370,10189371,10189372,10189373,10189374,10189375,10189376,10189377,10189378,10189379,10189380,10189381,10189382,10189383,8609699,8609700,10425559,10425560,10425561,10850493,10850494,10850495,10850496,10850497,10850498,10850499,10850500,10850501,10850502,10850503,10850504,10850505,10850506,10850507,10850508,10850509,10447310,10620852,10620853,10620854,10620855,10620856,8583190,8583191,8583192,8583193,8583194,8583195,8583196,10431303,10431304,9915732,10940248,10940249,10940250,10940251,10940252,10940253,10940254,8861833,8861834,8861835,8861836,8861837,8861838,8861839,8861840,8861841,8861842,8861843,10120156,10120157,10120158,10120159,10120160,10120161,10120162,10120163,10120164,10120165,10120166,10938682,10938683,10938684,7058678,8567142,8863277,8852685,4974153,9177451,9177452,9177453,9177454,9177455,9177456,9177457,4974314,4974315,8551573,8551574,8551575,8551576,8551577,8551578,8551579,8551580,8551581,8551582,8551583,8551584,2809146,3651911,3651912,3651913,8565742,8565743,8565744,8565745,8565746,8565747,8565748,9176800,10418841,10418842,9200983,8064613,8064614,8064615,8064616,8064617,8064618,8064619,8064620,8064621,8064622,8064623,8064624,8064625,8064626,8064627,8064628,8064629,8064630,8064631,8064632,8064633,8064634,8064635,8064636,8064637,8064638,8064639,8064640,8064641,8064642,8064643,8064644,8064645,8064646,9201166,9161261,9161262,9161263,9161264,9161265,9161266,9161267,9161268,9161269,9161270,9161271,9161272,9161273,9161274,9161275,9161276,9161277,9161278,8549551,8549552,8549553,6670747,6670748,6670749,6670750,6670751,6670752,6670753,6670754,6670755,6670756,6670757,6670758,6666943,9207092,6679540,10116051,10116052,10116053,10116054,10116055,10116056,10116057,10116058,10116059,10116060,10116061,10116062,10116063,10116064,10116065,10116066,10116067,10116068,10116069,10116070,10116071,10116072,10116073,10427441,10946421,10946422,10946423,10946424,10946425,10946426,10946427,10946428,10946429,10946430,10946431,10946432,10946433,10946434,10946435,10946436,10946437,10946438,10946439,10946440,10946441,10155522,10155523,10155524,10155525,10155526,10155527,10155528,10155529,10155530,10155531,10155532,10155533,10155534,10155535,10155536,10155537,10155538,10155539,10155540,10155541,10155542,10155543,10155544,10155545,10155546,10910350,10166438,7000695,10917954,10917955,10905472,10905473,10905474,10915725,10915726,10915727,10895995,10895996,10895997,10895998,10895999,10896000,10896001,10896002,10896003,10896004,10896005,10167582,10172599,10172600,10177652,10876700,10876701,10876702,10876703,10876704,10876705,10876706,10876707,10876708,10876709,10876710,10876711,10876712,10876713,10876714,10876715,10876716,10876717,10876718,10876719,10876720,10876721,10876722,10876723,10876724,10876725,10876726,10876727,10876728,10876729,10876730,10876731,10876732,10876733,10876734,10876735,10876736,10876737,10876738,10876739,10876740,10876741,10876742,10876743,10876744,10876745,10631438,10644300,10644301,10644302,10644303,10644304,10644305,10644306,10644307,10644308,10644309,10644310,10644311,10644312,10644313,10644314,10644315,10644316,10644317,10644318,10644319,10644320,10587529,10587530,10587531,10650625,10650626,10650627,10609717,10603722,10603723,10603724,10603725,10603726,10603727,10603728,10603729,10603730,10603731,10603732,10603733,10603734,10603735,10603736,10603737,10603738,10603739,10603740,10603741,10603742,10603743,10603744,10603745,10603746,10603747,10603748,10603749,10603750,10603751,10603752,10603753,10603754,10603755,10603756,10603757,10603758,10603759,10603760,10603761,10603762,10603763,10603764,10603765,10603766,10603767,10603768,10603769,10603770,10603771,10603772,10603773,10603774,10603775,10603776,10648993,10478943,8562627,10407810,10407811,10407812,10407813,10407814,10407815,10407816,10407817,10463472,10407818,10463473,10407819,10463474,10407820,10463475,10407821,10463476,10463477,10463478,10463479,10463480,10463481,10463482,10463483,10463484,10463485,10463486,10463487,10463488,10463489,10463490,10463491,10463492,10463493,10463494,10463495,10463496,10463497,10463498,10714891,10489369) 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'