SELECT
	SUBSTRING(LAW.url FROM 'http://[a-z0-9._-]+') AS url_simples,
	LAW.usuario AS usuario
FROM log_acesso_web LAW
WHERE
	( LAW.data BETWEEN '2008-01-16 00:00:00' AND '2008-04-17 00:00:00' )

GROUP BY url_simples, LAW.usuario
HAVING NOT SUBSTRING(LAW.url FROM 'http://[a-z0-9._-]+') = '' AND NOT LAW.usuario = ''
ORDER BY url_simples, LAW.usuario