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 ('88508','81345','88576','88581','88574','88051','88065','88067','88435','88514','87049','88513','88510','88509','88055','88512','88362','88277','88511','88365','88498','88523','88532','88525','88536','88526','88507','88497','88543','88558','88559','88541','88549','88547','88527','88540','88556','88506','88504','88496','88528','88519','88535','88548','88552','88517','88492','88550','88554','88520','88522','88352','88534','88518','88495','88553','88531','88544','88529','88538','88551','88501','88530','88505','88546','88494','88555','88499','88502','88500','88545','88359','88537','88516','88503','88533','88491','88521','88493','88524','88557','88539','88542','88486','88490','88488','88487','88489','88242','88058','88053','88056','88476','88243','88059','88244','88477','88433','88472','88473','88434') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc
