Guest User

Untitled

a guest
Jun 17th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.27 KB | None | 0 0
  1. meco=> SELECT COUNT(*) FROM documents WHERE _stanford IS NULL AND source_id IN (SELECT id FROM sources_twitter);
  2.  COUNT
  3. --------
  4.  627584
  5. (1 ROW)
  6.  
  7. meco=> SELECT COUNT(*) FROM documents WHERE source_id IN (SELECT id FROM sources_twitter);
  8.   COUNT
  9. ----------
  10.  16308434
  11. (1 ROW)
Add Comment
Please, Sign In to add comment