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='33') and material.ID in ('88533','88498','88542','88535','88549','88492','88526','88495','88497','88496','88525','88547','88538','88556','88536','88523','88558','88534','88548','88519','88550','88559','88507','88493','88528','88494','88521','88540','88359','88504','88516','88532','88557','88531','88545','88541','88502','88506','88543','88503','88522','88546','88553','88537','88518','88552','88499','88544','88524','88554','88551','88539','88500','88530','88555','88501','88517','88529','88352','88520','88491','88505','88527','88490','88487','88489','88486','88488','88059','88245','88485','88472','88052','88244','88473','88484','88050','88056','88054','88243','88434','88477','88482','88058','88053','88433','88476','88481','88480','88242','88483','88314','88317','88315','88438','88436','88474','88475','88324','88325','88439') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc