MySQL连接查询使用count函数计算总数不正确

使用左连接查询数据，在查询字段的前面加上DISTINCT关键字，例子如下

SELECT
    COUNT(DISTINCT x_client.client_id) AS `numrows`
FROM
    (`x_client`)
LEFT JOIN `x_client_agent` ON `x_client_agent`.`client_id` = `x_client`.`client_id`
WHERE
    (
        x_client.client_code LIKE '%王小卓%'
        OR x_client.real_phone LIKE '%王小卓%'
        OR x_client. NAME LIKE '%王小卓%'
        OR x_client.real_name LIKE '%王小卓%'
    )
AND `x_client`.`user_id` = '123'