| select * from categorylinks
left join page on (page.page_id =... |
2 years ago |
| select page_title from categorylinks
left join page on (page.page_id =... |
2 years ago |
| SELECT * FROM content LIMIT 5 |
2 years ago |
| SELECT * FROM content LIMIT 50 |
2 years ago |
| SHOW TABLES |
2 years ago |
| SELECT * FROM text LIMIT 50 |
2 years ago |
| SELECT * FROM text LIMIT 50 |
2 years ago |
| SELECT * FROM text LIMIT 50 |
2 years ago |
| SELECT * FROM comment LIMIT 50 |
2 years ago |
| SELECT * FROM comment LIMIT 5 |
2 years ago |
| SELECT * FROM comment |
2 years ago |
| SELECT * FROM revision
JOIN page ON page_id = revision.rev_page
LIMIT 5; |
2 years ago |
| SELECT * FROM revision
JOIN page ON page_id = revision.rev_page
AND dbname =... |
2 years ago |
| SELECT * FROM revision
JOIN page ON page_id = revision.rev_page
JOIN... |
2 years ago |
| select rev_comment from revision limit 10; |
2 years ago |
| select rev_comment from revision limit 10; |
2 years ago |
| select rev_comment from revision limit 10; |
2 years ago |
| select rev_comment from revision limit 10; |
2 years ago |
| select rev_comment from revision limit 10; |
2 years ago |
| select rev_comment from revision limit 10; |
2 years ago |
| select rev_user_text from revision limit 10; |
2 years ago |
| select rev_user_text from revision limit 10; |
2 years ago |
| select rev_user_text from revision limit 10; select rev_comment from... |
2 years ago |
| SELECT * FROM revision
JOIN page ON page_id = revision.rev_page
JOIN... |
2 years ago |
| SELECT * FROM revision
JOIN page ON page_id = revision.rev_page
AND dbname =... |
2 years ago |
| SELECT * FROM revision
JOIN page ON pg.page_id = revision.rev_page
AND... |
2 years ago |
| SELECT * FROM page AS pg
JOIN revision ON pg.page_id = revision.rev_page
AND... |
2 years ago |
| SELECT * FROM page AS pg, revision
JOIN revision ON pg.page_id =... |
2 years ago |
| SELECT * FROM page AS pg, revision
JOIN page ON pg.page_id =... |
2 years ago |
| SELECT * FROM page AS pg, revision
JOIN page ON pg.page_id =... |
2 years ago |
| SELECT * FROM page AS pg, revision
JOIN page ON pg.page_id =... |
2 years ago |
| SELECT * FROM page AS pg, revision
JOIN page ON pg.page_id = rev_page
AND... |
2 years ago |
| SELECT * FROM page AS pg
JOIN page ON pg.page_id = rev_page
AND dbname =... |
2 years ago |
| SELECT * FROM page AS pg
-- JOIN page ON pg.page_id = pg.rev_page
AND dbname... |
2 years ago |
| SELECT * FROM page AS pg
-- JOIN page ON pg.page_id = pg.rev_page
-- AND... |
2 years ago |
| SELECT * FROM page AS pg
JOIN page ON pg.page_id = pg.rev_page
AND dbname =... |
2 years ago |
| SELECT * FROM page AS pg
JOIN page ON pg.page_id = rev_page
AND dbname =... |
2 years ago |
| SELECT * FROM page
JOIN page AS pg ON page_id = rev_page
AND dbname =... |
2 years ago |
| SELECT * FROM page
JOIN page AS pg ON page_id = rev_page
AND dbname =... |
2 years ago |
| SELECT * FROM page AS pg
JOIN page ON page_id = rev_page
AND dbname =... |
2 years ago |
| SELECT * FROM page
JOIN page ON page_id = rev_page
AND dbname = 'enwiki_p'
LIMIT 5; |
2 years ago |
| SELECT * FROM page
JOIN page ON page_id = rev_page
JOIN toolserver.namespace... |
2 years ago |
| SELECT * FROM page LIMIT 5; |
2 years ago |
| SHOW DATABASES LIKE 'a%'; |
2 years ago |
| SHOW DATABASES LIKE 'ab%'; |
2 years ago |
| STATUS |
2 years ago |
| SELECT DATABASE() FROM DUAL; |
2 years ago |
| SELECT * FROM category WHERE dbname=abwiki_p LIMIT 5; |
2 years ago |
| SELECT * FROM category LIMIT 5; |
2 years ago |
| SELECT * FROM text LIMIT 5; |
2 years ago |
| SELECT * FROM category LIMIT 5; |
2 years ago |
| SELECT * FROM category LIMIT 500; |
2 years ago |
| SELECT * FROM category LIMIT 5; |
2 years ago |
| SELECT * FROM content_models LIMIT 5; |
2 years ago |
| SELECT * FROM content LIMIT 5; |
2 years ago |
| SELECT * FROM page LIMIT 5; |
2 years ago |
| SELECT * FROM toolserver.namespace LIMIT 5; |
2 years ago |
| SELECT * FROM toolserver.namespace LIMIT 5; |
2 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
2 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
2 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
2 years ago |
| SELECT
DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
... |
2 years ago |
| SELECT
CONCAT(ns_name, ':', page_title),
page_len
FROM page
JOIN... |
2 years ago |
| SELECT
CONCAT(ns_name, ':', page_title),
page_len
FROM page
JOIN... |
2 years ago |
| SELECT
CONCAT(ns_name, ':', page_title),
page_len
FROM page
JOIN... |
2 years ago |
| SELECT
ns_name,
page_title,
page_len
FROM page
JOIN... |
2 years ago |
| SELECT
ns_name,
page_title,
page_len
FROM page
JOIN... |
2 years ago |
| SELECT
ns_name,
page_title,
page_len
FROM page
JOIN... |
2 years ago |
| SELECT
ns_name,
page_title,
page_len
FROM page
JOIN... |
2 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title
FROM page
JOIN pagelinks
ON pl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title, cl_from, cl_to
FROM page
JOIN templatelinks
ON tl_from... |
2 years ago |
| SELECT
*, cl_from, cl_to
FROM page
JOIN templatelinks
ON tl_from =... |
2 years ago |
| SELECT
*, cl_from, cl_to
FROM page
JOIN templatelinks
ON tl_from =... |
2 years ago |
| SELECT
*, cl_from, cl_to
FROM page
JOIN templatelinks
ON tl_from =... |
2 years ago |
| SELECT
*, cl_from, cl_to
FROM page
JOIN templatelinks
ON tl_from =... |
2 years ago |
| SELECT
page_title, cl_from, cl_to
FROM page
JOIN templatelinks
ON tl_from... |
2 years ago |
| SELECT
page_title, cl_from, cl_to
FROM page
JOIN templatelinks
ON tl_from... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from = page_id
JOIN... |
2 years ago |
| SELECT
page_title,
cat_pages,
cat_subcats
FROM page
JOIN categorylinks... |
2 years ago |
| SELECT DISTINCT
cl_to
FROM categorylinks AS cat
JOIN page AS pg1
ON... |
2 years ago |
| SELECT DISTINCT
cl_to
FROM categorylinks AS cat
JOIN page AS pg1
ON... |
2 years ago |
| SELECT
page_namespace,
ns_name,
page_title,
COUNT(*)
FROM... |
2 years ago |
| SELECT
DISTINCT(enwiki_p.page.page_title),
... |
2 years ago |
| SELECT
DISTINCT(enwiki_p.page.page_title),
... |
2 years ago |
| SELECT
DISTINCT(enwiki_p.page.page_title),
... |
2 years ago |
| SELECT
DISTINCT(enwiki_p.page.page_title),
... |
2 years ago |
| SELECT
DISTINCT(enwiki_p.page.page_title),
... |
2 years ago |
| SELECT
DISTINCT(enwiki_p.page.page_title),
... |
2 years ago |
| SELECT
actor_name,
log_namespace,
log_timestamp,
log_action,
... |
2 years ago |
| SELECT
actor_name,
log_namespace,
log_timestamp,
log_action,
... |
2 years ago |
| SELECT
rev_id,
page_title,
page_namespace,
rev_timestamp,
... |
2 years ago |
| SELECT
rev_id,
page_title,
page_namespace,
rev_timestamp,
... |
2 years ago |
| SELECT
rev_id,
page_title,
page_namespace,
rev_timestamp,
... |
2 years ago |
| SHOW TABLES FROM abwiki_p |
2 years ago |
| SHOW TABLES FROM abwiki |
2 years ago |
