vojtarek

en/de dump

Jun 5th, 2011
476
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. SELECT id FROM documents
  2. WHERE LANGUAGE='en' AND pubdate >= '2011-05-01'
  3. AND source_id NOT IN (8791, 1632, 1, 1676, 8793)
  4. ;
  5.  
  6. SELECT id FROM documents
  7. WHERE LANGUAGE='de' AND pubdate >= '2011-05-01'
  8. AND source_id NOT IN (8792, 1645, 1635, 1672)
  9. ;
Add Comment
Please, Sign In to add comment