MySQL query with 2 COUNT() of other tables with where conditions
- by Isern Palaus
Hello,
I've a table called sports that contains a list of list of sports, other called seasons that contains the seasons for a specific sport and competitions that have the competitions of a specific sport and season.
I need one MySQL query to print the list of sports with how much seasons and competitions has each. My tables structure:
sports
…