Aerospace & Defence - 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 = 82 order BY events.EventStartdate desc
Page 1 of 10 | 1 2 3 4 5 6 7 8 9 10 |