Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 30th, 2012  |  syntax: None  |  size: 0.78 KB  |  hits: 23  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. FQL query to fetch all feeds by page name
  2. SELECT post_id,message
  3. FROM stream
  4. WHERE source_id IN (
  5.     SELECT page_id
  6.     FROM page
  7.     WHERE name='coca-cola'
  8. ) LIMIT 5
  9.        
  10. SELECT post_id,message
  11. FROM stream
  12. WHERE source_id IN (
  13.     SELECT page_id
  14.     FROM page
  15.     WHERE name='coca-cola'
  16. ) and actor_id IN (
  17.     SELECT page_id
  18.     FROM page
  19.     WHERE name='coca-cola'
  20. )
  21.        
  22. SELECT post_id,message
  23. FROM stream
  24. WHERE source_id IN (
  25.     SELECT page_id
  26.     FROM page
  27.     WHERE name='coca-cola'
  28. ) and actor_id IN (
  29.     SELECT page_id
  30.     FROM page
  31.     WHERE name='coca-cola'
  32. )
  33.        
  34. SELECT post_id,message
  35. FROM stream
  36. WHERE source_id IN (
  37.     SELECT page_id
  38.     FROM page
  39.     WHERE name='coca-cola'
  40. ) and actor_id IN (
  41.     SELECT page_id
  42.     FROM page
  43.     WHERE name='coca-cola'
  44. )
create a new version of this paste RAW Paste Data