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(8630761,8630762,10861480,10848640,10848641,10870641,10848642,10848647,10848648,10861849,10849071,8631509,8631841,10862925,10872252,10872253,10860648,10872785,10866270,10866271,7201346,7201348,7201349,7201350,7201356,10866652,10866653,8595132,7201736,7201905,7201906,7201907,7201976,10867022,10867023,10867024,10867025,10867026,10867027,10867037,10867038,10867039,10867046,10867047,10867048,10867049,10867050,10867051,10867052,7202356,7202357,7202360,7202361,7202362,7202363,10867514,10867515,10867516,10867517,10867518,10867519,10859654,10859655,10859656,10867713,10867714,10867715,10865240,10865243,10865280,10865289,10865290,10865305,10865306,10865311,10865317,10865318,10865329,10865352,10865354,10865360,10857697,10857698,8627223,8627232,8627233,8627262,8627271,8627272,8627273,8627295,8627299,10855417,10855418,10855426,10855427,10855435,8625202,8625203,10855878,10855879,10855880,8625283,10856121,10856122,10856123,10864195,10856226,10856227,10101449,3923616,10853596,10853597,10853598,7196573,7196574,10854078,10854079,10854080,10854081,10854082,10854083,8906892,8906912,10854401,10838897,10855075,10855076,10855077,10617212,10617369,10617370,10617457,10617475,10852891,10853070,10850781,10615682,10851039,10851040,10851041,10851042,10851043,10851044,10851045,10851046,10851047,10426205,10616475,10616595,10616879,10614766,10612328,10610054,8852827,8852853,8852854,8852855,8852856,8852857,8852858,8852859,8852860,8852861,8852862,8852863,8852864,8852865,8852866,8852867,8852868,8852869,8852870,8852871,8852872,8852873,8852874,8852875,10610728,10610842,10515317,10117779,9169777,8849713,10118323,6674336,9913314,10419357,10419358,10415388,7014222,7014223,10419524,10419525,10417531,10418547,10418550,10418585,10418586,10418596,10418597,10418613,10418614,10418620,10418627,10418628,10418642,10418654,10418665,10418667,10418674,10415691,7014546,7014547,10419908,10419909,10419910,10419911,10419912,10419913,10419923,10419924,10419925,10419932,10419933,10419934,10419935,10419936,10419937,10419938,10418072,10471171,8855255,8855257,8855259,8855261,8855262,8855265,8855271,10174932,10884019,10889517,10889759,10889762,10889764,10890055,10887962,10887963,10888252,10888446,10625075,10625076,10625077,10887409,10608383,10601680,10601681,10420290,10422290,10420291,10420292,10420293,10420294,10420295,10423418,10423419,10423420,10420446,10420447,10420448,10411235,10411236,10411237,10409307,10409877,10409878,10409879,10409880,10409881,10409882,10414085,10414086,10410129,10408157,10408158,10408159,10408160,10408161,10408162,10408163,10412285,10412286,10412287,10410591,10410592,10410601,10410602,10410611,10414891,10414892,10406901,10406902,10406903,10406908,10406909,10406910) 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>