AndrewTavis_WMDE added a comment.

  Accounting for namespaces 
<https://www.wikidata.org/wiki/Help:Namespaces#Table_of_Namespaces> brings us 
back up as we need `0` for main content, `120` for properties and `146` for 
lexemes.
  
  Current query:
  
    SELECT 
        COUNT(DISTINCT page_id) AS total_pages
    
    FROM 
        wmf_raw.mediawiki_page
        
    WHERE 
        wiki_db = 'wikidatawiki'
        -- wikibase-item, wikibase-property, wikibase-lexeme
        AND page_content_model LIKE 'wikibase%'
        AND (
            page_namespace = 0
            OR page_namespace = 120 
            OR page_namespace = 146
        )
        AND page_is_redirect = false
  
  Current value: `104,702,674`

TASK DETAIL
  https://phabricator.wikimedia.org/T337245

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: AndrewTavis_WMDE
Cc: Lydia_Pintscher, Aklapper, Manuel, AndrewTavis_WMDE, Astuthiodit_1, 
karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

Reply via email to