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(10962634,10943524,8630695,3228553,8630973,4970696,4970699,3228963,10963298,10963299,10963300,10963301,10963312,10963313,10963314,10963315,10963316,3229047,10963317,8569623,8583139,8583140,3229152,3229276,8621878,10976733,10950722,10950723,10950724,10950725,10950761,8632315,8632316,8632357,8632358,8632359,8632397,8632398,8632399,8609636,8609638,10938596,10938599,10938604,10938605,8629594,8629595,3227476,3227557,8630260,7067660,7067661,8630442,8630444,8630445,8630447,8630448,8630450,8630451,8630453,10998508,7201233,8594637,8594638,8594639,8594640,8594641,8594642,8594643,8594644,8594645,8594646,8594647,8594648,8594649,8594650,8594651,8594698,8594699,8594700,8594703,7072068,7201399,7201401,7201402,7201403,7201459,7201460,7201467,7064223,7201470,7201474,7201476,7201482,7201486,7201490,7201495,7201496,7201509,7201512,7201513,10103452,10960058,7201728,7201729,3899093,8628341,7201975,8628384,8628385,8628386,8628387,8628388,8628391,8628392,8628398,8628429,8618625,8628491,8628492,7202121,7202165,7202168,7202171,8572118,8572119,8572121,8572122,10104075,8572123,10104076,7202300,7202302,7202304,7202307,7202310,3912110,3912111,3912112,10843904,10986956,10961090,5654772,8629111,8629112,8629116,8629138,8629147,8629148,8629149,8629190,8629194,8629197,8629205,10928832,10928833,8629324,3227187,3227188,3227206,11010585,11010586,3237352,8064267,8064268,8064275,8064278,8064279,10102358,10958949,10958965,7200539,7200581,7200584,8626995,7200667,7200668,7200669,7200670,7200694,7200695,7200696,7200706,7200715,7200786,11011342,8624507,7198115,8624522,8624526,7198173,7198174,10995662,10995663,10995664,10995665,10995666,10995667,10995668,10995669,8624673,8624674,8624675,8624676,7198284,10100181,10100182,10100187,10100188,7198334,7198335,7198336,7198337,7198339,7198395,7198426,10941117,7198679,7198687,7198705,7198728,7198744,7198745,7198747,7198764,7198769,8859514,8859516,8859517,8859518,8859519,8859521,11009308,11009309,11009310,11009311,11009312,11009313,11009405,11009407,11009408,11009409,11009410,8625500,8625501,8625502,8625503,8625504,8625534,8625535,8625536,8625537,8625567,8625568,8625648,8625649,8625650,8625651,8625652,8625653,8625654,8625655,8625680,8616006,8625997,8625999,10101514,10958372,8906074,8906090,10967883,10967884,10967885,3923593,10967886,10967887,10967888,10967889,10967890,10967891,10967895,10967896,3923642,7196554,7196574,3924401,7197602,10839112,11008049,11008050,7197619,8907434,7197660,7197736,7197737,7197738,10619885,10619886,10617087,10617095,8541471,10617123,10617165,8611934,8611936,8611938,8611939,10836967,10836968,10836969,10836971,10836972,10836973,10836974,8541789,10617446,10617447,8541855,8612210,8905500,3922840,3922841,8905507,8905508,8905533,11045204,10954254,10614983,10614991,8609701,8632542,10615219,10615220,10615225,10615232,10425450,10425451,10425452,10425453,10425454,10425455,10425457,10425458,10425459,10425487,10615398,11042939,3581798,10615604,10615615,3581884,3581885,3581886,3581887,10425933,10425937,10425938,10425940,10426012,8633399,8633400,10426151,10615952,10615967,10426196,10426285,10426286,10426287,10426288,10426289,10426290,10426291,10426292,10426339,10426347,8634107,8634108,8611304,8611313,8634146,10616733,10616734,10616735,8611451,8611474,8634354,8611544,8541249,7155282,10427108,10427112,10427113,10616911,10616913,10614078,10614079,10562246,7059643,7059644,8853725,10614567,10614568,6670215,6670224,6670227,6670229,6670242,6670245,6670247,10611813,10612107,7017283,7017284,7017309,7017310,7017311,10612320,7017312,10612321,7017349,7017350,7017351,7017352,7017353,7017354,10612406,10612598,10612620,8851809,10612653,8862526,10612683,8851848,8862575,10612737,10612758,10612763,10612764,10612765,10612766,10612767,10612771,10612782,10612783,10612784,10612785,10612786,10612787,10612800,10612801,10612802,10612803,10612806,10612807,10612818,10612819,8852005,8852009,8852010,8852011,8852012,8852013,10612869,10612927,10612939,10609998,10610027,10610042,8852248,8852261,8852280,8852342,8852347,8852408,10613295,10613350,8852567,10613496,8852734,8852778,8852919,9205227,9205228,10610916,6673505,6673644,9169440,6673660,10515280,10515281,10515282,10117693,10117694,9169639,9169672,9161682,10117961,10117962,10117963,10117964,10118014,10118015,10118016,9169824,10511651,8849713,10511747,6674149,9169966,9170065,8551401,8551403,8551405,8551406,8551412,8551417,8551418,8551423,6674331,8551424,8551427,8551428,8551429,8551430,8551431,8551432,8551435,8849994,990568,990569,990570,990571,990572,990573,990574,990575,990576,990577,990578,990579,990580,990581,990582,990583,990584,990585,990587,10512018,10512019,6674446,8850099,8850109,8850111,10514102,10514103,10514107,8850166,8850167,10514155,10516164,10516165,10118559,10516175,10516176,990779,990780,990781,990782,10118592,990783,990784,990785,990786,990788,990791,990793,990794,990795,990796,10512221,990797,990799,990800,990802,10514227,10118612,990803,990804,990807,990808,990809,990811,990812,990813,990814,990815,990816,990817,990818,990819,990820,990821,990822,990823,990824,990825,990826,990827,990828,990829,990830,990831,990833,990834,990835,990837,990839,990841,990842,990843,990845,10514271,10514272,990848,990849,990851,990852,990853,990854,10512347,10512348,10512349,10512350,10512351,10512352,10512353,10512354,10512355,10512356,10512357,10512358,10514364,7016247,7016248,7016249,7016250,10514418,10512495,10512496,10512497,10512498,8850518,8850554,10514586,10514587,10514588,10514589,10514590,10514605,10514606,10514607,10514608,10119060,10514785,10514786,10514787,10514788,10514802,10514834,10514870,10514871,10514872,10515078,10515079,10515080,10515096,10418299,10417309,6672602,10417367,10416383,10416385,6672691,6672693,6672694,9168529,9168593,9168595,9168687,9168691,9168702,9168703,9168704,9168705,9168706,9168707,9160788,10116986,9160790,9160797,10415719,9160798,9160799,9160800,9160801,9160802,9160816,9160817,9160818,9160819,9160820,9160821,9160827,9160829,9160830,10417016,10117379,10416197,6673484,6673498,6673499,6673500,6673501,6673502,6673503,6673504,8549491,8549492,8549496,10469237,8550207,8550208,8916797,9191228,9191229,9191230,9191231,9175560,9167634,9183745,10466443,9175955,9175956,9168147,10468732,9168159,9168164,9168199,10468785,10468786,10468787,10468788,10468789,10888485,10888487,10888492,10888521,10888526,10888588,10893597,10888602,10883669,10883675,10174689,10628321,10883940,10889077,10884120,10884121,10889486,10889487,10884534,10889540,10884644,10899877,10884926,10885113,10885128,10890130,10890146,10890147,10880199,10880203,10880207,10880208,10880209,10885253,10885254,10885262,10885286,10885288,10890288,10885346,10885349,10887645,10627313,10882847,10882894,10888000,10888011,10888012,10883293,10154305,10154316,10154317,10154318,10888306,10154326,10154340,10154341,10154342,10154344,10154346,10154347,10154349,10154359,10154361,10154363,10154367,10154376,10154377,10154378,10154379,10154388,10154389,10154395,10154398,10154399,10154413,10888432,10890717,10885828,10885921,10885987,10885997,10886097,10886250,10891298,10891348,10886432,10167576,10167580,10626099,10876750,10886779,10886970,10168025,10168027,10168028,10887159,10897166,10882316,10887464,10601358,10566129,10599321,10599322,10599325,10599326,10590463,10590464,10590465,10527477,10527478,10527479,10527480,10527481,10527482,10527483,10527484,10527485,10527486,10527487,10527488,10527489,10527490,10527491,10527492,10527493,10527494,10527495,10527496,10537574,10549796,10549797,10549798,10549799,10549800,10549801,10549922,10549952,10549953,10549954,10549955,10549956,10549957,10549969,10549970,10549971,10549972,10548047,10548048,10528646,10542654,10548751,10528972,10528973,10542990,10542991,10542992,10542993,10542994,10542995,10542996,10542997,10542998,10542999,10543000,10543001,10543002,10543003,10543004,10543005,10543006,10543007,10425227,10425228,10425229,10425230,10425231,10425232,10425233,10425234,10425235,10425236,10425237,10508159,10508160,10508322,10508324,10508338,10508348,10508352,10508353,10508354,10508367,10508368,10508369,10505543,10505544,10505563,10507582,10507672,10507687,10507688,10507689,10507690,10507691,10507692,10507700,10507701,10507702,10507759,10508027,10409311,10407448,10407449,10407450,10407451,10407455,10407457,10407822,10408158,10408160,10408161,10408162,10408163,10410220,10410221,10410222,10410223,10410224,10410225,10410470,10410471,10408822,10408972,10408981,10409053,10409054,10409055,10411079,10411080,10411081,10411082,10411083,10411136,10411164,10411165,10411166) 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'