Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*), SECTION FROM documents, instances, entities, sources
- WHERE
- instances.item_id=documents.id
- AND entities.id=instances.entity_id
- AND entities.enttype_id=62
- AND source_id=sources.id
- --and source_id in (1, 1677, 1676)
- AND category='news'
- GROUP BY SECTION
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement