Page History

SELECT bb.`lower_user_name`,bb.`user_key`,aa.`email_address`,aa.`display_name` FROM cwd_user aa,app_user bb
WHERE aa.`lower_user_name` = bb.`lower_user_name`

SELECT
	na.SOURCE_NODE_ID as "问题id",
	na.SINK_NODE_ID as "模块id",
	c.cname as "模块名称"
FROM
	nodeassociation na
	LEFT JOIN component c on na.SINK_NODE_ID=c.ID
WHERE
	SOURCE_NODE_ID = 10939 
	AND SINK_NODE_ENTITY = 'Component';