find external links which consist of string "quarry.wmflabs"

Fork of erraneous external links, specific to etwiki by Estopedist1

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

SQL

use enwiki_p;
SELECT page_title, el_to, page_namespace
FROM externallinks
INNER JOIN page ON page_id=el_from 
where el_to like "%quarry.wmflabs%"
AND page_title NOT LIKE "%Andmepäringud%"
/*and el_to not like "https://%" and el_to not like "%commons.wikimedia.org/wiki/Category%"
	and el_to not like "//web.archive.org/%" and el_to not like "//tools.wmflabs.org/geohack/%" 
    and el_to not like "//www.ncbi.nlm.nih.gov%" and el_to not like "//www.worldcat.org/oclc%"
    and el_to not like "//www.jstor.org/stable/%" */
GROUP BY page_title
LIMIT 300;

SQL

Checking query status...