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(10845745,4970908,4970909,4970951,8583464,8583465,7074273,10871676,10871699,8575615,10871755,10871756,8576057,8620015,8620041,8620042,10872523,10961957,10872627,8620272,8620287,8573665,8573846,8838166,11001540,11001541,8617776,8835438,10972743,10972824,10972880,7072256,11012303,7072638,10999343,10999344,7072777,7072870,7073060,7073061,7073101,8836692,5654805,8619459,8619528,8619661,10102205,10942743,8616982,8617063,8617096,8617276,8617397,8617398,8617496,8617497,8617498,7071758,4430453,8617684,8617685,8617686,3655590,3925612,3925723,10863643,10970049,3925842,8615305,8615326,3925922,3926012,3656242,3656243,3656244,11035583,10970793,8909189,8909404,8909824,3927165,8073510,10942490,8909990,8909991,10618051,10618062,8906101,11032801,11032802,11032803,11032804,11032805,8906247,8906248,8906249,7156807,10928818,8906428,10919057,10919058,10968843,7157822,7158013,7158088,8907670,10969433,10918220,10918416,10920587,10920813,10920814,10920815,10920816,10920888,10921010,10921011,10921012,8576682,8576683,10921140,8576874,10921296,10921297,10615803,8577079,10921439,10921528,8577184,10921577,3231704,8577486,8577487,10921919,10921920,10921943,10922037,10922038,10922039,10922040,8853234,6678013,6678014,8853985,6678386,6678387,9916444,9195315,9203354,9171359,10557188,9203402,9913724,9913756,10557363,10557364,10557365,9203570,9913788,9913789,9913790,9195590,9195591,9195592,9195671,9195672,9195673,9203705,9195736,9187743,9195831,9195832,9195833,9195834,9203884,9203885,9187937,9196113,9196128,7058298,7058310,9196575,9196637,9172897,8849185,8849186,9193416,9193721,4974603,4974604,4974605,9177815,9177816,9177817,9177818,9177819,9177820,9177821,9177822,8849648,10555680,10555681,10555682,10555683,10555684,10555685,10555686,10555687,9193975,9193976,9202017,9202101,9202150,9202151,9194206,9194207,9194208,9194209,9202328,9194395,9194396,9194529,9194663,9194755,9194756,9194781,10556604,10556605,10556606,10556607,10556608,10556609,9202895,9194963,9194964,9194965,6675178,10556823,10556824,10556825,10556826,7057179,10556827,10556828,10556829,10556955,10556956,10556957,10556958,10516971,9203158,9195186,9195187,9195188,9200519,9200520,8848492,8848493,10428115,9200863,9200893,8854174,9916601,9916685,8854343,9916804,8854527,8854528,10123347,8847425,10124157,10124193,10124225,8847871,10124274,9200100,6680425,6680426,6680427,9200241,10174524,10628040,10628080,10174722,10908791,10908792,10888880,10883922,10908951,10165098,10165099,10165280,10180301,10180302,10180303,10909335,10909336,10909424,10904565,10904566,10165606,10180708,10180709,10914723,10909770,10909771,10904780,10909841,10909880,10181039,10166129,10880217,10181315,10181316,10629948,10183767,10183768,10183769,10153860,10913014,10913015,10888118,10888119,10913202,10913203,10913204,10164289,10164290,10164291,10164292,10164293,10174391,10181574,10181575,10890801,10890806,10890885,10890886,10890997,10182105,10182106,10182267,10182268,10182324,10172354,10906390,10906391,10182409,10177412,10177451,10162585,10182691,10182692,10182861,10906909,10906910,10183015,10183100,10183182,10183183,10183269,10887323,10183356,10631903,10571556,10571557,10577626,10577627,10577628,10577629,10577630,10577631,10577632,10577633,10577634,10577635,10577636,10577637,10577638,10577639,10577640,10568773,10568774,10568914,10652980,10652981,10577971,10575014,10575015,10575016,10575017,10575018,10572045,10572046,10578110,10575278,10575279,10575280,10575281,10575282,10575283,10578463,10578464,10578465,10578466,10578467,10578468,10578469,10578470,10578471,10578472,10578473,10578555,10575711,10579317,10579318,10579319,10579320,10579321,10579322,10579323,10579324,10579325,10604210,10601622,10601623,10577005,10577006,10649157,10551220,10551221,10551222,10551323,10551324,10551325,10551326,10553328,10551397,10539551,10539552,10523576,10523577,10523578,10523579,10523580,10523581,10523582,10539594,10539595,10539596,10553678,10553679,10553680,10553681,10553682,10553683,10553684,10553685,10553686,10553687,10553688,10553689,10553690,10553691,10553692,10553693,10553694,10553695,10553696,10553697,10553698,10554096,10554097,10554098,10554099,10554100,10524144,10536191,10536192,10536193,10536194,10536195,10554324,10554325,10554326,10554327,10554328,10554329,10554330,10554331,10554332,10554333,10554334,10554335,10554336,10554337,10554338,10554339,10554340,10554341,10554342,10554343,10554344,10554345,10554346,10554347,10538391,10550581,10536666,10534720,10534721,10534722,10534723,10528743,10528758,10528759,10552768,10552769,10552770,10552771,10552772,10552773,10540841,10528858,10528859,10528860,10532959,10532960,10554993,10554994,10554995,10554996,10554997,10554998,10554999,10555000,10555001,10555002,10555003,10555004,10555005,10555006,10555007,10555008,10555009,10555010,10555011,10555012,10555013,10555014,10555015,10555016,10555017,10555018,10555019,10555020,10535060,10535061,10535062,10535063,10535064,10535065,10535066,10535067,10535068,10535069,10535070,10535071,10535072,10535073,10535074,10535075,10535076,10535077,10423087,10493905,10493957,10487962,10488046,10494064,10494177,8562571,10477886,10477887,10477978,10478020,10478141,10493791,10487839,10493863) 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'