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