Select All Tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

WITH allData AS (
    SELECT
                ROW_NUMBER() OVER (ORDER BY T.Id) AS row
                , T.Id
                , T.TagName
                , T.ExcerptPostId
                , P.Body
    FROM        Tags    AS T
    Left Join   Posts   AS P
    On          P.Id = T.ExcerptPostId
)
SELECT      *
FROM        allData
WHERE       row    >= 1 + 50000*(##StartRow:INT?1## - 1)
ORDER BY    row

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results