USE enwiki_p; SET @language = 'en';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p; SET @language = 'en';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p; SET @language = 'en';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p; SET @language = 'eb';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p; SET @language = 'eb';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p; SET @language = 'eb';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p; SET @language = 'eb';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p;
SET @language = 'en';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p;
SET @language = 'en';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p;
SET @language = 'en';
SELECT
CONCAT('https://', @language ,... |
4 years ago |
USE enwiki_p;
SET @language = 'en';
SELECT CONCAT('https://', @language... |
4 years ago |
USE enwiki_p;
SET @language = 'en';
SELECT CONCAT('https://', @language... |
4 years ago |
USE enwiki_p;
SET @language = 'en';
SELECT CONCAT('https://', @language... |
4 years ago |
USE enwiki_p;
SET @language = 'en';
SELECT CONCAT('https://', @language... |
4 years ago |
# goal: find examples like "[http://example.com/page foo] on... |
4 years ago |
USE barwiki_p;
SET @language = 'bar';
SELECT CONCAT('https://', @language... |
4 years ago |
USE barwiki_p;
SET @language = 'bar';
SELECT CONCAT('https://',... |
4 years ago |
USE barwiki_p;
SET language = 'bar';
SELECT CONCAT('https://',... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) ) AS... |
4 years ago |
USE barwiki_p;
SELECT LOWER('Aachen');
SELECT... |
4 years ago |
USE barwiki_p;
SELECT LOWER('Aachen');
SELECT... |
4 years ago |
USE barwiki_p;
SELECT LOWER('Aachen');
SELECT... |
4 years ago |
USE barwiki_p;
SELECT LOWER('Aachen');
SELECT LOWER(REPLACE(page_title, '_',... |
4 years ago |
USE barwiki_p;
SELECT LOWER('Aachen');
SELECT LOWER(REPLACE(page_title),... |
4 years ago |
USE barwiki_p;
SELECT LOWER('Aachen');
SELECT REPLACE(LOWER(page_title),... |
4 years ago |
USE barwiki_p;
SELECT LOWER('Aachen');
SELECT REPLACE(page_title, '_', ''),... |
4 years ago |
USE barwiki_p;
SELECT LOWER('Aachen');
SELECT LOWER(page_title), page_title,... |
4 years ago |
USE barwiki_p;
SELECT LOWER(page_title), page_title, rooturl,
SUM(IF(... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) ) AS... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) ) AS... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) ) AS... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) ) AS... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) ) AS... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) ) AS... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) ) AS... |
4 years ago |
USE barwiki_p;
SELECT page_title, rooturl,
SUM(IF( url=rooturl, 1, 0) AS... |
4 years ago |
USE barwiki_p;
SELECT
page_id,
page_title,
el_to AS url,
... |
4 years ago |
USE barwiki_p;
SELECT
page_id,
page_title,
el_to AS url,
... |
4 years ago |
USE barwiki_p;
SELECT
page_id,
page_title,
el_to AS url,
... |
4 years ago |