Sql Query Hibernate

SELECT
        fraud.identity,
        fraud.logcase,
        fraud.fraudIn,
        userFraud.nickName,
        userRigged.nickName,
        keyword.name,
        bankInformation.accountHolderDeposit,
        bankInformation.agency,
        bankInformation.accountNumber,
        bank.bankName 
    FROM
        fraud fraud 
    LEFT JOIN
        bankInformation bankInformation 
            ON fraud.bankInformationIdentity = bankInformation.identity 
    INNER JOIN
        bank bank 
            ON bankInformation.bankNameIdentity = bank.identity 
    LEFT JOIN
        keyword keyword 
            ON fraud.keyWordIdentity = keyword.identity 
    INNER JOIN
        users userFraud 
            ON fraud.fraudsterIdentity = userFraud.identity 
    INNER JOIN
        users userRigged 
            ON fraud.riggedIdentity = userRigged.identity 
    INNER JOIN
        product product 
            ON fraud.productIdentity = product.identity 
    LEFT JOIN
        city citySendProduct 
            ON product.productCityIdentity = citySendProduct.identity 
    LEFT JOIN
        state stateSendProduct 
            ON citySendProduct.cityStateIdentity = stateSendProduct.identity 
    LEFT JOIN
        payment payment 
            ON product.paymentIdentity = payment.identity 
    LEFT JOIN
        city cityPayment 
            ON payment.paymentCityIdentity = cityPayment.identity 
    LEFT JOIN
        state statePayment 
            ON cityPayment.cityStateIdentity = statePayment.identity 
    WHERE
        fraud.statusFraud = 'C' 
        AND fraud.typeFraud = 'V' 
        AND userFraud.nickName LIKE '%%' 
        AND bankInformation.accountHolderDeposit LIKE '%%' 
        AND bankInformation.accountNumber LIKE '%%' 
        AND bankInformation.agency = 1945