Tag Filtering (No Tag assigned)

[R_Rabbit10]

I have about 5000 articles on my Joomla site with an unknown number of articles without a TAG.
I need to assign TAGS to those articles.
Is there an easy way from the Administrator back-end Content->Articles to filter just those articles that do not have a TAG?
"Filter Options -> Tag" does not have a "No Tag"/"Empty" option, so does not work. There is also no option available to display a "Tag" column in the article overview screen.

[imanickam]

One way would be to execute the following SQL in tools like phpMyAdmin.

Code: Select all

SELECT `id`,`title` FROM `xyz_content` WHERE `id` NOT IN (SELECT DISTINCT (`content_item_id`) FROM `xyz_contentitem_tag_map` WHERE `type_id` = 1) ORDER BY `id`;

Note:
Substitute xyz with the database/table prefix of your joomla installation/site

[R_Rabbit10]

One way would be to execute the following SQL in tools like phpMyAdmin.

Code: Select all

SELECT `id`,`title` FROM `xyz_content` WHERE `id` NOT IN (SELECT DISTINCT (`content_item_id`) FROM `xyz_contentitem_tag_map` WHERE `type_id` = 1) ORDER BY `id`;

Note:
Substitute xyz with the database/table prefix of your joomla installation/site

Thank you.