Skip to content

Instantly share code, notes, and snippets.

@zettca

zettca/pages_with_records.sql

Created December 11, 2015 01:06
Show Gist options
  • Save zettca/642f5aeb17ded3fec7df to your computer and use it in GitHub Desktop.
Save zettca/642f5aeb17ded3fec7df to your computer and use it in GitHub Desktop.
Download ZIP
Páginas com registos
Raw
pages_with_records.sql
SELECT reg_pag.userid
FROM pagina INNER JOIN reg_pag ON reg_pag.pageid = pagina.pagecounter INNER JOIN registo ON registo.regcounter = reg_pag.regid
WHERE pagina.ativa=1 AND reg_pag.ativa = 1 AND registo.ativo = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment