enwiki: weblinks to TLDs space, website

Fork of dewiki: weblinks to TLDs club, space, website by MisterSynergy

This query is marked as a draft This query has been published by Lustiger seth.

see https://meta.wikimedia.org/wiki/Talk:Spam_blacklist#Thoughts_about_blacklisting_.club/_.space/_and_.website/

SQL

USE dewiki_p;

SELECT
	page_namespace,
    page_title,
    el_to
FROM
	externallinks
JOIN
	page
ON
	el_from=page_id
WHERE
	el_index LIKE 'http://club.%'
    OR el_index LIKE 'https://club.%'
ORDER BY el_index;

SELECT
	page_namespace,
    page_title,
    el_to
FROM
	externallinks
JOIN
	page
ON
	el_from=page_id
WHERE
    el_index LIKE 'http://space.%'
    OR el_index LIKE 'https://space.%';

SELECT
	page_namespace,
    page_title,
    el_to
FROM
	externallinks
JOIN
	page
ON
	el_from=page_id
WHERE
    el_index LIKE 'http://website.%'
    OR el_index LIKE 'https://website.%';

SQL

Checking query status...