Datasource: art Template: links-en.htx ODBCOptions: SQL_ACCESS_MODE = 1 SQLStatement: SELECT Link_types.name_en AS LinksType +FROM Link_types +WHERE Link_types.link_type_nr=%type%; SQLStatement:SELECT Links.name_en AS Name, Links.web AS URL, Links.image_file AS Image, Links.comments_en AS Descr, Countries.country_en AS Country, Links.end_date AS Enddate, Links.link_type_nr AS LinkType, Links.enabled +FROM Links INNER JOIN Countries ON Countries.country_nr = Links.country_nr +WHERE Links.link_type_nr=%type% AND Links.enabled = 1 AND (Links.end_date IS Null OR Links.end_date >= Date()) +ORDER BY name_en;