Untitled query #85006

SQL

SELECT COUNT(*) AS c, page_title AS title, page_len FROM imagelinks
JOIN page ON il_from = page_id
JOIN categorylinks il_from = cl_from
WHERE il_from_namespace = 0 AND page_len <= 30000
AND LOWER(cl_to) NOT LIKE "%платформ%"
AND LOWER(cl_to) NOT LIKE "%станци%"
AND LOWER(cl_to) NOT LIKE "%железн%"
AND LOWER(cl_to) NOT LIKE "%остановочн%"
AND LOWER(cl_to) NOT LIKE "%поезд%"
AND LOWER(cl_to) NOT LIKE "%осьановк%"
GROUP BY title
ORDER BY c DESC
LIMIT 100;
SQL

Checking query status...
