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(7066051,7066052,7066053,7066054,7066055,10862597,10862598,10862599,10862600,10862601,10862602,10862603,10862604,10862605,10862606,10862607,10862608,10862609,7201405,7201406,7201407,7201408,7201409,7201410,7201411,7201412,5654613,7202620,7202621,7202622,7202623,7202624,7202625,7202626,7202627,7202628,7202629,7202630,7202631,7202632,10859914,10859915,10859916,10859917,10859918,10859919,10859920,10859921,10859922,10859923,10859924,10859925,10859926,10859927,10859928,10859929,10859930,10859931,10859932,10859933,10859934,10859935,10859936,10859937,10859938,10859939,10859940,10859941,10859942,10859943,10859944,10859945,10859946,10859947,10859948,10859949,10859950,10859951,10859952,10859953,10859954,10859955,10859956,10859957,10859958,10859959,10859960,10859961,10859962,10859963,10859964,10859965,10859966,10859967,10859968,10859969,10859970,10859971,10859972,10859973,10859974,10859975,10859976,10859977,10859978,10859979,10859980,10859981,10859982,10859983,10859984,10859985,10859986,10859987,10859988,10859989,10859990,10859991,10859992,10859993,10859994,10859995,3927606,7198488,7198489,7198490,7198491,7198492,10864167,10864168,10864169,10864170,10864171,10864172,10864173,10864174,10864175,10864176,10864177,10864178,10864179,10864180,10864181,10864182,10864183,10864184,10864185,10864186,10864187,10864188,8906019,10622365,3232802,8905568,8905569,10616572,8851935,8851936,8851937,8851938,8851939,8851940,8851941,8851942,8566664,10613083,10613084,10613085,10613086,10613087,10613088,10613089,10613090,10613091,10613092,10613093,10613094,10613095,10613096,10613097,10613098,10613099,10613100,10613101,10613102,10613103,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613118,10613119,10613120,10613121,10613373,6673520,6673521,7015175,7015176,7015177,7015178,7015179,7015180,7015181,7015182,7015183,7015184,7015185,7015186,7015187,7015188,7015189,7015190,7015191,7015192,7015193,7015194,7015195,7015196,7015197,7015198,7015199,7015200,7015201,7015202,7015203,7015204,7015205,7015206,7015207,7015208,7015209,7015210,7015211,7015212,7015213,7015214,7015215,7015216,7015217,7015218,7015219,7015220,7015221,7015222,7015223,7015224,7015225,7015226,7015227,7015228,7015229,7015230,7015231,7015232,7015233,7015234,7015235,7015236,7015237,7015238,7015239,7015240,7015241,7015242,7015243,7015244,7015245,7015246,7015247,7015248,7015249,7015250,7015251,7015252,7015253,7015254,7015255,7015256,7015257,7015258,7015259,7015260,7015261,7015262,7015263,7015264,7015265,7015266,7015267,7015268,7015269,7015270,7015271,7015272,7015273,7015274,7015275,7015276,7015277,7015278,7015279,4974691,4974698,4974706,10118052,10118053,10118054,4974714,9912454,9912455,8850171,8850172,8850510,9912899,10416239,10416240,10416241,10416242,10416243,10416244,10416245,10416246,10416247,10416248,10416249,10416250,10416251,10416252,10417506,10417507,10417508,10417509,10417510,10417511,10417512,10417513,10417514,10417515,10417516,10417517,10417518,10417519,10417520,10417521,10417522,10417523,10417524,10417525,10417526,10417527,10417528,9168798,10468887,10468888,10468889,10468890,10468891,10468892,10468893,10468894,10468895,10468896,10468897,10468898,10468899,10468900,10468901,10469527,10468366,10888631,7000838,10885528,10885529,10885530,10885531,10885532,10885533,10885534,10885535,10885536,10885537,10885538,10885539,10885540,10625500,10625501,10625502,10887192,10887193,10887194,10887195,10887196,10887197,10887198,10580339,10580340,10647511,10507565,10507992,10414310,10414311,10414312,10414313,10414314,10414315,10414316,10414317,10414318,10414319,10414320,10414321,10414322,10414323,10414324,10414325,10414326,10414327,10414328,10414329,10414330,10414331,10414332,10414333,10414334,10414335,10414336,10414337,10414338,10414339,10414340,10414341,10414342,10414343,10414344,10414345,10414346,10414347,10414348,10414349,10414350,10414351,10414352,10414353,10414354,10414355,10414356,10414357,10414358,10414359,10414360,10414361,10414362,10414363,10414364,10414365,10414366,10414367,10414368,10414369,10414370,10414371,10414372,10414373,10414374,10414375,10414376,10414377,10414378,10414379,10414380,10414381,10414382,10414383,10414384,10414385,10414386,10414387,10414388,10414389,10414390,10414391,10414392,10414393,10414394,10495556,10495557,10495558,10495559,10495560,10495561,10495562,10495563,10495564,10495565,10495566,10495567,10495568,10495569,10495570,10495571,10495572,10495573,10495574,10495575,10495576,10495577,10495578,10495579,10495580,10495581,10495582,10495583,10495584,10495585,10495586,10495587,10495588,10495589,10495590,10495591,10495592,10495593,10495594) 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>