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(8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8631617,8631680,8631681,8631682,8631683,8631684,8631687,8631688,8631689,8631690,8631822,8631823,10863155,10863156,10863157,10863158,10863184,10863185,10863188,10863189,10863190,10863191,10863192,10863193,10863194,10863195,10863196,10863197,10863198,10863199,10863200,10863201,10863202,10863203,10863204,10863205,10863206,10863207,8573319,8630457,8630459,8630460,8630461,8630462,8630464,8630466,8630468,8630514,8630515,8630516,8630517,8630518,8630519,8630520,8630521,8630522,8630523,8630524,8630525,8630526,8630527,8630528,8630529,8630530,8630531,8630532,8630533,8630534,8630535,8630536,8630537,8630538,8630539,8630540,8630541,8630542,8630543,8630544,8630545,8630546,8630547,8630548,8630549,8630550,8630551,8630552,8630553,8630554,8630555,8630556,8630557,8630558,8630559,8630560,8630561,8630562,8630563,8630564,8630565,8630566,8630567,8630568,8630569,8630570,8630571,8630572,8630573,8630574,8630575,8630576,8630577,8630578,8630579,8630580,8629434,8629436,8629437,10856910,8624451,8624453,8624454,8624456,8624458,8634738,8634739,8634740,8634741,8634742,8634743,8634744,8634745,8634746,8634747,8634748,8634749,8634750,8634751,8634752,8634753,8634754,8634755,8634756,8634757,8634758,8634759,8634760,8634761,8634762,8634763,10954097,8633326,8633330,8633331,8540897,9913326,9910571,10416704,10416705,10416706,10416707,10416708,10416733,10416734,10416737,10416738,10416739,10416740,10416741,10416742,10416743,10416744,10416745,10416746,10416747,10416748,10416749,10416750,10416751,10416752,10416753,10416754,10416755,10416756,8550156,10890032,10411817) 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>