--ACCESS=access administration pages
SELECT u.uid, u.name, timestamp, message, location, type, severity, wid, 
  variables
FROM {watchdog} w JOIN {users} u on u.uid=w.uid 
  WHERE u.name = :name ORDER BY timestamp desc
  LIMIT 100