Advertisement
vojtarek

about "affected" documents

Nov 8th, 2011
354
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. SELECT COUNT(*), SECTION FROM documents, instances, entities, sources
  2. WHERE
  3. instances.item_id=documents.id
  4. AND entities.id=instances.entity_id
  5. AND entities.enttype_id=62
  6. AND source_id=sources.id
  7. --and source_id in (1, 1677, 1676)
  8. AND category='news'
  9. GROUP BY SECTION
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement