Tu guía de putas
SELECT DISTINCT `a`.`idanuncio`, `a`.`codsitio`, `a`.`titulo`, `a`.`descripcion`, (CASE WHEN a.telefono IS NULL AND s.idagencia IS NOT NULL AND idagencia<>0 THEN busca_propiedad_sitio(s.idagencia,"telefono") ELSE a.telefono END) AS `telefono`, `s`.`fotopral` FROM `anuncios` AS `a` INNER JOIN `zonas` AS `z` ON a.zona = z.provincia INNER JOIN `sitios` AS `s` ON a.codsitio = s.codsitio WHERE (z.zona="Cassa-de-La-Selva") AND (a.fechafin >="2013-06-19") AND (a.tipo="Destacado") AND (a.tiposexo="Chicas" OR a.tiposexo IS NULL OR a.tiposexo="" )