| USE testwiki_p;
SELECT ug.*, u.user_name, gu.gu_locked
FROM user_groups... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @whitelistPage = 62534307;
SET @botActorId = 192619287;
SET... |
3 years ago |
| SET @changedRedirectTagId = 10;
SET @newRedirectTagId = 11;
SET... |
3 years ago |
| SET @changedRedirectTagId = 10;
SET @newRedirectTagId = 11;
SET... |
3 years ago |
| SELECT * FROM change_tag_def;
SELECT
rev.*,
pg.page_namespace,
... |
3 years ago |
| SELECT
rev.*,
pg.page_namespace,
pg.page_title
FROM
revision... |
3 years ago |
| SELECT
rev.*,
pg.*
FROM
revision rev
JOIN
page pg
ON pg.page_id =... |
3 years ago |
| SELECT
page_id AS 'pageid',
page_title AS 'title',
ptrpt_value AS... |
3 years ago |
| SELECT
page_id AS 'pageid',
page_title AS 'title',
ptrpt_value AS... |
3 years ago |
| SELECT u.user_name, ug.*
FROM user u
JOIN user_groups ug
ON ug.ug_user =... |
3 years ago |
| SELECT pg.page_namespace, pg.page_title, rd.*
FROM page pg
JOIN redirect... |
3 years ago |
| SELECT pg.page_namespace, pg.page_title, rd.*
FROM page pg
JOIN redirect... |
3 years ago |
| SELECT pg.page_namespace, pg.page_title, rd.*
FROM page pg
JOIN redirect... |
3 years ago |
| SELECT pg.page_namespace, pg.page_title, rd.*
FROM page pg
JOIN redirect... |
3 years ago |
| SELECT
pg.page_title,
eni.img_name
# comi.img_name
FROM page pg
LEFT... |
3 years ago |
| SELECT
pg.page_title,
eni.img_name
# comi.img_name
FROM page pg
LEFT... |
3 years ago |
| SELECT
pg.page_title,
eni.img_name
# comi.img_name
FROM page pg
LEFT... |
3 years ago |
| SELECT
pg.page_title,
eni.img_name
# comi.img_name
FROM page pg
LEFT... |
3 years ago |
| SELECT
pg.page_title,
eni.img_name
# comi.img_name
FROM page pg
LEFT... |
3 years ago |
| SELECT
pg.page_title,
eni.img_name
# comi.img_name
FROM page pg
LEFT... |
3 years ago |
| SELECT
pg.page_title,
eni.img_name
# comi.img_name
FROM page pg
LEFT... |
3 years ago |
| SELECT
pg.*,
eni.img_name
# comi.img_name
FROM page pg
LEFT JOIN... |
3 years ago |
| SELECT
pg.*,
eni.img_name,
comi.img_name
FROM page pg
LEFT JOIN... |
3 years ago |
| SELECT * FROM page
LEFT JOIN image eni ON page_title = eni.img_name
LEFT... |
3 years ago |
| SELECT * FROM page
LEFT JOIN image eni ON page_title = eni.img_name
LEFT... |
3 years ago |
| SELECT * FROM page
LEFT JOIN image eni ON page_title = eni.img_name
LEFT... |
3 years ago |
| SELECT * FROM page
LEFT JOIN image ON page_title = img_name
LEFT JOIN... |
3 years ago |
| SELECT * FROM page
LEFT JOIN image ON page_title = img_name
WHERE... |
3 years ago |
| SELECT * FROM page
LEFT JOIN image ON page_title = img_name
WHERE... |
3 years ago |
| SELECT * FROM page
LEFT JOIN image ON page_title = img_name
WHERE... |
3 years ago |
| SELECT page_title AS user
FROM page
JOIN templatelinks
ON page.page_id =... |
3 years ago |
| SELECT page_title AS user
FROM page
JOIN templatelinks
ON page.page_id =... |
3 years ago |
| SELECT * FROM slot_roles
/*
SELECT DISTINCT img_media_type FROM image LIMIT... |
3 years ago |
| SELECT DISTINCT img_media_type FROM image LIMIT 10;
SELECT DISTINCT... |
3 years ago |
| SELECT DISTINCT us_media_type FROM uploadstash LIMIT 10;
/*
USE... |
3 years ago |
| SELECT DISTINCT img_media_type FROM image LIMIT 10;
SELECT DISTINCT... |
3 years ago |
| SELECT DISTINCT img_media_type FROM image LIMIT 10;
SELECT DISTINCT... |
3 years ago |
| SELECT DISTINCT img_media_type FROM image LIMIT 10;
/*
USE... |
3 years ago |
| SELECT DISTINCT img_media_type FROM image LIMIT 10;
SELECT DISTINCT... |
3 years ago |
| SELECT DISTINCT img_media_type FROM image LIMIT 11
/*
USE metawiki_p;
SELECT... |
3 years ago |
| USE metawiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups ug
JOIN... |
3 years ago |
| USE metawiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups ug
JOIN... |
3 years ago |
| USE mediawikiwiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups... |
3 years ago |
| USE enwikiversity_p;
SELECT ug.ug_group, u.user_name FROM user_groups... |
3 years ago |
| USE wikidatawiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups ug
JOIN... |
3 years ago |
| USE metawiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups ug
JOIN... |
3 years ago |
| USE metawiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups ug
JOIN... |
3 years ago |
| USE mediawikiwiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups... |
3 years ago |
| USE mediawikiwiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups... |
3 years ago |
| USE metawiki_p;
SELECT ug.ug_group, u.user_name FROM user_groups ug
JOIN... |
3 years ago |
| USE metawiki_p;
SELECT ug.ug_group, u.user_name, FROM user_groups ug
JOIN... |
3 years ago |
| use frwiki_p;
SELECT page_title #COUNT(*), linter_params
FROM linter
JOIN... |
4 years ago |
| use frwiki_p;
SELECT COUNT(*), linter_params FROM linter
JOIN page ON... |
4 years ago |
| use dewiki_p;
SELECT COUNT(*), linter_params FROM linter
JOIN page ON... |
4 years ago |
| SELECT COUNT(*), linter_params FROM linter
JOIN page ON page_id =... |
4 years ago |
| SELECT COUNT(*), linter_params FROM linter
JOIN page ON page_id =... |
4 years ago |
| SELECT page_title FROM linter
JOIN page ON page_id = linter_page
WHERE... |
4 years ago |
| SELECT * FROM linter
JOIN page ON page_id = linter_page
WHERE linter_cat =... |
4 years ago |
| SELECT * FROM linter
WHERE linter_cat = 3
#AND linter_page = 478917
AND... |
4 years ago |
| SELECT * FROM linter
WHERE linter_cat = 3
AND linter_page = 478917
LIMIT... |
4 years ago |
| SELECT * FROM linter
WHERE linter_cat = 3
LIMIT 100;
/*
USE... |
4 years ago |
| SELECT * FROM linter
LIMIT 100;
/*
USE specieswiki_p;
SELECT... |
4 years ago |
| SELECT page_namespace, page_title
FROM page JOIN categorylinks ON page_id =... |
4 years ago |
| USE specieswiki_p;
SELECT CONCAT('Template:', page_title) FROM page
WHERE... |
4 years ago |
| USE specieswiki_p;
SELECT CONCAT('Template:', page_title) FROM page
WHERE... |
4 years ago |
| USE specieswiki_p;
SELECT CONCAT('Template:', page_title), * FROM page
WHERE... |
4 years ago |
| SELECT CONCAT('Template:', page_title), SUBSTRING(page_title, 18) FROM... |
4 years ago |
| SELECT CONCAT('Template:', page_title), SUBSTRING(page_title, 18) FROM... |
4 years ago |
| SELECT *, SUBSTRING(page_title, 18) FROM page
WHERE page_namespace = 10
AND... |
4 years ago |
| SELECT *, SUBSTRING(page_title, 16) FROM page
WHERE page_namespace = 10
AND... |
4 years ago |
| SELECT *, SUBSTRING(page_title, 16) FROM page
WHERE page_namespace = 8
AND... |
4 years ago |
| SELECT *, SUBSTRING(page_title, 16) FROM page
WHERE page_namespace = 8
AND... |
4 years ago |
| SELECT *, SUBSTRING(page_title, 16) FROM page
WHERE page_namespace = 8
AND... |
4 years ago |
| SELECT *, SUBSTRING(page_title, 16) FROM page
WHERE page_namespace = 8
AND... |
4 years ago |
| SELECT *, SUBSTRING(page_title, 16) FROM page
WHERE page_title lIKE... |
4 years ago |
| SELECT *
FROM page
LEFT JOIN pagetriage_page ON ptrp_page_id = page_id
LEFT... |
4 years ago |
| SELECT *
FROM page
LEFT JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN... |
4 years ago |
| SELECT *
FROM page
LEFT JOIN pagetriage_page ON ptrp_page_id = page_id
WHERE... |
4 years ago |
| SELECT *
FROM page
LEFT JOIN pagetriage_page ON ptrp_page_id = page_id
LEFT... |
4 years ago |
| SELECT *
FROM page
WHERE page_id = 62933448
LEFT JOIN pagetriage_page ON... |
4 years ago |
| SELECT *
FROM page
WHERE page_id = 62933448
;
/*
JOIN pagetriage_page ON... |
4 years ago |
| SELECT *
FROM page
JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN... |
4 years ago |
| SELECT *
FROM page
JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN... |
4 years ago |
| SELECT *
FROM page
JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN... |
4 years ago |
| SELECT *
FROM page
JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN... |
4 years ago |
| SELECT
page_id AS 'pageid',
page_title AS 'title',
ptrpt_value AS... |
4 years ago |
| SELECT *
FROM page
JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN... |
4 years ago |
| /*
USE commonswiki_p;
SELECT page_title FROM page
WHERE page_namespace =... |
4 years ago |
| /*
USE commonswiki_p;
SELECT page_title FROM page
WHERE page_namespace =... |
4 years ago |
| USE commonswiki_p;
SELECT page_title FROM page
WHERE page_namespace = 6
AND... |
4 years ago |
| USE commonswiki_p;
SELECT page_title FROM page
WHERE page_namespace = 6
AND... |
4 years ago |
| USE commonswiki_p;
SELECT page_title FROM page
WHERE page_namespace = 6
AND... |
4 years ago |
| USE enwikinews_p;
SELECT page_title FROM page
LEFT JOIN page_restrictions ON... |
4 years ago |
| /*
USE enwikinews_p;
SELECT page_title FROM page
LEFT JOIN page_restrictions... |
4 years ago |
| USE enwikinews_p;
SELECT page_title FROM page
LEFT JOIN page_restrictions ON... |
4 years ago |
| SELECT user_name, ug_group FROM user
JOIN user_groups ON ug_user =... |
4 years ago |
| SELECT user_name, ug_group FROM user
JOIN user_groups ON ug_user =... |
4 years ago |
| SELECT * FROM user
JOIN user_groups ON ug_user = user_id
WHERE user_name in... |
4 years ago |
| SELECT * FROM user
JOIN usergroups ON ug_user = user_id
WHERE user_name in... |
4 years ago |
| USE enwikinews_p;
SELECT page_title FROM page
LEFT JOIN page_restrictions ON... |
4 years ago |
| USE enwikinews_p;
SELECT page_title FROM page
LEFT JOIN page_restrictions ON... |
4 years ago |
| USE enwikinews_p;
SELECT page_title FROM page
LEFT JOIN page_restrictions ON... |
4 years ago |
| USE enwikinews_p;
SELECT page_title FROM page
LEFT JOIN page_restrictions ON... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM page
LEFT JOIN page_restrictions ON page_id... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM page
LEFT JOIN page_restrictions ON page_id... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM page
JOIN page_restrictions ON page_id =... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM page
WHERE page_namespace = 0
AND page_id... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM page
WHERE page_namespace = 0
AND page_id... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM page
WHERE page_namespace = 0
AND page_id... |
4 years ago |
| SELECT * FROM recentchanges
WHERE rc_type = 3
AND rc_log_type =... |
4 years ago |
| SELECT * FROM recentchanges
WHERE rc_type = 3
AND rc_log_type =... |
4 years ago |
| SELECT * FROM recentchanges
WHERE rc_type = 3
LIMIT 100;
/*
SELECT *
FROM... |
4 years ago |
| SELECT * FROM recentchanges
LIMIT 100;
/*
SELECT *
FROM templatelinks
WHERE... |
4 years ago |
| SELECT * FROM recent_changes
LIMIT 100;
/*
SELECT *
FROM templatelinks
WHERE... |
4 years ago |
| SELECT *
FROM templatelinks
WHERE tl_namespace = 6
AND NOT EXISTS (
SELECT... |
4 years ago |
| SELECT *
FROM templatelinks
WHERE tl_namespace = 6
LIMIT 10;
SELECT *
FROM... |
4 years ago |
| SELECT *
FROM page
JOIN pagetriage_page ON ptrp_page_id = page_id
JOIN... |
4 years ago |
| SELECT *
FROM pagetriage_page
JOIN pagetriage_page_tags ON ptrpt_page_id =... |
4 years ago |
| SELECT *
FROM pagetriage_page
JOIN pagetriage_page_tags ON ptrpt_page_id =... |
4 years ago |
| SELECT *
FROM pagetriage_page
WHERE ptrp_page_id = 60231771
/*
SELECT... |
4 years ago |
| SELECT page_title, r.* FROM page
JOIN redirect AS r ON page_id =... |
4 years ago |
| SELECT page_title, r.* FROM page
JOIN redirect AS r ON page_id =... |
4 years ago |
| SELECT page_title, r.* FROM page
JOIN redirect AS r ON page_id =... |
4 years ago |
| SELECT page_title, r.* FROM page
JOIN redirect ON page_id = rd_from
WHERE... |
4 years ago |
| SELECT page_title FROM page
WHERE page_is_redirect = 1
AND page_namespace =... |
4 years ago |
| SELECT page_title FROM page
WHERE page_is_redirect = 1
AND page_namespace =... |
4 years ago |
| SELECT page_title FROM page
WHERE page_is_redirect = 1
AND page_namespace =... |
4 years ago |
| SELECT page_title FROM page
WHERE page_namespace = 0
AND page_is_redirect =... |
4 years ago |
| SELECT page_title FROM page
WHERE page_namespace = 0
AND page_is_redirect =... |
4 years ago |
| USE commonswiki_p;
SELECT * FROM page
JOIN revision ON rev_id =... |
4 years ago |
| USE commonswiki_p;
SELECT * FROM page
JOIN revision ON rev_id =... |
4 years ago |
| USE commonswiki_p;
SELECT * FROM page
JOIN revision ON rev_id =... |
4 years ago |
| USE commonswiki_p;
SELECT * FROM page
JOIN revision ON rev_id =... |
4 years ago |
| USE commonswiki_p;
SELECT * FROM page
WHERE page_id = 2385461
/*
USE... |
4 years ago |
| USE enwikinews_p;
SELECT count(*), a.*
FROM archive_userindex a
WHERE... |
4 years ago |
| USE enwikinews_p;
SELECT count(*), a.*
FROM archive_userindex a
WHERE... |
4 years ago |
| USE enwikinews_p;
SELECT count(*), *
FROM archive_userindex
WHERE ar_actor =... |
4 years ago |
| USE enwikinews_p;
SELECT count(*), *
FROM archive_userindex
WHERE ar_actor =... |
4 years ago |
| USE enwikinews_p;
SELECT count(*), *
FROM archive_userindex
WHERE ar_actor =... |
4 years ago |
| USE enwikinews_p;
SELECT count(*), *
FROM archive_userindex
WHERE ar_actor =... |
4 years ago |
| USE enwikinews_p;
SELECT count(*), *
FROM archive_userindex
WHERE ar_actor =... |
4 years ago |
| USE enwikinews_p;
SELECT *
FROM archive_userindex
WHERE ar_actor =... |
4 years ago |
| USE enwikinews_p;
SELECT *
FROM archive_userindex
LIMIT 10;
SELECT *
FROM... |
4 years ago |
| USE enwikinews_p;
SELECT *
FROM archive_userindex
LIMIT 10;
/*
USE... |
4 years ago |
| SELECT *
FROM page JOIN redirect ON rd_from = page_id
WHERE page_namespace =... |
4 years ago |
| SELECT *
FROM page JOIN redirect ON rd_from = page_id
WHERE page_namespace =... |
4 years ago |
| SELECT *
FROM page JOIN redirect ON rd_from = page_id
WHERE page_namespace =... |
4 years ago |
| SELECT *
FROM page JOIN redirect ON rd_from = page_id
WHERE page_namespace =... |
4 years ago |
| SELECT *
FROM page JOIN redirect ON rd_from = page_id
WHERE page_namespace =... |
4 years ago |
| SELECT *
FROM page JOIN redirect ON rd_from = page_id
WHERE page_namespace =... |
4 years ago |
| SELECT *
FROM page JOIN redirect ON rd_from = page_id
WHERE page_namespace =... |
4 years ago |
| USE mediawikiwiki_p;
SELECT * FROM change_tag
WHERE ct_tag_id = 61
LIMIT... |
4 years ago |
| USE mediawikiwiki_p;
SELECT * FROM change_tag
WHERE ct_tag_id = 61
LIMIT... |
4 years ago |
| USE mediawikiwiki_p;
SELECT * FROM change_tag
LIMIT 100;
SELECT * FROM... |
4 years ago |
| USE mediawikiwiki_p;
SELECT * FROM change_tag
LIMIT 100;
/*
USE... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.page_title AS `Redirect from`, r.rd_title AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.page_title AS `Redirect from`, r.rd_title AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.page_id AS `Redirect from`, r.rd_title AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.page_id AS `Redirect from`, r.rd_title AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.page_id, r.rd_title #pg.*, r.*
FROM page... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.*, r.*
FROM page pg
JOIN redirect r ON... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.*
FROM page pg
WHERE page_is_redirect = 1
AND... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.*
FROM page pg
WHERE pg.page_namespace = 1
AND... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.*, r.*
FROM page pg
JOIN redirect r ON... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.*
FROM page pg
WHERE pg.page_namespace = 1
AND... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg.*
FROM page pg
WHERE pg.page_namespace =... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg1.*, pg2.*
FROM page pg1
JOIN page pg2 ON... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg1.*, pg2.*
FROM page pg1
JOIN page pg2 ON... |
4 years ago |
| USE wikidatawiki_p;
SELECT *#pg1.*, pg2.*
FROM page pg1
JOIN page pg2 ON... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg1.*, pg2.*
FROM page pg1
JOIN page pg2 ON... |
4 years ago |
| USE wikidatawiki_p;
SELECT pg1.*, pg2.*
FROM page pg1
JOIN page pg2 ON... |
4 years ago |
| SELECT pp.pp_value #pg.page_id, pl.*, pp.*
FROM pagelinks pl
JOIN page AS... |
4 years ago |
| SELECT pg.page_id, pl.*, pp.* FROM pagelinks pl
JOIN page AS pg
ON... |
4 years ago |
| SELECT pg.page_id, pl.*, pp.* FROM pagelinks pl
JOIN page AS pg
ON... |
4 years ago |
| SELECT pg.page_id, pl.* FROM pagelinks pl
JOIN page AS pg
ON page_title =... |
4 years ago |
| SELECT pg.page_id, pl.* FROM pagelinks pl
JOIN page AS pg
ON page_title =... |
4 years ago |
| SELECT * FROM pagelinks
JOIN page ON page_title = pl_title AND... |
4 years ago |
| SELECT * FROM pagelinks
WHERE pl_from = 39377526
LIMIT 100; |
4 years ago |
| SELECT rc.rc_namespace, rc.rc_title, rc.rc_comment_id, rc.rc_logid,... |
4 years ago |
| SELECT rc.rc_namespace, rc.rc_title, rc.rc_comment_id, rc.rc_logid,... |
4 years ago |
| SELECT rc.rc_namespace, rc.rc_title, rc.rc_comment_id, rc.rc_logid,... |
4 years ago |
| SELECT rc.rc_namespace, rc.rc_title, rc.rc_comment_id, rc.rc_logid,... |
4 years ago |
| SELECT rc.*, u.user_name, u.user_editcount, u.user_registration FROM... |
4 years ago |
| SELECT rc.*, u.* FROM recentchanges_userindex rc
JOIN actor AS a ON... |
4 years ago |
| SELECT rc.*, u.* FROM recentchanges_userindex rc
JOIN actor AS a ON... |
4 years ago |
| SELECT * FROM recentchanges_userindex rc
JOIN actor AS a ON rc.rc_actor =... |
4 years ago |
| SELECT * FROM recentchanges_userindex
JOIN actor ON rc_actor = actor_id
JOIN... |
4 years ago |
| SELECT * FROM recentchanges#_userindex
WHERE rc_type = 3
AND rc_log_type =... |
4 years ago |
| SELECT * FROM recentchanges#_userindex
WHERE rc_type = 3
AND rc_log_type =... |
4 years ago |
| SELECT * FROM recentchanges#_userindex
WHERE rc_type = 3
LIMIT 100 |
4 years ago |
| SELECT * FROM recentchanges_userindex
WHERE rc_type = 3
LIMIT 100 |
4 years ago |
| SELECT * FROM recentchanges_userindex
LIMIT 100 |
4 years ago |
| SELECT * FROM logging_userindex
WHERE log_type = 'move'
LIMIT 100 |
4 years ago |
| SELECT * FROM logging_logindex
WHERE log_type = 'move'
AND
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'move'
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
WHERE log_type = move
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
LIMIT 100 |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT ips.*,... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT ips.*,... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT ips.*,... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT ips.*,... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
#DESCRIBE wb_items_per_site;
SELECT * FROM... |
4 years ago |
| USE wikidatawiki_p;
#SHOW TABLES;
DESCRIBE wb_items_per_site; |
4 years ago |
| USE wikidatawiki_p;
SHOW TABLES; |
4 years ago |
| USE wikidatawiki_p;
SHOW tables; |
4 years ago |
| USE wikidatawiki_p;
LIST tables; |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
CONCAT('[[Talk:', pg1.page_title, ']]') AS... |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
CONCAT('[[Talk:', pg1.page_title, ']]') AS... |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
CONCAT('[[Talk:', pg1.page_title, ']]') AS... |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
CONCAT('[[Talk:', pg1.page_title, ']]') AS... |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
DISTINCT (CONCAT('[[Talk:',... |
4 years ago |
| SELECT
DISTINCT cat1.cl_from,
DISTINCT CONCAT('[[Talk:', pg1.page_title,... |
4 years ago |
| SELECT cat_title, cat_pages, cat_subcats FROM category
WHERE cat_title LIKE... |
4 years ago |
| SELECT cat_title, cat_pages, cat_subcats FROM category
WHERE cat_title LIKE... |
4 years ago |
| SELECT cat_title, cat_pages, cat_subcats FROM category
WHERE cat_title LIKE... |
4 years ago |
| SELECT cat_title, cat_pages, cat_subcats FROM category
WHERE cat_title LIKE... |
4 years ago |
| SELECT cat_title, cat_pages, cat_subcats FROM category
WHERE cat_title LIKE... |
4 years ago |
| SELECT * FROM category
WHERE cat_title LIKE 'Unassessed_%_articles'
LIMIT 10 |
4 years ago |
| SELECT * FROM category
LIMIT 10 |
4 years ago |
| SELECT user_groups.*, user.user_name FROM user_groups
LEFT JOIN user ON... |
4 years ago |
| SELECT *, user.user_name FROM user_groups
LEFT JOIN user ON user_id =... |
4 years ago |
| SELECT * FROM user_groups
LEFT JOIN user ON user_id = ug_user
WHERE... |
4 years ago |
| SELECT * FROM sites
WHERE site_global_key LIKE 'co%'
LIMIT 10 |
4 years ago |
| SELECT * FROM sites
WHERE site_global_key LIKE 'c%'
LIMIT 10 |
4 years ago |
| SELECT * FROM sites
LIMIT 10 |
4 years ago |
| SELECT * FROM page_props
WHERE pp_propname = 'expectunusedcategory'
LIMIT 10 |
4 years ago |
| SELECT * FROM page_props
WHERE pp_page = 7851067
LIMIT 10 |
4 years ago |
| SELECT * FROM page_props
WHERE pp_propname = 'EXPECTUNUSEDCATEGORY'
LIMIT 10 |
4 years ago |
| SELECT * FROM image
WHERE img_name LIKE '%.Png' |
4 years ago |
