Attempting to pull all submissions from MySQL by entry_id (which we use everyday on front end) but confused by multiple ID, entry_id columns and rows in both in wp_gf_entry and wp_gf_entry_meta.
I’m clearly no DBA , but when browsing tables it appears that each entry has multiple entry IDs. How best to pull only those rows that correspond to entry IDs used by GF, GV?
The wp_gf_entry table has an id column that is the entry ID. To get all entry meta associated with an entry, you would join on the entry_id column in the wp_gf_entry_meta column.
Depending on your needs though, you might consider using the GFAPI::get_entries() function which is very performant and returns a “complete” entry object.