SELECT mk.Make_ID, mk.Make_Name, mk.Make_URL, md.Model_ID, md.Model_Name, md.Model_URL, md.Page_Header, md.Page_Content, md.Meta_Title, md.Meta_Desc, md.Meta_Keywords FROM k300_spax.Dampers_Make as mk, k300_spax.Dampers_Model as md WHERE mk.Make_ID = md.Make_ID AND Model_URL = ''