Query Run
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(log_title, '_', '... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(log_title, '_', '... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(log_title, '_', '... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(log_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(log_title, '_', '... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 2 months ago
SELECT page_namespace, page_title FROM page WHERE ... 2 months ago
SELECT page_namespace, page_title FROM page WHERE ... 2 months ago
SELECT page_namespace, page_title FROM page WHERE ... 2 months ago
SELECT page_title FROM revision JOIN page ON rev_page =... 2 months ago
SELECT page_namespace, page_title, rev_timestamp FROM ... 2 months ago
SELECT page_namespace, page_title, rev_timestamp FROM ... 2 months ago
SELECT page_namespace, page_title, rev_timestamp FROM ... 2 months ago
USE ckbwiki_p; SELECT CONCAT('# [[داڕێژە:', REPLACE(page_title, '_', ' '),... 3 months ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 10 --... 3 months ago
SELECT DISTINCT z_type FROM wikifunctionswiki_p.zobject; 3 months ago
SELECT * FROM wikifunctionswiki_p.page LIMIT 1000; 3 months ago
SELECT * FROM wikifunctionswiki_p.content WHERE content_model = 2; 3 months ago
SELECT COUNT(*) AS function_count FROM wikifunctionswiki_p.content WHERE... 3 months ago
SELECT model_id, model_name FROM wikifunctionswiki_p.content_models; 3 months ago
DESCRIBE wikifunctionswiki_p.content_models; 3 months ago
SELECT content_model, COUNT(*) AS count FROM... 3 months ago
SELECT DISTINCT content_model FROM wikifunctionswiki_p.content; 3 months ago
DESCRIBE wikifunctionswiki_p.content; 3 months ago
SHOW TABLES FROM wikifunctionswiki_p; 3 months ago
SELECT COUNT(*) AS function_count FROM wikifunctionswiki_p.zobject WHERE... 3 months ago
SELECT * FROM page; 3 months ago
SELECT * FROM pages; 3 months ago
SELECT * FROM site_stats; 3 months ago
SELECT * FROM sites; 3 months ago
SHOW TABLES FROM wikifunctionswiki_p; 3 months ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 10 --... 8 months ago
USE ckbwiki_p; SELECT tl_title FROM templatelinks WHERE tl_title LIKE '%قورئان%'; 8 months ago
USE ckbwiki_p; SELECT page_title FROM templatelinks WHERE tl_title LIKE... 8 months ago
USE ckbwiki_p; SELECT page_title, cat_pages, cat_subcats FROM... 1 year ago
USE ckbwiki_p; SELECT page_namespace, CONCAT('[[', CASE WHEN... 1 year ago
USE ckbwiki_p; SELECT page_namespace, CONCAT('[[', CASE WHEN... 1 year ago
USE ckbwiki_p; SELECT page_namespace, CASE WHEN page_namespace = 2... 1 year ago
USE ckbwiki_p; SELECT page_namespace, CONCAT('[[', page_namespace, ':',... 1 year ago
USE ckbwiki_p; SELECT page_namespace, CONCAT('[[', REPLACE(page_title,... 1 year ago
USE ckbwiki_p; SELECT page_namespace, page_title FROM page WHERE page_title... 1 year ago
USE ckbwiki_p; SELECT page_namespace, page_title FROM page WHERE page_title... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_title RLIKE '.*ئارام... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_title RLIKE 'ئارام... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_title LIKE '%ئارام... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_title LIKE '%ئارام بکر%' 1 year ago
USE ckbwiki_p; SELECT page_title, cat_pages, cat_subcats FROM... 1 year ago
USE ckbwiki_p; SELECT page_title, cat_pages, cat_subcats FROM... 1 year ago
USE ckbwiki_p; SELECT comment_text, COUNT(*) AS uses FROM... 1 year ago
USE ckbwiki_p; SELECT comment_text, COUNT(*) AS uses FROM... 1 year ago
USE ckbwiki_p; SELECT CONCAT(ns_name, ':', page_title), page_len FROM... 1 year ago
USE ckbwiki_p; SELECT CONCAT(ns_name, ':', page_title), page_len FROM... 1 year ago
USE ckbwiki_p; SELECT CONCAT(ns_name, ':', page_title), page_len FROM... 1 year ago
USE ckbwiki_p; SELECT CONCAT(ns_name, ':', page_title), page_len FROM... 1 year ago
USE ckbwiki_p; SELECT COUNT(*), TRIM(LEADING 'www.' FROM... 1 year ago
USE ckbwiki_p; SELECT pl_title, count(*), page_id FROM... 1 year ago
USE ckbwiki_p; select rev_user, count(*) / (... 1 year ago
USE ckbwiki_p; SELECT pl_title, count(*), page_id FROM... 1 year ago
USE ckbwiki_p; SELECT pl_title, count(*), page_id FROM... 1 year ago
USE ckbwiki_p; SELECT pl_title, count(*), page_id FROM... 1 year ago
USE ckbwiki_p; SELECT pl_title, count(*), page_id FROM... 1 year ago
USE ckbwiki_p; SELECT pl_title, count(*), page_id FROM... 1 year ago
USE ckbwiki_p; select DATE_FORMAT(log_timestamp,"%Y-%m-%d"), count(*) ... 1 year ago
USE ckbwiki_p; select DATE_FORMAT(log_timestamp,"%Y-%m-%d"), count(*) ... 1 year ago
USE ckbwiki_p; select DATE_FORMAT(log_timestamp,"%Y-%m-%d"), count(*) ... 1 year ago
USE ckbwiki_p; SELECT DATE( log_timestamp ) AS Date, COUNT( log_id ) AS... 1 year ago
USE ckbwiki_p; SELECT DISTINCT rev_user_text, user_editcount FROM... 1 year ago
USE ckbwiki_p; SELECT DAY, ACTIONS FROM (SELECT SUBSTR(log_timestamp,... 1 year ago
USE ckbwiki_p; SELECT MONTH, USERS FROM (SELECT SUBSTR(afl_timestamp,... 1 year ago
USE ckbwiki_p; SELECT SUBSTR(rev_timestamp, 1, 6) AS MONTH, ... 1 year ago
USE ckbwiki_p; SELECT CONCAT(month, '/', year) monthly, SUM(period < 7)... 1 year ago
USE ckbwiki_p; SELECT rc_title, count(*) as num_edits FROM recentchanges... 1 year ago
USE ckbwiki_p; SELECT log_user_text, COUNT(*) FROM logging JOIN... 1 year ago
USE ckbwiki_p; SELECT rev_user_text, COUNT(*) FROM revision JOIN page ON... 1 year ago
USE ckbwiki_p; SELECT rev_user_text, COUNT(*) FROM revision JOIN page ON... 1 year ago
USE ckbwiki_p; SELECT rev_user_text, COUNT(*) FROM revision JOIN page ON... 1 year ago
USE ckbwiki_p; SELECT rev_user_text, COUNT(*) FROM revision JOIN page ON... 1 year ago
USE ckbwiki_p; SELECT page_namespace, page_title, page_len FROM... 1 year ago
USE ckbwiki_p; SELECT page_namespace, page_title, page_len FROM... 1 year ago
USE ckbwiki_p; SELECT page_namespace, page_title, page_len FROM... 1 year ago
USE ckbwiki_p; SELECT page_namespace, page_title, page_len FROM... 1 year ago
USE ckbwiki_p; SELECT page_namespace, page_title, page_len FROM... 1 year ago
USE ckbwiki_p; WITH InactiveBotsData AS ( SELECT actor_name AS... 1 year ago
USE ckbwiki_p; WITH ActiveBotsData AS ( SELECT actor_name AS... 1 year ago
USE fawiki_p; WITH ActiveBotsData AS ( SELECT actor_name AS... 1 year ago
USE kuwiki_p; WITH ActiveBotsData AS ( SELECT actor_name AS... 1 year ago
USE arwiki_p; WITH ActiveBotsData AS ( SELECT actor_name AS... 1 year ago
USE arwiki_p; WITH ActiveBotsData AS ( SELECT actor_name AS... 1 year ago
USE arwiki_p; WITH ActiveBotsData AS ( SELECT actor_name AS... 1 year ago
WITH BotsData AS ( SELECT actor_name AS Username, ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate DES) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SELECT (@row_number := @row_number + 1) AS '#', ... 1 year ago
USE ckbwiki_p; SELECT @row_number := @row_number + 1 AS '#', ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS '#', actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SET @rownum = 0; SELECT (@rownum := @rownum + 1) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS `#`, actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS '#', actor_name AS... 1 year ago
USE ckbwiki_p; SELECT @counter := @counter + 1 AS `#`, actor_name... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS 'num', actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS '#', actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS #, actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY LastEditDate ASC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS '#', actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS '#' actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS #, actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS #, actor_name AS... 1 year ago
USE ckbwiki_p; SELECT '#' AS #, actor_name AS Username, ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS "#", actor_name AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER () AS '#', actor_name AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON rev_actor =... 1 year ago
SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON rev_actor =... 1 year ago
SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON rev_actor =... 1 year ago
SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON rev_actor =... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS total_edit_count FROM revision JOIN actor... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS count FROM revision_userindex JOIN actor... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS count FROM revision_userindex JOIN actor... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS count FROM revision_userindex JOIN actor... 1 year ago
USE ckbwiki_p; SELECT COUNT(DISTINCT rev_id) AS edit_count FROM... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; -- Count the number of edits by AramBot SELECT COUNT(*) AS... 1 year ago
USE ckbwiki_p; -- Count the number of edits by AramBot SELECT COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN actor ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN user ON... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision JOIN user ON... 1 year ago
USE ckbwiki_p; -- Count the number of edits by AramBot SELECT COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM actor JOIN... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision WHERE rev_user =... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision WHERE... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision WHERE rev_user =... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision WHERE... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision WHERE... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision WHERE rev_user =... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS edit_count FROM revision WHERE... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, MAX(rev_timestamp) AS... 1 year ago
USE ckbwiki_p; SELECT user.user_name AS Username, ... 1 year ago
SELECT user.user_name AS Username, MAX(rev_timestamp) AS... 1 year ago