netjunky

Untitled

Oct 1st, 2011
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.23 KB | None | 0 0
  1. SELECT
  2.     B.`photo_album_id`, B.`photo_album_id`
  3. FROM
  4.     `bulletin` AS B
  5. INNER JOIN
  6.     `network` AS N
  7.         ON B.`mem_id` = N.`mem_id`
  8. WHERE
  9.     B.`parentid` = 0 AND
  10.     (
  11.         N.`frd_id` = 329 OR
  12.         B.`mem_id` = 329
  13.     )
  14. ORDER BY
  15.     B.`date` DESC
  16. LIMIT 0, 20
Add Comment
Please, Sign In to add comment