frwiki: weblinks

SQL

USE frwiki_p;

SELECT COUNT(*) AS cnt_http_club FROM externallinks WHERE el_index LIKE 'http://fr.lemonde.%';
SELECT COUNT(*) AS cnt_https_club FROM externallinks WHERE el_index LIKE 'https://fr.lemonde.%';
SELECT COUNT(*) AS cnt_http_space FROM externallinks WHERE el_index LIKE 'http://fr.lefigaro.%';
SELECT COUNT(*) AS cnt_https_space FROM externallinks WHERE el_index LIKE 'https://fr.lefigaro.%';
SELECT COUNT(*) AS cnt_http_website FROM externallinks WHERE el_index LIKE 'http://fr.liberation.%';
SELECT COUNT(*) AS cnt_https_website FROM externallinks WHERE el_index LIKE 'https://fr.liberation.%';

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

Checking query status...
