In my site the posts content is always the name of a school, so if I search for Chicago I get a lot of posts with different schools as content. What I want to do is to get the Schools with the most posts, so I could display this somewhere:
School A - 4 School B - 3 School C - 2 School D - 2
(The number at the right is the number of posts the school has)
So what I need to get the most repeated post contents from a particular search including the ones that don't appear in first results page.
I don't know how complicated it can be so if there is no simple way I would be very grateful for just being pointed towards the right direction, so I later figure out how to do it. My site is made with wordpress and the posts are on a SQL database. Please ask if it's not clear or for any more info.