SELECT * FROM (
SELECT
a.,
(SELECT realname FROM 72crm_admin_user WHERE user_id=a.create_user_id) AS create_user_name,
(SELECT realname FROM 72crm_admin_user WHERE user_id=a.owner_user_id) AS owner_user_name,
d.customer_name AS customer_name,
z.
FROM
72crm_crm_contacts AS a
LEFT JOIN 72crm_crm_customer d ON a.customer_id = d.customer_id
JOIN (
SELECT
b.batch_id AS field_batch_id
,MAX(CASE WHEN a.name = '是否关键决策人' THEN a.value END) AS 是否关键决策人
,MAX(CASE WHEN a.name = 'remark' THEN a.value END) AS remark
FROM 72crm_admin_fieldv AS a RIGHT JOIN (SELECT batch_id FROM 72crm_crm_contacts AS a
WHERE 1=1
AND create_user_id IN (3) AND create_time BETWEEN '2020-01-01 00:00:00' AND '2020-12-31 23:59:59' ORDER BY update_time DESC LIMIT 0,15
) AS b ON a.batch_id = b.batch_id
GROUP BY b.batch_id
) z ON a.batch_id = z.field_batch_id
) AS views
WHERE 1=1
ORDER BY
update_time DESC

查询了72crm_crm_contacts表中的remark（a.*），然后又在72crm_admin_fieldv表中as一个remark，这是什么意思？现在字段冲突报错，目前我将72crm_admin_fieldv的remark改了一个名字，请问是否会有影响？