Support Forum

Okay...I used PROCESSLIST to capture the query, and ran it in phpMyAdmin with no errors. Though I'm not certain about that "unique column" warning.

 

SELECT SQL_CALC_FOUND_ROWS DISTINCT
 wp_1_sfmembers.user_id, display_name,
 (SELECT GROUP_CONCAT(item_id) FROM wp_1_sfuseractivity WHERE type_id=6 AND wp_1_sfuseractivity.user_id=wp_1_sfmembers.user_id) AS topics
 FROM wp_1_sfmembers
 JOIN wp_1_sfuseractivity ON wp_1_sfmembers.user_id = wp_1_sfuseractivity.user_id WHERE item_id IS NOT NULL AND type_id = 6 ORDER BY wp_1_sfmembers.user_id DESC LIMIT 0, 20

I also presume it's only returning 20 results, since that is the number of entries listed on the admin page. We surely have many more users who have subscribed to topics.

This shed any light on my mystery?

Thanks for this @mr-papa .

That will come in handy if/when I actually need to review user subs.

At this point I'm much more concerned about what may be causing the site to load inside the admin pane, and what other havoc that may be causing.

For whatever reason, I am now seeing the query, and the form loads properly when I add this:

vshow($query);
 return '';

The query, however, returns no results when searching for a username that has known subscriptions as shown of the Topic Subscriptions tab.

My guess is something odd still going on with that query. Any thoughts on how I might troubleshoot that are appreciated. Web console revealed nothing.