Kunena 6.3.0 released

The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3

Topics must relate to a currently supported version of Kunena. If you are unsure what is the current supported version of Kunena, please go to the download page.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Question See which users are subscribed to which category

More
5 years 3 months ago #1 by jderrick
See which users are subscribed to which category was created by jderrick
Hello,

Just did a google to see if there is a way to see which users are subscribed to which category. There didn't seem to be an answer and I couldn't reply to any of the old posts asking them same question, so I thought I'd leave an answer here to help anyone else wondering the same thing.

Run the following SQL query (replacing #__ with your own prefix) and bingo...

SELECT u.id, u.username, c.name FROM #__users as u
JOIN #__kunena_user_categories as uc
ON u.id = uc.user_id AND subscribed = 1
JOIN #__kunena_categories as c
ON uc.category_id = c.id

Please Log in or Create an account to join the conversation.

Time to create page: 0.509 seconds