这里我直接列出来了全部的情况查出来的
select distinct a.*
from stadium a,stadium b,stadium c
where a.people>=100 and b.people>=100 and c.people>=100
and (
(a.id+1=b.id and b.id+1=c.id)or/*abc*/
(a.id+1=b.id and b.id+1=c.id)or/*acb*/
(a.id-1=b.id and a.id+1=c.id)or/*bac*/
(a.id-2=b.id and a.id-1=c.id)or/*bca*/
(a.id-1=c.id and a.id+1=b.id)or/*cab*/
(a.id-1=b.id and a.id-2=c.id)/*cba*/
)
order by a.id