| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
6 months ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
7 months ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
7 months ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
1 year ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
1 year ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| - |
1 year ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| select log_id,log_timestamp,(select actor_name from actor where... |
1 year ago |
| select ROW_NUMBER() OVER(order by page_title) num, -- get row number
... |
1 year ago |
| select ipb_address
from ipblocks_ipindex
where ipb_user = 0 -- filter IP... |
1 year ago |
| select ROW_NUMBER() OVER(order by page_namespace asc, page_title asc) num,... |
1 year ago |
| SELECT
actor_logging.actor_user,
actor_logging.actor_name,
COUNT(*)... |
1 year ago |
| SELECT
actor_logging.actor_user,
actor_logging.actor_name,
COUNT(*)... |
1 year ago |
| SELECT
actor_logging.actor_user,
actor_logging.actor_name,
COUNT(*)... |
1 year ago |
| use bnwiki_p;
SELECT
... |
1 year ago |
| SELECT
CONCAT('# [[Talk:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
1 year ago |
| use bnwiki_p;
SELECT
... |
1 year ago |
| use bnwiki_p;
SELECT
... |
1 year ago |
| SELECT CONCAT('# [[Talk:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
1 year ago |
| use bnwiki_p;
SELECT
... |
1 year ago |
| use bnwiki_p;
select substr(rev_timestamp,1,4) as... |
1 year ago |
| use bnwiki_p;
select substr(rev_timestamp,1,4) as... |
1 year ago |
| use bnwiki_p;
select substr(rev_timestamp,1,4) as... |
1 year ago |
| SELECT actor.actor_name, COUNT(*)
FROM logging
INNER JOIN actor ON... |
1 year ago |
| SELECT actor.actor_name, COUNT(*)
FROM logging
INNER JOIN actor ON... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| -- |
1 year ago |
| SELECT CONCAT('# [[আলাপ:',page_title,']]')
FROM page
LEFT JOIN pagelinks
ON... |
1 year ago |
| SELECT actor_name, COUNT(log_id)
FROM logging_logindex
JOIN actor_logging ON... |
1 year ago |
| SELECT actor_name, COUNT(log_id)
FROM logging_logindex
JOIN actor_logging ON... |
1 year ago |
| USE bnwiki_p;
SELECT
s.page_namespace AS subject_ns,
t.page_namespace... |
1 year ago |
| USE bnwiki_p;
select ar_actor,actor_name,count(ar_actor) as cnt
from... |
1 year ago |
| USE bnwiki_p;
select ar_actor,actor_name,count(ar_actor) as cnt
from... |
1 year ago |
| set @actor1:="Yahya";
select actor_id into @actorid from actor where... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
bnwiki_p.templatelinks... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
bnwiki_p.templatelinks... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
bnwiki_p.templatelinks... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
bnwiki_p.templatelinks... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
bnwiki_p.templatelinks... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
bnwiki_p.templatelinks... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
enwiki_p.templatelinks... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
bnwiki_p.templatelinks... |
1 year ago |
| WITH sock_template AS (
SELECT tl.tl_from FROM
bnwiki_p.templatelinks... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| SELECT CONCAT('https://bn.wikipedia.org/wiki/User:', p.page_title) AS... |
1 year ago |
| blank query |
1 year ago |
| SELECT COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
| select ipb_address, ipb_timestamp, ipb_expiry, comment_text from ipblocks,... |
2 years ago |
| SELECT
actor.actor_name AS thành_viên,
GROUP_CONCAT(DISTINCT... |
2 years ago |
| SELECT
actor.actor_name AS user,
GROUP_CONCAT(DISTINCT... |
2 years ago |
| -- Modify startdate and enddate to change dates
SET @startdate =... |
2 years ago |
| -- Modify startdate and enddate to change dates
SET @startdate =... |
2 years ago |
| -- Modify startdate and enddate to change dates
SET @startdate =... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| SELECT actor_name, count(log_actor)
from logging
join actor on... |
2 years ago |
| -- |
2 years ago |
| SELECT p.page_title AS "Page Title", COUNT(ct.ct_rev_id) AS n_rollback FROM... |
2 years ago |
| SELECT p.page_title AS "Page Title", COUNT(ct.ct_rev_id) AS n_rollback FROM... |
2 years ago |
| SELECT COUNT(ipb_id) as "blocks", actor.actor_name
FROM ipblocks
JOIN... |
2 years ago |
| -- |
2 years ago |
| select CONCAT('[[User talk:', page_title, ']]') as user_talk -- format as... |
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 |
| /*
MalnadachBot - 215006043 (use rev_timestamp < '20220708')
WOSlinkerBot -... |
2 years ago |
| /*
MalnadachBot - 215006043 (use rev_timestamp < '20220708')
WOSlinkerBot -... |
2 years ago |
| SELECT actor_name, COUNT(*)
FROM page
JOIN page ON page_id = page_id
... |
2 years ago |
| SELECT actor_name, COUNT(*)
FROM pagetriage_page
JOIN page ON... |
2 years ago |
