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(7066710,10870120,10870121,10870122,10870123,10870124,10870125,10870126,10870127,10870128,10870129,10870130,10870131,10870132,10870133,10870134,10870135,10870136,10870137,10870138,10870139,10870140,10870141,10870142,10870143,10870144,10870145,10870146,10870147,10870148,10843006,10843007,7072255,10843008,10843009,8836217,8836218,10843977,8615065,10941784,10941785,10941786,10941787,10941788,10941789,10941790,10941791,10941792,10941793,10941794,10941795,10941796,10941797,10941798,10941799,10941800,7070762,7070763,7070764,7070765,7070766,7070767,7070768,7070769,7156035,10992007,10992008,10992009,10992010,10992011,10992012,10992013,10992014,10992015,10992016,10992017,10992018,10992019,10992020,10992021,10992022,10992023,10992024,10992025,10992026,10992027,10992028,10992029,10992030,10992031,10992032,10992033,10992034,10992035,10992036,10992037,10992038,10992039,10992040,10992041,10992042,10992043,10992044,10992045,10992046,10992047,10992048,10992049,10992050,10992051,10992052,10992053,10992054,10992055,10992056,10992057,10992058,10992059,10992060,10992061,10992062,10992063,10992064,10992065,10992066,10992067,10992068,10992069,10992070,10992071,10992072,10992073,10992074,10992075,10992076,10992077,10992078,10992079,10992080,10992081,10992082,10992083,10992084,10992085,10992086,10992087,10992088,10992089,10992090,10992091,10992092,10992093,10992094,10992095,10992096,10992097,10992098,10992099,10992100,10992101,10992102,10992103,10992104,10992105,10992106,10992107,10992108,10992109,10992110,10992111,10992112,10992113,10992114,10992115,10992116,10992117,10992118,10992119,10992120,10992121,10992122,10992123,10992124,10992125,10992126,10992173,10992174,10992175,8864206,10122113,10122114,10122115,10122116,10122117,9185950,9185951,9185952,9185953,9185954,9185955,9185956,9185957,9185958,9185959,9185960,9185961,9185962,9185963,9185964,9185965,9185966,9185967,9185968,9185969,9185970,9185971,9185972,9185973,9185974,9185975,9185976,9185977,9185978,9185979,9185980,9185981,9185982,7057459,7057460,7057461,7057462,7057463,7057464,10471524,10471525,8550651,10903647,10903648,7001075,10530287,10530288,10530289,10530290,10530291,10530292,10530293,10530294,10530295,10530296,10530297,10530298,10530299,10530300,10530301,10530302,10530303,10530304,10530305,10530306,10530307,10530308,10530309,10530310,10530311,10530312,10530313,10530314,10530315,10530316,10530317,10530318,10530319,10530320,10530321,10530322,10530323,10530324,10530325,10530326,10530327,10530328,10530329,10530330,10530331,10530332,10530333,10530334,10530335,10530336,10530337,10530338,10530339,10530340,10530341,10530342,10530343,10530344,10530345,10530346,10530347,10530348,10530349,10530350,10530351,10530352,10530353,10530354,10530355,10530356,10530357,10530358,10530359,10530360,10530361,10530362,10530363,10530364,10530365,10530366,10530367,10530368,10530369,10530370,10530371,10530372,10530373,10530374,10530375,10530376,10530377,10530378,10530379,10530380,10530381,10530382,10530383,10530384,10530385,10530386,10530387,10530388,10530389,10530390,10530391,10530392,10530393,10530394,10530395,10530396,10530397,10530398,10530399,10530400,10530401,10530402,10530403,10530404,10530405,10530406,10530407,10530408,10530409,10530410,10530411,10530412,10530413,10530414,10530415,10530416,10530417,10530418,10530419,10530420,10530421,10530422,10530423,10530424,10530425,10530426,10530427,10530428,10530429,10530430,10530431,10530432,10530433,10530434,10530435,10530436,10530437,10530438,10530439,10530440,10530441,10530442,10530443,10530444,10530445,10530446,10530447,10530448,10530449,10530450,10530451,10530452,10530453,10530454,10530455,10530456,10530457,10530458,10530459,10530460,10530461,10530462,10530463,10530464,10530465,10530466,10530467,10530468,10530469,10530470,10530471,10530472,10530473,10530474,10530475,10530476,10530477,10530478,10530479,10530480,10530481,10530482,10530485,10422002,10422003,10422004,10422005,10422006,10422007,10422008,10422009,10422010,10422011,10422012,10422013) 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>