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(11001986,4970750,10459186,10459187,10459188,11002337,11002338,11002339,11002349,11002350,11002351,10459248,10459249,10459250,10459251,11028394,11028395,11028396,11028397,11028398,11028399,11028400,11028401,11028402,11028403,11028404,11028523,11028524,11028525,11002526,11028526,11002527,11028527,11002528,11028528,11028529,11002529,11028530,11002530,11028531,11028532,11002533,11028533,11028534,11028535,11028536,11028537,11028538,11028539,11028540,11028541,11028542,11028543,11028544,11028545,11028546,11028547,11028548,11028549,11028550,11028551,11028552,11028553,11028554,8569875,11002669,11002670,11002675,11002676,11002677,11002678,11002679,11002680,11002681,11002682,11002683,11002684,11002848,11002849,11002956,11002987,11002988,11002989,11002990,11002991,11003059,11003244,11003245,11003246,11003247,11003248,11003249,11003250,11003251,11003252,11003253,11003254,11003255,11003256,11003257,11003258,11003259,11003260,11003404,11003405,11003406,11003409,11003410,11003537,11003538,11013807,10961880,10498064,8620132,8591550,8591551,8620201,8620204,11014107,11014108,11014109,11014110,8620310,8837982,8837983,8837984,11014294,11014295,11014296,11014297,11014298,11014299,11014362,11014363,7067686,10873123,8065514,8065515,8065516,8066003,8560126,11025931,11025932,11025933,11025934,11025935,11025936,11025937,11025938,11025939,11025940,11025941,11025942,11026056,11026057,11026058,11026059,11026060,11026061,11026062,11026063,11026064,8066477,10104812,10961563,10933258,11023953,11023954,10998120,10858146,11034626,7069001,7069002,7069003,11034797,11034799,10863408,11034824,11034825,11034826,11034913,11035034,11035036,11035122,11035123,11035124,11022207,11022208,11022209,11022210,11022211,11022212,11022213,11022214,11022215,11022216,11022217,11035257,11035354,11035374,11035375,11035376,11035606,11035607,11035608,11035609,11035610,11035611,11035612,11035613,11035614,11035615,11035616,11035630,11035631,11022682,11022697,11022698,11022699,11035792,11035793,11022824,11022825,11022826,11022827,11022994,11023040,11023041,10997136,10997137,11023199,11023200,11023201,10997266,10997267,10942232,10942233,11023434,11023472,11023561,10853311,11020051,11020052,11020053,11020054,11020055,11020056,11020057,11020058,11020059,11020060,11020061,11020062,11033491,11033650,11033651,11033659,11033660,11033661,11033662,11033663,11033664,7157631,7157635,11033818,11033819,11033820,11033833,11033834,11034041,11034042,10995163,10995203,3234983,11034294,11034295,11034581,11034582,11005626,11005627,11005732,11031821,11031839,11031840,11031841,11031842,11031843,11031844,11031845,11031846,11031847,11031848,10852701,3232858,10967154,10967155,11032196,11032197,11032198,11032199,11032200,10837285,10837286,10967578,11003623,11003624,11003625,10460549,11003737,11003738,11003740,11003741,10925680,10925681,11003895,11003896,11003988,11003989,11003990,11004073,11030345,11030346,11030347,11030412,11030413,11030414,11030415,11030416,11030417,11030418,11030419,11030420,11030421,11030422,11030423,11030424,10952410,11004592,11004593,11004997,11004998,11031056,11031057,11031058,10979058,11031059,10979059,11031060,11031070,11031071,11031072,8611433,10966322,10966323,11031359,11031360,11031361,11031362,11031363,11031364,11005395,11005396,11005424,11005425,3232189,8634437,7155344,7059732,9173785,7058739,8863495,6674675,9179087,9179088,10427947,10416944,9174598,8569156,6666867,6666868,9190884,9206919,9206920,9206921,8855272,9175660,9191951,9191962,9191977,10888869,10893892,10155772,10629580,10158676,10158677,10158678,10158679,10158680,10163876,10163877,10171610,10171611,10171612,10171613,10171614,10171615,10948420,10948421,10630105,10167445,10949363,10949364,10568549,10650044,10599336,10599337,10599338,10599339,10653826,10650892,10650893,10650894,10650895,10650896,10650897,10650898,10650899,10650900,10607671,10541789,10541790,10541791,10541792,10541793,10541794,10541795,10522782,10522783,10522784,10423863,10412064,10479930,10479933,10494990,10412716,10480828) 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>