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(10845912,10870498,10870514,7073939,7073969,10849665,7066524,7066704,10850051,3230230,10872445,10872446,10872447,10872448,7067227,8561310,8561311,6000258,6000259,6000283,6000284,6000285,6000286,10842928,11012013,11012014,11012015,11012016,11012133,11012134,11012135,11012136,10866776,10866777,10866778,10866779,8559437,8559466,8559467,8559468,3899119,10103913,8559741,10843720,3899482,3899483,3899484,8065965,8619141,8837046,3237377,10942719,10942720,10942721,10942725,10942726,11037179,11037180,7200759,10102850,10102851,3925425,3925426,3925427,3925428,3925429,3655792,3656151,3656152,3656153,3656154,3656155,10864158,10101036,3926968,10857040,8073489,8073490,8906019,7156557,7156558,10618273,10618274,10618298,10994183,10994187,10994188,10994196,10994197,10994198,10994199,10994200,3235104,8905952,8905956,8905957,8905958,8905959,10951631,10850466,11004088,10615492,10615493,10615494,10991473,10991474,10991475,10991476,10991477,9217526,10930930,10930931,9217667,8540755,11005089,11005090,11005091,8540991,8611477,10852004,10852005,8541409,9915710,9915711,9173768,10714265,9173794,6678134,6678135,6678136,10714432,10714433,8864516,8864705,8864706,8864707,8864709,10122394,9187311,9187332,9211514,9211518,10563583,9212112,9188229,9188230,9188231,9188232,8567730,10515318,9185592,9185593,9161762,10126117,8849781,10516919,10516920,8552496,8552497,10419632,10419633,10419634,10419635,10419636,4974108,4974109,4974110,4974111,4974112,4974113,4974114,4974115,4974116,9916950,8854927,8916801,10124070,9184030,8917773,8917774,10904011,10904012,10175169,10175170,10175171,8594407,10909916,10909917,10629428,10912765,10912766,10912767,10912768,10912769,10908226,10908227,10910898,10910899,10162012,10162013,10177119,10177120,10177121,10177122,10177123,10177124,10177125,10172255,10177256,10912150,10950071,10608029,10590612,10590613,10590614,10590615,10590616,10590617,10590618,10590619,10590620,10590623,10604506,10546030,10546031,10546114,10546115,10423565,10423566,10423567,10508531,10505532,10505533,10505534,10422194,8562209,10407485,10411896,8562988,10407213) 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>