SELECT
    InvoiceNo,
    NetAmountAbs,
    InvoiceDate
  FROM tblinvoice
  WHERE GrossAmountAbs >= 200
  GROUP BY InvoiceNo,
           NetAmountAbs,
           InvoiceDate
  HAVING COUNT(*) > 1
  AND SUM(CASE WHEN NetAmount_Doc >= 0 THEN 1 ELSE 0 END) > 1
  AND MIN(AccountNumber) != MAX(AccountNumber)
  AND MAX(GrossAmountAbs) != MIN(GrossAmountAbs)
  AND MAX(ImportID) = 2

[mysqld]
log_bin_trust_function_creators=1
datadir=E:/MariaDB 10.2.8
port=3306
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
innodb_buffer_pool_size=25000M
character-set-server=utf8
innodb_io_capacity=200
innodb_read_io_threads=64
innodb_thread_concurrency=0
innodb_write_io_threads=64
max_connections=1000
innodb_lock_wait_timeout=50
lower_case_table_names=2
event_scheduler=on
character-set-server=utf8
max_allowed_packet=100M
connect_timeout=10
innodb-log-file-size=96M
innodb_log_buffer_size=32M
[client]
port=3306
plugin-dir=C:/ProgramFiles/MariaDB 10.2/lib/plugin