ERROR - 2025-11-12 11:26:58 --> Get Sql Query Live filter count Topup  Report :  SELECT COUNT(id) AS total_count_topup_data
FROM `oz_pg_trnx_details`
WHERE DATE_FORMAT(cust_txn_initiate_datetime,'%Y-%m-%d') = '2025-11-12'
AND `cust_id` = '186'
ERROR - 2025-11-12 11:27:56 --> Get Sql Query history filter All payout Report :  SELECT `order_id`, `agent_id`, `distributor_id`, `amount`, `time`, `status`, `FUNDTRANSNO`
FROM `oz_money_transfer_history`
WHERE DATE_FORMAT(time,'%Y-%m-%d') >= '2025-09-11'
AND DATE_FORMAT(time,'%Y-%m-%d') <= '2025-11-11'
AND `agent_id` = '186'
ORDER BY `time` DESC
 LIMIT 10
ERROR - 2025-11-12 12:04:39 --> Get Sql Query archive filter count payout  Report :  SELECT COUNT(id) AS total_count_fund_data
FROM `oz_money_transfer_archive`
WHERE `agent_id` = '186'
ERROR - 2025-11-12 12:04:39 --> Get Sql Query archive filter All payout Report :  SELECT `id`, `order_id`, `agent_id`, `distributor_id`, `info`, `status`, `time`, `update_time`, `amount`, `com_amount`, `cashback`, `retailer_com`, `retailer_gst`, `retailer_tds`, `distributor_com`, `distributor_gst`, `distributor_tds`, `api_com`, `api_gst`, `admin_com`, `resp`, `ip`, `callbackresp`, `checksum`, `payout_id`, `FUNDTRANSNO`, `payout_partner`, `txn_mode`, `merchant_info`
FROM `oz_money_transfer_archive`
WHERE `agent_id` = '186'
ORDER BY `id` DESC
 LIMIT 10
ERROR - 2025-11-12 12:14:26 --> Get Sql Query archive filter count payout  Report :  SELECT COUNT(id) AS total_count_fund_data
FROM `oz_money_transfer_archive`
WHERE `order_id` = '43543543fdgfdg'
AND `agent_id` = '186'
ERROR - 2025-11-12 12:21:44 --> Get Sql Query Archive filter Count transaction Report :  SELECT COUNT(txn_id) AS total_count_data
FROM `oz_money_trnx_archive`
WHERE `txn_agentid` = '186'
ERROR - 2025-11-12 12:21:44 --> Get Sql Query Archive filter All transaction Report :  SELECT `txn_id`, `txn_order_id`, `txn_agentid`, `txn_opbal`, `txn_crdt`, `txn_dbdt`, `txn_clbal`, `txn_checktime`, `txn_type`, `txn_time`, `txn_date`, `txn_ip`, `txn_comment`
FROM `oz_money_trnx_archive`
WHERE `txn_agentid` = '186'
ORDER BY `txn_id` DESC
 LIMIT 10
ERROR - 2025-11-12 12:28:34 --> Get Sql Query Archive filter Count transaction Report :  SELECT COUNT(txn_id) AS total_count_data
FROM `oz_money_trnx_archive`
WHERE `txn_type` = '984535fdgfdg'
AND `txn_agentid` = '186'
ERROR - 2025-11-12 12:34:15 --> Get Sql Query Archive filter Count transaction Report :  SELECT COUNT(txn_id) AS total_count_data
FROM `oz_money_trnx_archive`
WHERE `txn_agentid` = '186'
ERROR - 2025-11-12 12:34:15 --> Get Sql Query Archive filter All transaction Report :  SELECT `txn_id`, `txn_order_id`, `txn_agentid`, `txn_opbal`, `txn_crdt`, `txn_dbdt`, `txn_clbal`, `txn_checktime`, `txn_type`, `txn_time`, `txn_date`, `txn_ip`, `txn_comment`
FROM `oz_money_trnx_archive`
WHERE `txn_agentid` = '186'
ORDER BY `txn_id` DESC
 LIMIT 10
ERROR - 2025-11-12 14:08:38 --> Get Sql Query Archive filter Count transaction Report :  SELECT COUNT(txn_id) AS total_count_data
FROM `oz_money_trnx_archive`
WHERE `txn_agentid` = '186'
ERROR - 2025-11-12 14:08:38 --> Get Sql Query Archive filter All transaction Report :  SELECT `txn_id`, `txn_order_id`, `txn_agentid`, `txn_opbal`, `txn_crdt`, `txn_dbdt`, `txn_clbal`, `txn_checktime`, `txn_type`, `txn_time`, `txn_date`, `txn_ip`, `txn_comment`
FROM `oz_money_trnx_archive`
WHERE `txn_agentid` = '186'
ORDER BY `txn_id` DESC
 LIMIT 10
ERROR - 2025-11-12 14:09:01 --> Get Sql Query Archive filter Count transaction Report :  SELECT COUNT(txn_id) AS total_count_data
FROM `oz_money_trnx_archive`
WHERE `txn_agentid` = '186'
ERROR - 2025-11-12 14:09:01 --> Get Sql Query Archive filter All transaction Report :  SELECT `txn_id`, `txn_order_id`, `txn_agentid`, `txn_opbal`, `txn_crdt`, `txn_dbdt`, `txn_clbal`, `txn_checktime`, `txn_type`, `txn_time`, `txn_date`, `txn_ip`, `txn_comment`
FROM `oz_money_trnx_archive`
WHERE `txn_agentid` = '186'
ORDER BY `txn_id` DESC
 LIMIT 10