MySQL: campi con stesso identificativo

[Progeny]

$mysql->query("SELECT visits.uid,
                      DATE_FORMAT(visits.date, '%e %M %Y - %T') AS `fdate`,
                      visits.target,
                      users.username,
                      users.sex,
                      cities.description AS `city`
               FROM visits, profile AS `profile_tmp`
               LEFT JOIN users ON users.id = visits.uid
               LEFT JOIN `cities` ON cities.id = profile_tmp.city
               WHERE visits.target = '$uid' AND visits.date > DATE_ADD(CURDATE(), INTERVAL -1 DAY)
               ORDER BY visits.date DESC"); 

Database error: Invalid SQL: SELECT visits.uid, DATE_FORMAT(visits.date, '%e %M %Y - %T') AS `fdate`, visits.target, users.username, users.sex, cities.description AS `city` FROM visits, profile AS `profile_tmp` LEFT JOIN users ON users.id = visits.uid LEFT JOIN `cities` ON cities.id = profile_tmp.city WHERE visits.target = '1' AND visits.date > DATE_ADD(CURDATE(), INTERVAL -1 DAY) ORDER BY visits.date DESC
MySQL Error: 1054 (Unknown column 'visits.uid' in 'on clause')
Session stopped.

non va