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 ('87036','87031','87034','87030','87063','87035','87068','87080','87013','87009','87061','87014','87081','87011','87033','87016','87059','87015','87010','87026','87058','87022','87006','87075','87023','87027','87070','87077','87025','87020','87005','87001','87003','87029','87074','87032','87007','87028','87017','87021','87072','87018','87012','87019','87071','87002','87066','87008','76062','87004','82472','70168','70969','85312','77196','76519','81504','78504','86715','69954','77796','86458','86824','78492','64120','86195','82182','82892','77135','81806','86985','86990','86982','86988','86992','86998','86997','85351','86983','86984','86993','85323','85400','86986','86991','86994','82916','86975','85349','86973','86820','86214','76898','86954','86969','86956','86957','86968','86967','86962','86533') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc