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