select up_user, actor_name, actor_id, rev_timestamp from user_properties join actor join revision_userindex

on up_user = actor_user

and rev_actor = actor_id

where up_property = 'gender'

and up_value = 'female'

#actor_name = 'IKhitron'

and rev_timestamp like '202206%' or rev_timestamp like '202207%'

/*and exists

(select * from revision_userindex

 where rev_actor = actor_id

 and rev_timestamp like '202206%' or rev_timestamp like '202207%')*/

limit 100

​