Wikimedia Sverige technology pool image usage

SQL

USE commonswiki_p;
SELECT /* SLOW_OK */
                COUNT(page.page_title) AS total_usage,
                COUNT(DISTINCT CONCAT(gil.gil_wiki, gil.gil_page)) AS different_pages,
                COUNT(DISTINCT page.page_title) AS images_used,
                COUNT(DISTINCT gil.gil_wiki) AS different_projects
            FROM image
            CROSS JOIN page ON image.img_name = page.page_title
            CROSS JOIN categorylinks ON page.page_id = categorylinks.cl_from
            CROSS JOIN globalimagelinks gil ON gil.gil_to = image.img_name
            WHERE
                categorylinks.cl_to = "Media_created_by_technology_pool_of_Wikimedia_Sverige"
                AND img_timestamp > '20150101000001'
                AND img_timestamp < '20150630235959'
                AND gil.gil_page_namespace_id = 0
SQL

Checking query status...
