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(8594578,8594579,10873391,10873392,10930418,10930419,10930420,8838670,8838671,8838672,8838673,8838674,8838675,8838676,7076247,10448369,10448370,10448371,10448372,10448373,10448374,10448375,10870902,8621668,8621669,8621670,8621671,8621672,8621673,8621674,8621675,8621676,8621677,8621678,8621679,8621680,8621681,8621682,8621683,8631538,8631540,10933368,10933369,10933370,10933371,10933372,10933373,7073983,7073984,10950887,10950888,8622247,8622288,10847221,10847223,11042234,11042235,11042236,11042237,11042238,11042239,11042240,11042241,11042242,11042243,11042244,11042245,11042246,11042247,11042248,11042249,11042250,11042251,11042252,11042253,11042254,11042255,11042256,11042257,11042258,3230025,3230026,3230027,3230028,3230029,3230030,3230031,3230032,3230033,10868947,10868950,10868951,10868952,10990355,10990356,10868962,10868963,8067750,8067751,8067752,7066748,7066749,7066750,7066751,7066752,7066753,7066754,7066755,7066756,7066759,7066760,7066761,7066762,7066763,7066764,10437740,8629478,8629480,8629481,8629482,8573403,8573404,7075417,7075418,7075419,7075420,7075421,7075422,7075423,7075424,7075425,7075426,7075427,7075428,7075429,7075430,3228030,3228031,10962363,10962364,10962365,10962366,10962367,10962368,10860978,10962380,10962400,10962401,10962402,10962403,10962404,10962405,10962457,10866167,8617848,7201299,8835591,8835592,8835600,8835616,8835628,8835629,8835640,10103382,10103383,10103384,10103385,10103386,8594946,3238769,8075307,8075308,8075309,8075310,8075311,8075312,8075313,8075314,8075315,8075316,8075317,8075318,8075319,3898998,8559518,10932088,8559835,8559836,8559838,8559856,8559857,8559858,8559880,8559898,8559899,8559900,8559917,10867330,10867331,10867332,10867333,10867334,10867335,7073172,10104382,10104383,10104384,8596067,8560531,8560532,8560533,8560535,8560536,8560537,10844501,10844502,10844503,10844504,10933191,10844505,10844508,10844509,10844510,3237295,3237296,3237297,3237298,3237299,3237300,3237301,3237302,3237303,3237304,3237305,3237306,3237307,3237308,3237309,3237310,3237311,3237312,3237313,3237314,3237315,3237316,3927597,8626947,8834873,10985071,10985072,8861414,8861415,8861416,8861417,10998413,10998414,10839630,10839631,10839632,10839633,10839634,10839635,10839639,3235756,3235757,3235758,3235759,10944866,10944867,10944868,3926311,3926312,3926314,10996693,3656709,3656710,3656711,3656712,3656713,3656714,3656715,10856525,11035968,3657274,8557539,8557540,8557541,8565326,8565327,8565328,8557575,10865031,10853159,8579065,8579066,10618238,10618239,8554195,10838134,10838135,10838136,10838137,10838138,11007126,11007127,11007128,11007129,11007130,11007131,11007132,11007133,11007134,11007135,11007136,11007137,11007138,11007139,11007140,11007141,8554584,8554589,8554590,7157490,3235016,3235017,3235018,3235019,3235020,3235021,8624256,3232379,8611861,8611862,8611863,8611864,8611865,8611866,8611867,8611868,8611869,8611870,8611871,8611872,11044940,11044941,11044942,11044943,11044944,11044945,11044950,11044951,11044952,11044953,3230411,8570402,8570403,10952265,8633330,10952478,10952479,10930983,10930984,10926731,10926732,10926733,10926734,10926735,10926736,10926737,10926738,10926739,10926740,10926741,10851958,10614070,7059598,7059599,7059600,7059601,7059602,7059603,9189587,9189588,9189589,9189590,9189591,9189592,9189593,9189594,9189595,7059762,9189596,10714210,10714473,10714474,10714475,6666008,9214027,7057720,7057721,9211734,9211735,9211736,7057922,9171956,9171957,9171958,9171959,9171960,9171961,9171962,9171963,9171964,9171965,9171966,9171967,9171968,9171970,9171971,9211972,9172006,9172007,8862680,8862681,8862682,8862683,6676372,6676373,6676374,6676375,8862709,3653536,3653541,3653542,3653543,9196443,9196445,9196446,6676693,7058676,7026194,7026195,7026196,7026197,7026198,7026199,10558454,10558455,10558456,10558457,9204784,9204785,4974165,10428741,4974261,4974262,9911849,10513865,10513866,10513867,10513868,10513869,10513870,10513871,10513872,10513873,10513874,10513875,10513876,10513877,10513878,10513879,10513880,10513881,10513882,10513883,10513884,10513885,10513900,10513901,10513902,10513916,9170162,6674847,6674955,6674959,10118987,10118988,10118989,6675079,6675081,6675088,10427710,10419274,10419278,10419285,10418316,8918067,8918068,4973664,4973665,4973666,4973667,4973668,4973669,9208838,9208839,9208840,9208841,9208842,9208843,9208844,9208845,9208846,9208847,9208848,9208849,9208850,9208851,9208852,9208853,9208854,9208855,9208856,9208857,9208858,9208859,9208860,9208861,9208862,9208863,9208864,9208865,9208866,6681314,10420137,10420138,10420139,10420140,4974150,6666527,6666528,6666529,6666530,6666531,6666532,6666533,6666534,8865072,8865073,8865074,8865075,10467175,10467176,8569232,8569233,8569384,9166895,9175064,9191116,9191121,9191122,9191123,9191124,9191125,8916883,8916884,8916885,8855292,8855293,9175491,9167540,8563467,8563468,8563469,8563470,8563471,8563472,8563473,6667604,6667605,8917487,9183980,6668132,6668135,6668136,10893910,8594464,8594544,8069244,8069245,8069246,8069247,8069248,8069249,8069250,8069251,10910049,10910050,7001363,7001364,7001365,10891196,10891197,10891198,10891199,10891200,10891201,10891202,10891203,10891204,10891205,10891206,10891207,10891208,10891209,10891234,10187687,10187688,10187689,10187690,10187691,10187692,10631335,10631336,10631337,10631338,10631339,10631340,10631341,10631342,10631343,10631344,10631345,10631346,10631347,10631348,10631349,10631350,10631351,10631352,10631353,10631354,10163055,10163056,10163057,10163058,10163059,10882406,10882407,10882408,10882409,10882410,10882411,10882412,10882413,10882414,10882415,10646998,10647999,10648000,10648001,10648002,10648003,10648004,10648005,10648006,10648007,10648008,10648009,10648010,10648011,10648012,10654108,10654109,10654110,10654111,10654112,10654113,10654114,10654115,10654116,10654117,10579490,10579491,10654580,10654581,10585890,10585891,10585893,10585898,10585899,10585900,10585901,10585902,10585903,10585904,10585905,10585906,10585907,10585908,10585909,10585910,10585911,10585912,10585913,10585914,10585915,10585916,10585917,10585918,10585919,10585920,10585921,10585922,10585923,10585924,10585925,10585926,10585927,10585928,10585929,10585930,10585931,10585932,10585933,10585934,10585935,10585936,10585937,10585938,10585939,10585940,10585941,10585942,10585943,10585944,10585945,10585946,10585947,10585948,10585949,10585950,10585951,10585952,10585953,10585954,10585955,10585956,10585957,10585958,10585959,10585960,10585961,10585962,10585963,10585964,10585965,10585966,10585967,10585968,10585969,10521346,10542405,10542406,10542407,10542408,10542409,10542410,10542411,10542412,10542413,10542414,10542415,10542416,10542417,10542418,10542419,10542420,10542421,10542422,10542423,10542424,10542425,10542426,10542427,10542428,10542429,10542430,10542431,10542432,10542433,10542434,10542435,10542436,10542437,10542438,10542439,10542440,10542441,10542442,10542443,10421247,10421248,10421249,10421250,10421254,10421255,10424061,10424062,10409362,10411560,10411563,8562940,10408643,10482559,10482560,10482561,10415002) 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<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>