SELECT material.Season, material.OfferPos, material.CODE, New, Best, FreeSend, Eukairia, ShopOnly,BARCODE, Mini_DescrLANG, WHSPRICE,RTLPRICE, StockHouse, material.Timh_x_katast, Timh_l_katast, material.TitleLANG, material_category.CT1, material_category.CT2, material_category.CT3, material_category.CT4, material.DescrLANG, material_color.COLORGROUP as Color, Offer, OfferPrice, OfferDate, OfferDateTo, VAT_ID, material.Active,Synthesi,mainszlid,material.ID,material.Availability,material.FileName,DATE_FORMAT(material.AvailExpected,'%d/%m/%Y') as _AvailExpected, (select TitleLANG from manufacture where manufacture.Active=1 and manufacture.ManufID=material.ManufacturerID) as Manufacture, (select TitleLANG from marka where marka.Active=1 and marka.MarkID=material.MarkaID) as Marka, material.QTY,RESERVED,AvailExpected FROM material inner join material_category on material_category.MaterialID=material.ID left join material_filterXM on material_filterXM.MaterialID = material.ID left join material_color on material_color.ID = material.ID WHERE material.Active=1 AND (CT1='31') and FilterID4= '2' and material.ID in ('67473','62677','62676','62640','67886','62643','84455','79668','88908','88912','88649','88916','88921','88750','88824','88804','88805','88915','88307','88913','88515','88822','88918','88631','88906','88919','88760','88823','88793','88907','88917','88911','88920','88650','88639','88803','88843','88066','88904','88819','88820','79874','88826','88821','88873','88878','88871','88881','88875','88887','88872','88865','88898','88896','88880','88879','88895','88889','88874','88877','88884','88868','88876','88890','88894','88892','88888','88893','88882','88891','88866','88885','88851','88858','88870','88852','88861','88856','88850','88849','88862','88864','88854','87609','88855','88859','88860','88863','88867','88853','88857','87090','88837','88833','88835','88832','88839','88844','88838','88842','88834') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc