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 76
2 24
3 24
4 12
5 3
6 5
7 1
8 2
9 1
10 1
13 1
14 1

No of Applicants attending N events

Number_Of_Events Count
1 35
2 6
3 2
5 1
7 1

No of Others attending N events

Number_Of_Events Count
1 15