Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select recurso0_.id_recurso,
- extract(day from recurso0_.dt_entrada),
- recurso0_.ds_alegacao,
- recurso0_.tp_recurso,
- count(*)
- from RECURSO recurso0_,
- registro registro1_,
- faixa faixa2_,
- site site3_,
- contrato contrato4_
- where recurso0_.id_registro=registro1_.id_registro
- and registro1_.id_faixa=faixa2_.id_faixa
- and faixa2_.id_site=site3_.id_site
- and site3_.id_contrato=contrato4_.id_contrato
- and (recurso0_.dt_distribuicao is null)
- group by recurso0_.id_recurso,extract(day from recurso0_.dt_entrada),recurso0_.ds_alegacao,recurso0_.tp_recurso
- order by extract(day from recurso0_.dt_entrada)
Add Comment
Please, Sign In to add comment