Percent of bot edits in previous month in articles on plwiki

SQL

USE plwiki_p;
SELECT CONCAT('# [[', page_title ,']]') AS page_title
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND (el_to LIKE 'http://www.fis-ski.com/de/%' OR el_to LIKE 'http://www.fis-ski.com/uk/%' OR el_to LIKE 'http://www.fis-ski.com/fr/%')
GROUP BY page_title
ORDER BY page_title;
SELECT CONCAT('#', el_to ) AS el_to#, COUNT(*) AS counting
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND (el_to LIKE 'http://www.fis-ski.com/de/%' OR el_to LIKE 'http://www.fis-ski.com/uk/%' OR el_to LIKE 'http://www.fis-ski.com/fr/%')
GROUP BY el_to
ORDER BY /*counting DESC,*/ el_to;

SQL

Checking query status...