MySQL Query : select *,(select count(*) from hfresult a where a.id='fjyrgy/20230319160000/103' 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 = 'fjyrgy/20230319160000/103' 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