gistfile1.txt

SELECT pid, caption, aid, owner, link, src_big, src_small, created, modified FROM photo WHERE aid IN (
    SELECT aid FROM album WHERE owner IN (
          SELECT uid2 FROM friend WHERE uid1=me()
      ) 
      AND (
          (type = 'app' AND name = 'Camera Photos')
      )
)
AND created > 1353867084 ORDER BY created DESC
LIMIT 30000

SELECT pid, caption, aid, owner, link, src_big, src_small, created, modified FROM photo WHERE aid IN (
    SELECT aid FROM album WHERE owner IN (
          SELECT uid2 FROM friend WHERE uid1=me()
      ) 
      AND (
          (type = 'mobile')
      )
)
AND created > 1353867084 ORDER BY created DESC
LIMIT 30000

SELECT pid, caption, aid, owner, link, src_big, src_small, created, modified FROM photo WHERE aid IN (
    SELECT aid FROM album WHERE owner IN (
          SELECT uid2 FROM friend WHERE uid1=me()
      ) 
      AND (
          (type = 'normal' AND name <> 'Cover Photos')
      )
)
AND created > 1353867084 ORDER BY created DESC
LIMIT 30000