# 例如某個連結失效了 https://cloud.test.com/s/T8wnofnnZjHk93e # 我們可以透過以下語法,找到哪個帳號停用了 select * from ( select uid_owner uid,ldap_dn name,token from oc_share,oc_ldap_user_mapping where uid_owner=owncloud_name union select uid_owner uid,displayname name,token from oc_share,oc_users where uid_owner=uid ) as NewUnionTable where token='T8wnofnnZjHk93e'