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(7074036,7074037,7074038,7074040,7074041,7074042,7074043,7074044,8067480,8067481,8067482,8067483,8067484,8067485,8067486,8067487,8067488,8067489,8067490,8067491,8067492,8067493,8067494,8067495,8067496,8067497,8067498,8067499,8067500,8067501,8067502,8067503,8067504,8067505,8067509,8067511,8067516,10918746,10918747,10918748,10918749,10918750,10918751,10918752,10918753,10918754,10918755,10918756,10918757,10918758,10918759,10918760,10918761,10918762,10918763,10918764,10918765,10918766,10918767,10918768,10918769,10918770,10918771,10918772,10918773,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,10918783,10918784,10918785,10918786,10918787,10918788,10918789,10918790,10918791,10918792,10918793,10918794,10918795,10918796,10918797,10918798,10918799,10918800,10918801,10918802,10918803,10918804,10918805,10918806,10918807,10918808,10918809,10918810,10918811,10918812,10918813,10918814,10918815,10918816,10918817,10918818,10918819,10918820,10918821,10918822,10918823,10918824,10918825,10918826,10918827,10918828,10918829,10918830,10918831,10918832,10918833,10918834,10918835,10918836,10918837,10918838,10918839,10918840,10918841,10918842,10918843,10918844,10918845,10918846,10918847,10918848,10918849,10918850,10918851,10918852,10918853,10918854,10918855,10918856,10918857,10918858,10918859,10918860,10918861,10918862,10918863,10918864,10918865,10918866,10918867,10918868,10918869,10918870,10918871,10918872,10918873,10918874,10918875,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,10918884,10918885,10918886,10918887,10918888,10918889,10918890,10918891,10918892,10918893,10918894,10918895,10918896,10918897,10918898,10918899,10918900,10918901,10918902,10918903,10918904,10918905,10918906,10918907,10918908,10918909,10918910,10918911,10918912,10918913,10918914,10918915,10918916,10918917,10918918,10918919,10918920,10918921,10918922,10918923,10918924,10918925,10918926,10918927,10918928,10918929,10918930,10918931,10918932,10918933,10918934,10918935,10918936,10918937,10918938,10918939,10918940,10918941,10918942,10918943,10918944,10918945,10918946,10918947,10918948,10918949,10918950,10918951,10918952,10918953,10918954,10918955,10918956,10918957,10918958,10918959,10918960,10918961,10918962,10918963,10918964,10918965,10918966,10918967,10918968,10918969,10918970,10918971,10918972,10918973,10918974,10918975,10918976,10918977,10918978,10918979,10918980,10918981,10918982,10918983,10918984,10918985,10918986,10918987,10918988,10918989,10918990,10918991,10918992,10918993,10918994,10918995,10918996,10918997,10918998,10918999,10919000,10919001,10919002,10919003,10919004,10919005,10919006,10919007,10919008,10919009,10919010,10919011,10919012,10919013,10919014,10919015,10919016,10919017,10919018,10919019,10919020,10919021,10919022,10919023,10919024,10919025,10919026,10919027,10919028,10919029,10919030,10919031,10919032,10919033,10919034,10919035,10919036,10919037,10919038,10919039,10919040,10919041,10919042,10919043,10919044,10919045,10919046,10919047,10919048,10919049,10919050,10919051,10919052,10919053,10919054,10919055,10919056,10919057,10919058,10919059,10919060,10919061,10919062,10919063,10919064,10919065,10919066,10919067,10919068,10919069,10919070,10919071,10919072,10919073,10919074,10919075,10919076,10919077,10919078,10919079,10919080,10919081,10919082,10919083,10919084,10919085,10919086,10919087,10919088,10919089,10919090,10919091,10919092,10919093,10919094,10919095,10919096,10919097,10919098,10919099,10919100,10919101,10919102,10919103,10919104,10919105,10919106,10919107,10919108,10919109,10919110,10919111,10919112,10919113,10919114,10919115,10919116,10919117,10919118,10919119,10919120,10919121,10919122,10919123,10919124,10919125,10919126,10919127,10919128,10919129,10919130,10919131,10919132,10919133,10919134,10919135,10919136,10919137,10919138,10919139,10919140,10919141,10919142,10919143,10919144,10919145,10919146,10919147,10919148,10919149,10919150,10919151,10919152,10919153,10919154,10919155,10919156,10919157,10919158,10919159,10919160,10919161,10919162,10919163,10919164,10919165,10919166,10919167,10919168,10919169,10919170,10919171,10919172,10919173,10919174,10919175,10919176,10919177,10919178,10919179,10919180,10919181,10919182,10919184,10919185,10919186,10919187,10919188,10919189,10919190,10919191,10919192,10919193,10919194,10919195,10919196,10919197,10919198,10919199,10919200,10919201,10919202,10919203,10919204,10919205,10919206,10919207,10919208,10919209,10919210,10919211,10919212,10919213,10919214,10919215,10919216,10919217,10919218,10919219,10919220,10919221,10919222,10919223,10919224,10919225,10919226,10919227,10919228,10919229,10919230,10919231,10919232,10919233,10919234,10919235,10919236,10919237,10919238,10919239,10919240,10919241,10919242,10919243,10919244,10919245,10919246,10919247,10919248,10919249,10919250,10919251,10919252,10919253,10919254,10919255,10919256,10919257,10919258,10919259,10919260,10919261,10919262,10919264,10919268,10919269,10919274,10919276,10919277,10919278,10919279,10919280,10919281,10919283,10919284,10919285,10919286,10919287,10919290,10919291,10919292,10919299,10919300,10919302,10919306,10919308,10919309,10919310,10919314,10919317,10919320,10919321,10919323,10919326,10919333,10919334,10919343,10919344,10919351,10919352,10919356,10919359,10919360,10919362,10919366,10919368,10919369,10919370,10919371,10919372,10919373,10919374,10919375,10919376,10919377,10919378,10919379,10919380,10919383,10919384,10919385,10919386,10919387,10919388,10919389,10919390,10919391,10919392,10919393,10919394,10919395,10919396,10919397,10919398,10919399,10919401,10919402,10919408,10919409,10919410,10919412,10919413,10919414,10919415,10919416,10919417,10919421,10919422,10919426,10919428,10919429,10919432,10919433,10919434,10919437,10919443,10919444,10919445,10919446,10919447,10919448,10919449,10919450,10919456,10919457,10919460,10919461,10919462,10919465,10919466,10919467,10919468,10919469,10919470,10919471,10919472,10919473,10919474,10919475,10919476,10919477,10919478,10919479,10919480,10919481,10919482,10919484,10919485,10919486,10919487,10919488,10919489,10919490,10919491,10919492,10919493,10919494,10919495,10919496,10919497,10919498,10919499,10919500,10919501,10919502,10919503,10919504,10919505,10919506,10919507,10919508,10919509,10919510,10919511,10919512,10919513,10919514,10919515,10919516,10919517,10919518,10919519,10919520,10919521,10919522,10919523,10919524,10919525,10919526,10919527,10919528,10919529,10919530,10919531,10919532,10919533,10919534,10919535,10919536,10919537,10919538,10919539,10919540,10919541,10919542,10919543,10919544,10919545,10919546,10919547,10919548,10919549,10919550,10919551,10919552,10919553,10919554,10919555,10919556,10919557,10919558,10919559,10919560,10919561,10919562,10919563,10919564,10919565,10919566,10919567,10919568,10919569,10919570,10919571,10919572,10919573,10919574,10919575,10919576,10919577,10919578,10919579,10919580,10919581,10919582,10919583,10919584,10919585,10919586,10919587,10919588,10919589,10919590,10919592,10919593,10919594,10919601,10919602,10919607,10919608,10919609,10919610,10919621,10919622,10919623,10919625,10919628,10919629,10919630,10919631,10919642,10919647,10919650,10919654,10919659,10919660,10919663,10919664,10919665,10919677,10919678,10919680,10919681,10919682,10919683,10919684,10919685,10919686,10919687,10919689,10919690,10919693,10919694,10919695,10919698,10919700,10919703,10919706,10919709,10919715,10919722,10919723,10919727,10919729,10919732,10919733,10919735,10919736,10919737,10919738,10919739,10919740,10919741,10919742,10919743,10919747,10919749,10919750,10919751,10919752,10919753,10919754,10919761,10919764,10919768,10919775,10919777,10919778,10919779,10919783,10919786,10919791,10919792,10919793,10919795,10919799,10919800,10919807,10919810,10919811,10919812,10919813,10919814,10919815,10919816,10919817,10919818,10919819,10919820,10919821,10919822,10919823,10919824,10919825,10919826,10919827,10919828,10919829,10919830,10919831,10919832,10919833,10919834,10919835,10919836,10919837,10919838,10919839,10919840,10919841,10919842,10919843,10919844,10919845,10919846,10919847,10919848,10919849,10919850,10919851,10919852,10919853,10919854,10919855,10919856,10919857,10919858,10919859,10919860,10919861,10919862,10919863,10919864,10919865,10919866,10919867,10919868,10919869,10919870,10919871,10919872,10919873,10919874,10919875,10919876,10919877,10919878,10919879,10919880,10919881,10919882,10919883,10919884,10919885,10919886,10919887,10919888,10919889,10919890,10919891,10919892,10919893,10919894,10919895,10919896,10919897,10919898,10919899,10919900,10919901,10919902,10919903,10919904,10919905,10919906,10919907,10919908,10919909,10919910,10919911,10919912,10919913,10919914,10919916,10919920,10919921,10919922,10919923,10919926,10919927,10919928,10919929,10919942,10919943,10919944,10919945,8864749,4974396,4974397,10629547,10629548,10629549,10629550,10629551,10629552,10629553,10629554,10629555,10629556,10629557) 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>