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(10930107,10939603,7075914,10962667,10962676,10873299,8838545,10845921,10861804,10861805,8839045,11015317,10950359,10459449,11041617,11041618,11041649,11041650,10871271,10459578,10459590,10459638,10459643,10459648,10459653,10459677,10459701,10950765,10950766,11015831,10459725,10459749,10459773,10950849,9215914,9215915,8067337,10459883,10459888,10459893,10459935,7066395,10459975,10460015,10460055,11016176,10951134,10460095,11016227,11016231,10460135,9216223,11016264,11016267,10862870,10862871,10862872,10862873,10862874,11016286,11016287,10460175,7066611,7066612,7066616,7066618,7066619,7066624,7066625,7066626,7066630,7066631,7066632,10460215,11016334,11016335,10990351,10990352,10460255,11016381,11016382,10460295,10460335,10437732,10990491,3227387,3227388,7075293,7067609,8838233,8838245,10962460,10962461,10962462,10962463,10962464,10102996,10985772,10103324,10842949,10103386,7201608,10843156,10843157,10843158,10843159,10843160,8075291,8075292,7064531,10932049,10932050,10843771,10859432,10859438,10859443,10859447,10867501,10932755,8560335,10859724,10104661,8837047,7073565,10844375,10104852,10933187,10933189,10933190,7065755,7200100,10958948,8558246,7200592,7200593,10998169,8861396,7071526,11047518,8071712,4938645,8071777,4938646,10839724,8071842,8071907,10863396,8071972,8072037,8072102,8072167,8072232,8072480,8072481,8072482,8625285,8625286,8072496,8625288,8625290,8072508,8072511,8072515,8072520,8072523,8072530,8072569,8072614,8072620,10101106,10101110,3656672,8616161,8616175,8616181,3926869,8860417,10942251,10101690,10101743,10853155,3233331,10993656,10993658,10993659,10993660,10993661,3923374,4936873,3923612,4937038,4937050,4937109,4937114,4937120,4937148,8613269,11007135,11007136,11007137,11007138,4937177,11007139,11007140,11007141,4937198,4937237,4937242,4937249,4937321,4937386,4937451,8554700,4937516,4937581,4937646,10968638,10968639,4937711,8907093,4937776,4937841,4937906,8071079,4937971,8071287,8071299,4938218,4938219,4938220,4938234,8071368,8071373,4938246,8071379,4938249,4938253,4938258,4938261,4938268,8071407,3234992,8071436,4938319,4938325,8071457,10839356,10839364,10839379,8071499,8071504,8071511,8071582,8071647,11018508,11018509,11018579,10617224,10617225,10617226,10852370,11018827,10852622,11019083,11019084,11019086,11019091,11019156,11045221,11045222,11045223,11045224,10617958,8609725,8609726,3230360,8622785,8622786,10460681,10460687,8632847,8632848,8632849,11042922,10460849,10460868,10916010,10460934,10460935,10848152,10848153,10848154,11017110,11017130,8570498,11017226,11017325,11017339,11017346,11017356,11017387,10991388,11017441,11017485,11017498,11017511,10916487,11017516,11017517,10952460,11017518,10930841,11017583,11017590,11017596,11017641,8540530,11017712,3231591,10916861,11017989,11017992,11018209,8541061,11018479,8567977,9165554,10614315,9166038,9166039,6666133,6666136,6666137,6666138,6666139,6666140,9214144,9214201,9190238,8542696,10119797,10609341,10120072,8566390,9914105,9212027,10612889,9172246,9172471,10564458,10564459,9196672,9915067,9205174,4974172,10428700,10428701,4974185,4974221,4974233,4974235,9161399,9161400,4974284,4974288,4974331,10117751,7055806,10515633,10515634,10515635,10515636,10515637,10515638,10515639,10515640,10515641,10515642,10515643,10515732,10515733,10515734,10515776,10515777,10515778,10515779,10515780,9170001,10515909,10515913,10515914,10515915,10515916,10514074,10514075,10514076,10514077,10514078,10514079,10514080,10514081,10514082,10514083,10514084,10514085,10514086,10514087,10514088,10514089,10516134,10516135,6674588,10514368,10514381,10514382,10514383,10514384,10514385,10514437,10514438,10514439,10514440,10514441,10514442,10514443,10514444,10514445,10516494,10118916,10514947,10514948,10514963,10515060,10515061,10515067,10515068,10515069,10515070,6672559,7014079,7014080,7014081,7014082,7014091,7014092,7014093,7014094,9176496,9176497,9176498,10416436,10416437,10416438,10416439,10416440,9910859,4973583,10415652,10415653,4973591,4973592,4973668,4973669,9168872,10416934,6681312,10117393,4974140,6666329,6666330,6666331,6666332,6666333,6666334,6666335,6666336,6666337,6666338,6666339,10471111,4971474,4971475,9916933,6666871,6666909,6671134,6671137,9190932,6671138,6671139,6671140,8550245,10123300,10123301,10469942,8855283,8855284,8550653,8550654,6667599,6667605,976431,976437,10466252,8563593,8563594,9207824,9207825,6667858,6667876,976666,976670,976677,10468518,10468768,10179568,10903627,8594270,10889709,10889710,10890032,10890075,10885313,10178485,10158579,10907610,10907611,10907612,10907613,10178807,10173825,10178833,10627918,10905831,10891312,10891313,10891314,10891447,10891448,10172505,10172506,10172507,10881568,10187611,10187612,10187613,10187614,10177700,10631238,10631239,10631240,10631241,10631242,10631243,10631244,10631245,10177833,10911836,10177856,10876885,10876886,10188007,10178070,10178083,10173281,10887377,10601176,10601177,10601178,10601179,10601180,10598585,10599016,10584142,10603166,10567357,10567358,10567359,10651425,10651426,10651427,10651428,10651429,10651430,10607406,10607410,10607411,10545398,10545399,10545400,10549564,10549590,10525603,10525604,10525605,10545948,10541972,10548706,10508207,10508208,10508209,10509290,10422763,10423993,10423994,10508097,10508098,10484499,10484502,10484503,10484505,10484510,10484511,10484517,10484518,10484521,10413897,10413907,10413910,10413912,10414130,10414159,10487012,10487013,10487014,10487475) 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>