select a.name
from mesta as a join mes_oso as b on (a.id = b.id_mesta)
join osobennosti as c on (b.id_os=c.id)
where c.name_os in ('wi_fi', 'coffee_to_go')
group by a.name
having count(*) = 2
listen 127.0.0.42:80;
Listen 127.0.0.43:80
Но я нахожусь в Украине, а у нас на данный момент этот сервис заблокирован
WHERE f=1
AND tab.site_id = '5568'
AND user_payment >= '2016-06-01'
AND user_payment < '2017-07-01'