Untitled query #88016

SQL

SELECT COUNT(*) AS element_count
FROM (
    SELECT ips.ips_item_id
    FROM wb_items_per_site ips
    WHERE ips.ips_site_id LIKE '%wiki'
    GROUP BY ips.ips_item_id
    HAVING 
        (SELECT COUNT(*) 
         FROM wb_items_per_site ips_bis 
         WHERE ips_bis.ips_site_id = "ruwiki" 
           AND ips_bis.ips_item_id = ips.ips_item_id 
           AND ips_bis.ips_site_page NOT REGEXP '^(Категория|Шаблон|Модуль|MediaWiki|Справка|Портал|Википедия)') < 1
        AND 
        (SELECT COUNT(*) 
         FROM wb_items_per_site ips_bis 
         WHERE ips_bis.ips_site_id = "ukwiki" 
           AND ips_bis.ips_item_id = ips.ips_item_id) > 0
) AS filtered_elements;
SQL

Checking query status...
