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 |