0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT COUNT(a.id), MAX(a.id)
FROM (
  SELECT TOP 10000 
         p1.id AS id
  FROM posts p1
      INNER JOIN posts p2 ON p1.acceptedanswerid = p2.id
  WHERE p1.tags LIKE '%<java>%'
        and p1.id > 54025406
  order by p1.id
) AS a;

fork query

edited apr 14 23

created apr 14 23 jon.doe41399