SELECT COUNT(`id`)
             FROM   ( (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_AstroPay) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` ,`iban` ,`account_owner` ,`sandbox` ,`processor`
                    FROM transaction_bank_withdraw) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_cepbank) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_cmtcuzdan) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_community_banking) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_faturapay) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_finrax) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_instant_banking) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_instant_papara) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` ,`processor`
                    FROM transaction_instant_papara_withdraw) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_maldopay_banking) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` , '' AS `serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_mkarekod) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_papara) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` ,`processor`
                    FROM transaction_paparapay) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_paykasa) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_paykwik) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` ,`processor`
                    FROM transaction_payznet_checkout) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_piiupay_papara) UNION ALL (SELECT `id` ,`referenceOrderId` ,`serviceTransactionId` ,`serviceId` ,`codeId` ,`brandId` ,`player_id` ,`dateCreated` ,`dateUpdated` ,`type` ,`amount` ,`currencyCode` ,`serviceData1` , '' AS `iban` , '' AS `account_owner` ,`sandbox` , '' AS `processor`
                    FROM transaction_rocketpay) )tmp
             WHERE  (dateCreated BETWEEN '2020-01-11' AND '2020-01-18') AND brandId=694 AND sandbox=0