USE commonswiki_p;

SELECT  COUNT(*) AS 'Edit count' FROM page

        INNER JOIN revision ON page_id=rev_page

        INNER JOIN ip_changes ON rev_id=ipc_rev_id

    WHERE page_namespace=1198

#       AND page_title REGEXP 'Commons:Wiki_Loves_Folklore/(?:[0-9]+|Page_display_title)/' # main page

        AND page_title REGEXP 'Commons:Wiki_Loves_Folklore(?:/(?:Rules|FAQ|International_Team|Organize_Local_Events|Categories|Contact_us))/(?:[0-9]+|Page_display_title)/' # all pages except main

​