select nickname,c.title,latitude,longitude
from locations as l
join users as u
on u.location_id=l.id
join users_chats as uc
on u.id=uc.user_id
join chats as c
on c.id=uc.chat_id
where (latitude between 41.139999 and 44.129999) and (longitude between 22.209999 and 28.359999)
order by c.title asc