SET @Begin = "20170901000000";
SET @Initial =... |
2 years ago |
SET @Begin = "20170901000000";
SET @Initial =... |
2 years ago |
SET @Begin = "20170901000000";
SET @Initial =... |
2 years ago |
SET @Begin = "20170901000000";
SET @Initial =... |
2 years ago |
SET @Begin = "20170901000000";
SET @Initial =... |
2 years ago |
SET @Begin = "20170901000000";
SET @Initial =... |
2 years ago |
SELECT 'Commons_wiki' as db_name, *
FROM revision
LIMIT 10 |
2 years ago |
SELECT 'Commons_wiki' as db_name, *
FROM revision
LIMIT 10 |
2 years ago |
SELECT Commons_wiki as db_name, *
FROM revision
LIMIT 10 |
2 years ago |
SELECT Commons_wiki as db_name, *
LIMIT 10 |
2 years ago |
SELECT Commons_wiki as db_name
LIMIT 10 |
2 years ago |
SELECT *
FROM user
LIMIT 10 |
2 years ago |
SELECT *
FROM user
LIMIT 10 |
2 years ago |
SELECT *
FROM user
LIMIT 10 |
2 years ago |
SELECT *
FROM wikimedia_editor_tasks_counts
LIMIT 10 |
2 years ago |
WITH
cat_filter AS (
SELECT T1.rev_id, T1.rev_actor
FROM... |
2 years ago |
SELECT *
FROM globaluser
LIMIT 10 |
2 years ago |
SELECT COUNT(gu_name)
FROM globaluser
WHERE gu_home_db = "commonswiki"
LIMIT 10 |
2 years ago |
SELECT *
FROM globaluser
WHERE gu_home_db = "commonswiki"
LIMIT 10 |
2 years ago |
SELECT *
FROM globaluser
WHERE gu_name = "KCVelaga"
LIMIT 10 |
2 years ago |
SELECT *
FROM globaluser
LIMIT 10 |
2 years ago |
SELECT *
FROM globaluser
LIMIT 10 |
2 years ago |
SELECT *
FROM global_user
LIMIT 10 |
2 years ago |
SELECT *
FROM global_user
LIMIT 10 |
2 years ago |
SELECT *
FROM global_user
LIMIT 10 |
2 years ago |
SELECT *
FROM global_user
LIMIT 10 |
2 years ago |
SELECT *
FROM global_user
LIMIT 10 |
2 years ago |
SELECT *
FROM global_user
LIMIT 10 |
2 years ago |
SELECT *
FROM global_user
LIMIT 10 |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, COUNT(DISTINCT rev_id)
FROM... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount
FROM... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount, COUNT... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount, rev_id,... |
2 years ago |
SELECT actor_user, user_name, user_editcount as editcount, rev_id,... |
2 years ago |
SELECT actor_user, user_name, user_editcount as editcount, rev_id,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount, rev_id,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount, rev_id,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount, rev_id,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount, rev_id,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_editcount as editcount, rev_id,... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_registration as... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_registration as... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_registration as... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_registration as... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_registration as... |
2 years ago |
SELECT DISTINCT actor_user, user_name, user_registration as... |
2 years ago |
SELECT *
FROM revision
# WHERE rev_page = "26729834"
LIMIT 100 |
2 years ago |
SELECT *
FROM revision
WHERE rev_page = "26729834"
LIMIT 100 |
2 years ago |
SELECT *
FROM revision
WHERE rev_actor = "171327"
LIMIT 100 |
2 years ago |
SELECT *
FROM revision
WHERE rev_actor = "17132753848"
#LIMIT 100 |
2 years ago |
SELECT *
FROM revision
WHERE rev_actor = "1716753848"
#LIMIT 100 |
2 years ago |
SELECT *
FROM revision
WHERE rev_actor = "1716"
#LIMIT 100 |
2 years ago |
SELECT *
FROM revision
WHERE rev_actor = "1716"
LIMIT 100 |
2 years ago |
SELECT *
FROM revision
WHERE rev_page = "26729834"
LIMIT 100 |
2 years ago |
SELECT *
FROM revision
WHERE rev_page = "26729834"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_id = "533452800"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_page = "533452800"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_page = "533452800"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
WHERE rev_id = "533452800"
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
LIMIT 10 |
2 years ago |
SELECT *
FROM revision
|
2 years ago |
SELECT REGEXP_SUBSTR(rc_title, 'W[a-z]/[a-z]+') AS prefix, COUNT(*) AS... |
2 years ago |
SELECT REGEXP_SUBSTR(rc_title, 'W[a-z]/[a-z]+') AS prefix, COUNT(*) AS... |
2 years ago |
USE incubatorwiki_p;
SELECT REGEXP_SUBSTR(rc_title, 'W[a-z]/[a-z]+') AS... |
2 years ago |
USE incubatorwiki_p;
SELECT REGEXP_SUBSTR(rc_title, 'W[a-z]/[a-z]+') AS... |
2 years ago |
USE incubatorwiki_p;
SELECT REGEXP_SUBSTR(rc_title, 'W[a-z]/[a-z]+') AS... |
2 years ago |
USE incubatorwiki_p;
SELECT REGEXP_SUBSTR(rc_title, 'W[a-z]/[a-z]+') AS... |
2 years ago |
USE incubatorwiki_p;
SELECT REGEXP_SUBSTR(rc_title, 'W[a-z]/[a-z]+') AS... |
2 years ago |
SELECT *
FROM recentchanges
LIMIT 100
|
2 years ago |
SELECT *
FROM recentchanges
LIMIT 10
|
2 years ago |
SELECT user_name FROM user WHERE user_email = 'nivas10798@gmail.com'; |
2 years ago |
SELECT user_name FROM user WHERE user_email = 'nivas10798@gmail.com'; |
2 years ago |