| SELECT
page_namespace,
MAX(notredir),
MAX(redir)
FROM (
SELECT... |
10 months ago |
| -- -- |
2 years ago |
| select user_name from `user`
where user_name rlike 'বট$'
limit 100; |
2 years ago |
| select user_name from `user`
where user_name rlike 'বট[[:>:]]'
limit 100; |
2 years ago |
| select user_name from `user`
where user_name like '%বট%'
limit 100; |
2 years ago |
| -- -- |
2 years ago |
| select
CONCAT('[[User:', page_title, ']]'),
rd_title
from page join... |
2 years ago |
| select CONCAT('[[User:', page_title, ']]'), rd_title from page
join... |
2 years ago |
| select page_title, rd_title from page
join redirect
where page_namespace =... |
2 years ago |
| select page_title, rd_title from page
join redirect
where page_namespace =... |
2 years ago |
| select rd_interwiki from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select rd_interwiki from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select rd_interwiki from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select rd_interwiki from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select rd_interwiki from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select rd_interwiki from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select rd_interwiki from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select rd_interwiki from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select * from page
join redirect
where page_namespace = 2
and... |
2 years ago |
| select * from page
where page_namespace = 2
and page_is_redirect = 1
limit 1 |
2 years ago |
| select * from page limit 3; |
2 years ago |
| -- -- |
2 years ago |
| -- -- |
2 years ago |
| -- -- |
3 years ago |
| select page_title from page
where page_title like '%:%'
limit 50; |
3 years ago |
| select count(page_title) from page
where page_title like '%:%' |
3 years ago |
| select page_title from page
where page_title like 'বিষয়শ্রেণী:%' |
3 years ago |
| -- -- |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS day,
COUNT(rev_timestamp) AS... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d %H") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d %H") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d %H") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d %H") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d %h") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d:%h") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
3 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
3 years ago |
