Image tagging database

[sanmadjack]

Okay I'm working on a small tag-based image gallery thing, and I've hit a snag. The table is 2 columns, one with a hash identifying an image and the other being a single tag. The following:

 

 

SELECT t1.tag, COUNT(t1.tag) AS TagCount FROM tags AS t1 JOIN tags AS t2 ON t1.hash = t2.hash WHERE (t2.tag = 'test_the_first'  AND t1.tag <> 'test_the_first') GROUP BY t1.tag ORDER By TagCount DESC;

 

Returns a list of all the tags that are also on images with the tag test_the_first along with a count of the tags occurrences, but does not return the tag test_the_first itself. It works great, but want to be able to search by multiple tags so that I can get all the tags that are also on images that have two particular tags. Something like this:

 

SELECT t1.tag, COUNT(t1.tag) AS TagCount FROM tags AS t1 JOIN tags AS t2 ON t1.hash = t2.hash WHERE (t2.tag = 'test_the_first'  AND t1.tag <> 'test_the_first') AND (t2.tag = 'test_the_second'  AND t1.tag <> 'test_the_second') GROUP BY t1.tag ORDER By TagCount DESC;

 

Any ideas?

[aschk]

That sounds like a good answer to your own question. Have you tried it?