
            SELECT  COUNT(*) AS rowsQty 
            FROM transaction 
            INNER JOIN users ON users.id = transaction.user_id
            INNER JOIN accounts ON accounts.id = transaction.account
            LEFT JOIN customer ON customer.id = transaction.customer_id
            LEFT JOIN provider ON provider.id = transaction.provider_id
            WHERE transaction.deleted = '0'  AND (transaction.entity LIKE LOWER('%%') OR transaction.account LIKE LOWER('%%') ) ;