SELECT MAX(`price`) FROM `ce9cq_rseventspro_tickets` WHERE `ide` IN ( SELECT * FROM (SELECT `e`.`id` FROM `ce9cq_rseventspro_events` AS `e` LEFT JOIN `ce9cq_rseventspro_locations` AS `l` ON `l`.`id` = `e`.`location` LEFT JOIN `ce9cq_rseventspro_tickets` AS `tickets` ON `tickets`.`ide` = `e`.`id` WHERE 1 AND (`e`.`completed` = '1' AND `e`.`published` IN (1,3) AND `e`.`id` IN (SELECT `tx`.`ide` FROM `ce9cq_rseventspro_taxonomy` AS `tx` LEFT JOIN `ce9cq_categories` AS `c` ON `c`.`id` = `tx`.`id` WHERE `c`.`id` IN (8,9,10,11) AND `tx`.`type` = 'category' AND `c`.`extension` = 'com_rseventspro' AND `c`.`access` IN (1,5)) AND ( (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` >= '2025-12-15 03:00:00' AND `e`.`end` <= '2025-12-22 02:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` >= '2025-12-15 03:00:00' AND `e`.`start` <= '2025-12-22 02:59:59' AND `e`.`end` >= '2025-12-22 02:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` <= '2025-12-15 03:00:00' AND `e`.`end` >= '2025-12-15 03:00:00' AND `e`.`end` <= '2025-12-22 02:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` <= '2025-12-15 03:00:00' AND `e`.`end` >= '2025-12-22 02:59:59') OR (`e`.`end` = '0000-00-00 00:00:00' AND `e`.`start` >= '2025-12-15 03:00:00' AND `e`.`start` <= '2025-12-22 02:59:59') ) ) OR (`e`.`sid` = 'g1haqurpi9bg6ndrru2g8uchd5' AND `e`.`published` IN (0,1,3) AND `e`.`completed` IN (0,1) AND `e`.`id` IN (SELECT `tx`.`ide` FROM `ce9cq_rseventspro_taxonomy` AS `tx` LEFT JOIN `ce9cq_categories` AS `c` ON `c`.`id` = `tx`.`id` WHERE `c`.`id` IN (8,9,10,11) AND `tx`.`type` = 'category' AND `c`.`extension` = 'com_rseventspro' AND `c`.`access` IN (1,5)) AND ( (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` >= '2025-12-15 03:00:00' AND `e`.`end` <= '2025-12-22 02:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` >= '2025-12-15 03:00:00' AND `e`.`start` <= '2025-12-22 02:59:59' AND `e`.`end` >= '2025-12-22 02:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` <= '2025-12-15 03:00:00' AND `e`.`end` >= '2025-12-15 03:00:00' AND `e`.`end` <= '2025-12-22 02:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` <= '2025-12-15 03:00:00' AND `e`.`end` >= '2025-12-22 02:59:59') OR (`e`.`end` = '0000-00-00 00:00:00' AND `e`.`start` >= '2025-12-15 03:00:00' AND `e`.`start` <= '2025-12-22 02:59:59') )) GROUP BY `e`.`id` ORDER BY `e`.`start` DESC ) AS subquery)

Mapa de eventos