Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.64 KB | None | 0 0
  1. SELECT wallMessage.message, wallMessage.author,
  2. wallMessage.id,
  3. `user`.name,  
  4. `user`.surname,
  5. wallMessage.author,
  6. wallMessage.`date`,
  7. wallMessage.pulse
  8. FROM wallMessage
  9. JOIN (SELECT idOutgoing AS idFriend
  10. FROM `myFriends`
  11. WHERE idInput=6  AND STATUS = 1
  12. UNION
  13. SELECT idInput AS idFriend
  14. FROM `myFriends`
  15. WHERE idOutgoing=6  AND STATUS = 1) AS myFriendsOnly
  16. ON wallMessage.author =  myFriendsOnly.idFriend
  17. LEFT JOIN `user` ON `user`.id = wallMessage.author
  18. WHERE wallMessage.author <> 6 or (CURRENT_TIMESTAMP - `wallMessage`.`date`) < TIMESTAMP( '0000-00-00 00:15:00')
  19. GROUP BY `id`
  20. ORDER BY `wallMessage`.`id` DESC limit 0, 15
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement