Query Run
USE ckbwiki_p; SELECT user_count, male_count, female_count, ... 10 months ago
USE kuwiki_p; SELECT Subquery.UserName AS "Username", Subquery.Bytes AS... 10 months ago
USE kuwiki_p; SELECT Subquery.UserName AS "Username", Subquery.Bytes AS... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName AS "Username", Subquery.Bytes... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName AS "Username", Subquery.Bytes... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT * from change_tag_def; 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT * FROM change_tag_def; 10 months ago
USE ckbwiki_p; SELECT * FROM change_tag limit 100; 10 months ago
USE ckbwiki_p; SELECT * FROM change_tag; 10 months ago
USE ckbwiki_p; SELECT * FROM change_tag_def; 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ArticleTitle... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.Bytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.TotalBytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.TotalBytes, ... 10 months ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.TotalBytes, ... 1 year ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.TotalBytes, ... 1 year ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.TotalBytes, ... 1 year ago
USE ckbwiki_p; SELECT Subquery.UserName, ArticleTitle AS... 1 year ago
USE ckbwiki_p; SELECT Subquery.UserName, Subquery.TotalBytes, ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Subquery.TotalScore... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Subquery.TotalScore... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Subquery.TotalScore... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Subquery.TotalScore... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Subquery.TotalScore... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Subquery.TotalScore... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Subquery.TotalScore... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Subquery.TotalScore... 1 year ago
USE ckbwiki_p; WITH RankedUsers AS ( SELECT ROW_NUMBER() OVER (ORDER... 1 year ago
USE ckbwiki_p; WITH RankedUsers AS ( SELECT ROW_NUMBER() OVER (ORDER... 1 year ago
USE ckbwiki_p; WITH RankedUsers AS ( SELECT ROW_NUMBER() OVER (ORDER... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
USE ckbwiki_p; USE metawiki_p; SELECT ROW_NUMBER() OVER (ORDER BY... 1 year ago
USE ckbwiki_p; USE kuwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS... 1 year ago
USE ckbwiki_p; USE kuwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY... 1 year ago
USE ckbwiki_p; USE kuwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY... 1 year ago
USE ckbwiki_p; USE metawiki_p; SELECT ROW_NUMBER() OVER (ORDER BY... 1 year ago
USE ckbwiki_p; USE meta_p; SELECT ROW_NUMBER() OVER (ORDER BY TotalScore... 1 year ago
USE ckbwiki_p; USE metawiki_p; SELECT ROW_NUMBER() OVER (ORDER BY... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
-- Replace PAGE_ID_WITH_METAWIKI_PAGE_ID with the actual Page ID of the... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, UserName, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank, ... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY (0.5 * PercentileArticles + 0.5 *... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY (0.8 * NumberOfArticles + 0.2 *... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY (0.7 * NumberOfArticles + 0.3 *... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY (0.7 * NumberOfArticles + 0.3 *... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY (0.6 * NumberOfArticles + 0.5 *... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY (0.5 * NumberOfArticles + 0.5 *... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY (0.5 * NumberOfArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * ZScoreArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles) +... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (ArticleZScore) + 0.5... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * MinMaxArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * MinMaxArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * PercentileRankArticles... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * CDF(ZScoreArticles) +... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * ZScoreArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * ZScoreArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * ZScoreArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * ZScoreArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * ZScoreArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY 0.5 * ZScoreArticles + 0.5 *... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RANK() OVER (ORDER BY (0.5 * (NumberOfArticles /... 1 year ago
USE ckbwiki_p; SELECT RowNumber AS Rank, CONCAT('[[User:', UserName,... 1 year ago
USE ckbwiki_p; SELECT RowNumber AS Rank, CONCAT('[[User:', UserName,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY (0.5 *... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY (0.5 *... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY (0.5 *... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank, ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank, ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank, ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank, ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC, SUM(rev_len) DESC) AS... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC, SUM(rev_len) DESC) AS... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC, SUM(rev_len) DESC) AS... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC, SUM(rev_len) DESC) AS... 1 year ago
select pl_title from pagelinks where pl_from = 157289 and pl_namespace = 2 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC, SUM(rev_len) DESC) AS... 1 year ago
USE ckbwiki_p; SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS... 1 year ago
USE ckbwiki_p; SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS... 1 year ago
USE ckbwiki_p; SELECT CONCAT('[[', REPLACE(page_title, '_', ' '),... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_len = 0 AND... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_len = 0; AND... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_len = 0; # AND... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 AND... 1 year ago
USE ckbwiki_p USE ckbwiki_p; SELECT page_title FROM page WHERE... 1 year ago
USE ckbwiki_p SELECT page_title FROM page WHERE page_namespace = 0 --... 1 year ago
USE ckbwiki_p; -- Main query to get user statistics based on the usernames... 1 year ago
USE ckbwiki_p; -- Main query to get user statistics based on the usernames... 1 year ago
USE ckbwiki_p; -- Main query to get user statistics based on the usernames... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
USE ckbwiki_p; -- Subquery to fetch usernames from a specific page WITH... 1 year ago
select pl_title from pagelinks where pl_from = 157289 and pl_namespace = 2 1 year ago
SELECT REPLACE(REPLACE(page_title, '[[User:', ''), '|', '') AS... 1 year ago
SELECT REPLACE(REPLACE(page_title, '[[User:', ''), '|', '') AS... 1 year ago
SELECT REPLACE(REPLACE(page_title, '[[User:', ''), '|', '') AS... 1 year ago
SELECT REPLACE(REPLACE(page_title, '[[User:', ''), '|', '') AS... 1 year ago
SELECT REPLACE(REPLACE(page_title, '[[User:', ''), '|', '') AS... 1 year ago
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX( revision_text.text, '[[User:',... 1 year ago
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX( revision_text.text, '[[User:',... 1 year ago
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX( revision_text.text, '[[User:',... 1 year ago
SELECT REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(rev_text, '[[User:', -1),... 1 year ago
SELECT REPLACE(REPLACE(page_title, '[[User:', ''), '|', '') AS... 1 year ago
SELECT REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(text, '[[User:', -1), '|',... 1 year ago
SELECT REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(text, '[[User:', -1), '|',... 1 year ago
-- Find usernames in wikitext on a specific page USE ckbwiki_p; -- Replace... 1 year ago
-- Find usernames in wikitext on a specific page USE ckbwiki_p; -- Replace... 1 year ago
-- Get a list of usernames from a specific page in ckbwiki USE... 1 year ago
-- Replace 'your_table_name' with the actual table name in the ckbwiki... 1 year ago
SELECT REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(rc.old_text, ']]', 1), '|',... 1 year ago
SELECT REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(page_content, '|', -1),... 1 year ago
SELECT DISTINCT REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(rev_text, '|',... 1 year ago
-- Use Quarry to extract usernames from a specific page on ckbwiki SELECT ... 1 year ago
-- Use Quarry to extract usernames from a specific page on ckbwiki SELECT ... 1 year ago
-- Replace 'بەکارھێنەر:Aram/تاقیکردنەوە' with your desired page... 1 year ago
-- Find usernames in wikitext on a specific page SELECT DISTINCT REPLACE( ... 1 year ago
-- Find usernames in wikitext on a specific page SELECT DISTINCT REPLACE( ... 1 year ago
-- Find usernames in wikitext on a specific page SELECT DISTINCT ... 1 year ago
-- Find usernames in wikitext on a specific page SELECT DISTINCT ... 1 year ago
SELECT REGEXP_REPLACE( SUBSTRING_INDEX( ... 1 year ago
SELECT REGEXP_REPLACE( SUBSTRING_INDEX( ... 1 year ago
-- Get usernames from the 'بەکارھێنەر:Aram/تاقیکردنەوە' page SELECT -- Use... 1 year ago
-- Get usernames from the 'بەکارھێنەر:Aram/تاقیکردنەوە' page SELECT -- Use... 1 year ago
-- Get usernames from the 'بەکارھێنەر:Aram/تاقیکردنەوە' page SELECT -- Use... 1 year ago
-- Get usernames from the 'بەکارھێنەر:Aram/تاقیکردنەوە' page SELECT -- Use... 1 year ago
-- Sample Quarry Query to Extract Usernames SELECT DISTINCT page_title AS... 1 year ago
-- Sample Quarry Query to Extract Usernames SELECT DISTINCT page_title AS... 1 year ago
-- Quarry query to extract usernames from a specific page in ckbwiki SELECT ... 1 year ago
-- Quarry query to extract usernames from a specific page in ckbwiki SELECT ... 1 year ago
-- Quarry query to extract usernames from a specific page in ckbwiki SELECT ... 1 year ago
-- Quarry query to extract usernames from a specific page in ckbwiki SELECT ... 1 year ago
-- Sample Quarry Query to Extract Usernames from Wikitext USE ckbwiki_p; --... 1 year ago
-- Get a list of usernames from wikitext on ckbwiki SELECT DISTINCT --... 1 year ago
-- Get a list of usernames from wikitext on ckbwiki SELECT DISTINCT --... 1 year ago
-- Get a list of usernames from wikitext on ckbwiki SELECT DISTINCT --... 1 year ago
-- Get a list of usernames from wikitext on ckbwiki SELECT DISTINCT --... 1 year ago
-- Get a list of usernames from wikitext on ckbwiki SELECT DISTINCT --... 1 year ago
-- Get a list of usernames from wikitext on ckbwiki SELECT DISTINCT --... 1 year ago
-- Get a list of usernames from wikitext on ckbwiki SELECT DISTINCT --... 1 year ago
USE ckbwiki_p; SELECT DISTINCT SUBSTRING_INDEX( SUBSTRING_INDEX( ... 1 year ago
SELECT page_title AS username FROM page WHERE page_title =... 1 year ago
USE ckbwiki_p; SELECT page_title AS username FROM page WHERE ... 1 year ago
USE ckbwiki_p; SELECT REPLACE( REPLACE( REPLACE( ... 1 year ago
USE ckbwiki_p; SELECT REPLACE( REPLACE( REPLACE( ... 1 year ago
USE ckbwiki_p; SELECT REPLACE( REPLACE( REPLACE( ... 1 year ago
USE ckbwiki_p; SELECT DISTINCT SUBSTRING_INDEX( SUBSTRING_INDEX( ... 1 year ago
SELECT REPLACE( SUBSTRING_INDEX( SUBSTRING_INDEX(ar_text,... 1 year ago
SELECT REPLACE( SUBSTRING_INDEX( SUBSTRING_INDEX(old_text,... 1 year ago
SELECT REPLACE( SUBSTRING_INDEX( SUBSTRING_INDEX(rev_text,... 1 year ago
SELECT page_title AS username FROM page WHERE page_namespace = 2 --... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 2 -- User... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 2 -- User... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 2 -- User... 1 year ago
USE ckbwiki_p; SELECT DISTINCT pl_title FROM pagelinks WHERE pl_from =... 1 year ago
USE ckbwiki_p; SELECT DISTINCT page_title FROM page JOIN pagelinks ON... 1 year ago
USE ckbwiki_p; SELECT DISTINCT pl_title FROM page JOIN pagelinks ON page_id... 1 year ago
USE ckbwiki_p; SELECT DISTINCT pl_title FROM page JOIN pagelinks ON page_id... 1 year ago
USE ckbwiki_p; SELECT DISTINCT pl_title FROM page JOIN pagelinks ON page_id... 1 year ago
USE ckbwiki_p; SELECT page_title AS linked_page FROM page WHERE ... 1 year ago
USE ckbwiki_p; SELECT page_title AS linked_page FROM page WHERE ... 1 year ago
USE ckbwiki_p; SELECT page_title AS linked_page FROM pagelinks WHERE ... 1 year ago
USE ckbwiki_p; SELECT page_title AS 'Internal Link' FROM ... 1 year ago
USE ckbwiki_p; SELECT page_title AS Link FROM page WHERE page_namespace =... 1 year ago
USE ckbwiki_p; SELECT page_title AS Link FROM page WHERE page_namespace =... 1 year ago
USE ckbwiki_p; SELECT page_title AS linked_page FROM pagelinks WHERE... 1 year ago
USE ckbwiki_p; SELECT DISTINCT page_title FROM pagelinks JOIN page ON... 1 year ago
USE ckbwiki_p; SELECT DISTINCT page.page_title AS linked_page FROM... 1 year ago
USE ckbwiki_p; SELECT DISTINCT page.page_title AS linked_page FROM... 1 year ago
USE ckbwiki_p; SELECT DISTINCT page.page_title AS linked_page FROM... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks JOIN page... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks JOIN page... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks JOIN page... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks JOIN page... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks JOIN page... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks JOIN page... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks JOIN page... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks WHERE ... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks WHERE ... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks WHERE ... 1 year ago
USE ckbwiki_p; SELECT pl_title AS link_title FROM pagelinks WHERE ... 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM page WHERE... 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM page LIMIT 100 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM page 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM page WHERE ... 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM page WHERE ... 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM pagelinks WHERE pl_from... 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM page WHERE ... 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM page WHERE ... 1 year ago
SELECT page_title AS Link FROM pagelinks WHERE pl_from = (SELECT page_id... 1 year ago
SELECT page_title AS Link FROM pagelinks WHERE pl_from = (SELECT page_id... 1 year ago
SELECT page_title FROM pagelinks WHERE pl_from = (SELECT page_id FROM page... 1 year ago
SELECT DISTINCT page_title FROM page JOIN pagelinks ON pl_from =... 1 year ago
SELECT page_title FROM page JOIN pagelinks ON pl_from = page_id WHERE... 1 year ago
SELECT DISTINCT page_title AS Link FROM pagelinks WHERE pl_from = (SELECT... 1 year ago
USE ckbwiki_p; SELECT pl_title FROM pagelinks WHERE pl_from = (SELECT... 1 year ago
SELECT pl_title AS linked_page FROM pagelinks WHERE pl_from = (SELECT... 1 year ago
SELECT pl_title AS linked_page FROM pagelinks WHERE pl_from = (SELECT... 1 year ago
SELECT page_title AS linked_page FROM pagelinks WHERE pl_from =... 1 year ago
SELECT page_title AS linked_page FROM pagelinks WHERE pl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM pagelinks WHERE ... 1 year ago
USE ckbwiki_p; SELECT pl_title AS linked_page FROM pagelinks WHERE ... 1 year ago
USE ckbwiki_p; SELECT pl_title AS linked_page FROM pagelinks WHERE ... 1 year ago
SELECT pl_title FROM pagelinks WHERE pl_from = ( SELECT page_id FROM... 1 year ago
USE ckbwiki_p; SELECT page_title AS link_title FROM pagelinks WHERE pl_from... 1 year ago
USE ckbwiki_p; SELECT page_title, pl_title FROM page JOIN pagelinks ON... 1 year ago
USE ckbwiki_p; SELECT page_title, pl_title FROM page JOIN pagelinks ON... 1 year ago
USE ckbwiki_p; SELECT pl_title FROM pagelinks WHERE pl_from = (SELECT... 1 year ago
USE ckbwiki_p; SELECT page_title, pl_namespace, pl_title FROM ... 1 year ago
USE ckbwiki_p; SELECT page_id, page_title, pl_namespace, ... 1 year ago
USE ckbwiki_p; SELECT pl_title FROM pagelinks WHERE pl_from = (SELECT... 1 year ago
USE ckbwiki_p; SELECT pl_title FROM pagelinks WHERE pl_from = (SELECT... 1 year ago
USE ckbwiki_p; SELECT page.page_title AS page_title, pagelinks.pl_title... 1 year ago
USE kuwiki_p; SELECT DISTINCT... 1 year ago
USE ckbwiki_p; SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(cl_to, ':', -1),... 1 year ago
USE kuwiki_p; SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(cl_to, ':', -1),... 1 year ago
USE ckbwiki_p; SELECT REPLACE(REPLACE(page.page_title,... 1 year ago
USE kuwiki_p; SELECT REPLACE(REPLACE(page.page_title,... 1 year ago
USE kuwiki_p; SELECT REPLACE(REPLACE(page.page_title,... 1 year ago
USE ckbwiki_p; SELECT p.page_title, ... 1 year ago
USE ckbwiki_p; SELECT p.page_title, t.old_text FROM page AS p JOIN... 1 year ago
USE ckbwiki_p; SELECT p.page_title, t.old_text FROM page AS p JOIN... 1 year ago
USE ckbwiki_p; SELECT page_title, ... 1 year ago
USE ckbwiki_p; SELECT page_title, ... 1 year ago
USE ckbwiki_p; SELECT page_title, page_namespace, old_id, old_text FROM... 1 year ago
USE ckbwiki_p; SELECT page_title, page_namespace, old_id, old_text FROM... 1 year ago
USE ckbwiki_p; SELECT page_title, rev_id, rev_page, ... 1 year ago
USE ckbwiki_p; SELECT page_title, old_text FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title, t.old_text FROM page AS p JOIN... 1 year ago
USE ckbwiki_p; SELECT p.page_title, t.old_text FROM page AS p JOIN... 1 year ago
USE ckbwiki_p; SELECT p.page_title, t.old_text FROM page AS p JOIN revision... 1 year ago
USE ckbwiki_p; SELECT page_title, old_text FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT page_title, old_text FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT page_title, rev_text FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT page_title, old_text FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT page_title, old_text FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT page_title, old_text FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT page_title, old_text FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT SUBSTRING_INDEX( ... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT SUBSTRING_INDEX( ... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT SUBSTRING_INDEX( ... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT SUBSTRING_INDEX( ... 1 year ago
USE ckbwiki_p; -- Subquery to extract usernames from the specified... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT SUBSTRING_INDEX( ... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT SUBSTRING_INDEX( ... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT ... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT ... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT ... 1 year ago
USE ckbwiki_p; WITH Usernames AS ( SELECT ... 1 year ago
WITH UsernamesCTE AS ( SELECT ... 1 year ago
WITH UsernamesCTE AS ( SELECT ... 1 year ago
WITH UsernamesCTE AS ( SELECT ... 1 year ago
WITH UsernamesCTE AS ( SELECT ... 1 year ago
WITH UsernamesCTE AS ( SELECT ... 1 year ago
WITH UsernamesCTE AS ( SELECT ... 1 year ago
WITH UsernamesCTE AS ( SELECT ... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC,... 1 year ago
USE ckbwiki_p; SELECT ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) AS Rank, ... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE kuwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT user_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT user_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT user_name AS username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT user_name AS username, SUM(original_size) AS... 1 year ago
USE ckbwiki_p; -- Subquery to get the earliest revision for each user WITH... 1 year ago
USE ckbwiki_p; WITH FirstRevisions AS ( SELECT rev_page, ... 1 year ago
USE ckbwiki_p; WITH FirstRevisions AS ( SELECT rev_page, ... 1 year ago
USE ckbwiki_p; WITH FirstRevisions AS ( SELECT rev_page, ... 1 year ago
USE ckbwiki_p; WITH FirstRevisions AS ( SELECT rev_page, ... 1 year ago
USE ckbwiki_p; WITH FirstRevisions AS ( SELECT rev_page, ... 1 year ago
USE ckbwiki_p; SELECT actor.user_name AS username, ... 1 year ago
USE ckbwiki_p; SELECT users.actor_name AS username, ... 1 year ago
USE ckbwiki_p; SELECT users.user_name AS username, ... 1 year ago
USE ckbwiki_p; -- Subquery to get the first edit for each article WITH... 1 year ago
USE ckbwiki_p; -- Subquery to get the first edit for each article WITH... 1 year ago
USE ckbwiki_p; -- Subquery to get the earliest revision of each... 1 year ago
USE ckbwiki_p; -- Subquery to get the first edit for each article WITH... 1 year ago
USE ckbwiki_p; WITH FirstRevisions AS ( SELECT rev_page, ... 1 year ago
USE ckbwiki_p; -- Subquery to get the first edit for each article WITH... 1 year ago
USE ckbwiki_p; -- Subquery to get the first edit for each article WITH... 1 year ago
USE ckbwiki_p; -- First Subquery: Retrieve the earliest revisions for all... 1 year ago
USE ckbwiki_p; SELECT user_name AS username, rev_len AS... 1 year ago
USE ckbwiki_p; SELECT user_name AS username, rev_len AS... 1 year ago
USE ckbwiki_p; SELECT rev_user_text AS username, rev_len AS... 1 year ago
USE ckbwiki_p; SELECT rev_user_text AS username, rev_len AS... 1 year ago
USE ckbwiki_p; SELECT rev_user_text AS username, rev_len AS... 1 year ago
USE ckbwiki_p; SELECT rev_user_text AS username, rev_len AS... 1 year ago
USE ckbwiki_p; SELECT rev_user_text AS username, rev_len AS... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, page_len AS... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, MIN(rev_timestamp)... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, MIN(rev_timestamp)... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, MIN(rev_timestamp)... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, MIN(rev_timestamp)... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, MIN(rev_timestamp)... 1 year ago
USE ckbwiki_p; SELECT p.page_title AS article_title, r.rev_user_text AS... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, MIN(rev_timestamp)... 1 year ago
USE ckbwiki_p; SELECT rev_page AS article_id, page_title AS... 1 year ago
USE ckbwiki_p; SELECT rev_page AS article_id, page_title AS... 1 year ago
USE ckbwiki_p; SELECT rev_page AS article_id, page_title AS... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, page_len AS... 1 year ago
USE ckbwiki_p; SELECT rev_page AS article_id, page_title AS... 1 year ago
USE ckbwiki_p; SELECT rev_page AS article_id, page_title AS... 1 year ago
USE ckbwiki_p; SELECT rev_page AS article_id, page_title AS... 1 year ago
USE ckbwiki_p; SELECT rev_page AS article_id, page_title AS... 1 year ago
USE ckbwiki_p; SELECT page_title AS article_title, page_len AS... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles FROM... 1 year ago
SELECT  actor_name AS Username,  COUNT(*) AS NumberOfInitialEdits FROM... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles FROM... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles FROM... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles FROM... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles FROM... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor.actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor.actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT Username, COUNT(*) AS NumberOfArticles, SUM(TotalBytes) AS... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles, ... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(DISTINCT... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT actor_name AS Username, COUNT(*) AS... 1 year ago
USE ckbwiki_p; SELECT DISTINCT rev_timestamp, page_title FROM revision,... 1 year ago
USE ckbwiki_p; SELECT DISTINCT rev_timestamp, page_title FROM revision,... 1 year ago
USE ckbwiki_p; SELECT DISTINCT rev_timestamp, page_title FROM revision,... 1 year ago
USE ckbwiki_p; select DISTINCT rev_timestamp, page_title from ... 1 year ago
USE ckbwiki_p; select DISTINCT rev_timestamp, page_title from ... 1 year ago
USE ckbwiki_p; select rev_timestamp, page_title from ... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN revision ON rev_page =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN revision ON rev_page =... 1 year ago
USE ckbwiki_p; SELECT DISTINCT p.page_title AS article_title FROM page... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS created_articles,... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_id IN ( SELECT... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_id IN ( SELECT... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_id IN ( SELECT... 1 year ago
USE ckbwiki_p; SELECT page_title FROM revision JOIN page ON page_id =... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS created_articles FROM page JOIN ( ... 1 year ago
USE ckbwiki_p; SELECT COUNT(*) AS created_articles FROM page JOIN revision... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN categorylinks ON cl_from =... 1 year ago
USE ckbwiki_p; SELECT log_title AS "Deleted file title", ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_timestamp AS deletion_date, log_user AS... 1 year ago
USE ckbwiki_p; SELECT log_timestamp AS deletion_date, log_user_text... 1 year ago
USE ckbwiki_p; SELECT log_timestamp AS deletion_date, user_name AS... 1 year ago
USE ckbwiki_p; SELECT log_timestamp AS deletion_date, user_name AS... 1 year ago
USE ckbwiki_p; SELECT log_timestamp AS deletion_date, log_user AS... 1 year ago
USE ckbwiki_p; SELECT log_timestamp AS deletion_date, log_user_text... 1 year ago
USE fawiki_p; SELECT log_title AS deleted_file_title, log_timestamp... 1 year ago
USE enwiki_p; SELECT log_title AS deleted_file_title, log_timestamp... 1 year ago
USE arwiki_p; SELECT log_title AS deleted_file_title, log_timestamp... 1 year ago
USE fawiki_p; SELECT log_title AS deleted_file_title, log_timestamp... 1 year ago
USE enwiki_p; SELECT log_title AS deleted_file_title, log_timestamp... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE ckbwiki_p; SELECT log_title AS deleted_file_title, ... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN revision ON page_id =... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 #... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT p.page_title FROM page p LEFT JOIN revision r ON... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 --... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 --... 1 year ago
SELECT page_title FROM page WHERE page_namespace = 0 -- articles only AND... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 AND... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 AND... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 AND... 1 year ago
USE ckbwiki_p; SELECT page_title, actor_name FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT count(distinct(page_id)) FROM pagelinks INNER JOIN... 1 year ago
USE ckbwiki_p SELECT REPLACE(page_title,'_',' ') AS 'Page... 1 year ago
USE ckbwiki_p SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE ckbwiki_p; SELECT page_title, actor_name FROM page JOIN revision ON... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE ckbwiki; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE ckbwiki_p; SELECT page_title, actor_name FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT page_title, actor_name FROM page JOIN revision ON... 1 year ago
USE ckbwiki_p; SELECT page_title FROM page JOIN revision ON rev_page =... 1 year ago
USE ckbwiki_p; # SELECT page.page_title, user.user_name FROM page inner... 1 year ago
USE ckbwiki_p; # SELECT page.page_title, user.user_name FROM page inner... 1 year ago
USE ckbwiki_p; SELECT page.page_title, user.user_name FROM page inner join... 1 year ago
USE ckbwiki_p; SELECT page.page_title, user.user_name FROM page inner join... 1 year ago
USE ckbwiki_p; SELECT * FROM user; 1 year ago
USE ckbwiki_p; SELECT * FROM page WHERE page_namespace = 0 #Returns... 1 year ago
USE ckbwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE ckbwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 1 year ago
USE enwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
USE enwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
USE enwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... 2 years ago
USE enwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
USE enwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
USE enwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page title' FROM... 2 years ago
USE enwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page title' FROM... 2 years ago
SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... 2 years ago
SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... 2 years ago
SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... 2 years ago
SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... 2 years ago
SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... 2 years ago
SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... 2 years ago
SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last... 2 years ago
#USE ckbwiki_p; # SELECT CONCAT('Category:', page_title) FROM page #SELECT... 2 years ago
#USE ckbwiki_p; # SELECT CONCAT('Category:', page_title) FROM page #SELECT... 2 years ago
#USE ckbwiki_p; # SELECT CONCAT('Category:', page_title) FROM page #SELECT... 2 years ago
USE ckbwiki_p; # SELECT CONCAT('Category:', page_title) FROM page SELECT... 2 years ago
USE ckbwiki_p; SELECT CONCAT('Category:', page_title) FROM page WHERE... 2 years ago
USE ckbwiki_p; SELECT CONCAT('Category:', page_title) FROM page WHERE... 2 years ago
USE ckbwiki_p; SELECT CONCAT('Category:', page_title) WHERE... 2 years ago
USE ckbwiki_p; SELECT page_title FROM page WHERE page_is_redirect =... 2 years ago
USE ckbwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
USE ckbwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
USE ckbwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
#ckb use ckbwiki_p ; select page_id as ID, page_title as title from... 2 years ago
#ckb use ckbwiki_p ; # select wd.ips_item_id,ckbp.page_title from page as... 2 years ago
#ckb use ckbwiki_p ; # select wd.ips_item_id,ckbp.page_title from page as... 2 years ago
# Resultset (391 rows) as of May 30, 2022 # Resultset (423 rows) on Jun 1,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, ... 2 years ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
USE incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
use incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
use incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
use incubatorwiki_p; SELECT REPLACE (page_title,'_',' ') AS 'Page... 2 years ago
use ckbwiki_p; SELECT REPLACE (page_title,'_',' ') FROM page WHERE... 2 years ago
use ckbwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 AND... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, ... 2 years ago
use ckbwiki_p; SELECT DISTINCT page.page_id, page.page_title,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; #SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; #SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; SELECT page.page_id, page.page_title, page.page_namespace,... 2 years ago
use ckbwiki_p; SELECT page_id, page_title, page_namespace,... 2 years ago
use ckbwiki_p; SELECT page_id, page_title, page_namespace,... 2 years ago
use ckbwiki_p; SELECT page_id, page_title, page_is_redirect,... 2 years ago
use enwiki_p; SELECT page_id, page_title FROM page WHERE page_namespace =... 2 years ago
use enwiki_p; #show tables; # select * from page_props where pp_propname... 2 years ago
use enwiki_p; #show tables; # select * from page_props where pp_propname... 2 years ago
use enwiki_p; #show tables; # select * from page_props where pp_propname... 2 years ago
use enwiki_p; #show tables; # select * from page_props where pp_propname... 2 years ago
use wikidatawiki_p; #show tables; select * from page_props where pp_propname... 2 years ago
use wikidatawiki_p; #show tables; select * from page_props where pp_propname... 2 years ago
use wikidatawiki_p; #show tables; select * from page_props where pp_propname... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites, page WHERE... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites, page WHERE... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites, page_title WHERE... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE site_group =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE pl_title =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM sites WHERE pl_namespace = 0 and... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE pl_namespace... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE pl_namespace... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE pl_title =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks, sites WHERE pl_title =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks WHERE site_domain !=... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks WHERE pl_title =... 2 years ago
#ckb use wikidatawiki_p ; SELECT * FROM pagelinks WHERE pl_title =... 2 years ago
#ckb use wikidatawiki_p ; SELECT t1.term_text AS label, t2.term_text AS... 2 years ago
#ckb use wikidatawiki_p ; SELECT t1.term_text AS label, t2.term_text AS... 2 years ago
#ckb use wikidata_p ; SELECT page_namespace, page_title FROM page LEFT JOIN... 2 years ago
#ckb use ckbwiki_p ; SELECT * FROM `actor`; 2 years ago
#ckb use ckbwiki_p ; SELECT * FROM 'actor'; 2 years ago
#ckb use ckbwiki_p ; SELECT * FROM `page`; 2 years ago
#ckb use ckbwiki_p ; SELECT * FROM `page` order by user_registration ASC; 2 years ago
#ckb use ckbwiki_p ; # SELECT * FROM concat('','') `user` order by... 2 years ago
#ckb use ckbwiki_p ; SELECT * FROM `user` order by user_registration ASC; 2 years ago
#ckb use ckbwiki_p ; SELECT * FROM `user`; 2 years ago
#ckb use ckbwiki_p ; DESCRIBE site_stats; 2 years ago
#ckb use ckbwiki_p ; # select wd.ips_item_id,ckbp.page_title from page as... 2 years ago
use enwiki_p; SELECT user_name, user_editcount, user_registration,... 2 years ago
use arwiki_p; SELECT user_name, user_editcount, user_registration,... 2 years ago
use ckbwiki_p; SELECT user_name, user_editcount, user_registration,... 2 years ago
USE ckbwiki_p; SELECT COUNT(*) FROM revision_userindex WHERE rev_actor =... 2 years ago
USE enwiki_p; SELECT COUNT(*) FROM revision_userindex WHERE rev_actor =... 2 years ago
USE ckbwiki_p; SELECT COUNT(*) FROM revision_userindex WHERE rev_actor =... 2 years ago
USE ckbwiki_p; SELECT COUNT(*) FROM revision_userindex WHERE rev_actor =... 2 years ago
USE ckbwiki_p; SELECT COUNT(*) FROM revision_userindex WHERE rev_actor =... 2 years ago
USE ckbwiki_p; SELECT COUNT(*) FROM revision_userindex WHERE rev_actor =... 2 years ago