版本号：

1.3.78

问题描述：

查询时参数传递错误

错误日志&截图：

如图，当点击红1时，应当传参数前台卫生间，但却传了蓝1对应的总经理室，
当点击红8时，应当传参数男卫生间，但却传了蓝8对应的华正大学



结论：总是传该数字在本列第一次出现时所对应的巡检地点
下面为数据源及数据预览：
SELECT firecheck.ytm,location.name,firecheck.january ,firecheck.february ,firecheck.march ,firecheck.april ,firecheck.may ,firecheck.june ,firecheck.july ,firecheck.august ,firecheck.september
,firecheck.october ,firecheck.november ,firecheck.december
FROM fire_location location,
(SELECT ytm,pk,
SUM(CASE tm WHEN '01' THEN num ELSE 0 END) AS 'january',
SUM(CASE tm WHEN '02' THEN num ELSE 0 END) AS 'february',
SUM(CASE tm WHEN '03' THEN num ELSE 0 END) AS 'march',
SUM(CASE tm WHEN '04' THEN num ELSE 0 END) AS 'april',
SUM(CASE tm WHEN '05' THEN num ELSE 0 END) AS 'may',
SUM(CASE tm WHEN '06' THEN num ELSE 0 END) AS 'june',
SUM(CASE tm WHEN '07' THEN num ELSE 0 END) AS 'july',
SUM(CASE tm WHEN '08' THEN num ELSE 0 END) AS 'august',
SUM(CASE tm WHEN '09' THEN num ELSE 0 END) AS 'september',
SUM(CASE tm WHEN '10' THEN num ELSE 0 END) AS 'october',
SUM(CASE tm WHEN '11' THEN num ELSE 0 END) AS 'november',
SUM(CASE tm WHEN '12' THEN num ELSE 0 END) AS 'december'
FROM(SELECT DATE_FORMAT(create_time,'20%y')ytm,DATE_FORMAT(create_time,'%m')tm, pk, COUNT(*) AS num FROM fire_facility_check GROUP BY ytm,tm,pk) AS a GROUP BY ytm,pk) AS firecheck
WHERE location.id = firecheck.pk

重现步骤：

友情提示（为了提高issue处理效率）：

• 未按格式要求发帖，会被直接删掉;
• 请针对问题报表提供SQL脚本或在官网制作报表并提供ID;
• 针对不好重现的问题，请录制操作视频或详细的重现步骤；