joomla/joomla-cms — pull request #3786 by Harmageddon (2014-06-15 16:15:48+00:00)
Title: Only show published content in mod_tags_popular

The "Popular Tags" module shows tags from all articles, regardless of their respective publishing status. If you have an article that is not published yet tagged with "Tag1", this tag shows in "Popular Tags" with 1 article, but if you click on the link for the article list, no article is shown.
### Testing instructions:
1. Create a mod_tags_popular module (optionally: enable "Display number of items")
2. Create a taggable item (e.g. an article) and tag it.
3. Set the item's status to "unpublished".
* Look at the module's output in frontend.
4. Set the item to published, but with a future publish date.
* Look at the module's output in frontend.
5. Set the item to published, but with a past de-publish date.
* Look at the module's output in frontend.
6. Apply the patch and repeat steps 3-5.

Please be aware that there are more taggable item types than just articles. I tested it with articles and contacts without any problems. And please have a short look at the SQL query, too, to ensure, that everything is correct here. Thanks!