I have some sql I use to pull some reports out from the db tables.
SELECT pziou_rg_form.id, pziou_rg_form.title, pziou_rg_lead.date_created, pziou_rg_lead.ip, pziou_rg_lead.source_url, pziou_rg_lead_detail.field_number, pziou_rg_lead_detail.<code>value</code> FROM pziou_rg_form INNER JOIN pziou_rg_lead ON pziou_rg_form.id = pziou_rg_lead.form_id INNER JOIN pziou_rg_lead_detail ON pziou_rg_lead.id = pziou_rg_lead_detail.lead_id
Works well, but obviously the fields are only identified by the field number.
How/Where can I get that data?
I see the _meta table filled with serialized data, but I'm having a bit of trouble understanding how it's formatted. It looks like a multidimensional JSON array.