| USE enwiki_p;
SELECT
'en' as 'lang',
t.page_id AS 'Page ID',
r2.rev_id AS... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.page_id AS 'Page ID',
r2.rev_id AS... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.page_id AS 'Page ID',
t.rev_id AS... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.page_id AS 'Page ID',
t.rev_id AS... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.page_id AS 'Page ID',
r.rev_id AS... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.page_id AS 'Page ID',
r2.rev_id AS... |
7 years ago |
| USE enwiki_p;
SELECT
t.*,r.*
FROM (
SELECT COUNT(*) AS cnt,
... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.*
FROM (
use orwiki_p;
... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.*
FROM (
SELECT COUNT(*) AS... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.*, r2.*
FROM (
SELECT COUNT(*)... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.*, r2.*,r1.*
FROM (
SELECT... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang',
t.*
FROM (
SELECT COUNT(*) AS... |
7 years ago |
| blank query |
7 years ago |
| USE enwiki_p;
SELECT
*
FROM (
SELECT COUNT(*) AS cnt,... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang', *
FROM (
SELECT COUNT(*) AS cnt,... |
7 years ago |
| USE enwiki_p;
SELECT
'en' as 'lang', *
FROM (
SELECT COUNT(*) AS cnt,... |
7 years ago |
| USE enwiki_p;
SELECT *
WHERE cl_to =... |
7 years ago |
| blank query |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
JOIN categorylinks
ON cl_from =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
JOIN categorylinks
ON cl_from =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
WHERE page_namespace = 14 AND page_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
WHERE page_namespace = 14 AND page_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
WHERE page_namespace = 14 AND page_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
WHERE page_namespace = 14 AND page_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
WHERE page_namespace = 14 AND page_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
WHERE page_namespace = 14 AND page_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM page
WHERE page_namespace = 14 and page_title =... |
7 years ago |
| use mlwiki_p;
SELECT
*
FROM page
WHERE page_namespace = 14;
|
7 years ago |
| use mlwiki_p;
SELECT
*
FROM page
WHERE page_namespace = 10;
|
7 years ago |
| use mlwiki_p;
SELECT
*
FROM pages
WHERE page_namespace = 10;
|
7 years ago |
| use mlwiki_p;
SELECT *
FROM categorylinks
WHERE cl_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM categorylinks
WHERE cat_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM category
WHERE cat_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM category
WHERE
cat_title =... |
7 years ago |
| use mlwiki_p;
SELECT *
FROM category
WHERE
rev_timestamp >= "20160701"; |
7 years ago |
| use mlwiki_p;
SELECT *
FROM catalogs
WHERE
rev_timestamp >= "20160701"; |
7 years ago |
| use mlwiki_p;
SELECT *
FROM catalog
WHERE
rev_timestamp >= "20160701"; |
7 years ago |
| use mlwiki_p;
SELECT *
FROM revision
WHERE
rev_timestamp >= "20160701"; |
7 years ago |
| use mlwiki_p;
SELECT *
FROM revision_userindex
WHERE
rev_timestamp >=... |
7 years ago |
| use mlwiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
7 years ago |
| use mlwiki_p;
Describe revision;
Describe revision_userindex; |
7 years ago |
| use mlwiki_p;
Describe category;
Describe categorylinks ; |
7 years ago |
| use mlwiki_p;
SELECT DISTINCT
pages,
rev_user_text,
... |
7 years ago |
| use mlwiki_p;
SELECT DISTINCT
rev_user_text,
user_editcount
FROM... |
7 years ago |
| use mlwiki_p;
SELECT DISTINCT
rev_user_text,
user_editcount
FROM... |
7 years ago |
| use mlwiki_p;
SELECT DISTINCT
rev_user_text,
user_editcount
FROM... |
7 years ago |
| use mlwiki_p;
SELECT DISTINCT
rev_user_text,
user_editcount
FROM... |
7 years ago |
| SELECT DISTINCT
rev_user_text,
user_editcount
FROM revision
LEFT JOIN... |
7 years ago |
