3704

---

sql : select isnull(count(*),0) as returnvalue from program where open_program=1 and programid in(select program from class where classid= (select classid from tournament where id=))