select sum(count) from(
SELECT count(*) count from wcr_r where unicalId=xand storeId=x and status in (3,4,5)
UNION
SELECT count(*) count from wcr_u where unicalId=x and storeId=x and status in (3,4,5)
UNION
SELECT count(*) count from wcr_s where unicalId=x and storeId=x and status in (3,4,5)
UNION
SELECT count(*) count from wcr_f where unicalId=x and storeId=x and status in (3,4,5)
UNION
SELECT count(*) count from wcr_i where unicalId=x and storeId=x and status in (3,4,5)
UNION
SELECT count(*) count from wcr_o where unicalId=x and storeId=x and status in (3,4,5)
) a