SELECT NULL AS 'country_id', '' AS 'country', COUNT(rider.user_id) AS 'count' FROM user JOIN rider ON user.user_id = rider.user_id WHERE country_id IS NULL OR country_id = '' AND (u.user_id in (SELECT rider_id FROM `comp-rider` group by rider_id) OR `last_login` > `member_since`) GROUP BY 'country'

The Rider:

Rider (9531)   →   Without given nationality (0)   →   ,


no image
Personal Data:
Name:
Gender: female
Age:
Country:
 
Favourite trick:
Club:
Home Cable:
Started Riding:
First Invert:
Sponsors:
2019 Best Results:
PosCompetitionCategoryDiscipline
2018 Best Results:
PosCompetitionCategoryDiscipline
n.b. some results may not be included in current rankings.
-= The official website of the EAME Cable Wakeboard Council and the Cable Wakeboard World Council =-