Not So Simple Query - Help

[jandrox_ox]

Here is the design of the database (small, don't be afraid to look):
http://citizensforsocialjustice.com/wiki/images/design.jpg
*Organization has and belongs to many keywords

What I am trying to do: given an array of keywords, search all organizations that belong to at least 1 or those keywords BUT return the result in hit order (the organization that matched with the most keywords comes first, then the next one, and so on...).

[walterquez]

jandrox_ox;10896918 wrote:

What I am trying to do: given an array of keywords, search all organizations that belong to at least 1 or those keywords BUT return the result in hit order (the organization that matched with the most keywords comes first, then the next one, and so on...).

SELECT o.name, COUNT/B count
FROM organizations o
JOIN keywords_organizations ko ON ko.organization_id = o.id
GROUP BY o.id
ORDER BY count DESC