All pastes #987640 Raw Edit

Stuff

public sql v1 · immutable
·published 2008-04-16 17:59 UTC
rendered paste body
SELECT	SUBSTRING(LAW.url FROM 'http://[a-z0-9._-]+') AS url_simples,	LAW.usuario AS usuarioFROM log_acesso_web LAWWHERE	( LAW.data BETWEEN '2008-01-16 00:00:00' AND '2008-04-17 00:00:00' )GROUP BY url_simples, LAW.usuarioHAVING NOT SUBSTRING(LAW.url FROM 'http://[a-z0-9._-]+') = '' AND NOT LAW.usuario = ''ORDER BY url_simples, LAW.usuario