spring_boot_repository_ClienteRepository5.java

public interface TimeRepository extends JpaRepository<Time, Long> {

    @Query(value = "SELECT t.* FROM time t "
		    + "cross JOIN boleiro_time bt, boleiro b "
		    + "WHERE t.id = bt.id_time "
		    + "AND bt.id_boleiro = b.id "
		    + "AND b.id_usuario = ?1 "
		    + "AND (t.id_gerente = ?1 "
		    + "  OR bt.id_boleiro IN (SELECT b2.id FROM boleiro b2 WHERE b2.id_usuario= ?1)"
		    + ")", nativeQuery = true)
    List<Time> findByIdUsuario(Long pIdUsuario);
}