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(10930305,10930306,10930307,8620901,8620902,8620903,8620904,8620905,8620906,8620907,10846780,10846781,10846782,8067651,8838411,8838412,8838413,8838414,10104154,3899534,3899535,11039311,11039312,11039313,11039314,11039315,11039316,11039317,11039318,11039319,11039320,11039321,11039322,11039323,11039324,11039325,11039326,11039327,11039328,11039329,11039330,11039331,11039332,11039333,11039334,11039335,11039336,11039337,11039338,11039339,11039340,11039341,11039342,11039343,11039344,11039345,11039346,11039347,11039348,11039349,11039350,11039351,11039352,11039353,11039354,11039355,11039356,11039357,11039358,11039359,11039360,11039361,10942936,10923864,10923865,10923866,10923867,10923868,10923869,10923870,10923871,10923872,10923873,10923874,10923875,10923876,10923877,10923878,10923879,10923880,10923881,10923882,10923883,10923884,10923885,10923886,10923887,10923888,10923889,10923890,10923891,10923892,10923893,10923894,10923895,10923896,10923897,10923898,10923899,10923900,10923901,10923902,10923903,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10923913,10923914,10923915,10923916,10923917,10923918,10923919,10923920,10923921,10923922,10923923,10923924,10923925,10923926,10923927,10923928,10923929,10923930,10923931,10923932,10923933,10923934,10923935,10923936,10923937,10923938,10923939,10923940,10923941,10923942,10923943,10923944,10923945,10923946,10923947,10923948,10923949,10923950,10923951,10923952,10923953,10923954,10923955,10923956,10923957,10923958,10923959,10923960,10923961,10923962,10923963,10923964,10923965,10923966,10923967,10923968,10923969,10923970,10923971,10923972,10923973,10923974,10923975,10923976,10923977,10923978,10923979,10923980,10923981,10923982,10923983,10923984,10923985,10923986,10923987,10923988,10923989,10923990,10923991,10923992,10923993,10923994,10923995,10923996,10923997,10923998,10923999,10924000,10924001,10924002,10924003,10924004,10924005,10924006,10924007,10924008,10924009,10924010,10924011,10924012,10924013,10924014,10924015,10924016,10924017,10924018,10924019,10924020,10924021,10924022,10924023,10924024,10924025,10924026,10924027,10924028,10924029,10924030,10924031,10924032,10924033,10924034,10924035,10924036,10924037,10924038,10924039,10924040,10924041,10924042,10924043,10924044,10924045,10924046,10924047,10924048,10924049,10924050,10924051,10924052,10924053,10924054,10924055,10924056,10924057,10924058,10924059,10924060,10924061,10924062,10924063,10924064,10924065,10924066,10924067,10924068,10924069,10924070,10924071,10924072,10924073,10924074,10924075,10924076,10924077,10924078,10924079,10924080,10924081,10924082,10924083,10924084,10924085,10924086,10924087,10924088,10924089,10924090,10924091,10924092,10924093,10924094,10924095,10924096,10924097,10924098,10924099,10924100,10924101,10924102,10924103,10924104,10924105,10924106,8578432,8578433,8578434,8578435,8578436,8578437,8578438,8578439,8578440,8578441,8578442,8578443,8578444,8578445,8578446,8578447,8578448,8578449,8578450,8578451,8578452,8578453,8578454,8578455,8578456,8578457,8578458,8578459,7023616,7023617,7023618,7023619,7023620,7023621,7023622,4974859,4974860,4974861,4974862,4974863,4974864,10125068,10125069,10125070,10125071,10125072,6681241,6681242,9206423,9206424,9206425,9206426,9206427,9206428,9206429,9206430,9206431,9206432,9206433,9206434,9206435,9206436,3963645,3963646,3963647,8917912,8917913,8917914,10186461,10186462,7001303,10630960,10630961,10901811,10653602,10494749,10494750) 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>