Basic Materials - Documentation
Proceedings of past Conferences, Seminars and Exhibitions

SELECT DISTINCT events.catalogid, events.EventStartDate FROM products events INNER JOIN Products_Categories prodcats ON events.catalogid = prodcats.CatalogId INNER JOIN Categories_AncestorOrSelfCategories ancestor ON ancestor.CategoryID = prodcats.CategoryId INNER JOIN Shopcountries country ON events.eventcountry = country.countryid INNER JOIN producttype eventtype ON events.eventtype = eventtype.typeid where events.isDocsEvent = 1 and ancestor.AncestorCategoryID = 217 order BY events.EventStartdate desc