SELECT COUNT(IF (log_id IS NULL, 1, NULL)) AS '# created before creation log', COUNT(*) AS 'total'

FROM page

LEFT JOIN templatelinks

    ON tl_namespace=10 AND tl_title=page_title

LEFT JOIN logging_logindex

    ON log_type='create' AND log_namespace=10 AND log_title=page_title

WHERE page_namespace=10

    AND tl_from IS NULL

    AND page_is_redirect=0

    AND page_title NOT LIKE '%/sandbox'

    AND page_title NOT LIKE '%/testcases'

    AND page_title NOT LIKE '%/doc';