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 material.ID in ('88411','88306','88102','88310','88313','88312','88090','88401','88097','88304','88311','88305','88108','88309','88101','88303','88110','88419','88426','88424','88355','88339','88338','88319','88353','88316','88320','88323','88342','88340','88354','87872','88343','88429','88302','88428','88418','88425','88336','88422','88330','88421','88427','88337','88420','88423','88430','88308','88431','88301','88318','87883','87189','87289','87893','87366','87898','88248','88247','88385','87631','88410','88416','88379','88396','88287','88384','88282','88377','88349','88285','88265','88393','88378','88414','88399','87292','88387','88284','88391','88256','88405','88383','88286','88266','88344','88380','88400','88283','88267','88348','88408','88234','88382','88388','88395','88394','88386','88407','88390','88381') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc