I'm look for a custom SQL query that will let me pull in the latest comments from across a WP multi-site install.
The end result will be identical to a regular recent comments widget, but from all sites within the installation.
Ok, I did some research based on בניית אתרים's solution here, as I'm interested in this too.
First you need to get a list of blog IDs, and
Then render the output:
You should also cache the results, and flush the cache like once every 10 minutes or so.
and you might want to have a look at diamond multisite widgets plugin witch already implements this a a widget and as a shortcode.
hopes this helps.
Thank you for your interest in this question.
Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.
Would you like to answer one of these unanswered questions instead?