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(7075912,7068094,8583091,10963553,10963554,10963555,10963556,10963557,10963558,10862257,8575152,8575153,8583522,10868461,8583656,10849716,8622459,8622462,8622463,8622464,8622469,8632287,8632288,8632289,8632290,8632301,8632302,8632313,8632314,3230165,3227260,3227261,8573072,8629652,10860386,10860583,10860584,10860585,10872659,10845281,10860817,8630224,10858191,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,7201567,8595057,8559386,7201901,8628340,10867012,10867013,10867014,7202132,10867210,10867211,8628606,8628607,8628608,8628796,7202404,10999917,5654580,11000034,11000035,11000036,11000037,11000038,8560324,11000064,3227085,8629317,8629318,7200115,7200127,7200128,8626652,8626653,10102164,8558224,7200542,10865593,10865594,8626955,8626962,7200580,10857646,10857688,10857693,4430155,10857937,8555799,8908063,10839816,7198394,10863537,10863549,10863616,10863617,10863618,10863625,10863626,10863627,7198684,7198731,7198752,7198763,7198764,7198766,8908760,8625382,8625383,8625384,8625390,8564678,10840912,8626320,10623063,10928652,7196259,7196276,7196277,7196282,7196285,7196286,7196287,7196291,7196307,7196308,7196309,7196310,7196316,7196317,7196337,7196345,7196355,10967931,7196506,7196508,7196512,7196516,7196517,7196520,7196523,7196524,7196525,7196526,7196527,7196528,7196532,7196533,7196539,7196542,7196544,8070168,8070234,8070314,8070319,8906650,7196919,7197019,10838528,8906888,8906889,8906892,8554784,8554799,10838993,7197632,7197634,7197717,7197722,10624632,10624633,11047217,11047218,11047219,11047220,11047221,8907596,7197814,7197820,3232327,3232336,8541475,11044801,10617328,8905263,10622431,8612193,3922838,8632595,8632624,3230545,3230546,10425582,8610133,3581898,3581902,3581907,10848506,10930738,10930752,10616060,10616126,10616127,10851388,8904334,8904341,3231824,3231825,3231826,3231827,3231828,3231829,3231830,3231883,3231884,3231885,8541011,3231924,3231925,3231926,3231927,3231928,3231951,3231952,3231953,3231954,3231955,3231991,3231992,3231993,3232013,3232023,3232024,3232025,3232033,3232047,3232063,3232078,3232079,3232080,3232081,3232082,3232083,3232084,3232085,3232086,3232159,10610988,10610989,10565158,8853209,8853215,8853231,8853321,8853363,8853369,10614496,10611539,10611544,10611551,10611555,10611563,10611641,9166129,10612104,10612105,7017836,7017837,9196448,10613133,10613341,10561536,10613529,9172931,9172932,9172933,9172934,9915223,9173120,10613905,10613906,10613907,10613908,10613909,10613910,10613911,9169317,9177376,9177377,8849321,8849322,9169638,9169941,10118678,6674695,8552192,8552193,9913193,9171117,9913352,8848141,8848142,8848145,9192336,6672592,10419455,6672758,6672888,9168804,6673023,10418823,8848740,8848741,8848742,8848765,8848766,8848767,9160951,9168969,10419891,10419892,10419893,8848866,8848867,6673293,9193107,9193108,9193109,10420044,10417065,10417070,10417082,10417131,10417132,10417136,10417137,10417138,8549456,9166855,10467803,9175228,9175232,9175252,8847270,8563360,8847309,8847310,976357,8847476,8847477,8847478,8847495,8847496,9207710,9207712,9207723,9207731,8847568,9207743,9207748,10468326,9207755,9207783,8848010,8848036,8848037,8848038,10883562,10883593,10883597,10883628,10883661,10893774,10884042,10894088,10894378,10627130,10627131,10627132,10883045,10948310,10895779,10895780,10886329,10886330,10886331,10631423,10631424,10188047,10188049,10887097,10173122,10887225,10887229,10631795,10631914,10602168,10602176,10602177,10602190,10602191,10602196,10598800,10598801,10598802,10602730,10647535,10647550,10606880,10606922,10582573,10607539,10648973,10591922,10539116,10521316,10549588,10549589,10528213,10548299,10548300,10548301,10548302,10548303,10544463,10544529,10423619,10407258,10484513,10484523,10486569,10496940,10408314,10496980,10496982,10496987,10478004,10497034,10497036,10497042,10412521,10414688,10412762,10414829,10414830,10472762,10478853,10478854,10478855) 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>