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(10497557,10497558,10497723,10497724,8591178,10497811,10497812,8591317,10497938,10497939,10497940,10497941,10497942,10498019,8591467,8591468,10929524,8068080,8068154,8068155,8068156,8068157,8068158,8068159,8068160,8068259,8068260,8068261,8068262,8068325,8068326,8068327,8068328,8068404,8068405,8835485,8835558,8835559,8068604,8068627,8068628,8068682,10841407,10841464,10841465,10841686,10841693,10841694,10102400,8908046,8555945,8555973,8555974,8556046,7069037,8613712,8613766,8613772,8613815,3924476,3924492,3924543,10216161,10216162,10216163,10216164,10216165,10216166,10216167,10216168,10216169,10216170,10216171,3581996,3581997,3582042,10216632,10216633,10216634,10216635,10217011,10217012,10217013,10217014,10217015,10217016,10217017,10217018,10217085,10217086,10217087,10426828,10426905,10426906,10217270,10426985,10217405,10217406,10217481,10217603,10217604,10217629,10217674,10217799,10217869,10217870,8905331,8575832,10215418,10215419,10215507,10215508,10215509,10215510,10215511,10215580,10215581,10215582,10215593,10215599,10425389,10215866,10215867,10215868,10215869,10215870,10215871,10215872,10215873,10215874,10215875,10215876,10425553,8569807,8569817,10498212,10498213,8591793,8574422,8574423,8574424,8574425,10930768,10930771,8574637,8574638,8574639,8574640,8574710,8574736,8574780,8574781,8574803,10621243,8574821,8574827,8574846,10621307,10621308,10621309,10616310,10616311,10616317,10616318,10616319,10621335,10621507,10214651,10214652,10214653,10214654,10214655,10214656,10214657,10214658,10214659,10214660,10214661,10214662,10214663,10214664,10214665,10214666,10214667,10214668,10214669,10214670,10214671,10621660,10621708,10621709,8583763,8583764,8583765,8583766,8583767,8853355,8853359,10940415,10940522,10940524,9179381,9179445,9179744,9179771,9179811,9179812,10120333,10120409,6676436,6676437,6676447,9914460,6676461,9914470,10120497,6676530,10120521,6676531,6676549,6676575,8567219,8567267,8567268,8567269,8567283,8863311,8567302,8567331,8567332,8567333,8863381,8567361,8567362,3654116,3654117,8863605,9178084,9178347,9178348,9178410,7056603,7056604,7056605,7056606,3651705,7056700,7056701,7056779,7056780,7056781,8066227,7056858,8066334,8066335,8066336,2809383,8066357,8066358,8066375,8066376,8066426,8066427,8066428,9178942,9178964,9178965,8066564,8066567,8066568,8066569,8066570,9178984,8066571,9178985,8066641,8066642,8066643,8066644,9179191,8066823,8066824,8066825,8066826,9179253,9179254,8851107,8851108,10427868,9910876,9910877,6672891,8848848,8848849,8848851,3963409,3963413,4972049,4972050,4972051,4972052,4972053,4972054,10463883,10463884,10463885,10463886,10463887,10463888,10463889,10463890,10463891,10463892,10463893,10463894,8917204,976607,10898543,10898574,10898589,10898615,10898631,8593698,8593699,10898744,10898745,10898746,10898747,10898748,8593762,8593915,8593925,8593944,8593960,8594011,8594012,10889153,10889154,10889175,10889195,10889196,10889197,10897520,10897521,10897561,10897562,10897563,10897634,10897653,10898086,10898087,10898159,10898160,10898252,10898253,10898254,10898255,10898256,10898257,10898258,10898259,10898260,10898261,10898262,10898263,10898264,10898265,10898266,10898267,10898430,10949199,10949444,10896695,10896930,10896957,10896964,10897047,10897048,10897049,10897294,10897295,10649568,10649624,10649820,10649836,10649837,10649838,10649839,10649840,10649841,10649855,10523761,10479661,10479662,10479663,10479831,10479882,10479883,10479884,10480010,10497066,10497067,10497140,10497141,10480208,10480209,10480281,10480282,10480283,10480403,10480404,10480441) 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>