Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '} ) ) * cos( radians( exp_channel_data.field_id_78 ) ) ' at line 1

SELECT exp_channel_data.entry_id, exp_channel_titles.url_title, exp_channel_titles.entry_id, exp_channel_titles.status, exp_channel_images.entry_id, exp_channel_images.filename, exp_channel_images.extension, exp_channel_titles.title, exp_channel_data.field_id_70, exp_channel_data.field_id_78, exp_channel_data.field_id_79, exp_channel_data.field_id_154, ( 6371 * acos( cos( radians( {lat1} ) ) * cos( radians( exp_channel_data.field_id_78 ) ) * cos( radians( exp_channel_data.field_id_79 ) - radians( {lon1} ) ) + sin( radians( {lat1} ) ) * sin( radians( exp_channel_data.field_id_78 ) ) ) ) AS distance FROM exp_channel_data INNER JOIN exp_channel_titles ON exp_channel_data.entry_id=exp_channel_titles.entry_id INNER JOIN exp_channel_images ON exp_channel_data.entry_id=exp_channel_images.entry_id HAVING (distance BETWEEN 0.01 AND 50) AND exp_channel_titles.status = 'open' ORDER BY distance LIMIT 0, 20

Filename: modules/query/mod.query.php

Line Number: 53