- 'SELECT a.hruid, pd.promo, p.ax_id, pd.directory_name, p.deathdate, DATE(MAX(s.start)) AS last
- FROM accounts AS a
- INNER JOIN account_profiles AS ap ON (ap.uid = a.uid AND FIND_IN_SET(\'owner\', ap.perms))
- INNER JOIN profiles AS p ON (p.pid = ap.pid)
- INNER JOIN profile_display AS pd ON (pd.pid = p.pid)
- LEFT JOIN logger.sessions AS s ON (s.uid = a.uid AND suid = 0)
- WHERE a.state = \'active\' AND p.deathdate IS NOT NULL
+ "SELECT a.hruid, pd.promo, p.ax_id, pd.directory_name, p.deathdate, DATE(MAX(s.start)) AS last
+ FROM #x4dat#.accounts AS a
+ INNER JOIN #x4dat#.account_profiles AS ap ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms))
+ INNER JOIN #x4dat#.profiles AS p ON (p.pid = ap.pid)
+ INNER JOIN #x4dat#.profile_display AS pd ON (pd.pid = p.pid)
+ LEFT JOIN log_sessions AS s ON (s.uid = a.uid AND suid = 0)
+ WHERE a.state = 'active' AND p.deathdate IS NOT NULL