Number total of articles per author

[Von Barron]

Hi all,
In the list of the authors of my site, I want to display the number total of articles for every author.
What would be the code for this, please?
Thx in advance

[Per Yngve Berg]

Code: Select all

select count() from #_content where author=<uid>

[Von Barron]

Thank you!
I'm supposed to copy/paste your code where I want to display the result, right?

[ceford]

Do you have a component to display a list of Authors? If so you would use a subquery to count the number of articles for each author.

[nacc]

Why not write a module that displays a list of authors and the count of articles they've written? Then you can display the module anywhere on the website that you like (and modules don't normally occupy a lot of screen real-estate). J! can only load one component on a page view whereas, with a module, you can display those things [more-or-less] anywhere you want; you can even embed a module within an article ... if you want.

[Von Barron]

To display the list of authors, I use a menu item Contacts > List of contacts in a category.

[ceford]

To elaborate on the previous replies, the query you need is something like this:

Code: Select all

SELECT a.id , (SELECT count(id) FROM `#__content` WHERE `created_by` = a.id) AS narticles FROM `#__users` AS a; 

[Von Barron]

Thank you!

[nacc]

@Von Barron: There is a module on the JED that does what you want.