kowiki: weblinks to TLDs club, space, website

SQL

USE kowiki_p;

SELECT COUNT(*) AS cnt_http_club FROM externallinks WHERE el_index LIKE 'http://club.%';
SELECT COUNT(*) AS cnt_https_club FROM externallinks WHERE el_index LIKE 'https://club.%';
SELECT COUNT(*) AS cnt_http_space FROM externallinks WHERE el_index LIKE 'http://space.%';
SELECT COUNT(*) AS cnt_https_space FROM externallinks WHERE el_index LIKE 'https://space.%';
SELECT COUNT(*) AS cnt_http_website FROM externallinks WHERE el_index LIKE 'http://website.%';
SELECT COUNT(*) AS cnt_https_website FROM externallinks WHERE el_index LIKE 'https://website.%';

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.%'
    OR el_index LIKE 'http://space.%'
    OR el_index LIKE 'https://space.%'
    OR el_index LIKE 'http://website.%'
    OR el_index LIKE 'https://website.%';
SQL

Checking query status...
