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