| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m") AS month,
... |
11 months ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y") AS year,
COUNT(rev_timestamp) AS... |
1 year ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y") AS year,
COUNT(rev_timestamp) AS... |
2 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y") AS year,
COUNT(rev_timestamp) AS... |
2 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%m %Y") AS month,
... |
2 years ago |
| -- -- |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision_userindex
JOIN... |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision_userindex
JOIN... |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision_userindex
JOIN... |
2 years ago |
| select * from user_groups
join user on user_id = ug_user
limit 30; |
2 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision_userindex
JOIN... |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| SELECT CONCAT("{{টেমপ্লেট:", page_title, '}}') as Template
FROM... |
2 years ago |
| SELECT page_title FROM categorylinks
JOIN page ON page_id = cl_from
WHERE... |
2 years ago |
| SELECT page_title FROM categorylinks
JOIN page ON page_id = cl_from
WHERE... |
2 years ago |
| SELECT page_title FROM categorylinks
JOIN page ON page_id = cl_from
WHERE... |
2 years ago |
| -- SELECT * FROM templatelinks
-- LIMIT 10;
SELECT * FROM categorylinks
JOIN... |
2 years ago |
| -- SELECT * FROM templatelinks
-- LIMIT 10;
SELECT * FROM... |
2 years ago |
| -- SELECT * FROM templatelinks
-- LIMIT 10;
SELECT * FROM... |
2 years ago |
| SELECT * FROM templatelinks
LIMIT 10;
SELECT * FROM categorylinks
LIMIT 10; |
2 years ago |
| SELECT count(*) FROM templatelinks
WHERE tl_namespace=10; |
2 years ago |
| SELECT count(*) FROM templatelinks
WHERE tl_namespace=0; |
2 years ago |
| SELECT * FROM templatelinks
LIMIT 10; |
2 years ago |
| -- -- |
2 years ago |
| SELECT COUNT(page_title)
FROM
(SELECT page_title,
COUNT(DISTINCT rev_actor)... |
3 years ago |
| SELECT page_title
FROM
(SELECT page_title,
page_latest,
COUNT(DISTINCT... |
3 years ago |
| SELECT page_title
FROM
(SELECT page_title,
page_latest,
COUNT(DISTINCT... |
3 years ago |
| SELECT count(page_title)
FROM
(SELECT... |
3 years ago |
| SELECT count(page_title)
FROM
(SELECT... |
3 years ago |
| SELECT count(page_title)
FROM
(SELECT... |
3 years ago |
| SELECT count(page_title)
FROM
(SELECT... |
3 years ago |
| SELECT count(page_title)
FROM
(SELECT... |
3 years ago |
| SELECT page_title
FROM
(SELECT page_title,
page_latest,
COUNT(DISTINCT... |
3 years ago |
| SELECT page_title
FROM
(SELECT page_title,
page_latest,
COUNT(DISTINCT... |
3 years ago |
| SELECT page_title
FROM
(SELECT page_title,
page_latest,
COUNT(DISTINCT... |
3 years ago |
| SELECT page_title
FROM
(SELECT page_title,
page_latest,
COUNT(DISTINCT... |
3 years ago |
| SELECT page_title
FROM
(SELECT page_title,
page_latest,
COUNT(DISTINCT... |
3 years ago |
| SELECT page_title
FROM
(SELECT page_title,
page_latest,
COUNT(DISTINCT... |
3 years ago |
| SELECT count(page_title)
FROM
(SELECT... |
3 years ago |
| SELECT COUNT(page_title) from
(SELECT page_title,
COUNT(DISTINCT rev_actor)... |
3 years ago |
| SELECT COUNT(page_title) from
(SELECT page_title,
COUNT(DISTINCT rev_actor)... |
3 years ago |
| SELECT page_id, page_title, user_name,
COUNT(*) AS rev_cnt,... |
3 years ago |
| SELECT page_id, page_title, user_name,
COUNT(*) AS rev_cnt,... |
3 years ago |
| SELECT page_id, page_title, user_name,
COUNT(*) AS rev_cnt,... |
3 years ago |
| SELECT page_id, page_title, user_name,
COUNT(*) AS rev_cnt,... |
3 years ago |
| SELECT page_id, page_title, user_name,
COUNT(*) AS rev_cnt,... |
3 years ago |
| SELECT page_id, page_title, user_name,
COUNT(*) AS cnt, user_editcount
FROM... |
3 years ago |
| SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
3 years ago |
| SELECT page_id, page_title, user_name,
COUNT(*) AS cnt, user_editcount
FROM... |
3 years ago |
| SELECT page_title, user_name,
COUNT(*) AS cnt, user_editcount
FROM... |
3 years ago |
| SELECT page_title, user_name,
COUNT(*) AS cnt, user_editcount
FROM... |
3 years ago |
| SELECT page_title, user_name,
COUNT(*) AS cnt
FROM revision
JOIN page
ON... |
3 years ago |
| SELECT page_title, user_name,
COUNT(*) AS cnt
FROM revision
JOIN page
ON... |
3 years ago |
| SELECT page_title, user_name,
COUNT(*) AS cnt
FROM revision
JOIN page
ON... |
3 years ago |
| SELECT page_title, user_name
FROM revision
JOIN page
ON rev_page =... |
3 years ago |
| SELECT page_title, user_name
FROM revision
JOIN page
ON rev_page =... |
3 years ago |
| SELECT page_title, user_name
FROM revision
JOIN page
ON rev_page =... |
3 years ago |
| SELECT *, COUNT(*) as cnt
FROM revision
JOIN page
ON rev_page = page_id
JOIN... |
3 years ago |
| SELECT *, COUNT(*) as cnt
FROM revision
JOIN page
ON rev_page = page_id
JOIN... |
3 years ago |
| SELECT *, COUNT(*) as cnt
FROM revision
JOIN page
ON rev_page = page_id
JOIN... |
3 years ago |
| SELECT
page_title,
COUNT(*) as cnt,
actor_name
FROM revision
JOIN... |
3 years ago |
| SELECT
page_title,
COUNT(*) as cnt,
actor_name
FROM revision
JOIN... |
3 years ago |
| SELECT
page_title,
COUNT(*) as cnt,
actor_name
FROM revision
JOIN... |
3 years ago |
| SELECT
page_title,
COUNT(*) as cnt,
actor_name
FROM revision
JOIN... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| /*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor =... |
3 years ago |
| SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE... |
3 years ago |
| SELECT *
FROM recentchanges
JOIN actor on rc_actor = actor_id
LIMIT 25; |
3 years ago |
| SELECT *
FROM recentchanges
WHERE rc_namespace = 0
LIMIT 25; |
3 years ago |
