Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT 'stanford true', COUNT(*)
- FROM documents
- WHERE source_id IN (SELECT id FROM prefered_sources)
- AND _stanford IS TRUE
- UNION
- SELECT 'analyzed true', COUNT(*)
- FROM documents
- WHERE source_id IN (SELECT id FROM prefered_sources)
- AND _analyzed IS TRUE
- UNION
- SELECT 'sentences not null', COUNT(*)
- FROM documents
- WHERE source_id IN (SELECT id FROM prefered_sources)
- AND sentences IS NOT NULL
- UNION
- SELECT 'termvetor not null', COUNT(*)
- FROM documents
- WHERE source_id IN (SELECT id FROM prefered_sources)
- AND termvector IS NOT NULL
- UNION
- SELECT 'calaised true', COUNT(*)
- FROM documents
- WHERE source_id IN (SELECT id FROM prefered_sources)
- AND _calaised IS TRUE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement