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(8574372,8574373,8574410,8574411,8574412,8574413,8574414,8574415,8574477,8574478,8574484,8574630,8574754,9215265,9215266,9215267,9215318,7068775,10940414,10940420,8569778,7068808,8569811,7068837,10940462,10940480,10940481,10940482,10940521,7068908,8583742,10868563,10977408,8609675,10977536,10977537,10977538,10977539,8591223,8591224,8591225,10497807,8591306,8591307,8591308,10497928,10497929,8068026,8068027,8591380,8068075,8068076,8591450,8591451,8591452,8591453,8591454,8068143,8068144,8068145,8068146,8068147,8591517,10498141,10498142,10498143,10498144,8591608,8068310,8068311,8068312,8068313,8068314,8591739,8068399,8068524,8068525,8068526,8068527,8068624,8835452,8835453,8066216,8066224,8066308,8066328,8066329,8066330,8066369,8066370,8066371,8066508,8066509,8066566,8066631,8066632,8066633,10497544,10497545,10497546,10497547,10497548,10497549,10497627,10497628,8591168,8591169,8591170,10102379,8908010,8555944,8555950,7069034,8555996,10841418,10981152,10981261,10981292,8613452,8613488,8613535,8613630,8613682,8613726,3924395,3924396,3924510,3924511,7158093,8907746,8907747,8907817,8907818,7155626,8905329,10425357,10977758,10977759,10977760,10977761,10977762,10977763,10977764,10977765,10425577,10978008,10978009,10978010,10978011,10978012,10978013,10978014,10978015,10978016,10978017,10978018,10978019,10978020,10978021,10978022,10978023,10978024,3581976,3581977,10978412,10978413,10978414,10978415,10978416,10978481,10978541,10978542,10978543,10978639,10978640,10978671,10978720,10978721,10621147,10621148,10621161,10978828,10978829,10978842,10978843,10621239,10621240,10621241,10621242,10621292,10621293,10621305,10621306,10426649,10426650,10979001,10426686,10426733,10426931,10621692,10621693,10621705,3232196,3232197,10979516,10979517,10979518,10979519,10979520,10979521,10979522,10979523,8853322,9179374,9179808,9179809,6676362,6676382,6676383,6676419,9914421,6676420,9914464,10120557,8567183,8567184,8567187,8567265,8863309,8863310,8863331,8863377,8863378,8863401,8863425,3654115,8863444,8863532,8863533,8592786,10126068,9178027,9178210,9178290,9178291,9178292,7056459,9178293,9178294,7056468,7056480,9178335,9178336,9178337,9178338,9178402,9178403,9178404,9178405,9178406,3651704,9178536,9178537,9178538,7056775,9178626,9178709,9178891,9178892,9178893,9178988,8850838,8850839,9910599,6666958,6666959,6666977,6666978,6666979,4971942,4971943,4972016,4972017,4972046,4972047,10462485,10462486,10462487,10462488,10462489,10462490,10462491,10462492,10462493,10462494,10462495,10462496,10462497,10462498,10462499,10462500,9168076,8593596,8593604,8593605,8593606,8593607,8593608,8593609,8593610,8593611,10898667,10898674,10898675,8593693,8593694,10898712,8593754,8593755,8593858,10889189,10889190,10889191,10889227,10897517,10897518,10897519,10897553,10897554,10897555,10897556,10897557,10897558,10897559,10897560,10897652,10897665,10897666,10897667,10897735,10897822,10897823,10897824,10897825,10168953,10168954,10168955,10168956,10898079,10898080,10949157,10949158,10949170,10949171,10949180,10949181,10949191,10949192,10949193,10949194,10949195,10949253,10949254,10949255,10949256,10949257,10896541,10949389,10896580,10896721,10896722,10896723,10896724,10896821,10896822,10896823,10896824,10896929,10896953,10896954,10896955,10896956,10897030,10897031,10897032,10897033,10897290,10897291,10897292,10897293,10897309,10897310,10897311,10897312,10897313,10897314,10897315,10897316,10897317,10897318,10897319,10897320,10897321,10643485,10643486,10649516,10649517,10649533,10649617,10649621,10649622,10649623,10649650,10649651,10649679,10649853,10649854,10523685,10479201,10479288,10479289,10479362,10479363,10479582,10479613,10479614,10479615,10479616,10479617,10479742,10479743,10479744,10479787,10479788,10479789,10479790,10479791,10479792,10479793,10479953,10479954,10480361) 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>