SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, iwl_prefix, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, iwl_prefix, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, iwl_prefix, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, iwl_prefix, page_is_redirect FROM plwiki_p.page LEFT JOIN... |
7 years ago |
SELECT page_title, iwl_prefix FROM plwiki_p.page LEFT JOIN plwiki_p.iwlinks... |
7 years ago |
SELECT page_title, iwl_prefix FROM plwiki_p.page LEFT JOIN plwiki_p.iwlinks... |
7 years ago |
SELECT page_title iwl_prefix FROM plwiki_p.page LEFT JOIN plwiki_p.iwlinks... |
7 years ago |
SELECT page_title iwl_prefix FROM plwiki_p.page JOIN LEFT plwiki_p.iwlinks... |
7 years ago |
SELECT page_title FROM plwiki_p.page WHERE
page_namespace = 0... |
7 years ago |
SELECT page_title FROM plwiki_p.page WHERE
page_namespace = 0... |
7 years ago |
SELECT
page_title
FROM
plwikisource_p.page
WHERE
page_namespace = 104
LIMIT 10; |
7 years ago |
SELECT
page_title
FROM
plwikisource_p.page
WHERE
page_namespace = 100
LIMIT 10; |
7 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like '%:%'
LIMIT 1000; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like '%:_%'
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like '%:[_]%'
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like '%_:%'
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like... |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like '%[e]:%'
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like '%:%'
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like... |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like... |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like... |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like '%:%'
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
WHERE
page_title Like '%:%
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
page
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
pages
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
pages
WHERE
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
flaggedrevs
WHERE
fr_page_id>486080
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
flaggedrevs
WHERE
fr_page_id=486088
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
flaggedrevs
LIMIT 100; |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
flaggedpages
WHERE
... |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
flaggedpages
WHERE
... |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
flaggedpages
WHERE
... |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
flaggedpages
WHERE
... |
8 years ago |
use plwikisource_p;
SELECT
*
FROM
flaggedpages
LIMIT 700; |
8 years ago |