There’s a different posts and comments table per site, so not really.
That said, you can and should keep track of blog ids they’ve commented on in a user meta to speed things up in the first round, and cache the formatted result in a separate usermeta to speed things up in subsequent rounds. These are easy enough to be tracked and invalidate on save/delete post/comment.
Related Posts:
- Resetting comment count
- Would switching to InnoDB from MyISAM improve performance of comments table?
- How to create a foreign key in phpmyadmin
- How get value from URL
- How to return number of found rows from SELECT query
- comment_post_ID 0 (cannot remove from dashboard)
- What for is the table “wp_commentmeta” exactly?
- How to properly insert data into custom table via plugin
- How to load and show comments with AJAX instead of pagination?
- Check if post of title already exists
- $wpdb->delete column values IN ARRAY()?
- How do I set up real anonymous posting in bbpress forums? [closed]
- How To Make Connection To WordPress Data Base In A Plugin?
- Can I store my custom comment_type into wp_comments table?
- Changing user_nicename
- Does WordPress cache get_user_meta() results?
- Using Disqus, how to stop storing comments in wp database?
- WordPress will not operate correctly
- How to Join two tables from separate databases within WordPress
- What are the additional fields in wp_comments used for?
- error importing localhost export file to server
- How to sort results from a custom database table
- Prevent WordPress from loading comments
- SQL query to delete comments older than 90 days?
- How can I call a row of user specific data from a custom table added to the WP Database
- How to merge local and live databases?
- How to track a users progress through pages by inserting data into WordPress Database?
- Import 10,000 Users into WordPress WITH a specific ID for each user
- migrate comments from old database to new database
- if statement on database query
- Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
- WordPress unresponsive after calling wp_update_comment()
- No wp-config.php file on local install of wordpress – site still displays
- What is the correct/safe way to delete all comments?
- How to migrate the posts from an old custom legacy blog to a new WordPress website?
- List User Comments on User Profile BuddyPress [closed]
- Add action on delete comments?
- Get total number of comment of the posts written by an author
- Different database query in function.php using mysqli
- How to write one comment and publish on every post using database or plugin?
- Cannot get local avatars to show [closed]
- How to create and work with custom data / tables (i.e., for arbitrary data)?
- Adding custom tables to WordPress
- Log file reports SQL Error processing child comments
- Create WP_Query to search for posts by their categories or their parent/child categories
- WordPress not reflecting changed of the database
- Delete all one-word comments
- WordPress ‘comment counts’ got messed up, because of a plugin – DISQUS
- Fastest way to get the comment and ping total count for a post
- How can I save unique user data on my site? [closed]
- Update results, Before deleting the related category [closed]
- The “\” is missing when comments is updated
- database sent to a JSON file
- delete duplicate comments
- Using custom tables for old posts
- Not connecting to database in file with multiple MySQL connections
- What do these phpMyAdmin errors mean on my WordPress databaes?
- WordPress Block developer from exporting Database via PHP
- wpdb prepare insert table doesn’t work
- Should I use WordPress to skin a database website?
- How do I display offsite database info on my wordpress site?
- Creating Database Table vs. Adding MetaData to Post & User
- WordPress and MySQL: trying to print data using PHP from user_meta custom field data
- Most commented posts by time period (last 12h, last 24h and etc)
- I can’t update my data through $wpdb
- Buddypress avatar image in database [closed]
- Why when I create a new post I found 2 record related to this post into the posts database table?
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- Add row to custom database Table and delete all rows older than 1 day
- How to display results from a data table with an encrypted user id?
- Return count for characters in the comment and perform action based on the length
- SQL error with custom query
- add_action for publish_post doesn’t work
- What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
- Please help! I have a problem with getting wordpress databas
- Error establishing a database connection (Set-up locally)
- Cant create table on plugin activation
- PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
- Moving a few select DB tables to a new WP instance
- Using wpdb to connect to a different database is not working
- Insert data from form to database
- Creating a “walled garden” of comments
- How to enable truly anonymous posting in bbPress forums? [closed]
- can’t delete a row from post_meta table
- How to set max users to 17.000
- two wordpress sites, two themes, one database, same content
- Insert double entry in DB
- How to connect database table to each registered wordpress user.
- Let users register weight each day and save it in DB
- MySQL database migration to WordPress
- Loop not displaying comments_popup_link
- How to modify the comments list in WP & BuddyPress? [closed]
- Custom query_posts() parameter
- How to pass username into form that sends data to database
- How to edit the default database of WordPress [closed]
- How to enable truly anonymous posting in bbPress forums? [closed]
- Display total count of products in orders of a specific order status
- Custom form that stores data in mysql database
- Putting form result in my database
- Can’t insert into a database wordpress