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 material.ID in ('88121','88230','88189','88088','88120','88122','88114','88117','88166','88119','88172','88123','88188','88113','88179','88083','88180','88262','88193','88115','88184','88263','88177','88116','88118','88196','88195','88261','88274','88276','88289','88273','88275','86252','76339','88181','88095','88197','88111','88140','88144','88063','88173','88062','88104','88175','87141','88145','88068','88176','88103','88147','88141','88174','88092','88085','88100','88136','88169','88138','88093','88146','88091','88171','88064','88167','87976','88061','88134','87057','88170','88112','88178','88060','88096','88194','88094','83089','87277','87239','88228','88229','88227','88132','87117','88153','87441','88160','88161','87471','88156','88159','88157','87400','88135','88133','88137','88158','87170','88152','87210') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc