|
|
|
 |
-
(+1 -1)
-
| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
|
| |
|
3 |
<queryset> |
| |
3 |
4 |
<rdbms><type>oracle</type><version>8.1.6</version></rdbms> |
| |
4 |
5 |
|
| |
5 |
|
<queryset> |
| |
6 |
6 |
<fullquery name="select_n_comments"> |
| |
7 |
7 |
<querytext> |
| |
8 |
8 |
select * from ( |
| |
9 |
9 |
select |
| |
10 |
10 |
c.comment_id, |
| |
11 |
11 |
r.title, |
| |
12 |
12 |
r.publish_date, |
| |
13 |
13 |
e.entry_id, |
| |
14 |
14 |
person.name(o.creation_user) as item_author |
| |
15 |
15 |
from |
| |
16 |
16 |
cr_revisions r, |
| |
17 |
17 |
cr_items i, |
| |
18 |
18 |
general_comments c, |
| |
19 |
19 |
pinds_blog_entries e, |
| |
20 |
20 |
acs_objects o |
| |
21 |
21 |
where |
| |
22 |
22 |
e.package_id = :package_id and |
| |
23 |
23 |
c.object_id = e.entry_id and |
| |
24 |
24 |
i.item_id = c.comment_id and |
| |
25 |
25 |
i.live_revision = r.revision_id and |
|