PERFORMANCE FIX & GENERAL BUG: removed the left join to the pv_user_log, need to reimplement.  Also add Rob's left join fix to the duplicate query.