Low views, high votes yet unanswered

0

Please login or register to vote for this query.

(click on this box to dismiss)

A list of questions with a high score and low view count

Arqade Meta

Q&A about the site for passionate videogamers on all platforms

-- Enter Query Title
-- Enter Query Description
Select p1.Id as Q_Id, p2.Id as A_Id, p1.Body as Q_Body, p2.Body as A_Body,
p2.ParentId as A_ParentId, p1.AcceptedAnswerId as Q_AcceptedAnswerId,
'false' as isExecuted, p1.Tags as Q_Tag, p1.CreationDate as Q_CreationDate,
p2.CreationDate as A_CreationDate, p1.Score as Q_Score, p2.Score as A_Score,
p1.ViewCount as Q_ViewCount, p1.Title as Q_Title, p1.AnswerCount as Q_AnswerCount,
p1.ClosedDate as Q_ClosedDate, p1.PostTypeId as Q_PostTypeId, p2.PostTypeId as A_PostTypeId,
p1.OwnerUserId as Q_OwnerUserId, p2.OwnerUserId as A_OwnerUserId, p1.OwnerDisplayName as
Q_OwnerDisplayName, p2.OwnerDisplayName as A_OwnerDisplayName, p1.FavoriteCount as
Q_FavoriteCount, p1.ContentLicense as Q_ContentLicense, p2.ContentLicense as A_ContentLicense
from Posts p1
Inner join Posts p2 on p1.Id = P2.ParentId
where p1.Score >=2 and p1.Id > 53683046 and p1.Id < 60000000 and p1.PostTypeId = 1 and p2.PostTypeId = 2
and (p1.Tags like '%spring%' or p1.Tags like '%java%' or p1.Tags like '%python%'
or p1.Tags like '%c%' or p1.Tags like '%c++%' or p1.Tags like '%javascript%'
or p1.Tags like '%c#%' or p1.Tags like '%php%' or p1.Tags like '%angular%'
or p1.Tags like '%react%' or p1.Tags like '%node%' or p1.Tags like '%aws%'
or p1.Tags like '%jquery%' or p1.Tags like '%html%' or p1.Tags like '%css%'
or p1.Tags like '%android%' or p1.Tags like '%typescript%' or p1.Tags like '%sql%'
or p1.Tags like '%xml%' or p1.Tags like '%mongo%'  or p1.Tags like '%api%'
or p1.Tags like '%jpa%' or p1.Tags like '%hibernate%' or p1.Tags like '%kotlin%'
or p1.Tags like '%r%' or p1.Tags like '%swift%'  or p1.Tags like '%blockchain%' 
or p1.Tags like '%artificial%' or p1.Tags like '%ruby%' or p1.Tags like '%thread%'
or p1.Tags like '%oops%' or p1.Tags like '%elastic%' or p1.Tags like '%jsp%' 
or p1.Tags like '%code%' or p1.Tags like '%google%' or p1.Tags like '%jsp%'
or p1.Tags like '%session%' or p1.Tags like '%npm%' or p1.Tags like '%jdbc%'
or p1.Tags like '%woocommerce%' or p1.Tags like '%struct%' or p1.Tags like '%Bootstrap%'
or p1.Tags like '%net%') 
order by p1.Id asc

Enter Parameters

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