[Aplaws-commit] r1065 - trunk/ccm-ldn-atoz/pdl/com/arsdigita/london/atoz

[<ap...@vh...>]

Author: apevec
Date: 2005-12-18 20:20:50 +0100 (Sun, 18 Dec 2005)
New Revision: 1065

Modified:
   trunk/ccm-ldn-atoz/pdl/com/arsdigita/london/atoz/AtoZCategoryProvider.pdl
Log:
apply ContentType black-list to subsite AtoZ query


Modified: trunk/ccm-ldn-atoz/pdl/com/arsdigita/london/atoz/AtoZCategoryProvider.pdl
===================================================================
--- trunk/ccm-ldn-atoz/pdl/com/arsdigita/london/atoz/AtoZCategoryProvider.pdl	2005-12-18 19:19:32 UTC (rev 1064)
+++ trunk/ccm-ldn-atoz/pdl/com/arsdigita/london/atoz/AtoZCategoryProvider.pdl	2005-12-18 19:20:50 UTC (rev 1065)
@@ -182,6 +182,18 @@
             where b.category_id = c.category_id
               and b.provider_id = :providerID
        )
+       and not exists (
+           select 1
+             from atoz_cat_ct_blacklist_map b, cat_object_category_map m,
+                  cms_bundles cb, cms_items ci
+            where b.type_id = ci.type_id
+              and ci.parent_id = cb.bundle_id
+              and ci.language = cb.default_language
+              and cb.bundle_id = m.object_id
+              and m.category_id = c.category_id
+              and m.index_p = '1'
+              and b.provider_id = :providerID
+       )
     union
     select c.category_id as id,
            a.object_type as object_type,