Struggling with Variables

I’m struggling to insert variables into my SQL query. I have this long query that works:


SELECT
wp_audit_trail.*,
LENGTH(t1.term_order) AS neonatal,
LENGTH(t2.term_order) AS obstetrical,
LENGTH(t3.term_order) AS pediatrics,
u1.user_email,
u1.user_login,
m1.meta_value AS firstname,
m2.meta_value AS lastname,
m3.meta_value AS country,
m4.meta_value AS state,
m5.meta_value AS county,
m6.meta_value AS city,
m7.meta_value AS zip,
m8.meta_value AS employer,
m9.meta_value AS credentials,
m10.meta_value AS profession,
m11.meta_value AS specialty,
m12.meta_value AS primarypractice,
m13.meta_value AS dhs,
m14.meta_value AS primaryhospital,
m15.meta_value AS secondhospital,
m16.meta_value AS otherhospital
FROM wp_audit_trail
LEFT JOIN wp_term_relationships t1 ON (t1.object_id=wp_audit_trail.item_id AND t1.term_taxonomy_id = '4')
LEFT JOIN wp_term_relationships t2 ON (t2.object_id=wp_audit_trail.item_id AND t2.term_taxonomy_id = '5')
LEFT JOIN wp_term_relationships t3 ON (t3.object_id=wp_audit_trail.item_id AND t3.term_taxonomy_id = '6')
INNER JOIN wp_users u1 ON wp_audit_trail.user_id = u1.ID
LEFT JOIN wp_usermeta m1 ON (m1.user_id = u1.ID AND m1.meta_key = 'first_name')
LEFT JOIN wp_usermeta m2 ON (m2.user_id = u1.ID AND m2.meta_key = 'last_name')
LEFT JOIN wp_usermeta m3 ON (m3.user_id = u1.ID AND m3.meta_key = 'country')
LEFT JOIN wp_usermeta m4 ON (m4.user_id = u1.ID AND m4.meta_key = 'user_state')
LEFT JOIN wp_usermeta m5 ON (m5.user_id = u1.ID AND m5.meta_key = 'user_county')
LEFT JOIN wp_usermeta m6 ON (m6.user_id = u1.ID AND m6.meta_key = 'user_city')
LEFT JOIN wp_usermeta m7 ON (m7.user_id = u1.ID AND m7.meta_key = 'user_zip')
LEFT JOIN wp_usermeta m8 ON (m8.user_id = u1.ID AND m8.meta_key = 'user_employer')
LEFT JOIN wp_usermeta m9 ON (m9.user_id = u1.ID AND m9.meta_key = 'user_credentials')
LEFT JOIN wp_usermeta m10 ON (m10.user_id = u1.ID AND m10.meta_key = 'user_profession')
LEFT JOIN wp_usermeta m11 ON (m11.user_id = u1.ID AND m11.meta_key = 'user_specialty')
LEFT JOIN wp_usermeta m12 ON (m12.user_id = u1.ID AND m12.meta_key = 'primary_practice')
LEFT JOIN wp_usermeta m13 ON (m13.user_id = u1.ID AND m13.meta_key = 'user_dhs_yn')
LEFT JOIN wp_usermeta m14 ON (m14.user_id = u1.ID AND m14.meta_key = 'primary_hospital')
LEFT JOIN wp_usermeta m15 ON (m15.user_id = u1.ID AND m15.meta_key = 'secondary_hospital')
LEFT JOIN wp_usermeta m16 ON (m16.user_id = u1.ID AND m16.meta_key = 'other_hospital')
WHERE wp_audit_trail.operation = 'template_redirect' AND (wp_audit_trail.happened_at BETWEEN '2014-10-01' AND '2014-11-01')


I would like to make the dates variables for filtering. I just don’t quite know what the settings would be.

Thank you,

https://wordpress.org/plugins/exports-and-reports/