Index: openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql,v diff -u -r1.6 -r1.6.2.1 --- openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql 29 Jul 2003 09:10:42 -0000 1.6 +++ openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql 18 Jan 2004 10:36:42 -0000 1.6.2.1 @@ -19,7 +19,10 @@ ci.parent_id = :parent_id and ci.content_type = 'ca_ad' and cm.keyword_id = :category_id and - ci.item_id = ads.ad_id + -- RBM (2004-01-17) - Dont remember why this was being compared to + -- item_id + -- ci.item_id = ads.ad_id + ci.latest_revision = ads.ad_id order by cm.keyword_id asc, cr.title asc