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(7068057,7068074,7068075,10940066,10940075,10873852,8583139,10950321,10950322,10862260,9215637,11015700,10868385,10868386,10868387,10862669,7074383,10849734,10850010,10850011,11013509,10938596,3227480,3227481,10872403,10860515,8629964,8630114,8630115,8630116,10930046,7072062,7072063,10959857,7064235,11012024,10973290,8572130,8572131,11012685,3899597,3899598,8560044,8560045,8560049,4967448,4967449,11013154,8837022,10867974,10974397,10974398,10974399,10974400,10974401,10974402,10974403,10974404,10974405,10974406,10974407,10974408,10974409,10974410,10974411,10974412,10974413,10974414,10974415,10974416,10974417,10974418,10974419,10974420,10974421,10974422,10974423,10974424,10974425,10974426,10974427,10974428,10974429,3927528,10102289,8064266,8064267,8064268,8064289,8064290,11011284,11011285,11011286,11011287,11011288,10998357,10998358,10998359,11011472,11011473,11011474,11011475,11011476,10944390,7068982,8563722,8908111,8908112,8908113,8908114,8908115,8908116,8563770,10863407,10863408,3235612,3235634,3235635,8908286,8615147,8908473,8859519,8564762,7199529,10856589,10856590,10856591,10856592,10856593,10856594,10856595,10856596,7199555,10856597,10856598,10856599,10856600,10856601,10841142,8969926,8860581,10853248,10853249,10853250,10853260,10853290,10853320,8613216,8613217,3234305,11046790,10838955,10981934,10981935,10981936,10981937,10981938,10981939,10981940,10981943,10981944,10981945,10619619,7197821,10619895,8555758,10836969,3922842,10954283,10615057,10615059,10615060,11016601,11016602,8609875,10620586,10620587,10620588,3231008,3231012,3231014,10616016,7154462,10952598,10979047,10979060,10953109,10953110,8552688,8853255,10714025,10614210,6669946,6670222,10611703,3962419,10119508,8542529,10119972,10119973,10119974,10119975,6676302,8851973,8863206,9915278,8853040,9169419,8592648,8849358,8592750,9912195,9912234,9912235,9912285,9912288,8551403,8551404,8551405,8551406,8551436,9186180,2809106,2809109,3651798,2809337,8552164,8565591,8565592,8565593,8565594,8552465,8861728,9910666,9910671,9160797,9160798,9160799,9160800,9160801,9160802,9160832,9160833,9168847,10416858,10416943,10416944,9177064,9177065,10462933,10122996,10122999,6666924,9191084,9191087,9167278,6473677,10115850,10115851,976495,10116026,10946820,10889687,10629298,10895177,10895178,10895179,10895180,10895181,10895182,10168679,10168680,10168681,10168682,10168683,10168684,10168696,10627262,10907773,10945588,10945589,10627292,10945633,10945634,10945635,10887942,10893042,10883064,10154340,10154341,10154342,10154343,10154344,10154345,10154346,10154347,10154348,10154349,10154350,10154412,10154413,10154414,10154415,10154416,10154417,10176570,10176571,10176728,10176729,10176730,10176731,10875837,10177011,10177073,10886150,10886151,10886152,10172276,10167398,10167470,10649457,10649458,10649459,10649460,10649461,10652719,10652720,10643751,10602559,10643777,10643778,10587099,10602999,10603064,10603065,10603066,10648674,10648675,10648676,10648677,10651765,10648933,10523116,10520467,10546722,10546723,10538763,10424479,10508484,10420630,10422664,10498681,10498682,10498683,10498684,10498685,10407269,10409444,10409445,10409446,10411608,10481353,10481354,10481355,10481356,10481357,10481358,10481359,10481360,10487100,10478449,10478450,10414796,10478451) 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>