SELECT `address`.`id`,`address`.`city`,`address`.`zip`,`address`.`street`, `address`.`type`, `address`.`url`, `address`.`location`, `countries`.`country_name` as country FROM address, countries WHERE `address`.`id`=245 AND `countries`.`id`=`address`.`country`


SELECT `address`.`id`,`address`.`city`,`address`.`zip`,`address`.`street`, `address`.`type`, `address`.`url`, `address`.`location`, `countries`.`country_name` as country FROM address, countries WHERE `address`.`id`=329 AND `countries`.`id`=`address`.`country`