SELECT  requested_url,
        MIN({wp_abj404_logsv2}.id) AS logsid,
        max({wp_abj404_logsv2}.timestamp) as last_used,
        count(requested_url) as logshits

FROM    {wp_abj404_logsv2}

        inner join {wp_abj404_redirects}
        on {wp_abj404_logsv2}.requested_url = {wp_abj404_redirects}.url 

group by requested_url