Guest User

Untitled

a guest
Jul 17th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. select
  2. b.parent,
  3. c.category_name,
  4. a.inode,
  5. a.title
  6.  
  7. from
  8. contentlet a
  9. inner join tree b
  10. on a.inode = b.child
  11. inner join category c
  12. on b.parent = c.inode
  13. where
  14. a.inode in (693592)
  15. and a.live=1
  16.  
  17. select
  18. b.parent,
  19. c.category_name,
  20. a.inode,
  21. a.title
  22.  
  23. from
  24. contentlet a
  25. inner join tree b
  26. on a.inode = b.child
  27. inner join category c
  28. on b.parent = c.inode
  29. where
  30. a.inode in (698806)
  31. and a.live=1
Add Comment
Please, Sign In to add comment