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(10861442,10861443,10861486,3229131,3229132,3229133,3229134,3229282,3229283,8631543,10862190,10862272,10862282,10862549,10862724,10862725,8632529,8594643,7201311,10866398,10866401,10866412,10866413,10866438,10858805,8911592,10866909,10859181,7200532,7198682,10856084,10856087,10856088,10856092,10101321,10853647,10853657,10623605,10623606,10953991,10615078,10615079,10615240,10615241,10425591,10615536,10615540,10425911,10426009,10426016,10615925,10615931,10615943,10616842,10611048,10611232,10614784,10614785,10614806,10614807,10614814,10614859,10614862,10611879,10612284,10612285,10612286,10612412,10612414,10612426,10612427,10612429,10612430,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612498,10612499,10612502,10612503,10612506,10612507,10612508,10612509,10612510,10612527,10612535,10612539,10612547,10612558,10612573,10612583,10612585,10612587,10612588,10612592,10612620,10612635,10612639,10612645,10612647,10612648,10612650,10612651,10612660,10612679,10612684,10612697,10612698,10612700,10612705,10612717,10609826,10612838,10612839,10612840,10612850,10612852,10612860,10612863,10612865,10612871,10612873,10612874,10612878,10612937,8852321,10610270,10610296,10610359,10610364,8852544,8852545,10610486,10610793,10610838,10610841,6673739,8849412,9912041,8850420,8850421,8850422,8850423,8850424,8850425,8850426,8850427,9913274,10419418,10415438,10419789,10415949,10415959,10416186,10469702,10469703,10469704,10469733,10469734,10469735,10469751,10469770,10469771,10469780,10469781,10469782,10469810,10469811,10469812,10469829,10469830,10469842,10469852,9168151,10880305,10888298,10877126,10163320,10647632,10604658,10604661,10604664,10604671,10604682,10604695,10507961,10413666,10409669,10409676,10411216,10411219,10411220) 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>