Can't tell you how much I appreciate the reply. Pulling my hair out for a couple of days. I had tried GROUP BY before and got an error. When I copied and pasted your query I got a similar error:
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 'GROUP BY venues.venueID' at line 2
This happens whenever I try to add GROUP BY. Any ideas?