...AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '49.18351590991' AND '49.36369609009'...
The meta_value field is of the type LONGTEXT (hence the CAST). The value I should be retrieving is 49.2843030. However, nothing is retrieved. If I alter the query to the following, it does work:
...AND CAST(mt1.meta_value AS DECIMAL) BETWEEN '49' AND '49.36369609009'...