fis where without left joins