MySql left join查询和where条件中添加子表的条件 并行存在的情况处理

1.车场表查询，关联运营商表，关联车场设备状态表。
其中车场和运营商是多对1的条件。车场和设备表之间是多对多关系。
sql语句

SELECT COUNT(0) FROM t_park p 
LEFT JOIN t_operation o ON p.operationId=o.operationId  AND o.d=0
LEFT JOIN (SELECT parkId, MIN(equipmentStatus) AS equipmentStatus FROM t_third_equipment GROUP BY parkId) pte ON pte.parkId = p.parkId 
WHERE p.d = 0 AND p.parkAccessType = 2   AND o.operationId =1593521378449416192 

查询运营商下的车场信息。返回信息为0
其中o.operationId =1593521378449416192 改
p.operationId =1593521378449416192 则返回结果为1。

SELECT COUNT(0) FROM t_park p 
LEFT JOIN t_operation o ON p.operationId=o.operationId  AND o.d=0
LEFT JOIN (SELECT parkId, MIN(equipmentStatus) AS equipmentStatus FROM t_third_equipment GROUP BY parkId) pte ON pte.parkId = p.parkId 
WHERE p.d = 0 AND p.parkAccessType = 2   AND p.operationId =1593521378449416192

原因一定为：t_operation表中不存在operationId =1593521378449416192 的记录。
t_park表中部分记录的operationId =1593521378449416192。

explain第一个sql语句结果：Impossible WHERE noticed after reading const tables
条件中常量值查询匹配结果为空。