SELECT 
COUNT(*) AS countresult 
 
FROM 
ac_user AS u LEFT JOIN tb_uvs AS uvs ON 
(u.ac_u_pk_id = uvs.ac_u_fk_id) LEFT JOIN tb_vs AS v ON  
(uvs.tb_v_fk_id = v.tb_v_pk_id) 
 
WHERE 
( 
u.ac_u_alias LIKE 'tester%'     OR 
uvs.tb_uvs_alias LIKE 'tester%'     
)                       AND  
uvs.tb_uvs_visible  = 0 AND 
v.tb_v_status       = 0 AND 
u.tb_c_fk_id        = 1 
 
GROUP BY  
u.ac_u_pk_id 

SELECT COUNT( DISTINCT u.ac_u_pk_id) AS countresult 
 
FROM      ac_user AS u  
LEFT JOIN tb_uvs  AS uvs ON uvs.ac_u_fk_id = u.ac_u_pk_id   
LEFT JOIN tb_vs   AS v   ON uvs.tb_v_fk_id = v.tb_v_pk_id 
 
WHERE (u.ac_u_alias LIKE 'tester%' OR uvs.tb_uvs_alias LIKE 'tester%') 
AND uvs.tb_uvs_visible  = 0 
AND v.tb_v_status       = 0 
AND u.tb_c_fk_id        = 1 
 
ORDER BY u.ac_u_pk_id