Ryan Edwards's dashboard

Hey i keep getting a database error whenever i try to register. it always says//

A Database Error Occurred
Error Number: 1052

Column 'email_address' in where clause is ambiguous

SELECT `u`.`user_name`, `u`.`email_address`, `u`.`date_created`, `u`.`id`, `u`.`old_member_id`, `u`.`password`, `u`.`postal_code`, `u`.`country`, `u`.`status_id`, `l`.`title` AS status, `u`.`last_login`, `u`.`referral_key`, `u`.`last_updated`, `ud`.`game_systems`, `ud`.`in_a_band`, `ud`.`favorite_bands`, `c`.`printable_name` as country_name, `s`.`id` AS survey_id, (CASE WHEN ml.unsub IS NULL OR ml.unsub='Y' THEN 1 ELSE 0 END) as unsubscribe FROM ((user u, `lookup` l)) LEFT JOIN `country` c ON `c`.`name` = `u`.`country` LEFT JOIN `beta_survey` s ON `s`.`user_id` = `u`.`id` LEFT JOIN `user_detail` ud ON `u`.`id`=`ud`.`user_id` LEFT JOIN `mailing_list` ml ON `ml`.`user_id`=`u`.`id` WHERE `l`.`id` = u.status_id AND `email_address` LIKE '%youdontneedtoknow@yahoo.com%'