select uid,name from hu60_user where access=0
and
(
((select count(*) from hu60_bbs_topic_content where uid=hu60_user.uid) > 0)
or
((select count(*) from hu60_addin_chat_data where uid=hu60_user.uid) > 0)
)
select uid,content from hu60_bbs_topic_content where uid in
(
select uid from hu60_user where access=0
and
(
((select count(*) from hu60_bbs_topic_content where uid=hu60_user.uid) > 0)
or
((select count(*) from hu60_addin_chat_data where uid=hu60_user.uid) > 0)
)
)
select uid,content from hu60_addin_chat_data where uid in
(
select uid from hu60_user where access=0
and
(
((select count(*) from hu60_bbs_topic_content where uid=hu60_user.uid) > 0)
or
((select count(*) from hu60_addin_chat_data where uid=hu60_user.uid) > 0)
)
)
update hu60_user set access=1 where access=0
and
(
((select count(*) from hu60_bbs_topic_content where uid=hu60_user.uid) > 0)
or
((select count(*) from hu60_addin_chat_data where uid=hu60_user.uid) > 0)
)