On Fri, 15 Nov 2019 at 12:54:06 +0100, William Gathoye wrote:
> As another request, would it be possible to give me the number of
> articles we have published on each WordPress sub-instance we have?
‘SELECT COUNT(*) FROM ${PREFIX}_posts WHERE post_type = 'post' AND
post_status = 'publish';’ gives
blog.documentfoundation.org 1044
design.blog.documentfoundation.org 73
pt-br.blog.documentfoundation.org 243
vi.blog.documentfoundation.org 3
roadshow.blog.documentfoundation.org 0
es.blog.documentfoundation.org 164
de.blog.documentfoundation.org 28
qa.blog.documentfoundation.org 29
ja.blog.documentfoundation.org 19
fr.blog.documentfoundation.org 5
--
Guilhem.
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/website/
Privacy Policy: https://www.documentfoundation.org/privacy
