#sql多表查询#

SELECT *

FROM sp_blog,sp_aboutme,sp_user,sp_info  

WHERE 

sp_aboutme.user_id=sp_user.user_id

AND sp_info.info_state=1

AND sp_info.user_id=sp_aboutme.user_id

AND sp_info.user_id=sp_user.user_id

AND sp_info.user_id=sp_blog.user_id

AND sp_blog.user_id=sp_aboutme.user_id

AND sp_blog.user_id=sp_user.user_id

AND sp_blog.blog_tj=1 

AND sp_blog.blog_cg=0

AND sp_blog.blog_default=0 

ORDER BY blog_time DESC LIMIT $pagen2,$page_sizen2