Query Run
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