@pfefferle Lots of love to you and respect for your time. Only reply if it is no bother at all. (I'm playing with #WebMentions).
I'm investigating who sends WebMentions. I created an SQL to do that. I assume no native method exists. I want to check that I'm not going to run up against something that was deprecated, and I didn't notice.
I'm worried that I should join the meta table twice to get protocol in the row, but I'm hoping comment type has me covered.
Gist: https://gist.github.com/lordmatt/31f4f0b508b2dcf353c36ab23f907eea