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(10950760,8067924,8067925,8573331,10860516,10860517,10860518,10860519,10860520,10860521,10860522,10860523,10860524,10860525,10860526,10860527,10860528,10860529,10860530,10860531,10860532,10860533,10860534,10860535,10860536,10860537,10860538,10860539,10860540,10860541,10860542,10860543,10939416,7201564,7201565,7201566,7201567,7201568,7201569,7201570,7201571,7201572,7201573,7201574,7201575,7201576,7201577,8595157,8595158,8911630,7200277,7200278,7200279,7200280,7200281,7200282,7200283,10865746,10865747,10865748,10865749,7198420,10101487,10101498,8906772,8906773,8906774,8906775,8906776,8906777,8906778,8906779,8906780,8906781,8906782,10838859,10617463,8905711,8905712,8905713,8905714,10620072,10426244,10616658,10616659,10616660,10616661,10616662,10616663,10616664,10616665,10616666,10616667,10616668,10616669,10616670,10616671,10616672,10616673,10616674,10616675,10616676,10616677,10616678,10616679,10616680,10616681,10616866,10714195,10714196,10614888,8851187,8851192,8851205,8851207,8851218,8851253,8851254,8851375,8851385,10612238,8851424,8851439,8851459,8851473,8851490,8851494,8851540,8851560,8851561,8852693,8852694,8852695,8852696,10613535,10613536,10613537,10613538,10613539,10613540,10613541,10613542,10613543,10613544,10613545,10613546,10613547,10613548,10613549,10613550,10613551,10613552,10613553,10613554,10613555,10613556,10613557,10613558,10613559,10613560,10613561,10613562,10613563,10613564,10613565,10613566,10613567,10613568,10613569,10613570,10613571,10613572,10613573,10613693,6673575,6673576,9169792,9169793,9169794,9169795,9169796,9912045,9912046,10118123,10118124,10118125,6674262,6674263,990475,8849962,9912568,9912569,10118559,10118560,9912570,10118561,9912571,10118562,9912572,9912573,10118563,10118564,9912574,10118565,9912575,10118566,9912576,10118567,2809285,8850770,8850790,8850797,8850799,8850825,8850830,9913222,9913223,9913224,9913225,9913226,9913227,9913228,9913229,8850851,8850852,8850893,8850898,8850900,8851051,8851094,9168921,9168922,9168923,9168924,9168925,9168926,9168927,9168928,9168929,9168930,9168931,9168932,9168933,9168934,9168935,9168936,9168937,9168938,9168939,9168940,9168941,10418958,10418959,10418960,10418961,10117485,10471070,10471071,10471072,10471073,10471074,10471075,10471076,10471077,10469249,10469250,10469251,10469252,10469253,10469254,976510,976511,9167792,9168293,10888652,10888653,10883956,10889548,10889549,10889550,10889551,10889552,10889553,10889554,10889555,10889556,10889557,10889558,10889559,10889560,10889561,10884631,10899928,10890224,10887881,10885859,10885860,10885861,10885862,10885863,10885864,10885865,10885866,10885867,10885868,10885869,10885870,10885871,10885872,10885873,10885874,10885875,10885876,10885877,10885878,10885879,10162072,10162212,10162213,10162214,10162215,10162216,10162217,10647528,10647529,10647530,10647685,10507567,10508030,10414797,10414798,10414799,10414800,10414801,10414802,10414803,10414804,10414805,10414806,10414807,10414808,10414809,10414810,10414811,10414812,10414813,10414814,10414815,10414816,10414817,10414818,10414819,10414820,10414821,10414822,10414823,10414824) 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>