| SELECT
SUBSTR(afl_timestamp, 1, 6) AS MONTH,
COUNT(afl_id) AS edits
FROM... |
3 months ago |
| -- -- |
4 months ago |
| select
concat('# [[Draft:', page_title, ']]')
from page
where page_namespace... |
4 months ago |
| select
concat('# [[Draft:', page_title, ']]')
from page
where page_namespace... |
4 months ago |
| select
concat('# [[Draft:', page_title, ']]')
from page
where page_namespace... |
4 months ago |
| select
concat('# [[Draft:', page_title, ']]')
from page
where page_namespace... |
4 months ago |
| select
concat('# [[Draft:', page_title, ']]')
from page
where page_namespace... |
4 months ago |
| SELECT DISTINCT rev_page
from revision
where UNIX_TIMESTAMP() -... |
4 months ago |
| SELECT rev_page, rev_timestamp
from revision
where UNIX_TIMESTAMP() -... |
4 months ago |
| SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(20231231235959) AS T; |
4 months ago |
| SELECT UNIX_TIMESTAMP(20231231235959) - UNIX_TIMESTAMP() AS T; |
4 months ago |
| SELECT UNIX_TIMESTAMP(20231231235959) - UNIX_TIMESTAMP AS T; |
4 months ago |
| SELECT UNIX_TIMESTAMP(20231231235959) AS T; |
4 months ago |
| select
concat('# [[Draft:', page_title, ']]')
from page
where page_namespace... |
4 months ago |
| select
count(page_id),
page_namespace
from page
group by page_namespace
limit 100; |
4 months ago |
| -- -- |
1 year ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
1 year ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
1 year ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%H") AS hour,
COUNT(rev_timestamp) AS... |
1 year ago |
| -- -- |
2 years ago |
| -- -- |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT
user_name AS user,
count(*) AS review_cnt
FROM
logging
JOIN... |
2 years ago |
| -- -- |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
| -- -- |
2 years ago |
| SELECT page_title
FROM page
JOIN templatelinks
ON page_id = tl_from
WHERE... |
2 years ago |
| -- -- |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| -- -- |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| -- -- |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
| -- -- |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| -- -- |
2 years ago |
| SELECT user_registration, user_name
FROM `user`
WHERE user_editcount >... |
2 years ago |
| SELECT user_id, user_name
FROM `user`
WHERE user_editcount > 500
AND user_id... |
2 years ago |
| blank query |
2 years ago |
| select COUNT(actor_user)
from revision
join actor
on rev_actor =... |
2 years ago |
| select COUNT(DISTINCT actor_user)
from revision
join actor
on rev_actor =... |
2 years ago |
| select DISTINCT actor_user
from revision
join actor
on rev_actor =... |
2 years ago |
| select DISTINCT actor_user
from revision
join actor
on rev_actor =... |
2 years ago |
| select *
from revision
join actor
on rev_actor = actor_id
where actor_user... |
2 years ago |
| select *
from revision
join actor
on rev_actor = actor_id
where actor_user... |
2 years ago |
| select actor_user
from revision
join actor
on rev_actor = actor_id
where... |
2 years ago |
| select actor_user
from revision
join actor
on rev_actor = actor_id
where... |
2 years ago |
| select *
from revision
join actor
on rev_actor = actor_id
join user
on... |
2 years ago |
| select * from user order by user_id desc limit 3; |
2 years ago |
| select * from user order by user_id dec limit 3; |
2 years ago |
| select * from user limit 3; |
2 years ago |
| -- -- |
2 years ago |
| -- -- |
2 years ago |
| SELECT
user_name AS user,
count(*) AS review_cnt
FROM
logging
JOIN... |
2 years ago |
| -- -- |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM revision
JOIN change_tag
ON... |
2 years ago |
| -- -- |
2 years ago |
| select page_title from page
where page_id = 68957 |
2 years ago |
| -- -- |
2 years ago |
| select pl_title, actor_name
from pagelinks
join (select page_title, page_id
... |
2 years ago |
| select *
from pagelinks
join (select page_title, page_id
from page
... |
2 years ago |
| select *
from pagelinks
join (select page_title, page_id
from page
... |
2 years ago |
| select *
from pagelinks
join (select page_title, page_id
from page
... |
2 years ago |
| select pl_title
from pagelinks
join (select page_title, page_id
from... |
2 years ago |
| select pl_title
from pagelinks
join (select page_title, page_id
from... |
2 years ago |
| select pl_title
from pagelinks
where pl_from = 7604
and pl_namespace = 0; |
2 years ago |
| select *
from pagelinks
where pl_from = 7604; |
2 years ago |
| select *
from pagelinks
where plfrom = 7604; |
2 years ago |
| -- comment |
2 years ago |
| -- comment
use bnwiki_p;
select... |
2 years ago |
| -- comment
use bnwiki_p;
select concat("#[[আলাপ:",page_title,"]]")
from... |
2 years ago |
| -- comment |
2 years ago |
| use bnwiki_p;
select page_title, rev_id, actor_name
from revision
join page
... |
2 years ago |
| -- comment |
2 years ago |
| use bnwiki_p;
select page_title, rev_id, actor_name
from revision
join page
... |
2 years ago |
| use bnwiki_p;
select page_title, rev_id, actor_user
from revision
join page
... |
2 years ago |
| SELECT *
FROM change_tag_def; |
2 years ago |
| SELECT
page_namespace as ns,
page_title,
page_id,
sum(rev_len) as... |
2 years ago |
| SELECT
count(distinct actor_name),
sum(rev_len) as length,
page_title... |
2 years ago |
| SELECT
rev_page,
count(distinct actor_name),
sum(rev_len) as length,
... |
3 years ago |
| SELECT
COUNT(*)
FROM revision
WHERE rev_user_text = 'Ahmad Kanik'; |
3 years ago |
| SELECT
comment_text,
COUNT(*) AS uses
FROM revision_userindex
JOIN... |
3 years ago |
| SELECT page_id, page_len
FROM page
WHERE page_is_redirect = 1
HAVING page_len > 1000; |
3 years ago |
| SELECT page_id
FROM page
WHERE page_is_redirect = 1
HAVING page_len >... |
3 years ago |
| SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE... |
3 years ago |
| SELECT
page_namespace,
page_title,
page_len
FROM page
WHERE... |
3 years ago |
| SELECT CONCAT('[[',page_title,']]')
FROM redirect
INNER JOIN page ON... |
3 years ago |
| SELECT *, CONCAT('[[',']]')
FROM redirect
INNER JOIN page ON... |
3 years ago |
| SELECT CONCAT('[[',*,']]')
FROM redirect
INNER JOIN page ON redirect.rd_from... |
3 years ago |
| SELECT CONCAT('[[',rd_title,']]')
FROM redirect
INNER JOIN page ON... |
3 years ago |
| SELECT rd_title
FROM redirect
INNER JOIN page ON redirect.rd_from =... |
3 years ago |
| SELECT *
FROM redirect
INNER JOIN page ON redirect.rd_from =... |
3 years ago |
| SELECT rd_from
FROM redirect
INNER JOIN page ON redirect.rd_from =... |
3 years ago |
| SELECT * FROM querycache_info
LIMIT 3; |
3 years ago |
| SELECT * FROM archive
LIMIT 3; |
3 years ago |
| SELECT * FROM content
LIMIT 3; |
3 years ago |
| SHOW TABLES; |
3 years ago |
| SHOW TABLE; |
3 years ago |
| .schema |
3 years ago |
| SELECT * FROM text
LIMIT 3; |
3 years ago |
| SELECT * FROM pagecontent
LIMIT 3; |
3 years ago |
| SELECT * FROM text
LIMIT 3; |
3 years ago |
| SELECT COUNT(*)
FROM revision_userindex
JOIN actor on rev_actor =... |
3 years ago |
| SELECT COUNT(*)
FROM revision_userindex
WHERE actor_name = 'Ahmad Kanik'; |
3 years ago |
| SELECT COUNT(*)
FROM revision
WHERE `user_name` = 'Ahmad Kanik'; |
3 years ago |
| SELECT COUNT(*)
FROM revision
WHERE user_name = 'Ahmad Kanik'; |
3 years ago |
| SELECT COUNT(*)
FROM revision; |
3 years ago |
