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 ('88576','88574','88581','88067','88051','88365','88514','88511','88065','88435','88513','88277','88362','88509','87049','88512','88510','88055','88552','88536','88493','88491','88553','88519','88544','88507','88525','88550','88528','88543','88502','88531','88549','88556','88495','88527','88497','88498','88506','88516','88520','88535','88548','88524','88496','88557','88518','88538','88359','88529','88501','88523','88554','88555','88551','88522','88530','88494','88352','88559','88505','88542','88532','88533','88500','88546','88521','88545','88492','88504','88547','88499','88540','88534','88517','88503','88541','88526','88539','88537','88558','88489','88486','88488','88490','88487','88059','88476','88484','88056','88477','88054','88434','88245','88473','88058','88480','88472','88243','88242','88244') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc