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(10943493,10939940,10939941,10939942,10950305,4971082,10862169,8631597,11041661,11041662,10950606,10849379,10951030,8622317,10862795,10862796,8622468,8622469,10964446,10964447,10964448,10964449,10964450,8629602,10860302,8629670,7067929,8911230,8559177,10866537,10866561,7201551,7201565,10866622,10866630,10866638,10866645,10866658,10866662,10866665,10866666,10866667,10866668,10866669,8595101,8618366,8618367,7201848,7201975,10960568,10960569,8065954,8065955,8065956,8065957,8065958,8628725,8618972,10999890,8836868,8836869,5654793,10932976,10932977,3227207,3227259,10102115,10102116,7200506,8626907,8626908,8626909,8626910,8626916,8626917,8626918,8626919,10958989,8910573,11037226,11037227,4430183,4430184,4430185,4430186,10866012,10866013,8558674,8558675,10866018,8558676,8558677,10866019,10866020,8970231,8970232,10855405,10855406,7198366,7198367,7198368,7198369,7198381,7198387,8615016,8908441,10840156,10840157,10840158,10840159,10840160,10840161,10840162,10840163,10840164,7198679,7198680,7198703,8908517,7198710,7198713,7198714,7198716,7198728,7198729,7198731,7198752,7198766,11009245,11009246,11009247,11009248,11009249,11009250,11009251,11009252,11009253,11009254,11009255,11009267,11009268,11009269,11009275,8564678,7069986,8557315,10864700,10101564,7196472,7196890,3234102,3234114,3234115,3234121,3234122,3234124,10838530,10838544,8906883,10968571,10838969,10838990,8907513,8907514,3234918,3234945,11008218,3234969,7197797,3234972,3234977,3234978,8624550,10922515,8541550,8541570,8541578,10836844,8905151,10836848,10836849,10836850,10836851,10836852,8905221,8905248,8905251,8905254,8634957,10617339,10617343,10617344,10617346,10617347,10617348,10617349,10617350,10617351,10617352,10617353,10617354,10617355,10617361,10617362,10617363,10617364,10617365,10617370,10617372,10617377,10617386,10617400,10617406,10617413,10617445,10617447,3232904,8612415,8612416,8612417,8612418,8612419,8612420,8612421,8612422,8612423,8542251,3233159,8905844,8632605,8632606,10615167,10848007,10620289,10620290,10620291,10620292,9217222,9217223,9217224,9217225,9217226,9217227,7154417,7154419,7154429,10426338,10616005,10616044,8540569,8541007,3232023,10852018,8634456,8634465,11044552,11044554,10562112,10562113,10562114,10562115,8853174,8853175,8853176,8853210,10562202,10562203,10562204,10562205,10562206,10562207,10562208,10562209,10562210,10562211,10562212,9915606,10562213,10562214,10562215,10562216,10562217,10562218,8864010,7059757,9197709,9197710,9173711,9197711,9197712,9197713,9197714,9197715,9197716,9197717,9197721,9173739,9173740,9173741,9173742,9173743,9173744,9173745,9173746,9173747,9173748,9173749,8853592,10611470,10614504,10614505,10611523,8864503,8864504,8864505,8864506,8864509,8864510,10611946,10609035,9913611,9913612,9211561,10612381,9211915,10612961,9212321,9212324,8567056,8567059,8567061,10610479,10610480,10610481,10613739,9173121,10562034,10562035,10562036,10562037,10562038,10562039,10562040,10562041,10562042,10562043,10562044,10562045,10562046,10562047,10562048,10562049,10562050,10562051,10562052,10562053,10562054,10562055,10562056,10562057,10562058,10562059,10562060,10562061,10562062,10562063,10562064,10562065,10562066,10562067,10562068,10562069,10562070,10562071,10562072,10562073,10562074,10562075,10562076,10562077,10562078,10562079,10562080,10562081,10562082,10562083,10562084,10562085,10562086,10562087,10562088,10562089,10562090,10562091,10562092,10562093,10562094,10562095,10562096,10562097,10562098,10562099,10562100,10562101,10562102,10562103,10562104,10562105,10562106,10562107,10562108,10562109,10562110,10562111,10117529,9185346,9169356,8849317,8849318,8849378,9911802,8592966,8592967,10517693,9169937,9169945,9169946,9169947,9169948,10118171,6674327,9912541,10118608,10118609,10514390,8850512,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10516910,10516911,8850978,9913365,9913366,10416358,10416359,9176445,9176446,10419470,6672774,6672775,10419507,10419512,10419518,10419531,10419534,10419536,10419537,10419538,8848755,8848756,8848757,8848758,9168939,10415875,6673267,6673289,10418018,10419167,10419174,10419175,10419176,8550263,9167324,10115555,10115556,10115557,10115558,8847268,8847273,8847274,10123653,10123654,10123658,10123659,10123660,10123661,10123662,10123663,8847310,8847487,8847488,9167682,976493,10468324,10468327,10468329,976584,10468416,9167988,8848024,8848025,8848026,8848027,8848028,9160290,9160291,9160292,9160293,9160294,9160295,9160296,9160297,10883560,10883561,10883593,10883660,10884042,10884078,10884089,10894125,10894126,10894127,10894128,10889776,10874974,10890131,10890134,10890135,10890136,10890151,10890153,10890164,10885347,10892690,10888032,10883073,10910877,10885956,10162113,10162242,10172747,10887022,10887098,10892200,10892201,10892202,10892203,10892204,10892205,10892206,10892207,10892208,10892209,10892210,10892211,10892212,10892213,10892214,10892215,10892216,10892217,10892218,10892219,10892220,10892221,10892222,10892223,10892224,10892225,10892226,10892227,10892228,10892229,10892330,10950152,10950153,10892384,10163475,10887464,10646255,10602163,10602171,10602172,10602173,10602179,10602180,10602181,10602189,10602236,10643547,10602691,10602692,10602701,10602702,10602705,10608831,10603683,10603684,10603689,10603690,10603694,10601436,10601440,10651654,10651655,10651656,10651657,10601448,10601453,10601454,10601455,10601456,10601457,10601464,10601687,10601688,10601697,10601698,10601699,10601706,10545356,10545357,10545358,10545371,10545372,10545373,10545390,10545391,10547872,10547904,10528659,10528665,10528666,10528670,10543042,10421274,10421389,10423512,10420570,10423582,10421618,10421834,10486108,10486126,10486127,10486154,10486155,8562502,10486561,10477872,10477873,10477874,10477875,10477876,10477877,10496981,10408563,10410583,10410584,10493255,10414645,10406985) 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'