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(8631031,8631032,8631033,8631034,8631035,8631036,8631037,8631038,8631039,8631040,8631041,8631042,8631043,8631044,8631045,10861851,10861852,10861853,10861854,10861855,10861856,10861857,10861858,10861859,10861860,10861861,10861862,10861863,10861864,10861865,10861866,10861867,10861868,10861869,10861870,10861871,10861872,10861873,10861874,10861875,10861876,10861877,10861878,10861879,10861880,10861881,10861882,10861883,10861884,10861885,10861886,10861887,10861888,10861889,10861890,10861891,10861892,10861893,10861894,10861895,10861896,10861897,10861898,10861899,10861900,10861901,10861902,10861903,10861904,10861905,10861906,10861907,10861908,10861909,10861910,10861911,10861912,10861913,10861914,10861915,10861916,10861917,10861918,10861919,10861920,8583528,7066140,7066245,7066246,8630295,7201414,7201415,7201416,7201417,7201418,7201419,7201420,7201421,8595286,8595287,8065845,8628601,8628602,5654633,9794580,7200340,7200341,7200342,7200343,7200344,7200345,7200346,7200347,7200348,7200349,7200350,7200351,7200352,7200353,7200354,7200355,7200356,7200357,7200358,7200359,7200360,7200361,7200362,7200363,7200364,7200365,7200366,7200367,7200368,7200369,7200370,7200371,7200372,7200373,7200374,7200375,7200376,7200377,7200378,7200379,7200380,7200381,10865822,10865823,10865824,10865825,10865826,10865827,10865828,10865829,10865830,10865831,7199267,7199268,7199269,7199270,7199271,10101546,10101575,3923592,10623491,10623492,8906592,8906785,8906786,8906787,8906788,8906789,8906790,8906791,8906792,8906793,8906794,7197205,7197206,10928330,8905874,8905875,8905876,8905877,8905878,8905879,8634104,8634107,8634110,8611394,10616745,10616746,10616747,10616748,10616749,10616750,10616751,10616752,10616753,10616754,10616755,10616756,10616757,10616758,10616759,10616760,10616761,10616762,10616763,10616764,10616765,10616766,10616767,10616768,10616769,10616770,10616771,10616772,10616773,10616774,10616775,10614050,10714169,10614597,10614598,10614599,10614600,10614601,10614602,10614603,10614604,10614605,10614606,10614607,10614608,10614609,10614610,10614611,10614612,10614613,10614614,10614615,10614616,10614617,10614618,10614619,10614620,10614621,10614622,10614623,10614624,10614625,10614626,10614627,10614628,10614629,10614630,10614631,10614632,9166039,10609562,8566717,8852197,8852198,8852199,8852700,8852701,8852702,8852703,8852704,8852705,8852706,8852707,8852708,8852709,8852710,8852711,8852712,6673521,9169322,9169323,9169324,9169325,6673744,6673745,6673746,6673747,6673748,9169808,9169809,9169810,9169811,10118249,10118250,6674267,10118524,10118537,10118606,10118607,9912821,9912822,9912823,9912824,9912825,9912826,9912827,9912828,9912829,9912830,9912831,9912832,9912833,9913255,10116725,10415693,10415694,10415695,10415696,10415697,10415698,10415699,10415700,10415701,10415702,10415703,10415704,10415705,10415706,10415707,10415708,10415709,10415710,10415711,10415712,10415713,10415714,10415715,10415716,10415717,10415718,10415719,10415720,10415721,10415722,10415723,10415724,10415725,10471087,10471088,10471089,10471090,10471091,10471092,10471093,10471094,10471095,8550018,10469641,10469642,10469643,10469644,10469645,10469646,10469647,10469648,10469649,10469650,10469651,10469652,10469653,10469654,10469655,10469656,10469657,10469658,10469659,976550,976551,10883971,10889628,10889629,10889630,10889631,10889632,10887566,10887567,10887568,10887569,10887570,10887571,10887572,10887573,10887574,10887575,10887576,10887577,10887578,10887579,10887580,10887581,10887582,10887583,10887584,10887585,10887586,10887587,10887588,10887589,10887590,10887591,10887592,10887593,10887594,10887595,10887596,10887597,10887598,10887599,10887600,10887601,10887602,10887603,10887604,10887605,10888325,10162120,10162121,10162122,10162123,10162124,10162125,10162219,10162220,10647608,10647609,10647610,10647611,10647612,10647613,10508026) 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>