Index: openacs-4/packages/news-aggregator/www/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/www/Attic/index.xql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/news-aggregator/www/index.xql 20 Mar 2004 11:12:29 -0000 1.3 +++ openacs-4/packages/news-aggregator/www/index.xql 25 Dec 2005 00:57:44 -0000 1.3.2.1 @@ -2,13 +2,34 @@ - - - select p.first_names || ' ' || p.last_name as user_name - from users u join - persons p on (u.user_id = p.person_id) - where u.user_id = :user_id - - + + + select item_id + from na_saved_items + where aggregator_id = :aggregator_id + + + + + select aggregator_name, + description as aggregator_description, + public_p + from na_aggregators + where aggregator_id = :aggregator_id + + + + + + select + top, bottom + from + na_purges + where + aggregator_id = :aggregator_id + order by top desc, bottom desc + + +