SELECT * FROM CONTENT 
WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT_LABEL 
					WHERE LABELID IN (SELECT LABELID FROM LABEL 
						WHERE NAME='<label name>' AND OWNER IN (SELECT USER_KEY FROM USER_MAPPING WHERE LOWER_USERNAME = '<username>')));