收藏(1)
sql语句如下：
SELECT udd.id,udd.doTime,udd.doType,udd.isOk,udd.resourceId,
udd.userId,uu.alias userName,uu.email AS email,bd.nid AS drugId,bd.drug_name_en AS drugName
FROM udl_drugs_downlaod_log udd LEFT
JOIN use_user uu ON udd.userId=uu.id
LEFT JOIN report rt ON rt.id=udd.resourceId
LEFT JOIN base_msg bd ON bd.nid=rt.drugId
WHERE 1=1
ORDER BY doTime DESC
LIMIT 0,10
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024