dewiki: weblinks to TLDs club, space, website

SQL

USE dewiki_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.%';

SQL

Checking query status...