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 or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?