0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

with myposts as (
select Posts.id as ID
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Tags.TagName in ('linux-kernel', 'kvm', 'libvirt', 'xen', 'yocto', 'android-source')
)

select DISTINCT Users.Id, DisplayName, WebsiteURL 
from Users, myposts, comments
where Comments.PostID = myposts.id and
Users.Id = Comments.UserId and Users.WebsiteUrl IS NOT NULL and LEN(Users.WebsiteUrl)>0

view current version

edited feb 23 18

created feb 23 18 anonymous