this is the sql:
SELECT DISTINCT tags.title FROM tags INNER JOIN pages_tags ON pages_tags.tags_id = tags.id WHERE pages_tags.pages_id IN ( SELECT pages.id FROM pages INNER JOIN pages_tags ON pages_tags.pages_id = pages.id INNER JOIN tags ON tags.id = pages_tags.tags_id Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
