Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT id, name_2 FROM instagram_itens ii
  2. JOIN gis.bra_adm2 br
  3.     ON ST_CONTAINS(br.geom, ii.geom)
  4. JOIN instagram_monitoring_itens imi
  5.     ON imi.item_id = ii.id
  6. WHERE imi.monitoring_id ILIKE 'hilaine-amostra%'
  7. AND ii.geom IS NOT NULL
  8. LIMIT 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement