SELECT top 300 u.Reputation, p.id as Post_Id, p.body as ...

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
  u.Reputation,
  
  p.id as Post_Id,
  p.body as Post_Body,
  
  p.id as Processed_Body, --TODO
  p.tags as Post_Tags,
  p.Title as Post_Title,
  p.id as Question_Length, --TODO
  p.id as Url_Image_Count, --TODO
  p.id as LOC, --TODO
  u.Reputation as User_Reputation,
  b.class,
  p.score,
  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