mysql八小时前的数据，根据条件关联查询

错误写法：

SELECT * from 
	( 
	 Select * from material where fieldp like ”%0000123%” and confirm1=1
	  ) a
Left join  
	(
	select abd,model_name ,model_id ,sence from  feedback where sence=3
	 ) b on a.type =b.model_id
where createtime >DATE_ADD(NOW(),INTERVAL -8 HOUR
)

下面这样写才是需求的 要求: sence=3才查询出来，不等于3没有数据， 却是根据material查询当前时间八小时前的数据

SELECT * from 
	(  
	SELECT * from 
		material
	 WHERE 
	 	fieldp like ”%0000123%”
	 	 and confirm1=1  
	 	 and createtime >DATE_ADD(NOW(),INTERVAL -8 HOUR)
	 ) a
	Left join  
	(
		SELECT  abd,model_name ,model_id ,sence from  feedback
  ) b on a.type =b.model_id

WHERE
	 sence=3