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= '1' and material.ID in ('87984','87961','87963','87965','87974','87968','87960','87969','87962','87964','76232','87973','87971','87975','87972','87977','87982','78478','87981','87845','87144','87581','82709','87113','83170','87097','87607','87855','87281','82180','87288','82710','87093','87135','86341','87107','87309','87076','87111','87585','87584','87450','87137','87444','87849','87586','87304','87145','87566','87483','87122','87286','87364','87462','87064','87206','87830','87443','87475','87182','87168','87833','87311','87841','87105','87472','87609','87163','87844','87842','87838','87839','87151','87260','87367','87202','87125','87576','87162','87233','87600','87834','87158','87278','87429','87045','87112','87591','87604','87836','87404','87831','87829','87562','87837','87618','87428','87840','87274','87430','87332') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc