select count(*), substring(page_touched, 1, 4) as year
from page
where... |
1 year ago |
select * from page
where page_title='चेन्नई'
limit 100
|
1 year ago |
select * from page
where page_title='मद्रास'
limit 100
|
1 year ago |
select * from page
where page_title='कलकत्ता'
limit 100
|
1 year ago |
select * from page
where page_title='भारत'
limit 100
|
1 year ago |
select * from page
limit 100
|
1 year ago |
select * from page
where page_title='Hyderabad'
limit 10
|
1 year ago |
select count(*), substring(page_touched, 1, 4) as year
from page
where... |
1 year ago |
select count(*), substring(page_touched, 1, 4) as year
from page
where... |
1 year ago |
select count(*), substring(page_touched, 1, 4) as year
from page
where... |
1 year ago |
select count(*), substring(page_touched, 1, 4) as year
from page
where... |
1 year ago |
select * from page
limit 10 |
1 year ago |
select count(*), substring(page_touched, 1, 4) as year
from page
where... |
1 year ago |
select count(*), substring(page_touched, 1, 4) as year
from page
where... |
1 year ago |
select count(*), substring(page_touched, 1, 4) as year
from page
where... |
1 year ago |
select count(*), substring(page_touched, 1, 5) as year from page
where... |
1 year ago |
select count(*) from page
where page_is_new=1
group by substring(page_touched, 1, 5); |
1 year ago |
select count(*), grouped from page
where page_is_new=1
group by... |
1 year ago |
select count(*), grouped from page
where page_is_new=1
group by... |
1 year ago |
select count(*), grouped from page
where page_is_new=1
group by... |
1 year ago |
select count(*), grouped from page
where page_is_new=1
group by... |
1 year ago |
select * from page
where page_is_new=1
LIMIT 10; |
1 year ago |
select * from page
LIMIT 10; |
1 year ago |
select * from page; |
1 year ago |
select * from p; |
1 year ago |
select * from hiwiki_p; |
1 year ago |
select * from hiwiki; |
1 year ago |
select * ; |
1 year ago |
select * from hiwiki; |
1 year ago |
select * from hiwiki; |
1 year ago |
select * from hiwiki; |
1 year ago |
select * from hiwiki; |
1 year ago |
use hiwiki
select * from hiwiki; |
1 year ago |