select *
from ip_changes
where ipc_rev_timestamp like "2005%" |
3 years ago |
select *
from ip_changes
where ipc_rev_timestamp like "2004%" |
3 years ago |
select *
from ip_changes
where ipc_rev_timestamp like "2003%" |
3 years ago |
select *
from ip_changes
where ipc_rev_timestamp like "2003" |
3 years ago |
select *
from ip_changes
where year(ipc_rev_timestamp)=2002 |
3 years ago |
select *
from ip_changes
where ipc_rev_timestamp like "2002%" |
3 years ago |
select *
from ip_changes
where ipc_rev_timestamp like "200301%" |
3 years ago |
select count(*)
from ip_changes
where ipc_rev_timestamp like "200301%" |
3 years ago |
select count(*)
from ip_changes
where ipc_rev_timestamp like "200701%" |
3 years ago |
select count(*)
from ip_changes
where ipc_rev_timestamp like "200201%" |
3 years ago |
select * from page
where page_title like "%Wikipedian%" |
3 years ago |
select * from category
where cat_title like "%Wikipedian%" |
3 years ago |
select * from category
limit 5 |
3 years ago |
select revactor_actor,count(*) as numberofrevision
from... |
3 years ago |
select revactor_actor as actorid,count(*) as numberofrevision
from... |
3 years ago |
select revactor_actor as actorid,count(*) as numberofrevision
from... |
3 years ago |