Do not perform an inner join on the archive table, for large tables this can make Piwik completely unresponsive and can result in invalidated archives never being purged.