If you execute the generated SQL outside of Grafana does it return a result?
You can also check the raw data that Grafana returns from MySQL using the network tab in the Chrome Developer Tools:
https://community.grafana.com/t/how-to-troubleshoot-metric-query-issues/50/2