
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} 

/* where requested_url = '" . $specificURL . "'"; */
{where_clause_here}

GROUP BY requested_url
order by requested_url
LIMIT 500
