select tags.id,tags.tag, count(posts_tags.post_id) as c1,
count(images_tags.post_id) as c2, count(events_tags.post_id)
from tags, posts_tags, images_tags, events_tags
where tags.id=posts_tags.tag_id and tags.id=images_tags.tag_id and
tags.id=events_tags.tag_id
group by (tags.id);


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to