SELECT cr.*, o.
nameorganizeName,t.organizeCode FROM
yh_tujian_clean_recordcr INNER JOIN sys_organize o ON o.id = cr.organizeId INNER JOIN sys_tunnel t ON t.id = cr.tunnelId WHERE cr.cleanTaskType = 1 and cr.organizeId in ( '35' ) and ( state = 1 or stationAudit = 0 ) order by cr.createTime desc LIMIT 0,10;
Mybatis 实例