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(8838482,8838483,10873315,11014793,11014794,11014795,11014796,11014797,11014798,10870898,10870899,11041372,11041674,11041675,10846863,9216076,8622357,8584094,10868992,8837427,8837428,8837429,8837466,8837467,11013752,11013777,11013778,11013779,11013780,11013781,11013782,11013783,11013784,11013785,8837639,8837640,10962090,7067685,10873096,11040501,11040502,11040503,11040504,11014566,11014567,8911019,8911020,7064526,11012251,11012480,11012551,11012552,11012553,11012559,10843634,3899605,11012982,11013032,7202594,8619222,8619288,11013334,8837141,11013480,11013481,10933237,10985231,10856054,8615701,10840706,10864814,3236991,3236992,10971286,11019646,11019687,11019688,11019717,7156615,7156616,7156757,10967945,7156989,11033454,11033455,11033456,11033457,7157329,3924210,3924216,8555177,11018973,11018974,11018975,11018976,11006033,10837203,11006268,11019459,11019460,11019461,11019472,11019473,11019474,11019475,11019476,11019477,11019478,11019481,11019482,11019483,11019484,11019485,11019486,11019487,11019488,11032497,11032502,11032503,10990660,10990661,10990662,10990663,10925621,10925622,10925623,11016853,11016854,11016855,11016856,11016857,11017080,11017081,11017089,3581930,10848566,10930780,10930781,11004869,8577595,8611311,10917110,10917111,10917175,10917176,10917177,10917178,8541239,8541240,8541244,9915823,9915873,9916100,9915385,9915391,4974342,9201638,9201639,9201640,7023330,7023331,4974982,4974983,4974984,4974985,4974986,3286009,3286010,6674818,9912981,7024836,7024837,7024838,7024839,7024840,7024841,7024842,7024843,7024844,7024845,7024846,7024847,7024848,7024849,7024850,7024851,7024852,7024853,8917951,8917952,8918235,9176808,9200999,9169161,10418137,10117429,8864985,9174547,9174548,9174549,8569150,9206850,9206851,6666867,6666868,8550199,6679586,10470005,10470006,8563419,9175545,6679794,9160272,10179485,10179486,10179487,10913529,10893584,10893585,10179688,10179689,10913709,10913728,10913729,10913730,10913731,10913732,10913733,10914024,10914025,10914026,10914027,10914079,10914080,10914081,10914082,10914083,10914084,10914085,10914086,10914087,10914088,10914089,10914090,10914091,10914092,10914093,10914094,10914095,10914096,8594194,10170819,10183960,10913387,10181685,10187177,10187599,10187685,10188005,10178072,10178073,10178074,10178239,10178240,10178241,10178242,10178243,10178244,10178249,10601255,10601256,10601257,10574487,10569050,10650222,10584369,10584370,10572649,10572650,10572651,10653789,10653790,10587883,10587884,10587885,10573033,10573034,10573035,10573036,10573037,10573038,10573039,10573040,10573041,10573042,10573043,10573044,10573045,10573046,10573047,10582063,10582064,10582065,10582066,10654205,10654206,10654207,10573263,10570637,10570638,10607549,10573723,10573724,10573725,10573726,10573727,10573728,10573729,10573730,10573811,10573812,10573813,10573814,10573815,10573816,10573817,10573818,10573819,10573820,10573821,10573822,10573823,10573824,10573825,10573826,10573827,10573828,10573829,10573830,10573831,10573832,10573833,10573834,10573835,10573836,10573837,10573838,10573839,10573840,10573841,10573842,10573843,10573844,10573845,10573846,10573847,10573848,10573849,10573850,10573851,10573852,10573853,10573854,10573855,10573856,10573857,10573858,10573859,10573860,10573861,10573862,10573863,10573864,10573865,10573866,10573867,10573868,10573869,10573870,10573871,10573872,10573873,10573874,10573875,10573876,10573877,10573878,10573879,10573880,10573881,10573882,10573883,10573884,10546287,10539066,10539067,10421278,10422536,10423844,10424005,10487293,10493644,10493645,10493646) 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>