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