SELECT
	`a`.`Name` AS `Name` ,
	`a`.`Price` AS `Price` ,
	`a`.`BookType` AS `BookType` ,
	`a`.`Remark` AS `Remark` ,
	`a`.`DataModel` AS `DataModel` ,
	`a`.`Tags` AS `Tags` ,
	`b`.`Name` AS `AuthorName` ,
	`a`.`ChapterIdList` AS `ChapterIdList` ,
	`a`.`Id` AS SugarNav_Id,
	`a`.`ChapterIdList` AS SugarNav_ChapterIdList
FROM
	(
	SELECT
		*
	FROM
		(
		SELECT
			`Name`,
			`Price`,
			`BookType`,
			`AuthorId`,
			`ChapterIdList`,
			`Remark`,
			`Tags`,
			`DataModel`,
			`TenantId`,
			`PlatformId`,
			`CreateId`,
			`CreateName`,
			`CreateTime`,
			`UpdateId`,
			`UpdateName`,
			`UpdateTime`,
			`Id`,
			`IsDeleted`
		FROM
			`BookNote`
		WHERE
			`name` LIKE '%三国%'
			AND NOT ( `IsDeleted` = 1 )
			AND ( `PlatformId` = '08ddb485-5917-4c85-817f-e7888d2704f7' ) ) MergeTable ) `a`
Left JOIN `Author` `b` ON
	( `a`.`AuthorId` = `b`.`Id` )
	AND NOT ( `b`.`IsDeleted` = 1 )
	AND ( `b`.`PlatformId` = '08ddb485-5917-4c85-817f-e7888d2704f7' )
WHERE
	(`b`.`Name` like concat('%', '吴承恩', '%'))
	AND NOT ( `a`.`IsDeleted` = 1 )
	AND ( `a`.`PlatformId` = '08ddb485-5917-4c85-817f-e7888d2704f7' )