Guess Who This Is
  1. Home
    1. Home
    2. About
    3. Site FAQs
    4. Synonyms
    5. Recent Entries
    6. Connect …
      1. RSS Feed
      2. Feedback
  2. Search
    1. Names
    2. Brief Facts
    3. Titles, Groups
    4. Born …
      1. Today
      2. Month and Day
      3. Month and Year
      4. Year
    5. Died …
      1. Month and Day
      2. Month and Year
      3. Year
      4. Same Event
    6. Categories
  3. People
    1. Birth Place
    2. Zodiac Sign
    3. Space Missions
    4. Halls of Fame
      & Awards …
      1. All Halls/Awards
      2. Select a Hall/Award
      3. Search for Halls/Awards
  4. Teams
    1. Baseball
    2. Basketball
    3. Football
    4. Hockey
    5. Soccer
    6. Rugby
  5. Music Groups
    1. Rap/Hip-hop
    2. Country
    3. Punk
    4. Metal
    5. Bluegrass
    6. Folk
DisplayRealNames: get MaxRows count
SELECT DISTINCT COUNT(*) AS cnt FROM realnames A,titlenames T WHERE A.showname = T.showname AND titlename='Saint John's University' AND hiphop=8 AND titlekind LIKE 'team'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's University' AND hiphop=8 AND titlekind LIKE 'team'' at line 1