Hi,
Two other ideas...
SELECT DISTINCT p.a, p.b, p.c, now(), count(item.item_pk)
FROM product p JOIN (select distinct a,b,c from products except select distinct a,b,c from navigation
)foo USING (a,b,c) LEFT JOIN item ON item.product_fk = product_pk
WHERE ...
GROUP BY p.a, p.b, p.c
or maybe
SELECT DISTINCT foo.*, now(), count(item.item_pk)
FROM (select distinct a,b,c from products WHERE ... except select distinct a,b,c from navigation )foo
LEFT JOIN item ON item.product_fk = product_pk
WHERE ...
GROUP BY p.a, p.b, p.c
HTH,
Marc Mamin
