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 FilterID4= '1' and material.ID in ('87595','87042','87912','87875','87899','87913','87165','87574','87890','87037','87048','85948','87452','87876','87914','87559','87086','87451','87854','78298','87868','87924','87069','87380','87115','87895','87896','87387','87902','87856','87132','87094','82030','87878','87891','87148','87886','83038','76392','87926','87942','87933','87943','87928','87932','87947','87940','87927','86426','87948','87937','87925','87938','85309','77523','85272','87997','88002','87931','88007','87939','87941','87930','88004','87934','85632','88006','87998','88000','87929','85915','88047','88037','88045','88040','88046','88039','88044','88038','88048','88041','88043','88042','87078','87397','87339','87540','87779','88034','87777','87405','87056','87770','87495','87781','88036','87778','87780','87771','87402','87403') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc