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(8630632,8630643,8630907,8630908,8631103,8631104,8631384,8631385,8631386,8631387,8631388,8631389,8631390,8631391,8631392,8631393,8631394,8631395,8631396,8631397,8631398,8631399,8631401,8631402,8631403,8631404,8631413,8631414,8631415,8631416,8631417,8631418,8631419,8631422,8631423,8631424,8631425,10862069,8631428,8631429,8631430,8631431,8631432,8631433,8631434,8631435,8631437,8631438,8631439,8631440,8631441,8631442,8631443,8631450,8631451,8631509,8631565,8631919,8632270,8632294,8632295,8632296,8632297,8632308,8632309,8632310,8632311,8632315,8632316,8632317,8632318,8632325,8632326,8632346,8632347,8632348,8632349,8632449,8632450,8632451,8632458,8632459,8632460,8632466,8632575,8629705,8630223,8630280,8630282,8630283,8620482,8630449,8630452,7201220,7201221,8627659,8627660,8627661,8627662,8627664,8627665,8627666,8627667,8627669,8627670,8627671,8627672,8627674,8627675,8627676,8627677,8627679,8627683,8627684,8627685,8627686,8627689,8627690,8627691,8627692,8627728,8628170,8628232,7202079,8628491,8628725,8628727,7202385,7202392,7202410,7202413,8628818,8628819,8628824,8628827,7202427,8628828,8628833,8628834,8628835,8628840,8628841,8628844,8629166,8629251,8629258,8626958,7200605,8627251,8627252,8627253,8627293,8627380,8627425,8627429,8627431,8627435,8627440,8627442,8627444,8625507,8625631,8625632,8625633,8625659,8625660,8625661,8625662,8625663,8625664,8625665,8625666,8625667,8625668,8625669,8625670,8625671,8625672,8625673,8625674,8625675,8625676,8625755,8625757,8625758,8625759,8625763,8625764,8625765,8625766,8625767,8625768,8625769,8625948,8625949,8625950,8626117,8626178,3923593,10623507,10838919,10838920,10838921,10838922,10838923,10838924,7197709,7197712,8624434,8624462,8624463,8624503,8624508,8624509,10619895,8624514,10619896,8624517,8624546,8634632,8634673,8634674,8634675,8634676,8634776,8634777,8634779,8634783,8634784,8634789,8634790,8634791,8634792,8634793,8634794,8634797,8634846,8634847,8634848,8634849,8634850,8634851,8634852,8634853,8634854,8634855,8634856,8634857,8634858,8634859,8632591,8632592,8632598,8632599,8632600,8632601,8632637,8632638,8632639,8632640,8632641,8632642,8632643,10620080,8632794,8632801,8632803,8632804,8632957,8632958,8632971,8632972,8632987,8632988,8632993,8632994,8633005,8633006,8633009,8633010,8633013,8633014,8633015,8633016,8633031,8633034,8633035,8633037,8633038,8633039,8633043,8633044,8633045,8633049,8633050,8633051,8633060,8633061,8633066,8633075,8633076,8633085,8633086,8633091,8633092,8633095,8633096,8633202,8633210,8633212,8633214,8633216,8633250,8633279,8633544,10611649,8567072,8567073,9204760,10610691,6672829,6672830,6672831,6672832,6672833,6672863,6672865,6672866,6672868,6672869,6672871,6672872,6672874,6672875,6672877,6672882,6672883,6672885,6672886,6672887,6672888,6672890,6672893,8563358,8563359,8551315,10883568,10883624,10883627,10883629,10883668,10630176,10630177,10631239,10631242,10579795,10579810,10579811,10579822,10508123) 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>