select * from ( select p.id pid,p.name,p.create_time,u.id,u.mobile,u.realname,u.authname,u.register_time,u.register_ip from project p inner join user u on p.user_id = u.id and p.id in ( Select DISTINCT t1.project_id from project_manhour t1 join project_manhour t2 on t1.project_id=t2.project_id join project_manhour t3 on t2.project_id=t3.project_id join project_manhour t4 on t3.project_id=t4.project_id join project_manhour t5 on t4.project_id=t5.project_id join project_manhour t6 on t5.project_id=t6.project_id join project_manhour t7 on t6.project_id=t7.project_id where DATEDIFF(t1.add_time,'2016-08-08 00:00:00')=0 and t1.manhour>0 and DATEDIFF(t2.add_time,t1.add_time)=1 and t2.manhour>0 and DATEDIFF(t3.add_time,t2.add_time)=1 and t3.manhour>0 and DATEDIFF(t4.add_time,t3.add_time)=1 and t4.manhour>0 and DATEDIFF(t5.add_time,t4.add_time)=1 and t5.manhour>0 and DATEDIFF(t6.add_time,t5.add_time)=1 and t6.manhour>0 and DATEDIFF(t7.add_time,t6.add_time)=1 and t7.manhour>0 ) ) tb1 inner join project_member tb2 on tb1.pid = tb2.project_id
