Between dates ?

[Johan Andersson]

I have this query

select
u1.user_name as `user_name being followed`,
u2.user_name as `follower_name that followes`,
ua.*
from users u1
join users_followers uf on uf.user_id=u1.user_id
join users u2 on u2.user_id = uf.follower_id
join user_activity ua on ua.user_id = u2.user_id
where u1.user_name='demo'
order by ua.activity_timestamp


but i only want to fetch query between column follower_since_timestamp in table users_followers and now().

How do i do this? Thanks!