select rev_timestamp
from revision
WHERE rev_timestamp like '2012%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2011%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2010%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2009%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2008%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2007%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2006%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2005%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2004%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2003%' |
2 years ago |
select rev_timestamp
from revision
WHERE rev_timestamp like '2003%'
LIMIT 2 |
2 years ago |
select rev_id, rev_timestamp from revision order by rev_timestamp LIMIT 2 |
2 years ago |
select rev_id, rev_timestamp from revision LIMIT 10 |
2 years ago |
select rev_timestamp from revision LIMIT 10 |
2 years ago |
select rev_timestamp from revision LIMIT 1000000 |
2 years ago |
select count(rev_id) from revision |
2 years ago |
select rev_timestamp from revision LIMIT 100000 |
2 years ago |
select rev_timestamp from revision LIMIT 10000 |
2 years ago |
select rev_timestamp from revision LIMIT 1000 |
2 years ago |