MySQL: campi con stesso identificativo

[Progeny]

risolto, santa la molecola della caffeina :rollo:

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