SELECT sum( s ) s, sum( ss ) ss, sum( sss ) sss, sum( ssss ) ssss, sum( sssss ) sssss
FROM (

SELECT NULL s, NULL ss, NULL sss, NULL ssss, NULL sssss
UNION
SELECT NULL s, count( id ) ss, NULL sss, NULL ssss, NULL sssss
FROM mp_indexing_batch a
JOIN demoas.main b ON a.fil_no = b.fil_no
WHERE date( entry_dt ) <= curdate( )
AND branch = '1'
AND clean_file_dt = '0000-00-00 00:00:00'
AND entry_dt != '0000-00-00 00:00:00'
AND process_id = '3'
UNION
SELECT NULL s, NULL ss, count( id ) sss, NULL ssss, NULL sssss
FROM mp_indexing_batch a
JOIN demoas.main b ON a.fil_no = b.fil_no
WHERE date( clean_file_dt ) <= curdate( )
AND branch = '1'
AND indexing_com_date = '0000-00-00 00:00:00'
AND clean_file_dt != '0000-00-00 00:00:00'
AND process_id = '3'
UNION
SELECT NULL s, NULL ss, NULL sss, count( id ) ssss, NULL sssss
FROM mp_indexing_batch a
JOIN demoas.main b ON a.fil_no = b.fil_no
WHERE date( indexing_com_date ) <= curdate( )
AND branch = '1'
AND pdf_generate_date = '0000-00-00 00:00:00'
AND indexing_com_date != '0000-00-00 00:00:00'
AND process_id = '3'
UNION
SELECT NULL s, NULL ss, NULL sss, NULL ssss, count( id ) sssss
FROM mp_indexing_batch a
JOIN demoas.main b ON a.fil_no = b.fil_no
WHERE rejection_date != '0000-00-00 00:00:00'
AND allowed_date = '0000-00-00 00:00:00'
AND branch = '1'
AND process_id = '3'
)zz