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(10939537,10939618,10939628,10962658,10962659,10962660,10962661,10962662,10962663,10939703,11001744,7076123,7076124,7076127,7076128,7076129,10939848,10939868,10939909,10939914,10939915,10939916,4970670,4970671,10940061,7068404,10989096,4970775,8569453,10940228,10976456,10940507,10940524,7065831,7065833,7065834,7065835,7065836,7065837,7065838,7065839,8066998,8066999,7065946,8067275,8067286,4968623,8067368,8067369,7066348,7074355,7074366,7074367,7074368,7074369,10990291,10990297,10437568,10964440,10964447,7066766,7066823,8067903,10938787,10938791,10938795,10938797,10938832,10938854,7067254,11001097,11001098,7075578,10962360,10962361,10939492,10939511,7071829,10959571,10960064,7064386,10999126,10986174,7064592,10960354,10960411,10960412,10960413,7064733,7064736,7064760,7064761,10986516,7064863,7064878,8065953,8065954,8065955,8065956,8065957,7064892,7064911,7064912,7064926,7064947,7064977,7064984,7064985,7064986,10999789,10999790,10999803,10999815,10999818,10999822,10999823,10999889,10999896,10999897,10960948,7073317,11000017,11000018,11000019,11000020,10932783,10932785,10932790,10932792,10932793,11000039,11000040,10932796,11000041,11000042,11000043,11000044,11000045,11000046,11000047,10932806,10932807,10932808,10932809,10932810,10932932,10932962,10932963,10932964,10932965,10932969,10932970,10932973,10932974,10932975,11000314,10942534,10942535,10997519,10997562,10997564,10942710,10942712,10942714,10942715,10942743,10942745,8860980,10942799,10942804,10942812,10942817,10997794,10942861,10942913,10942994,10943019,10943044,10943113,10943122,7071514,7071523,7071524,10943248,10943256,10943270,10943290,10943304,10943308,10995579,10944411,10940633,10995711,10995720,10940883,10944733,10940969,10940993,10940998,10941002,10941061,10941103,10941128,10941195,10941234,10941296,8859500,7069606,10941391,10941400,3656385,3656393,10996415,10941636,10941651,10941682,10941692,10941745,10941749,10941756,10996738,10996739,10996740,10996742,10996743,10996744,10941780,10996895,10996896,10996897,10996898,10996899,10996900,10996901,10996902,10996903,10996904,10996905,10996906,10996907,10996908,10996909,10996910,10996911,10941948,3656933,10941961,10941969,10941979,7070342,10942147,8860337,10942222,10942286,10942304,8860498,10942344,10942347,10942348,10942350,10942357,10942358,10942361,10942366,8073529,10993602,10623177,10967933,10955115,10623719,10623720,10623721,10623722,10968420,10968462,10981552,10624627,10624628,10624632,10624633,10995358,10995366,10995367,10995373,10619836,10995376,10995377,10995378,10619891,10619900,10619905,10619928,10953509,10953510,10953511,10953513,10922499,10922500,10922501,10922502,10922503,10922504,10922505,10922506,10922507,10922508,10922509,10922510,10922511,10922512,10922513,10922514,10617324,10617326,10617342,10617351,10617355,10617357,10617358,10617359,10617360,10622365,10617366,10617367,10617368,10617370,10617371,10617377,10617381,10617384,10617385,10922895,10617386,10617387,10617388,10617389,10922899,10617390,10922900,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617402,10617403,10617404,10617405,10617406,10617407,10617408,10617409,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617418,10617419,10617420,10617421,10617422,10617423,10617424,10617427,10922949,10617449,10617450,10928010,10928011,10617511,10954310,10928302,10928303,10993360,10954360,10993361,10993374,10993379,10993392,10993393,10993394,10993395,10993396,10993397,10993398,10614995,10620082,10620087,10620088,10620089,10620092,10620093,10620094,10615178,8570011,10620189,10620190,10620191,10620192,10620193,10620194,10620202,8570040,10990760,10990761,8570100,8570117,8570122,10615329,10615330,10615341,10615342,10964891,10964892,10620797,10930666,10615896,10930720,10615938,10615939,10991501,10965556,10616023,10616056,10616075,10926651,10926654,10991731,10931016,10616210,10616211,10616219,10616220,10616228,10616229,10616248,10616252,10616253,10616258,10616267,10616268,10616287,10616295,10616298,10616302,10616303,10616311,10616323,10616324,10616329,10616332,10616333,10616341,10616342,10991882,10616348,10616350,10616351,10616353,10616370,10616375,10616387,10991926,10991927,10616389,10991928,10991929,10991930,10991931,10616393,10991932,10616394,10616395,10616397,10616400,10616401,10616407,10616410,10616411,10616412,10616416,10616417,10616423,10616426,10616430,10616431,10616440,10616441,10616443,10991989,10616453,10616459,10992002,10922143,10616648,10922251,10922252,10922253,10922254,10922255,10927263,10927264,10922269,10922270,10922271,10922272,10922273,10922274,10922275,10922277,10992331,10922442,10922451,10610984,10610985,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10611025,10614038,10614039,10614040,10614041,10614042,10614043,10614044,10614045,10614046,10614047,10614048,10614049,10614050,10614051,10614052,10614053,10614054,10614055,10614056,10614057,8864074,7059757,7059787,7059800,7059859,9173715,9173716,9173718,9173720,9173721,9173722,9173724,9173726,9173727,9173728,9173729,9173730,9173731,9173734,9173736,9173739,9173742,9173743,9173746,8864279,8864323,10614497,10614498,10559706,6665932,9173983,10611658,9174017,9174068,9174080,9174084,10611758,9166129,9174154,10611835,6666211,6666214,6666217,6666220,10611940,10612050,8862099,10612381,8862394,8862481,9172146,10609839,10612939,10609943,8862850,8862865,10613017,10610030,7058534,10610095,10610096,8862959,8862960,7058620,10613127,10613137,9172520,9172521,9172522,10613214,10613215,10610306,10610307,10561523,10561524,10561564,10561565,10561566,10561567,10561568,10561569,10610434,10610449,10613475,10564883,10613736,10610739,10613740,10613760,9173114,10613797,9173137,9173272,9169378,9169475,9161492,7055723,10515377,7055775,4974543,7055932,4974643,4974717,4974718,4974725,4974728,4974729,4974734,4974735,4974736,4974737,4974738,4974740,4974741,4974742,4974743,4974744,9161894,9161896,7056091,9169937,9169951,9169952,9169953,7056270,7056309,10513974,9162163,7056339,10516162,10518649,10518650,10518666,10518671,10518677,10518682,10518684,10518688,10518689,10518701,10518704,10512782,7057197,7057450,4973308,10416397,10416398,10416405,10416429,10419468,10419478,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419495,4973434,4973436,10415575,10415576,10419668,10419671,10419672,10418676,10419684,10418689,10418691,10418692,10418701,10418702,10418703,10418704,10419704,10419706,10418707,10419708,10419709,10419711,10419714,10419715,10419718,10419721,10419724,10419730,10415730,10419731,10419733,10419743,10419753,10419754,10419755,10419756,4973736,10418824,10418825,9168937,9168938,9168939,9168940,9168941,10418863,10419897,10419904,10419905,10419906,10419907,4973903,9169078,9169079,9169080,9169081,9169082,9169083,9169084,9169085,9169086,10420016,7055299,10419109,10417113,10417115,10417117,10417118,10417127,10417134,10417141,10417142,10417146,10417158,10417160,10419190,7055446,8864869,8864930,8864940,8864941,10463003,10463007,8864957,10463030,10463032,6666503,10471171,4971471,4971473,10467218,10467219,10467220,6666650,8865186,8865187,10469277,10469278,10469382,10469383,10469384,10463400,9166826,9166828,8916476,9166855,8916760,10463730,10463740,10463754,10465768,10465776,9167233,6667234,9167238,9167239,10467838,8563251,10463931,8563299,4972257,8563362,8563363,10468234,10468237,8917337,10466324,10466394,10462402,6667868,10462510,9168100,4972972,4972973,6668128,10462727,6668177,8917857,10466846,10466853,10627985,10627986,10159562,10628380,10628381,10628382,10628383,10155856,10627085,10627145,10632160,10632161,10632162,10632163,10632164,10632165,10163939,10158966,10627587,10627589,10627775,10161660,10630189,10630244,10630245,10630272,10631238,10631239,10631240,10626241,10631243,10631244,10626291,10631425,10631426,10631451,10631452,10631453,10631454,10626710,10626815,10568114,10568115,10568116,10568117,10568119,10568120,10568123,10568124,10568126,10568127,10568128,10568130,10568294,10568295,10568296,10568297,10568298,10568299,10568300,10568301,10568302,10568303,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568313,10568314,10568315,10521691,10521692,10521696,10522292,10522297,10522298,10522302,10522303,10522304,10522307,10522354,10522355,10522356,10522357,10522358,10522359,10522360,10522594,10522595,10520756,10520783,10524867,10524868,10522946,10422280,10422348,10420425,10420428,10420429,10420430,10420431,10420435,10421603,10420629,10420711,10420848,10420849,10420851,10420873,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10421965,10423162,10477099,10477100,10477382,10477383,10473694,10474075,10474076,10474077,10474078,10474079,10474080,10474081,10474082,10474083,10474084,10474085,10474086,10474087,10474088,10474089,10476506,10476507) 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'