SELECT rp.regatta_id FROM regatta_page rp 
    JOIN regatta r ON r.regatta_id = rp.regatta_id
    WHERE (rp.regatta_id = 325 OR rp.short_url = '325') AND r.is_active = 1no regatta found