MySQL Query : select *,(select count(*) from hfresult a where a.id='fjfzglxg1/20220623053900/78' and (a.info='' or a.info is null) and a.speed+(100000-a.tid)/10000000>=hfresult.speed+(100000-hfresult.tid)/10000000) as mc from hfresult where id = 'fjfzglxg1/20220623053900/78' and (info='' or info is null) order by speed desc limit 0,100
MySQL Error : Unknown column 'a.info' in 'where clause'
MySQL Errno : 1054
Message : MySQL Query Error