| SELECT p.page_id, p.page_title
FROM page p
LEFT JOIN categorylinks cl
ON... |
5 months ago |
| SELECT p.page_id, p.page_title
FROM page p
LEFT JOIN categorylinks cl
ON... |
5 months ago |
| SELECT p.page_id, p.page_title
FROM page p
LEFT JOIN categorylinks cl
ON... |
5 months ago |
| SELECT p.page_id, p.page_title
FROM page p
LEFT JOIN categorylinks cl
ON... |
5 months ago |
| SELECT p.page_id, p.page_title
FROM page p
LEFT JOIN categorylinks cl
ON... |
5 months ago |
| USE ckbwiki_p;
SELECT p.page_id, p.page_title
FROM page p
LEFT JOIN... |
5 months ago |
| USE ckbwiki_p;
SELECT page_id, page_title
FROM page
LEFT JOIN... |
5 months ago |
| USE ckbwiktionary_p;
SELECT REPLACE (page_title,'_',' ') AS 'Page... |
7 months ago |
| USE ckbwiktionary_p;
SELECT rc_id, rc_timestamp, rc_title,... |
10 months ago |
| SELECT rc_id, rc_timestamp, rc_title, rc_this_oldid
FROM recentchanges
WHERE... |
10 months ago |
| SELECT rc_id, rc_timestamp, rc_namespace, rc_title, rc_this_oldid
FROM... |
10 months ago |
| SELECT *
FROM recentchanges
WHERE rc_bot = 0
AND rc_actor = (
SELECT... |
10 months ago |
| SELECT rc_id, rc_timestamp, rc_namespace, rc_title, rc_this_oldid
FROM... |
10 months ago |
| SELECT *
FROM recentchanges
WHERE rc_actor = (
SELECT actor_id
FROM... |
10 months ago |
| SELECT rc_id, rc_timestamp, rc_namespace, rc_title, rc_this_oldid
FROM... |
10 months ago |
| SELECT rc_id, rc_timestamp, rc_namespace, rc_title, rc_this_oldid
FROM... |
10 months ago |
| SELECT rc_id, rc_timestamp, rc_namespace, rc_title, rc_this_oldid
FROM... |
10 months ago |
| SELECT *
FROM recentchanges
WHERE rc_bot = 0
AND rc_actor = (
SELECT... |
10 months ago |
| SELECT *
FROM recentchanges
WHERE rc_bot = 0
AND rc_actor = (
SELECT... |
10 months ago |
| SELECT *
FROM recentchanges
WHERE rc_bot = 0
AND rc_actor = (
SELECT... |
10 months ago |
| SELECT *
FROM recentchanges
WHERE rc_bot = 0
AND rc_user = (SELECT actor_id... |
10 months ago |
| SELECT *
FROM recentchanges
WHERE rc_bot = 0
AND rc_user_text = 'AramBot';... |
10 months ago |
| SELECT rc.*
FROM recentchanges rc
JOIN actor a ON rc.rc_actor =... |
10 months ago |
| SELECT rc.*
FROM recentchanges rc
JOIN actor a ON rc.rc_actor =... |
10 months ago |
| SELECT rc.*
FROM recentchanges rc
JOIN actor a ON rc.rc_actor =... |
10 months ago |
| SELECT rc.*
FROM recentchanges rc
JOIN actor a ON rc.rc_actor =... |
10 months ago |
| USE ckbwiki_p;
SELECT
user_count,
male_count,
female_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
-- Assuming user_id, up_user, up_property, and up_value are... |
11 months ago |
| USE ckbwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE enwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
user_count,
COALESCE(male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE enwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE enwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
(SELECT COUNT(DISTINCT user_id) FROM user) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
u.user_count,
COALESCE(m.male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
u.user_count,
COALESCE(m.male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
u.user_count,
COALESCE(m.male_count, 0) AS... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT user.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE enwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(DISTINCT u.user_id) AS user_count,
... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(*) AS user_count,
SUM(CASE WHEN... |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(*) AS user_count,
SUM(up_value =... |
11 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) AS user_count FROM user; |
11 months ago |
| USE ckbwiki_p;
SELECT
COUNT(*) AS user_count,
SUM(up_value =... |
11 months ago |
| USE ckbwiki_p;
SELECT user_name
FROM user_properties
JOIN user ON... |
11 months ago |
| USE ckbwiki_p;
SELECT user_name FROM user_properties JOIN user ON user_id =... |
11 months ago |
| USE ckbwiki_p;
SELECT user_name FROM user_properties JOIN user ON user_id =... |
11 months ago |
| USE ckbwiki_p;
SELECT * FROM user_properties JOIN user ON user_id = up_user... |
11 months ago |
| USE ckbwiki_p;
SELECT * FROM user_properties WHERE up_property = 'gender'... |
11 months ago |
| USE ckbwiki_p;
SELECT * FROM user_properties WHERE up_property = 'gender'; |
11 months ago |
| USE ckbwiki_p;
SELECT * FROM user_properties; |
11 months ago |
| SELECT DISTINCT up_property FROM user_properties; |
11 months ago |
| SELECT * FROM user_properties; |
11 months ago |
| SELECT * FROM user_properties WHERE up_property = gender; |
11 months ago |
| SELECT * FROM user_properties; |
11 months ago |
| SELECT * FROM wbc_entity_usage LIMIT 100; |
11 months ago |
| SELECT * FROM wbc_entity_usage; |
11 months ago |
| SELECT * FROM user_properties_anon; |
11 months ago |
| SELECT * FROM user_properties; |
11 months ago |
| SELECT DISTINCT up_property FROM user_properties; |
11 months ago |
| SELECT * FROM user_properties; |
11 months ago |
| SELECT * FORM user_properties; |
11 months ago |
| SHOW TABLES; |
11 months ago |
| SELECT * FROM job; |
11 months ago |
| SELECT * FROM job; |
11 months ago |
| SELECT * FROM user; |
11 months ago |
| SHOW TABLES; |
11 months ago |
| SHOW TABLES; |
11 months ago |
| SELECT * FROM site_identifiers; |
11 months ago |
| SELECT * FROM site_stats; |
11 months ago |
| SELECT * FROM sites; |
11 months ago |
| SHOW * FROM sites; |
11 months ago |
| SHOW TABLES; |
11 months ago |
| SELECT * FROM legacy; |
11 months ago |
| SHOW * FROM legacy; |
11 months ago |
| SHOW TABLES; |
11 months ago |
| USE `ckbwiktionary_p`;
SELECT COUNT(*) AS user_count FROM user; |
11 months ago |
| USE `ckbwiktionary`;
SELECT COUNT(*) AS user_count FROM user; |
11 months ago |
| USE `ckbwiktionary`;
SELECT COUNT(*) AS user_count FROM user; |
11 months ago |
| USE `ckbwiki`;
SELECT COUNT(*) AS user_count FROM user; |
11 months ago |
| USE `arywiki`;
SELECT COUNT(*) AS user_count FROM user; |
11 months ago |
| USE `arywiki_p`;
SELECT COUNT(*) AS user_count FROM user; |
11 months ago |
| USE `ckbwiki_p`;
SELECT COUNT(*) AS user_count FROM user;
SELECT COUNT(*) AS... |
11 months ago |
| USE `ckbwiki_p`;
SELECT COUNT(*) AS user_count FROM user;
USE... |
11 months ago |
| USE `ckbwiki_p`;
SELECT COUNT(*) AS user_count FROM user;
USE... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| USE `meta_p`;
-- Query to retrieve the list of databases that meet the... |
11 months ago |
| USE `meta_p`;
-- Query to retrieve the list of databases that meet the... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| USE meta_p;
-- Query to retrieve the list of databases that meet the... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| -- Query to retrieve the list of databases that meet the specified... |
11 months ago |
| -- This query retrieves the count of registered users for multiple Wikimedia... |
11 months ago |
| -- This query retrieves the count of registered users for multiple Wikimedia... |
11 months ago |
| -- This query retrieves the count of registered users for multiple Wikimedia... |
11 months ago |
| USE meta_p;
SELECT COUNT(*) from user; |
11 months ago |
| USE meta_p;
SELECT COUNT(*) from user; |
11 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) from user; |
11 months ago |
| USE ckbwiki_p;
SELECT * from user; |
11 months ago |
| USE ckbwiki_p;
SELECT COUNT(*) from user Limit 10; |
11 months ago |
| USE ckbwiki_p;
SELECT * from user Limit 10; |
11 months ago |
| USE meta_p;
SELECT * from user Limit 10; |
11 months ago |
| USE ckbwiki_p;
SELECT * from user Limit 10; |
11 months ago |
| USE meta_p;
SELECT * from user Limit 10; |
11 months ago |
| USE meta_p;
SELECT * from users Limit 10; |
11 months ago |
| USE meta_p;
SELECT
url,
(
SELECT
COUNT(*)
FROM
... |
11 months ago |
| USE ckbwiki_p;
SELECT
url,
(
SELECT
COUNT(*)
FROM
... |
11 months ago |
| USE ckbwiki_p;
SELECT
url,
(
SELECT
COUNT(*)
FROM
... |
11 months ago |
| SELECT
url,
(SELECT COUNT(*) FROM... |
11 months ago |
| USE ckbwiki_p;
SELECT
u.user_name AS "User Name",
ug.ug_group AS "User... |
1 year ago |
| USE ckbwiki_p;
SELECT
u.user_name AS "User name",
ug.ug_group AS "User... |
1 year ago |
| USE ckbwiki_p;
SELECT
u.user_name AS "User Name",
ug.ug_group AS "User... |
1 year ago |
| USE ckbwiki_p;
SELECT
u.user_name,
ug.ug_group,
ug.ug_expiry
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
u.user_name,
ug.ug_group,
ug.ug_expiry
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
u.user_name,
ug.ug_group,
ug.ug_expiry
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT *
FROM user_groups;
|
1 year ago |
| USE ckbwiki_p;
SELECT
ug_group
FROM
user_groups;
|
1 year ago |
| USE ckbwiki_p;
SELECT *
FROM user_groups;
|
1 year ago |
| USE ckbwiki_p;
SELECT ug.*
FROM user_groups ug;
|
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY user_editcount DESC) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY user_editcount DESC) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY last_edit_date DESC,... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY last_edit_date DESC,... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY last_edit_date ASC) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY last_edit_date ASC) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY user_editcount DESC) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY last_edit_date DESC) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
ROW_NUMBER() OVER (ORDER BY user_editcount DESC) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
@row_number:=@row_number+1 AS row_number,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
u.user_name,
u.user_registration,
... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT
user_name,
user_registration,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
user_editcount,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
last_activity_date,
reputation
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
last_activity_date,
reputation
FROM
... |
1 year ago |
| USE your_database;
SELECT
user_name,
last_activity_date,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_registration,
... |
1 year ago |
| USE enwiki_p;
SELECT
user_name,
user_registration,
... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_editcount,
user_registration,
... |
1 year ago |
| SELECT
actor_name,
STR_TO_DATE(LEFT(MAX(rev_timestamp), 8), '%Y%m%d') AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
user_name,
user_editcount,
user_registration,
... |
1 year ago |
| SELECT
actor_name,
STR_TO_DATE(LEFT(MAX(rev_timestamp), 8), '%Y%m%d') AS... |
1 year ago |
| USE ckbwiki_p;
WITH ActiveBotsData AS (
SELECT
actor_name AS... |
1 year ago |
| USE ckbwiki_p;
WITH ActiveBotsData AS (
SELECT
actor_name AS... |
1 year ago |
| USE wikidatawiki_p;
SELECT
pp_value AS Category,
COUNT(*) AS... |
1 year ago |
| USE wikidatawiki_p;
SELECT
pp_value AS Category,
COUNT(*) AS... |
1 year ago |
| USE wikidatawiki_p;
SELECT
pp_value AS Category,
COUNT(*) AS... |
1 year ago |
| SELECT
wd_item_id AS WikidataItem,
COUNT(wb_items_per_site.site_id) AS... |
1 year ago |
| SELECT
wd_item_id AS WikidataItem,
COUNT(wb_items_per_site.site_id) AS... |
1 year ago |
| SELECT
cl_to AS CategoryLabel,
COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| SELECT
cl_to AS Category,
COUNT(*) AS NumLanguages
FROM
categorylinks
... |
1 year ago |
| SELECT DISTINCT
en_cats.page_title AS en_category,
COUNT(*) AS... |
1 year ago |
| SELECT DISTINCT cl_to AS category,
COUNT(DISTINCT langlinks.ll_lang)... |
1 year ago |
| SELECT DISTINCT cl_to AS category
FROM categorylinks
JOIN page ON cl_from =... |
1 year ago |
| SELECT
DISTINCT(cl_to) AS Category
FROM
categorylinks
WHERE
cl_from IN... |
1 year ago |
| SELECT DISTINCT
ll_title
FROM
langlinks
WHERE
ll_lang != 'ckb' --... |
1 year ago |
| SELECT DISTINCT
ll_title
FROM
langlinks
WHERE
ll_lang != 'ckb' --... |
1 year ago |
| SELECT DISTINCT
ll_title
FROM
langlinks
WHERE
ll_lang != 'ckb' --... |
1 year ago |
| SELECT DISTINCT
page_title AS category_title
FROM page
JOIN categorylinks... |
1 year ago |
| SELECT DISTINCT
page_title AS category_title
FROM page
JOIN categorylinks... |
1 year ago |
| -- Get the top 100 categories in most languages except ckbwiki
SELECT... |
1 year ago |
| SELECT
DISTINCT cl_to AS category
FROM
categorylinks
LEFT JOIN
... |
1 year ago |
| SELECT DISTINCT
c1.cl_to AS category_title
FROM categorylinks AS c1
JOIN... |
1 year ago |
| SELECT DISTINCT
c1.cl_to AS category_title
FROM categorylinks AS c1
JOIN... |
1 year ago |
| -- Find the top 100 categories available in most languages, excluding... |
1 year ago |
| -- Find the top 100 categories available in most languages, excluding... |
1 year ago |
| SELECT DISTINCT cl_to
FROM categorylinks
WHERE cl_from IN (
SELECT... |
1 year ago |
| SELECT
cl_title,
COUNT(DISTINCT ll_lang) AS lang_count
FROM
... |
1 year ago |
| SELECT
cat_title,
COUNT(DISTINCT ll_lang) AS lang_count
FROM
... |
1 year ago |
| SELECT DISTINCT
ll_title AS category
FROM
langlinks
WHERE
ll_from IN... |
1 year ago |
| SELECT DISTINCT
ll_title AS category
FROM
langlinks
WHERE
ll_from IN... |
1 year ago |
| -- Find the top 100 categories available in most languages except "ckbwiki"... |
1 year ago |
| -- Top 100 categories available in most languages except ckbwiki
SELECT
... |
1 year ago |
| SELECT DISTINCT
ll_title AS Category
FROM
langlinks
WHERE
ll_from IN... |
1 year ago |
| USE enwiki_p; -- Set the English Wikipedia database
SELECT
... |
1 year ago |
| USE enwiki_p;
SELECT
fr_p.page_title AS CategoryTitle,
... |
1 year ago |
| USE enwiki_p; -- Set the English Wikipedia database
SELECT
... |
1 year ago |
| USE enwiki_p; -- Set the English Wikipedia database
SELECT DISTINCT... |
1 year ago |
| USE enwiki_p;
SELECT en_cl.cl_to AS category, COUNT(ll.ll_lang) AS... |
1 year ago |
| USE enwiki;
SELECT en_p.page_title AS English_Category, COUNT(ll.ll_lang)... |
1 year ago |
| USE enwiki;
SELECT en_p.page_title AS English_Category, COUNT(ll.ll_lang)... |
1 year ago |
| USE enwiki_p;
SELECT en_cl.cl_to AS Category,
COUNT(DISTINCT... |
1 year ago |
| USE enwiki_p; -- Specify the database name
SELECT en_cl.cl_to AS Category,... |
1 year ago |
| USE enwiki_p; -- Specify the database name
SELECT en_cl.cl_to AS Category,... |
1 year ago |
| USE enwiki_p; -- Specify the database name
SELECT en_cl.cl_to AS Category,... |
1 year ago |
| USE enwiki_p; -- Specify the database name
SELECT en_cl.cl_to AS Category,... |
1 year ago |
| USE enwiki_p; -- Specify the database name
SELECT en_cl.cl_to AS Category,... |
1 year ago |
| USE enwiki_p;
SELECT
en_cl.cl_to AS Category,
COUNT(ll.ll_lang) AS... |
1 year ago |
| USE enwiki;
SELECT
en_cl.cl_to AS Category,
COUNT(ll.ll_lang) AS... |
1 year ago |
| USE enwiki_p;
SELECT
en_cl.cl_to AS English_Category,
COUNT(DISTINCT... |
1 year ago |
| USE enwiki_p;
SELECT
en_cl.cl_to AS English_Category,
COUNT(DISTINCT... |
1 year ago |
| SELECT
ROW_NUMBER() OVER (ORDER BY TotalScore DESC) AS Rank,
UserName,
... |
1 year ago |
| USE enwiki_p;
SELECT
en_p.page_title AS Category,
COUNT(ll.ll_lang)... |
1 year ago |
| SELECT en_p.page_title AS Category, COUNT(ll.ll_lang) AS LanguageLinks
FROM... |
1 year ago |
| SELECT en_p.page_title AS Category, COUNT(ll.ll_lang) AS LanguageLinks
FROM... |
1 year ago |
| USE enwiki_p;
SELECT en_p.page_title AS Category, COUNT(DISTINCT... |
1 year ago |
| SELECT en_p.page_title AS EnglishCategory, COUNT(DISTINCT ll.ll_lang) AS... |
1 year ago |
| SELECT DISTINCT en_cats.cl_to AS category_title, COUNT(ll.ll_lang) AS... |
1 year ago |
| SELECT en_cats.cl_to AS category_title, COUNT(ll.ll_lang) AS... |
1 year ago |
| SELECT en_cats.page_title, COUNT(ll.ll_lang) AS language_links_count
FROM... |
1 year ago |
| SELECT en_cl.cl_to AS Category,
COUNT(DISTINCT ll.ll_lang) AS... |
1 year ago |
| SELECT DISTINCT en_cats.cl_to AS Category
FROM categorylinks en_cats
JOIN... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM categorylinks en_cats
JOIN page en_p... |
1 year ago |
| SELECT DISTINCT en_p.page_title
FROM categorylinks en_cl
JOIN page en_p ON... |
1 year ago |
| SELECT DISTINCT en_p.page_title
FROM categorylinks en_cl
JOIN page en_p ON... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM (
SELECT en_p.page_title
FROM... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM (
SELECT en_p.page_title
FROM... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM categorylinks en_cats
JOIN page en_p... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM categorylinks en_cats
JOIN page en_p... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM categorylinks en_cl
JOIN page en_p... |
1 year ago |
| SELECT DISTINCT en_p.page_title
FROM page AS en_p
JOIN categorylinks AS... |
1 year ago |
| SELECT DISTINCT en_p.page_title
FROM categorylinks en_cl
JOIN page en_p ON... |
1 year ago |
| SELECT DISTINCT en_cats.cl_to AS category
FROM categorylinks en_cats
LEFT... |
1 year ago |
| SELECT DISTINCT en_p.page_title
FROM page en_p
JOIN categorylinks en_cl ON... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM categorylinks en_cats
LEFT JOIN (
... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM categorylinks en_cats
LEFT JOIN (
... |
1 year ago |
| SELECT DISTINCT en_p.page_title
FROM categorylinks en_cl
JOIN page en_p ON... |
1 year ago |
| SELECT DISTINCT en_cats.page_title
FROM categorylinks en_cl
JOIN page en_p... |
1 year ago |
| -- Get the top 100 categories available in most languages except ckbwiki and... |
1 year ago |
| SELECT DISTINCT cl_to
FROM categorylinks
LEFT JOIN page ON page_id =... |
1 year ago |
| SELECT DISTINCT cl_to
FROM categorylinks
LEFT JOIN page ON page_id =... |
1 year ago |
| SELECT DISTINCT cl_to
FROM categorylinks
LEFT JOIN page ON page_id =... |
1 year ago |
| -- Select the top 100 categories available in most languages except... |
1 year ago |
| -- First, let's create a temporary table to store the categories that are... |
1 year ago |
| SELECT DISTINCT
cl_to AS category_title,
COUNT(ll_lang) AS... |
1 year ago |
| SELECT
enwiki.ll_title AS en_category,
COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| SELECT
enwiki.ll_title AS en_category,
COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| SELECT
DISTINCT cl_to AS category_name
FROM
categorylinks
WHERE
... |
1 year ago |
| SELECT
DISTINCT c.cl_to AS category_name
FROM
categorylinks AS c
WHERE
... |
1 year ago |
| SELECT
DISTINCT cl_to AS category_name
FROM
categorylinks
WHERE
... |
1 year ago |
| -- First, we need to get the page_id of "Category:Hidden_categories" on... |
1 year ago |
| SELECT * FROM langlinks;
|
1 year ago |
| -- First, we need to get the page_id of "Category:Hidden_categories" on... |
1 year ago |
| SELECT
ll_title AS Category,
COUNT(*) AS LanguageCount
FROM
... |
1 year ago |
| SELECT
ll_title AS Category,
COUNT(*) AS LanguageCount
FROM
... |
1 year ago |
| SELECT
cl_to AS Category,
COUNT(DISTINCT ll_lang) AS LanguageCount
FROM
... |
1 year ago |
| SELECT
ll_title AS category_title,
COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| SELECT
ll_title AS category_title,
COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| SELECT
SUBSTRING_INDEX(ll_title, ':', -1) AS category_title,
... |
1 year ago |
| SELECT
SUBSTRING_INDEX(ll_title, ':', -1) AS category_title,
... |
1 year ago |
| SELECT
cl_to AS CategoryName,
COUNT(DISTINCT cl_language) AS... |
1 year ago |
| SELECT
cl_to AS category,
COUNT(*) AS lang_count
FROM... |
1 year ago |
| USE enwiki_p;
SELECT
DISTINCT cl_to AS Category
FROM
... |
1 year ago |
| USE enwiki_p;
SELECT
DISTINCT cl_to AS Category
FROM
... |
1 year ago |
| -- Use the enwiki_p database
USE enwiki_p;
-- Select the top 100 categories... |
1 year ago |
| USE wikidatawiki_p;
WITH category_counts AS (
SELECT
ll_title AS... |
1 year ago |
| USE wikidatawiki_p;
WITH category_counts AS (
SELECT
ll_title AS... |
1 year ago |
| USE wikidatawiki_p;
WITH category_counts AS (
SELECT
ll_title AS... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
ll_title AS category_title
FROM
... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| -- Use the enwiki_p database
USE enwiki_p;
-- Find the top 100 categories... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
ll_title AS... |
1 year ago |
| USE ckbwiki_p;
WITH CategoryCounts AS (
SELECT
ll_title AS... |
1 year ago |
| USE wikidatawiki_p;
SELECT
enwiki.ll_title AS category_title
FROM
... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
cl_to AS category
FROM
... |
1 year ago |
| USE enwiki_p;
-- Subquery to identify categories that are members of... |
1 year ago |
| USE enwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| -- First, switch to the enwiki database
USE enwiki_p;
-- Then, select the... |
1 year ago |
| USE enwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE enwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE enwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE enwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| -- Query for enwiki_p (English Wikipedia)
USE enwiki_p;
-- Get the top 100... |
1 year ago |
| USE enwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE enwiki_p
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE enwiki_p;
SELECT
cl_to AS category,
COUNT(*) AS count
FROM
... |
1 year ago |
| USE enwiki_p;
-- Subquery to identify categories that are members of... |
1 year ago |
| USE enwiki_p;
-- Subquery to identify categories that are members of... |
1 year ago |
| USE wikidatawiki_p;
SELECT DISTINCT ll_title AS CategoryTitle
FROM... |
1 year ago |
| USE wikidatawiki_p;
SELECT DISTINCT ll_title AS CategoryTitle
FROM... |
1 year ago |
| USE wikidatawiki_p;
SELECT DISTINCT ll_title AS CategoryTitle
FROM... |
1 year ago |
| USE wikidatawiki_p;
SELECT DISTINCT ll_title AS CategoryTitle
FROM... |
1 year ago |
| USE wikidatawiki_p;
SELECT
DISTINCT ll_title AS CategoryTitle
FROM
... |
1 year ago |
| -- Top 100 categories that are not available in ckbwiki and not hidden on... |
1 year ago |
| -- Top 100 categories that are not available in ckbwiki and not hidden on... |
1 year ago |
| USE enwiki_p;
WITH TopCategories AS (
SELECT
COUNT(*) AS... |
1 year ago |
| USE enwiki_p;
WITH TopCategories AS (
SELECT
COUNT(*) AS... |
1 year ago |
| USE enwiki_p;
WITH TopCategories AS (
SELECT
COUNT(*) AS... |
1 year ago |
| USE enwiki_p;
WITH TopCategories AS (
SELECT
COUNT(*) AS... |
1 year ago |
| USE enwiki_p;
WITH TopCategories AS (
SELECT
COUNT(*) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
DISTINCT en.ll_title AS category_title
FROM
(
... |
1 year ago |
| -- Specify the database to use
USE ckbwiki_p;
-- Fetch the top 100... |
1 year ago |
| -- Use the enwiki_p database
USE enwiki_p;
-- Get the top 100 categories... |
1 year ago |
| USE enwiki_p; -- Replace 'enwiki_p' with the appropriate database... |
1 year ago |
| -- Specify the database to use (replace 'enwiki_p' with the appropriate... |
1 year ago |
| USE wikidatawiki_p;
WITH CategoryCounts AS (
SELECT
ll_title AS... |
1 year ago |
| USE wikidatawiki_p;
WITH CategoryCounts AS (
SELECT
ll_title AS... |
1 year ago |
| USE wikidatawiki_p;
SELECT
ll_title AS category
FROM langlinks
WHERE
... |
1 year ago |
| USE wikidatawiki_p;
WITH CategoryCounts AS (
SELECT
ll_title AS... |
1 year ago |
| USE wikidatawiki_p;
WITH CategoryCounts AS (
SELECT
ll_title AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
page_title AS... |
1 year ago |
| USE wikidatawiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_title NOT IN... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
page_title AS category_title
FROM page
JOIN... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
page_title AS category_title
FROM page
JOIN... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
page_title AS category_title
FROM page
JOIN... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
cl_to AS category_title
FROM... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
page_title AS category_title
FROM page
JOIN... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
page_title AS category_title
FROM page
JOIN... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT
page_title AS category_title
FROM page
JOIN... |
1 year ago |
| -- Use the English Wikipedia database
USE enwiki_p;
-- Fetch the top 100... |
1 year ago |
|
SELECT en.ll_title AS category_title, COUNT(DISTINCT en2.ll_lang) AS... |
1 year ago |
|
SELECT en.ll_title AS category_title, COUNT(DISTINCT en2.ll_lang) AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT DISTINCT en.ll_title... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT DISTINCT en.ll_title... |
1 year ago |
| select concat("* [[:en:Category:",page_title,"]]"), count(cl_from)
from... |
1 year ago |
| select concat("* [[:en:Category:",page_title,"]]"), count(cl_from)
from... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT DISTINCT en.ll_title... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT DISTINCT en.ll_title... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT DISTINCT en.ll_title... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT category_title,... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT
en.ll_title AS... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT DISTINCT en.ll_title... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT DISTINCT en.ll_title... |
1 year ago |
| -- USE ckbwiki_p, enwiki_p, or wikidatawiki_p
SELECT DISTINCT en.ll_title... |
1 year ago |
| -- USE enwiki_p;
WITH LanguageCounts AS (
SELECT
ll_title AS... |
1 year ago |
| -- Find the top 100 categories available in most languages/wikipedias but... |
1 year ago |
| -- Find the top 100 categories available in most languages/wikipedias but... |
1 year ago |
| USE enwiki_p;
WITH AllCategoryCounts AS (
SELECT
ll_title AS... |
1 year ago |
| USE enwiki_p;
-- Find the categories available on most... |
1 year ago |
| USE ckbwiki_p;
WITH category_counts AS (
SELECT
ll_title AS... |
1 year ago |
| USE ckbwiki_p;
WITH category_counts AS (
SELECT
ll_title AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
WITH CategoryCounts AS (
SELECT
cl_to AS... |
1 year ago |
| -- Specify the database you want to use (e.g., ckbwiki_p, enwiki_p, or... |
1 year ago |
| -- USE the appropriate database (enwiki_p, ckbwiki_p, etc.)
USE... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| -- USE the appropriate database
USE enwiki_p;
-- Find categories that are... |
1 year ago |
| -- USE the appropriate database
USE enwiki_p;
-- Find categories that are... |
1 year ago |
| -- USE the appropriate database
USE wikidatawiki_p;
-- Find categories that... |
1 year ago |
| USE enwiki_p;
SELECT
ll_title AS category_title
FROM
langlinks
WHERE
... |
1 year ago |
| USE ckbwiki_p;
SELECT
c.cl_to AS ckbwiki_category,
l.ll_title AS... |
1 year ago |
| USE ckbwiki_p;
SELECT
cl_to AS category_title
FROM
categorylinks
WHERE
... |
1 year ago |
| USE ckbwiki_p;
SELECT
page.page_title AS EnglishCategoryTitle
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
ll_title AS CkbCategoryTitle
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT
page.page_title AS EnglishCategoryTitle
FROM
... |
1 year ago |
| USE enwiki_p;
SELECT DISTINCT enwiki.ll_title AS Category
FROM langlinks AS... |
1 year ago |
| USE enwiki_p;
SELECT
DISTINCT cl_to AS CategoryTitle
FROM
... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT
en_page.page_title AS... |
1 year ago |
| -- Specify the database to use
USE enwiki_p;
-- Retrieve the top 100... |
1 year ago |
| -- Specify the database to use
USE enwiki_p;
-- Retrieve the top 100... |
1 year ago |
| -- Specify the database to use
USE enwiki_p;
-- Retrieve the top 100... |
1 year ago |
| USE ckbwiki_p;
WITH CategoryCounts AS (
SELECT
ll_title AS... |
1 year ago |
| USE enwiki_p;
-- Find the top 100 categories available in most languages... |
1 year ago |
| -- Use ckbwiki_p, enwiki_p, or wikidatawiki_p
USE enwiki_p;
-- Find the top... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT SUBSTRING_INDEX(ll_title, ':', -1) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_lang !=... |
1 year ago |
| USE ckbwiki_p;
SELECT ll_title, COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT ll_title, COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT ll_title, COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_lang !=... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_lang !=... |
1 year ago |
| USE ckbwiki_p;
SELECT ll_title, COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_lang !=... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_lang !=... |
1 year ago |
| USE ckbwiki_p;
SELECT ll_title, COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT ll_title, COUNT(DISTINCT ll_lang) AS... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_title LIKE... |
1 year ago |
| USE ckbwiki_p;
-- Get categories that are available in most languages but... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_lang NOT IN... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_title LIKE... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_lang NOT IN... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT ll_title
FROM langlinks
WHERE ll_lang NOT IN... |
1 year ago |
| USE wikidatawiki_p;
WITH LanguageCategoryCounts AS (
SELECT
... |
1 year ago |
| USE wikidatawiki_p;
WITH CategoryLanguageCounts AS (
SELECT
cl_to AS... |
1 year ago |
| USE enwiki_p;
-- Find the categories available on most languages but not in... |
1 year ago |
| USE ckbwiki_p;
-- Create a temporary table to store category titles in... |
1 year ago |
| USE ckbwiki_p;
-- Create a temporary table to store category titles in... |
1 year ago |
| USE ckbwiki_p;
-- Create a temporary table to store category titles in... |
1 year ago |
| -- Get the top 100 categories available in most languages/wikipedias, but... |
1 year ago |
| USE ckbwiki_p; -- Use the ckbwiki database
-- Query to fetch categories... |
1 year ago |
| USE ckbwiki_p; -- Use the ckbwiki database
-- Query to fetch categories... |
1 year ago |
| USE ckbwiki_p; -- Use the ckbwiki database
-- Query to fetch categories... |
1 year ago |
| USE ckbwiki_p; -- Use the ckbwiki database
-- Query to fetch categories... |
1 year ago |
| USE ckbwiki_p; -- Use the ckbwiki database
-- Query to fetch categories... |
1 year ago |
| USE ckbwiki_p;
-- Query to fetch categories from namespace 14 available on... |
1 year ago |
| USE ckbwiki_p;
-- Query to fetch categories in namespace 14 available on... |
1 year ago |
| USE ckbwiki_p;
-- Query to fetch categories available on most languages but... |
1 year ago |
| USE ckbwiki_p;
-- Query to fetch categories linked to most language... |
1 year ago |
| USE ckbwiki_p;
-- Query to fetch categories linked to most language... |
1 year ago |
| USE wikidatawiki_p;
-- Query to fetch categories linked to most Wikipedias... |
1 year ago |
| USE enwiki_p;
-- Query to fetch categories linked to most Wikipedias but... |
1 year ago |
| USE wikidatawiki_p;
-- Query to fetch categories linked to most Wikipedias... |
1 year ago |
| USE wikidatawiki_p;
-- Query to fetch categories linked to most Wikipedias... |
1 year ago |
| USE ckbwiki_p;
SELECT * FROM interwiki |
1 year ago |
| USE wikidatawiki_p;
-- Query to fetch categories linked to most Wikipedias... |
1 year ago |
| USE ckbwiki_p;
Select * from user; |
1 year ago |
| USE ckbwiki_p;
Select * from sites; |
1 year ago |
| USE ckbwiki_p;
Select * from job; |
1 year ago |
| USE ckbwiki_p;
Select * from site_stats; |
1 year ago |
| USE wikidatawiki_p;
-- Query to fetch categories linked to most Wikipedias... |
1 year ago |
| USE wikidatawiki_p;
-- Query to fetch categories linked to most Wikipedias... |
1 year ago |
| USE wikidatawiki_p;
-- Query to fetch categories linked to most Wikipedias... |
1 year ago |
| USE wikidatawiki;
-- Query to fetch categories linked to most Wikipedias... |
1 year ago |
| USE wikidata; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE wikidata_p; -- Use the Wikidata database
-- Query to fetch categories... |
1 year ago |
| USE enwiki_p; -- Use the English Wikipedia database
-- Query to fetch... |
1 year ago |
| SELECT
pl_title AS Category
FROM categorylinks
WHERE cl_to NOT IN (
... |
1 year ago |
| -- Get 100 categories that exist in most Wikipedias (including English) but... |
1 year ago |
| USE enwiki_p;
SELECT
cl_to AS CategoryName
FROM categorylinks
WHERE
--... |
1 year ago |
| -- Use ckbwiki_p
USE ckbwiki_p;
-- Find articles in the "زیندووان" category... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles in the "زیندووان" category... |
1 year ago |
| -- Use ckbwiki_p
USE ckbwiki_p;
-- Find articles in the "زیندووان" category... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles in "زیندووان" category... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles in "زیندووان"... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles in the "زیندووان" category... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles in "زیندووان"... |
1 year ago |
| -- Use ckbwiki_p
USE ckbwiki_p;
-- Fetch articles in the "زیندووان"... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles in the "زیندووان" category... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles in "زیندووان" category... |
1 year ago |
| -- Use ckbwiki_p
USE ckbwiki_p;
-- Find articles in the "زیندووان" category... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles with Wikidata QIDs in the... |
1 year ago |
| -- Use ckbwiki_p
use ckbwiki_p;
-- Find articles with Wikidata QIDs in the... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT CONCAT('# [[', page.page_title, ']]') AS... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT CONCAT('# [[', page.page_title, ']]') AS... |
1 year ago |
| USE ckbwiki_p;
SELECT DISTINCT CONCAT('# [[', page.page_title, ']]') AS... |
1 year ago |
| # Use the ckbwiki_p database
use ckbwiki_p;
# Retrieve articles with... |
1 year ago |
| # Find ckbwiki articles in the "زیندووان" category with a Wikidata item and... |
1 year ago |
| use ckbwiki_p;
SELECT
pp.pp_value as Qid,
page.page_title as... |
1 year ago |
| use ckbwiki_p;
SELECT
pp.pp_value as Qid,
page.page_title as... |
1 year ago |
| use ckbwiki_p;
SELECT
pp.pp_value as Qid,
page.page_title as... |
1 year ago |
| USE ckbwiki_p;
SELECT
CONCAT('# [[', page.page_title, ']]') AS 'Page... |
1 year ago |
| USE ckbwiki_p;
SELECT
CONCAT('# [[', page.page_title, ']]') AS 'Page... |
1 year ago |
| SELECT
CONCAT('# [[', page.page_title, ']]')
FROM page
WHERE page_namespace... |
1 year ago |
| SELECT DISTINCT p.page_title
FROM page AS p
JOIN templatelinks AS tl ON... |
1 year ago |
| USE ckbwiki_p;
SELECT page_title
FROM page
JOIN categorylinks ON page_id =... |
1 year ago |
| USE ckbwiki_p;
SELECT page_title
FROM page
JOIN categorylinks ON page_id =... |
1 year ago |
| USE ckbwiki_p;
SELECT page_title
FROM page
JOIN categorylinks ON page_id =... |
1 year ago |
| SELECT DISTINCT p.page_title
FROM page p
JOIN categorylinks cl ON p.page_id... |
1 year ago |
| SELECT DISTINCT page_title
FROM categorylinks
JOIN page ON cl_from =... |
1 year ago |
| USE ckbwiki_p;
SELECT
page_title AS article_title
FROM
categorylinks
... |
1 year ago |
| USE ckbwiki_p;
SELECT
page_title,
il_to
FROM page
JOIN imagelinks
ON... |
1 year ago |
| SELECT
page_title,
il_to
FROM page
JOIN imagelinks
ON page_id =... |
1 year ago |
| SELECT
page_title,
il_to
FROM page
JOIN imagelinks
ON page_id =... |
1 year ago |
