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