err:Unknown column 'ac.keyword' in 'WHERE'<br>

	select ac.*
	  from m_account ac
	  left join(
	         select accountcd
	              , count(*) as cnt
	           from t_friend
	          where regtime between '2026/05/24 00:00:00' and '2026/05/24 23:59:59'
	          group by accountcd
	       ) fr
	    on (fr.accountcd = ac.accountcd)
	 where ac.delflg = 0
	   and ac.keyword <> ''
	   and coalesce(fr.cnt, 0) < ac.dayflwnum
	 order by rand()
	 limit 30