example with NinjaTables Pro
Thinking I can generate some simple tabled reports protected by Role with NinjaTables Pro…
How can I find and define the other calls I want to make to MySQL to get fields shown throughout EE?
Ticket Details Sold Quantity
Better yet, how can I find these MySQL table and column?
ACF seminar_number would be in wp_postmeta, in Max number is a custom field, it will be in wp_postmeta too.
event title would be in wp_posts
ticket details, sold, and quantity would all be in wp_esp_ticket.
If you have phpmyadmin installed on your server you can browse the tables and columns.