[Aplaws-commit] r963 - trunk/ccm-ldn-dublin/pdl/com/arsdigita/london/cms/dublin

[<ss...@vh...>]

Author: sshinde
Date: 2005-10-20 14:17:34 +0200 (Thu, 20 Oct 2005)
New Revision: 963

Modified:
   trunk/ccm-ldn-dublin/pdl/com/arsdigita/london/cms/dublin/query-getRelatedItems.pdl
Log:
Removed commented out query.


Modified: trunk/ccm-ldn-dublin/pdl/com/arsdigita/london/cms/dublin/query-getRelatedItems.pdl
===================================================================
--- trunk/ccm-ldn-dublin/pdl/com/arsdigita/london/cms/dublin/query-getRelatedItems.pdl	2005-10-20 12:10:15 UTC (rev 962)
+++ trunk/ccm-ldn-dublin/pdl/com/arsdigita/london/cms/dublin/query-getRelatedItems.pdl	2005-10-20 12:17:34 UTC (rev 963)
@@ -22,60 +22,6 @@
 //  * Matching LGCL category ID
 //  * Not in a subcat of the current Nav cat
 //  * Matching first Dublin keywords
-//  Original Query with duplicate resutls problem
-//query getRelatedItems {
-//    BigDecimal[1..1] itemID;
-//    BigDecimal[1..1] workingID;
-//    String[1..1] title;
-//    String[1..1] type;
-//    String[1..1] objectType;
-//
-//    do {
-//      select id.item_id,
-//             id.master_id,
-//             pd.title,
-//             t.label,
-//             o.object_type
-//      from cms_bundles bd,
-//           cat_object_category_map bsm,
-//           cat_object_category_map bdm,
-//           trm_terms tsd,
-//           cms_items id,
-//           acs_objects o,
-//           content_types t,
-//           cms_pages pd,
-//           ldn_dublin_core_items dd,
-//           ldn_dublin_core_item_map ddm
-//      where bsm.object_id = :bundleID
-//        and bsm.category_id = bdm.category_id
-//        and bd.bundle_id = bdm.object_id
-//        and bdm.category_id = tsd.model_category_id
-//        and tsd.domain = :subjectDomain
-//        and bd.bundle_id = id.parent_id
-//        and id.item_id = ddm.item_id
-//        and ddm.dublin_id = dd.dublin_id
-//        and dd.keywords like :keyword || '%'
-//        and id.type_id = t.type_id
-//        and id.version = 'live'
-//        and id.item_id = o.object_id
-//        and pd.item_id = id.item_id
-//        and id.item_id != :itemID
-//        and bdm.object_id not in (
-//          select bnm.object_id
-//            from cat_object_category_map bnm,
-//                 cat_cat_subcat_trans_index sti
-//           where bnm.category_id = sti.subcategory_id
-//             and sti.category_id = :navCategoryID
-//        )
-//    } map {
-//      itemID = id.item_id;
-//      workingID = id.master_id;
-//      title = pd.title;
-//      type = t.label;
-//      objectType = o.object_type;
-//    }
-//}
-
 query getRelatedItems {
     BigDecimal[1..1] itemID;
     BigDecimal[1..1] workingID;