select p1.Id as QId, p1.PostTypeId as QPostTypeId, p1.Ac...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

select 

p1.Id as QId, p1.PostTypeId as QPostTypeId, p1.AcceptedAnswerId as QAcceptedAnswerId,
p1.ParentId as QParentId, p1.CreationDate as QCreationDate, p1.DeletionDate as QDeletionDate,
p1.Score as QScore, p1.ViewCount as QViewCount,
p1.Body as QBody, p1.OwnerUserId as QOwnerUserId, p1.OwnerDisplayName as QOwnerDisplayName,
p1.LastEditorUserId as QLastEditorUserId, p1.LastEditorDisplayName as QLastEditorDisplayName, 
p1.LastEditDate as QLastEditDate, p1.LastActivityDate as QLastActivityDate,
p1.Title as QTitle, p1.Tags as QTags, p1.AnswerCount as QAnswerCount, p1.CommentCount as QCommentCount,
p1.FavoriteCount as QFavoriteCount, p1.ClosedDate as QClosedDate,
p1.CommunityOwnedDate as QCommunityOwnedDate, p1.ContentLicense as QContentLicense,
p1.Id as [Post Link],

-- Enter COLUMNS FOR ANSWER 
p2.Id as AId, p2.PostTypeId as APostTypeId, p2.AcceptedAnswerId as AAcceptedAnswerId,
p2.ParentId as AParentId, p2.CreationDate as ACreationDate, p2.DeletionDate as ADeletionDate,
p2.Score as AScore, p2.ViewCount as AViewCount,
p2.Body as ABody, p2.OwnerUserId as AOwnerUserId, p2.OwnerDisplayName as AOwnerDisplayName,
p2.LastEditorUserId as ALastEditorUserId, p2.LastEditorDisplayName as ALastEditorDisplayName,
p2.LastEditDate as ALastEditDate, p2.LastActivityDate as ALastActivityDate,
p2.Title as ATitle, p2.Tags as ATags, p2.AnswerCount as AAnswerCount, p2.CommentCount as ACommentCount,
p2.FavoriteCount as AFavoriteCount, p2.ClosedDate as AClosedDate,
p2.CommunityOwnedDate as ACommunityOwnedDate, p2.ContentLicense as AContentLicense

from posts p1 INNER JOIN posts p2 ON p1.Id = p2.ParentId

where p1.posttypeid = 1

-- recent
-- and p1.CreationDate > '2020-01-01'
-- and p1.CreationDate < '2016-01-01'
and p1.Score > 0
-- question body has words like api/library
-- and (p1.Body like '% api%' or p1.Body like '% library%' or p1.Body like '% libraries%')

-- tags for aspect Performance

and (p1.Tags like '%<performance>%' or p1.Tags like '%<optimization>%' or p1.Tags like '%<speed>%' or p1.Tags like '%<efficiency>%' or p1.Tags like '%<scalability>%' or p1.Tags like '%<parallelism>%' or p1.Tags like '%<multithreading>%' or p1.Tags like '%<memory-management>%' or p1.Tags like '%<cpu-usage>%' or p1.Tags like '%<network-optimization>%' or p1.Tags like '%<scaling>%' or p1.Tags like '%<throughput>%' or p1.Tags like '%<latency>%' or p1.Tags like '%<caching>%' or p1.Tags like '%<load-balancing>%' or p1.Tags like '%<profiling>%')

and p1.AcceptedAnswerId != ''
--and (p1.Tags like '%<java>%' or p1.Tags like '%<python>%')

and p1.Tags like '%<jsoup>%'

Enter Parameters

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