List taxonomy terms that belong to nodes that belong to another taxonomy term

Submitted by Benjamin Melançon on December 28, 2007 - 2:24pm

Searched words:

SQL filter taxonomy terms by terms of another vocabulary

The SQL for this is a little tricky. I know I wrote down what needed to be done for Christophe to tackle but I can't find it now.

In short:

Select all nodes that belong to the taxonomy term being passed into the Place page.

node -- in drupal 6 node_revision -- but in any case it comes from the taxonomy table.

Select all taxonomy terms that are in a given vocabulary that belong to those nodes.

This requires also a look at {term_data} which stores vocab information (as vid).

This isn't pretty SQL, and not very scalable (the massive list of terms can be cached once for the whole site).

Comments

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Internal paths in single or double quotes, written as "internal:node/99", for example, are replaced with the appropriate absolute URL or path. Paths to files in single or double quotes, written as "files:somefile.ext", for example, are replaced with the appropriate URL that can be used to download the file.
You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
Syntax highlight code surrounded by the {syntaxhighlighter SPEC}...{/syntaxhighlighter} tags, where SPEC is a Syntaxhighlighter options string or "class="OPTIONS" title="the title".
Lines and paragraphs break automatically.