SELECT top 300 p.id as Post_Id, p.body as Post_Body, p.b...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

SELECT
  top 300
  p.id as Post_Id,
  p.body as Post_Body,
  
  p.body as Processed_Body, --Post full textual body excluding code snippets and the html tags like <p>,<code>,<href>
  p.tags as Post_Tags,
  p.Title as Post_Title,
  p.body as Question_Length, --Length of the whole Processed Body
  p.score,
  u.Reputation,
  b.class,
  p.ViewCount,
  p.FavoriteCount,
  u.UpVotes,
  p.AnswerCount,
  p.AcceptedAnswerId,
  datediff(MINUTE, p.CreationDate, a.CreationDate) as QATimeGap

FROM
  Posts as p, Posts as a, Users as u, Badges as b
where
  p.Tags like '%python%'
/*
  p.Tags like '%string%'and 
  p.Tags not like '%javascript%' and 
  p.Tags not like '%c++%' and
*/
and p.owneruserid=u.id and p.owneruserid=b.id and p.id=a.ParentId

ORDER BY
  rand()

Enter Parameters

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