SELECT url_titles.url, url_types.type FROM urls, url_types, url_titles WHERE 
urls.type_id = url_types.type_id AND urls.title_id = url_titles.title_id