Extracting users from a series of events

So its not the same event - is a sequence of 'unrelated' events with the same title?

That isn't trivial I'm afraid. Assuming they are not repeating events with separate signups per event

Something like this MAY

SELECT atdees.*, atdce.id, det.evdet_id FROM onjqe_jev_attendees as atdees

INNER JOIN onjqe_jev_attendance as atdce on atdees.at_id = atdce.id

INNER JOIN onjqe_jevents_vevent as evt on atdce.ev_id = evt.ev_id AND atdce.allrepeats = 1

INNER JOIN onjqe_jevents_vevdetail as det on evt.detail_id = det.evdet_id

WHERE det.summary = 'test'

Yes, they are not the same event, but same title. Nope, they aren't repeating events

Will try and let you know. Thank you.

Thanks Geraint.

If I wanted to extract from a postcode range?

Unfortunately the custom field data for each attendee is stored in a combined text field in JSON format so extracting entries based on a range of values of a specific field is going to be very hard (unless you are using MySQL 5.7+) - even then it would be slow and only work if you use the same session template for each of these events.

oh..ok.. Thank you. We'll have to think of ways to do data extraction, I guess....

SELECT atdees.*, atdce.id, det.evdet_id FROM onjqe_jev_attendees as atdees
INNER JOIN onjqe_jev_attendance as atdce on atdees.at_id = atdce.id
INNER JOIN onjqe_jevents_vevent as evt on atdce.ev_id = evt.ev_id AND atdce.allrepeats = 1
INNER JOIN onjqe_jevents_vevdetail as det on evt.detail_id = det.evdet_id
WHERE det.summary = 'test'

The thing with this code is that....it extracts from the entire system, all event creators. If I wanted it from just one particular event creator? Possible?

where evt.created_by = 12