A Database Error Occurred

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 '`NULL` ORDER BY `em`.`event_interval` ASC' at line 11

SELECT *, ( 6371 * acos( cos( radians( -33.3520881 ) ) * cos( radians( e.latitude ) ) * cos( radians( e.longitude ) - radians( 149.9681453 ) ) + sin( radians( -33.3520881 ) ) * sin( radians( e.latitude ) ) ) ) AS distance FROM `events` as `e` JOIN `event_metadata` as `em` ON `em`.`event_id`=`e`.`event_id` JOIN `event_type_relation` as `t` ON `t`.`event_id`=`e`.`event_id` JOIN `event_type` as `ty` ON `ty`.`event_type_id`=`t`.`event_type_id` WHERE (`ty`.`event_type_id` = 39 or `ty`.`event_type_id` = 138) AND `ty`.`exclude_advanced_search` = '0' AND `exclusive` =0 AND `club_code` != 1 GROUP BY `e`.`event_name`, `e`.`event_name` HAVING `distance` < `IS` `NULL` ORDER BY `em`.`event_interval` ASC

Filename: models/Search_model.php

Line Number: 660