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(8595108,7201743,10859073,8629514,8627068,10857916,10857917,10857918,10857925,10857927,10857931,10857932,10857933,10857934,10857935,10857937,10857939,10857941,10857942,10857943,10857944,10857945,10857948,10857950,10857952,10857953,10857956,10857957,10857958,10857960,10857961,10857964,10857966,10857968,10857969,10857972,10857974,10857975,10857976,10857977,10857980,10857981,10857983,10857984,10857986,10857987,10857988,10857989,10857992,10857993,10857994,10857997,10857999,10858003,10858004,10858005,10858007,10858009,10858011,10858012,10858014,10858015,10858016,10858019,10858020,10858021,10858022,10858024,10858025,10858027,10858028,10858029,10858032,10858033,10858035,10858036,10858039,10858040,10858042,10858043,10858044,10858046,10858048,10858049,10858051,10858053,10858056,10858057,10858058,10858060,10858062,10858063,10858064,10858066,10858067,10858068,10858070,10858072,10858073,10858074,10858075,10858076,10858077,10858078,10858079,10858082,10858083,10858085,10858086,10858087,10858088,10858089,10858090,10858091,10858092,10858093,10858094,10858096,10858100,10858101,10858102,10858103,10858104,10858105,10858106,10858111,10858112,10858113,10858115,10858121,10858123,10858125,10858127,10858128,10858129,10858130,10858132,10858135,10858136,10858138,10858139,10858141,10858145,10858147,10858148,10858149,10858151,10858156,10858159,10858161,10858162,10858163,10858168,10858172,10858173,10858175,10858177,10858186,10858189,10858190,10858191,10858192,10195167,10856222,10856225,10856230,10856234,10856235,10856238,10101498,10857622,7197986,10855050,10855051,10855054,10855057,10855060,10855067,10855593,10855594,10855595,10855596,10855600,10855601,10855605,10866359,10866360,10866361,10866362,10866363,10866364,10866365,10866366,8554319,10426387,8540600,8632383,8632384,10615398,10615526,10615571,10861831,10861832,10861833,10861834,10861837,3229141,3229144,10616656,10616657,10862482,10862483,10862484,10862485,10862486,10862487,10862488,10862489,10862490,10862491,10862492,10862493,10862494,10862495,10862496,10862497,10862498,10862499,10862500,10862501,10862502,10862503,10862504,10862505,10862506,10862507,10862508,10862509,10862510,10616840,10862511,10616841,10862512,10862513,10862613,10614275,10614276,10612051,10612052,10612053,10612344,7017375,7017376,7017381,7017382,7017385,7017386,7017387,7017388,7017393,7017394,7017399,7017400,8852379,10613350,10613351,10613352,8853017,10117874,10117875,10118097,6674156,8850129,10416256,9168375,9168376,9168377,10419367,10419368,10419369,10419370,6672911,8549958,8549959,8549960,8549961,8550123,8550124,976478,10468437,10888576,10888577,10888578,10888579,10884727,10884728,10884729,10884730,10884759,10887785,10887786,10887787,10887788,10887789,10885731,10885732,10162051,10887136,10887137,10887138,10887139,10610271,10610289,10610300,10610836,10527002,10415675,10415676,10415677,10415678,10415680,10507757,10507892,10507986,10416120,10416121,10416122,10416123,10416124,10416125,10416126,10416127,10416128,10416129,10416130,10416131,10416132,10416133,10416134,10416135,10416136,10416137,10416138,10416139,10416140,10416141,10416142,10416143,10416144,10416145,10416146,10416147,10416148,10416149,10411315,10411318,10411321,10411322,10411325,10413575,10412236,10410263,10410264,10410270,10410273,10410277,10412501,10412502,10412503,10412509,10412511,10412513,10412516,10412517,10412518,10412519,10412521,10412523,10412525,10412526,10412527,10412528,10412529,10412530,10412532,10412534,10412535,10412537,10412539,10412540,10412543,10412544,10412545,10412547,10412548,10412551,10412553,10412555,10412556,10412559,10412560,10412561,10412562,10412563,10412566,10412567,10412569,10412570,10412572,10412573,10412574,10412575,10412578,10412579,10412580,10412583,10412585,10412589,10412590,10412591,10412592,10412594,10412596,10412597,10412598,10412600,10412601,10412602,10412603,10412604,10412605,10412606,10412608,10412609,10412611,10412612,10412613,10412616,10412619,10412620,10412622,10412623,10412624,10412625,10412626,10412627,10412628,10412629,10412630,10412631,10412634,10412635,10412636,10412638,10412639,10412641,10412642,10412643,10412645,10412646,10412647,10412649,10412651,10412652,10412653,10412654,10412655,10412656,10412657,10412658,10412660,10412661,10412662,10412664,10412665,10412666,10412667,10412668,10412669,10412670,10412671,10412672,10412673,10412674,10412675,10412676,10412680,10412681,10412682,10412683,10412684,10412685,10412687,10412689,10412690,10412691,10412692,10412693,10412695,10412697,10412699,10412700,10412701,10412702,10412704,10412706,10412707,10412708,10412709,10412710,10412712,10412715,10412717,10412718,10412719,10412721,10412726,10412728,10412729,10412731,10412732,10412733,10412734,10412736,10412738,10412740,10412741,10412742,10412744,10412745,10412746,10412755,10410756,10410757,10410758,10410759,10410760,10412760,10412761,10412762,10412763,10410764,10410765,10410766,10410767,10410771) 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>