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 ('88095','88175','88197','88167','88134','88174','88094','88091','87976','88100','88064','88060','88144','88063','88145','88171','88062','88176','88147','88096','88138','88169','88194','88178','88061','87057','88170','88136','88104','88173','88112','88141','88181','88068','88103','88085','88146','87141','88140','88092','88093','88111','83089','87277','87239','88227','88229','88228','88222','88151','88207','88202','88209','88160','87409','88204','88206','88217','88213','87471','87041','87441','88137','88224','88214','88161','88148','88154','88139','88143','88133','88132','88156','88199','88205','88219','88149','87587','88162','87170','88152','87117','88142','88215','88153','88216','88159','88223','88210','88201','88157','88135','88158','88220','88208','88150','88218','87400','87861','88212','88211') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc
