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(3228908,8067928,10861002,10861003,10861004,10861005,10861006,10861007,10861008,10861009,10861010,10861011,10861012,10861013,10861014,10861015,10861016,10861017,10861018,10861019,10861020,10861021,10861022,7201104,7201105,7201135,7201136,7201137,7201138,7201139,7201140,7201141,7201142,7201143,7201144,7201145,7201146,7201147,7201148,7201149,7201150,7201151,3923567,8905783,8905784,8905785,8905786,8905787,10614078,10614079,10614080,10614081,10614082,10614083,10614084,10614085,10614086,10614087,10614088,10614089,10614090,10614091,10614092,10614093,10614094,10614095,8852024,8852025,8852026,8852027,8852028,8852029,8852030,8852031,8852032,8852033,8852034,8852035,8852036,8852037,8852038,7055523,6673701,7015406,7015407,7015408,7015409,7015410,7015411,7015412,7015413,7015414,7015415,7015416,7015417,7015418,7015419,7015420,7015421,7015422,7015423,7015424,7015425,7015426,7015427,7015428,7015429,7015430,7015431,7015432,7015433,7015434,7015435,7015436,7015437,7015438,7015439,7015440,7015441,7015442,7015443,7015444,7015445,7015446,7015447,7015448,7015449,7015450,7015451,7015452,7015453,7015454,7015455,7015456,7015457,7015458,7015459,7015460,7015461,7015462,7015463,7015464,7015465,7015466,7015467,7015468,7015469,7015470,7015471,7015472,7015473,7015474,7015475,7015476,7015477,7015478,7015479,7015480,7015481,7015482,7015483,7015484,7015485,7015486,7015487,7015488,7015489,7015490,7015491,7015492,7015493,7015494,7015495,7015496,7015497,7015498,7015499,7015500,7015501,7015502,7015503,7015504,7015505,7015506,7015507,7015508,7015509,7015510,7015511,7015512,7015513,7015514,7015515,7015516,7015517,7015518,7015519,7015520,7015521,7015522,7015523,7015524,7015525,7015526,7015527,7015528,7015529,7015530,7015531,7015532,7015533,7015534,7015535,7015536,7015537,7015538,7015539,7015540,7015541,7015542,7015543,7015544,7015545,7015546,7015547,7015548,7015549,7015550,7015551,7015552,7015553,7015554,7015555,7015556,7015557,7015558,7015559,7015560,7015561,7015562,7015563,7015564,7015565,7015566,7015567,7015568,7015569,7015570,7015571,7015572,7015573,7015574,7015575,7015576,7015577,7015578,7015579,7015580,7015581,7015582,7015583,7015584,7015585,7015586,7015587,7015588,7015589,7015590,7015591,7015592,7015593,7015594,7015595,7015596,7015597,7015598,7015599,7015600,7015601,7015602,7015603,7015604,7015605,7015606,7015607,7015608,7015609,7015610,7015611,7015612,7015613,10118156,7015614,7015615,7015616,7015617,7015618,7015619,7015620,7015621,7015622,7015623,7015624,7015625,7015626,7015627,7015628,7015629,7015630,7015631,7015632,7015633,7015634,7015635,7015636,7015637,7015638,7015639,7015640,7015641,7015642,7015643,7015644,7015645,7015646,7015647,7015648,7015649,7015650,7015651,7015652,7015653,7015654,7015655,9912663,9912664,9912665,9912666,9912667,9912668,9169096,9169097,9169098,9169099,9169100,9169101,9169102,10469389,10469390,10469391,10469392,10469393,10469394,10469395,10949011,10886881,10886882,10886883,10886884,10886885,10886886,10886887,10886888,10886889,10886890,10886891,10886892,10886893,10886894,10886895,10886896,10886897,10886898,10886899,10886900,10886901,10886902,10886903,10886904,10886905,10886906,10602252,10647524,10647578,10415031,10415032,10415033,10415034,10415035,10415036,10415037,10415038,10415039,10415040,10415041,10415042,10415043,10415044,10415045,10415046,10415047,10415048,10415049,10415050,10415051,10415052,10415053) 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>