SELECT u.id_user, u.firstname, u.lastname, u.logo_src, c.city, us.user_id FROM users u, cities c, user_stalking us, COUNT(*) AS cnt WHERE u.city = c.id AND us.user_id = 100806 AND us.user_stalking_id = 100006 ORDER BY us.date DESC