SELECT * FROM `personage` WHERE `PersonageName` = '宋坤' AND `PersonagePenNameFlag` = '' AND `PersonageDeleteFlag` != 'Y'SELECT `PublishID`,`PublishTitle` FROM `publish` WHERE (`PublishWriter` like '%宋坤%') or (`PublishTranslator` like '%宋坤%') ORDER BY RAND() LIMIT 10