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(10845746,8630660,8631042,10874155,8584010,8584011,8632193,10863051,10872112,10872113,10872114,10872115,10872116,10872117,10872118,10872119,10845236,10845237,10845238,10845239,10845240,10845241,10845242,10845243,10845244,10845245,10845246,10845247,10845248,8558912,7201241,7201242,10858721,7202161,7202162,10859539,10104819,8626603,8626604,8626605,8626606,8626607,8626608,8626609,8624917,10856123,11009917,11009918,8626060,8626067,8626155,8626162,8626168,10928604,10928605,10928606,10928607,10928608,10853656,7197101,10838665,11046872,11046873,11046874,11046875,11046876,11046877,11046878,11046879,8624477,8624494,8634603,11044766,10852635,10622433,10993424,10993425,10993426,10993427,10993428,10993429,10993430,10993431,10993432,10993433,10993434,10993435,10993436,10993437,10853128,10837597,10620088,10620089,10964949,10964950,8633201,8633215,8633319,10615981,10615984,9217805,10616505,10616506,10616507,10616508,8634453,8634454,8634536,10119496,10612253,10612804,9188244,9188245,9188246,9188248,10612939,10610026,10613080,10610334,10613722,10613736,10515221,10512123,10512124,10512125,10512126,10512127,10512128,10512129,10512130,10512131,10512132,10512133,10512134,10512135,10512137,10512138,10512139,10512140,6674586,9186817,9186818,9186819,9186820,10416608,7014832,7014833,7014834,7014835,7014836,7014837,7014838,7014839,7014893,7014894,7014895,7014896,7014897,7014898,7014899,7014900,7014901,7014902,7014903,7014904,9174748,10465910,10465911,10465912,6671809,9168025,9168027,9168098,10628684,10628685,10628686,10628687,10628688,10628689,10628690,10628691,10628692,10628693,10628694,10628695,10628696,10628712,10175582,10175583,10175584,10175585,10175586,10632014,10882681,10627897,10627898,10627899,10627900,10911225,10911226,10911227,10911228,10911229,10911230,10177609,10631241,10631242,10631243,10652516,10578032,10587370,10587371,10599403,10599404,10599405,10599406,10599407,10599408,10599409,10599410,10599411,10599412,10599413,10604651,10604652,10604653,10604654,10604655,10604656,10604660,10604661,10604668,10604672,10604687,10604688,10600905,10600906,10600907,10576944,10532164,10532165,10534226,10532860,10532861,10532862,10532863,10539086,10423310,10423311,10423312,10423313,10423314,10423315,10423316,10423317,10506558,10424750,10411237,10413263,10409342,10409066) 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>