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 FilterID4= '1' and material.ID in ('80872','88080','88675','88684','88668','88743','88716','88736','88673','88676','88739','88738','88701','88679','88658','88742','88656','88712','88711','88740','88667','88678','88715','88662','88680','88655','88733','88714','88737','88741','88685','88666','88659','88686','88702','88681','88744','88663','88735','88732','88660','88700','88734','88708','88703','88672','88719','88706','88709','88731','88720','88657','88718','88682','88683','88713','88730','88669','88674','88661','88704','88677','88710','87222','87872','87218','68689','83547','88654','62096','88641','88638','88645','88625','88571','88644','88643','88633','88615','88616','88570','88624','88640','88629','88642','88612','88634','88566','88626','88630','88628','88610','88632','87191','88572','88565','88635','88568','88636','88637','88623') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc