Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- b.parent,
- c.category_name,
- a.inode,
- a.title
- from
- contentlet a
- inner join tree b
- on a.inode = b.child
- inner join category c
- on b.parent = c.inode
- where
- a.inode in (693592)
- and a.live=1
- select
- b.parent,
- c.category_name,
- a.inode,
- a.title
- from
- contentlet a
- inner join tree b
- on a.inode = b.child
- inner join category c
- on b.parent = c.inode
- where
- a.inode in (698806)
- and a.live=1
Add Comment
Please, Sign In to add comment