use hewiki_p;

select * from page inner join page_props

on pp_page = page_id

where page_title = 'ברה"מ'

and pp_propname = "disambiguation";

select * from user where user_name = "IKhitron";

select *, STR_TO_DATE(day,'%Y-%m-%d') from user_daily_contribs

where user_id = 933 limit 10;

select datediff(now(), '2015-05-13');

select min(day), max(day) from user_daily_contribs;

select * from user as u1

where not exists

(select * from user_daily_contribs as udc

 where udc.user_id = u1.user_id

 and datediff(now(), day) > 91)

and exists

(select * from user_daily_contribs as udc

 where udc.user_id = u1.user_id);

select datediff(now(), NULL)

​