meidu2021/daju/target/classes/cn/com/lzt/homepage/sql/HomepageMinidaoDao_queryUserBoardByUserid.sql

SELECT pd.id,pd.board_name name, pd.board_code code, upd.sort_num sortNum,upd.required_flag requiredFlag ,pd.link_url linkUrl,upd.checked_status checkedStatus
from t_bus_user_pc_dashboard upd
LEFT JOIN t_bus_pc_dashboard  pd
ON upd.boardid = pd.id
WHERE upd.userid =:userid
ORDER BY sort_num