MySQL 多表关联一对多查询取最新的一条数据

sql语句 

SELECT SQL_CALC_FOUND_ROWS
	* 
FROM
	tableA a
	LEFT JOIN (
	SELECT
		BC.* 
	FROM
		( SELECT MAX( id ) AS cid FROM tableB GROUP BY code ) AC
	LEFT JOIN tableB BC ON AC.owner_id = BC.id 
	) b ON a.code = b.code WHERE a.type = 1;