Views Modules to Show on Tags for Published Nodes

Hi,

I am using Drupal 6 to host a blog. It's all working fine. Free tagging is enabled to create tags for the blog entries. Because of the workflow we have created a number of blog entries which are not yet published.

We have a block which was created using Views 2 to show all the tags and to link to the relevant taxonomy page. This is all working fine. The challenge is that we want to only show tags for nodes which are both published and only for blog entries.

Using Views, this should be easy.

We

1. create a view displaying items of type node,
2. filter on node type and node published,
3. select just the taxonomy Term to display
4. create the block view and activate the block

All works fine, except that if a taxonomy term is repeated we get multiple entries.

Using Distinct doesn't work because the query is build from the node id (nid) and note the taxonomy term (tid).

If we work with items of type taxonomy, then I can't see how to get access to the node fields to filter just the required nodes.

I know that the final SQL statement I need is as follows:

SELECT
DISTINCT term_data.name AS term_data_name,
term_data.vid AS term_data_vid,
term_data.tid AS term_data_tid
FROM node node
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
WHERE (node.type in ('blog')) AND (node.status <> 0)

It is identical to the one created by Views, only the "node.nid AS nid" is removed. So my next step is to create a custom block. That will create unnecessary upgrade problems and the views approach is so close.

Yes I have tried grouping by Taxonomy term, however they just repeats the number of terms.

Can anyone provide guidance to what I am missing and how to get this result?

Thanks.