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 ('87408','87388','87340','87401','87432','87377','87345','87498','87493','87436','87347','87431','87417','87395','87399','87439','87358','87433','87393','87422','87375','87492','87411','87413','87389','87336','87424','87343','87435','87421','87392','87419','87494','87346','87344','87499','87398','87390','87341','87420','87373','71571','77324','82300','54038','86964','86854','64591','86594','82434','82764','71017','76398','76443','78177','85269','87013','87030','87080','87017','87036','87005','87009','87035','87006','87031','87027','87061','87014','87025','87012','87010','87068','85262','87070','87072','87028','87026','87059','87023','87008','87018','87034','87001','82779','87063','87033','87002','87058','87029','87074','87081','87032','87066','87015','87077','87003','87071','87021','87007','87022') AND material.FilterID3 IN ('2') group by material.ID ORDER BY Position desc, `material`.`ENTRYDATE` desc
