How many upvotes do I have for each tag?

0

Please login or register to vote for this query.

(click on this box to dismiss)

how long before I get tag badges?

Artificial Intelligence

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

select  p1.Id, p1.PostTypeId, p1.AcceptedAnswerId, p1.ParentId, p1.CreationDate, p1.DeletionDate, p1.Score, p1.ViewCount,
p1.OwnerUserId, p1.OwnerDisplayName, p1.LastEditorUserId, p1.LastEditorDisplayName, p1.LastEditDate, p1.LastActivityDate,
p1.Title, p1.Tags, p1.AnswerCount, p1.CommentCount, p1.FavoriteCount, p1.ClosedDate, p1.CommunityOwnedDate, p1.ContentLicense,
p2.Id, p2.PostTypeId, p2.AcceptedAnswerId, p2.ParentId, p2.CreationDate, p2.DeletionDate, p2.Score, p2.ViewCount,
p2.OwnerUserId, p2.OwnerDisplayName, p2.LastEditorUserId, p2.LastEditorDisplayName, p2.LastEditDate, p2.LastActivityDate,
p2.Title, p2.Tags, p2.AnswerCount, p2.CommentCount, p2.FavoriteCount, p2.ClosedDate, p2.CommunityOwnedDate, p2.ContentLicense,users.Id,Reputation,users.CreationDate,DisplayName,
LastAccessDate,WebsiteUrl,Location,UpVotes,DownVotes
from posts p2 
join posts p1  on p1.posttypeid=1 and p1.CreationDate between '2022/2/4 23:58:32' and '2022/2/10 00:00:00'and p2.posttypeid=2 and p2.ParentId=p1.id 
join users on p2.OwnerUserId=users.Id;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results