SELECT  IF (FIND_IN_SET('6689', `T1`.`Crossed`) > 0, 1, 0) AS `Crossed_listing`,  `T1`.*, `T3`.`Key` AS `Key`, `T3`.`Type` AS `Listing_type`, `T3`.`Parent_keys`, `T3`.`Parent_IDs`, `T3`.`Path` AS `Path`, IF (`T1`.`country` = 'countries_spain' AND `T1`.`country_level1` = 'countries_spain_catalonia' AND `T1`.`country_level2` = 'countries_spain_catalonia_ger' , 1, 0) AS `mf_filter_match`, IF(`T1`.`country` = 'countries_spain' AND `T1`.`country_level1` = 'countries_spain_catalonia' AND `T1`.`country_level2` = 'countries_spain_catalonia_ger' , 0, (3956 * 2 * ASIN(SQRT(POWER(SIN((42.4115 - `T1`.`Loc_latitude`) * 0.0174532925 / 2), 2) + COS(42.4115 * 0.0174532925) * COS(`T1`.`Loc_latitude` * 0.0174532925) * POWER(SIN((1.8443 - `T1`.`Loc_longitude`) * 0.0174532925 / 2), 2))))) AS `mf_distance`, IF(`T1`.`Date` != `T1`.`HighlightDate` AND `T1`.`HighlightDate` != '0000-00-00 00:00:00', '1', '0') as 'is_highlighted', IF (`T1`.`event_type` = '1',  IF (UNIX_TIMESTAMP( `T1`.`event_date` ) < UNIX_TIMESTAMP(DATE(NOW())), 1, 0),  IF (UNIX_TIMESTAMP( `T1`.`event_date_multi` ) < UNIX_TIMESTAMP(DATE(NOW())), 1, 0)  ) AS `Event_passed`, IF(`T1`.`Featured_date` IS NOT NULL, '1', '0') `Featured` FROM `{db_prefix}listings` AS `T1` LEFT JOIN `{db_prefix}categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` WHERE `T1`.`Status` = 'active' AND (`T1`.`Category_ID` = '6689' OR (FIND_IN_SET('6689', `T1`.`Crossed`) > 0) OR FIND_IN_SET('6689', `T3`.`Parent_IDs`) > 0 ) AND ((`T1`.`country` = 'countries_spain' AND `T1`.`country_level1` = 'countries_spain_catalonia' AND `T1`.`country_level2` = 'countries_spain_catalonia_ger') OR (3956 * 2 * ASIN(SQRT( POWER(SIN((42.4115 - `T1`.`Loc_latitude`) * 0.0174532925 / 2), 2) + COS(42.4115 * 0.0174532925) * COS(`T1`.`Loc_latitude` * 0.0174532925) * POWER(SIN((1.8443 - `T1`.`Loc_longitude`) * 0.0174532925 / 2), 2))) <= 124.27423844747)) AND IF (`T1`.`event_type` = '1',  UNIX_TIMESTAMP( `T1`.`event_date` ) >= 1787266800, UNIX_TIMESTAMP( `T1`.`event_date_multi` ) >= 1787266800)  AND `T1`.`Sub_status` <> 'invisible' ORDER BY `mf_filter_match` DESC, `mf_distance` ASC, `Featured` DESC , `event_date` ASC LIMIT 0, 24 Array
(
)