Any query

Great plugin. I have a question for you: can you add the option to create a free query typed by the user? Like a query below.

Please, help me.

Thx

Roberto ([email protected])

select date_format(dataprenotazione,’%d-%m-%Y’) as “Data Prenotazione”, orainizio as “Ora Inizio
“, orafine as “Ora Fine
(esclusa)”, (orafine – orainizio) as “N° ore”, user_login as “Prenotato da”, note from avwp_posts, avwp_prenotazioni_spazi, avwp_users where avwp_posts.post_type=”spazi” AND avwp_prenotazioni_spazi.idspazio=avwp_posts.id AND avwp_users.id=avwp_prenotazioni_spazi.idutente AND (orafine – orainizio) > 0 AND avwp_prenotazioni_spazi.idspazio=5 AND dataprenotazione BETWEEN IF( MONTH(CURDATE()) >= 1 AND MONTH(CURDATE()) <= 8, CONCAT(YEAR(CURDATE()) – 1,’-09-01′), CONCAT(YEAR(CURDATE()),’-09-01′) ) AND IF( MONTH(CURDATE()) >= 1 AND MONTH(CURDATE()) <= 8, CONCAT(YEAR(CURDATE()),’-09-01′), CONCAT(YEAR(CURDATE())+1,’-09-01′) )