0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

SELECT low
FROM 

(

SELECT ID, low 

FROM
(Select n1.ID ID, min(n2.ID) + 1 low
 from posts n1
inner join posts n2
on n1.ID < n2.ID 
WHERE n1.ID < 5000
 and n2.ID < 5000

Group by n1.ID) t
WHERE t.low not in (SELECT ID FROM posts)
and t.low < (Select MAX(ID) from posts) 
) t

INNER JOIN 
(

SELECT ID - 1 ID, high
 FROM
(Select n1.ID ID , min(n2.ID) - 1 high
 from posts n1
inner join posts n2
on n1.ID < n2.ID 
WHERE n1.ID < 5000
 and n2.ID < 5000
 
Group by n1.ID) t
WHERE t.high not in (SELECT ID FROM posts) 
) t2
ON t.ID = t2.ID

fork query

created sep 24 10 conradfrix