WITH allData AS ( SELECT ROW_NUMBER() OVER (ORDER BY scor...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Martial Arts Meta

Q&A about the site for students and teachers of all martial arts

WITH allData AS (
    SELECT
                ROW_NUMBER() OVER (ORDER BY score desc) AS row
                , id, tags, body, posttypeid, score, creationdate, deletiondate, answercount, favoritecount, closeddate from posts
                where 

 tags like '%<java>%' and body like '%freelanc%'
 )
 SELECT      *
FROM        allData
WHERE       row    >= ##StartRow:INT?1##
AND         row    <= ##EndRow:INT?50000##
ORDER BY    row

Enter Parameters

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