I'm still working on the mobile app, but after looking through the SQL backend, I can't find where the category information is found.
The obvious place would be in the events table, but all the event_category_id fields are empty. I see event-categories are listed in wp_term_taxonomy table - how can I grab events by category from an SQL query?
I've seen someone offering this code,
SELECT * FROM wp_em_events WHERE event_category_id = 1 ORDER BY event_start_date ASC
But, obviously with my event_category_id's being NULL, I'm wondering how I can pull this information so I can push it out for mobile use?