| USE enwiki_p;
SELECT /*+ MAX_EXECUTION_TIME(10000) */
COUNT(*),
... |
6 years ago |
| USE enwiki_p;
SELECT
COUNT(*),
TRIM(LEADING 'www.' FROM... |
6 years ago |
| USE enwiki_p;
SELECT
SUBSTRING(el_to FROM 1 FOR 60) AS index_prefix,
... |
6 years ago |
| USE enwiki_p;
SELECT
SUBSTRING(el_index FROM 1 FOR 60) AS index_prefix,
... |
6 years ago |
| USE euwiki_p;
SELECT el_index, el_index LIKE 'htTp://%' FROM (SELECT... |
6 years ago |
| USE euwiki_p;
SELECT el_index, CONVERT(el_index USING utf8) LIKE 'htTp://%'... |
6 years ago |
| USE euwiki_p;
SELECT el_index, CONVERT(el_index USING utf8) LIKE 'http://%'... |
6 years ago |
| USE euwiki_p;
SELECT el_index, el_index LIKE 'HTtp://%' FROM (SELECT... |
6 years ago |
| USE euwiki_p;
SELECT el_index, el_index LIKE 'HTtp://%' FROM (SELECT... |
6 years ago |
| USE euwiki_p;
SHOW INDEX FROM enwiki_p.externallinks; |
6 years ago |
| USE euwiki_p;
SHOW INDEX FROM externallinks; |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
main_domain,
... |
6 years ago |
| USE euwiki_p;
SELECT
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING(el_index... |
6 years ago |
| USE euwiki_p;
SELECT
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING(el_index... |
6 years ago |
| USE euwiki_p;
SELECT
REGEXP_REPLACE(SUBSTRING(el_index FROM 1 FOR 60),... |
6 years ago |
| USE euwiki_p;
SELECT
REGEXP_REPLACE(SUBSTRING(el_index FROM 1 FOR 60),... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
tld,
COUNT(DISTINCT... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
tld,
COUNT(DISTINCT... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
tld,
COUNT(DISTINCT... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
tld,
COUNT(DISTINCT... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
tld,
COUNT(DISTINCT... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
tld,
COUNT(DISTINCT... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
tld,
COUNT(DISTINCT... |
6 years ago |
| USE euwiki_p;
SELECT *
FROM (
SELECT
tld,
COUNT(DISTINCT... |
6 years ago |
| USE euwiki_p;
SELECT el_to, el_from, el_index FROM externallinks WHERE el_to... |
6 years ago |
| USE euwiki_p;
SELECT el_to, el_from, el_index FROM externallinks WHERE el_to... |
6 years ago |
| USE euwiki_p;
SELECT el_to, el_from, el_index FROM externallinks WHERE... |
6 years ago |
| USE euwiki_p;
SELECT el_to, el_from FROM externallinks WHERE el_to LIKE... |
6 years ago |
| USE euwiki_p;
SELECT el_to, el_from FROM externallinks LIMIT 100; |
6 years ago |
| USE euwiki_p;
SELECT el_index FROM externallinks LIMIT 100; |
6 years ago |
| USE euwiki_p;
SELECT el_index FROM externallinks WHERE el_index REGEXP '^//'... |
6 years ago |
| USE enwiki_p;
SELECT el_index FROM externallinks WHERE el_index REGEXP '^//'... |
6 years ago |
| USE enwiki_p;
SELECT el_index FROM externallinks WHERE el_index REGEXP... |
6 years ago |
| USE enwiki_p;
SELECT el_index FROM externallinks LIMIT 100; |
6 years ago |
| USE enwiki_p;
SELECT 'Ab' < 'Abc'; |
6 years ago |
| USE enwiki_p;
SELECT 'Ab' < 'Ac'; |
6 years ago |
| USE enwiki_p;
SELECT 'Ab' > 'Ac'; |
6 years ago |
| USE enwiki_p;
-- Extract all (page_id, domain) tuples.
... |
6 years ago |
