SELECT q.question_tax_number TIN, q.question_tax_country TIN_country,
       b.BALANCE,
       u.BALANCE as BALANCE_CURRENT, u.CREDIT, u.EQUITY,
       u.LOGIN, u.`GROUP`, 'CLASSIC' as server, u.COUNTRY,
       c.id user_id, c.username, c.full_name, c.email, c.client_uid, c.country, c.city, c.address, c.address2, c.birth_date, c.reg_date, c.ref_uid
FROM secure_mt_eu_classic_rserver.mt4_users u
JOIN sync_trading.`user` c ON c.client_uid = u.ID
JOIN sync_trading.user_questionnaire q ON q.user_id = c.id
LEFT JOIN secure_mt_eu_classic_rserver.mt4_daily b ON b.login = u.login AND time = '2016-12-30 23:59:59'
WHERE q.question_tax_number > 0 and c.`zone` = 2
AND c.full_name not like '#%'
UNION
SELECT q.question_tax_number TIN, q.question_tax_country TIN_country,
       b.BALANCE,
       u.BALANCE as BALANCE_CURRENT, u.CREDIT, u.EQUITY,
       u.LOGIN, u.`GROUP`, 'ECN' as server, u.COUNTRY,
       c.id user_id, c.username, c.full_name, c.email, c.client_uid, c.country, c.city, c.address, c.address2, c.birth_date, c.reg_date, c.ref_uid
FROM secure_mt_eu_ecn_rserver.mt4_users u
JOIN sync_trading.`user` c ON c.client_uid = u.ID
JOIN sync_trading.user_questionnaire q ON q.user_id = c.id
LEFT JOIN secure_mt_eu_ecn_rserver.mt4_daily b ON b.login = u.login AND time = '2016-12-30 23:59:59'
WHERE q.question_tax_number > 0 and c.`zone` = 2
AND c.full_name not like '#%'
UNION
SELECT q.question_tax_number TIN, q.question_tax_country TIN_country,
       b.BALANCE,
       u.BALANCE as BALANCE_CURRENT, u.CREDIT, u.EQUITY,
       u.LOGIN, u.`GROUP`, 'PLATINUM' as server, u.COUNTRY,
       c.id user_id, c.username, c.full_name, c.email, c.client_uid, c.country, c.city, c.address, c.address2, c.birth_date, c.reg_date, c.ref_uid
FROM secure_mt_eu_platinum_rserver.mt4_users u
JOIN sync_trading.`user` c ON c.client_uid = u.ID
JOIN sync_trading.user_questionnaire q ON q.user_id = c.id
LEFT JOIN secure_mt_eu_platinum_rserver.mt4_daily b ON b.login = u.login AND time = '2016-12-30 23:59:59'
WHERE q.question_tax_number > 0 and c.`zone` = 2
AND c.full_name not like '#%';