Stats

Error description: 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 'UNION Select 'Registered' as Title, count(*) as Count from eventAttendee where ' at line 2 SQL: Select 'Potential Attendees' as Title, count(*) as Count from eventPotentialAudience where No = UNION Select 'Registered' as Title, count(*) as Count from eventAttendee where No = UNION SELECT 'Members' as Title, Count(*) as Count FROM `eventAttendee` EA where EA.No = and EA.Source = 'M' UNION SELECT 'Applicants' as Title, Count(*) as Count FROM `eventAttendee` EA where EA.No = and EA.Source = 'A' UNION SELECT 'Potential New Members' as Title, Count(*) as Count FROM `eventAttendee` EA where EA.No = and EA.SourceNo = 0

All Events Stats

No of Members attending N events

No_Of_Events Count
1 81
2 27
3 19
4 7
5 5
6 4
7 2
8 1
10 1
12 1
13 1

No of Applicants attending N events

Number_Of_Events Count
1 33
2 6
3 2
4 1
7 1

No of Others attending N events

Number_Of_Events Count
1 14