Someone

		SELECT upd.userid, upd.hobbies, 'HOBBIES'
		FROM `USER_PROFILEDATA` upd
		JOIN USER_JOIN_XTRA ujx ON ujx.userid = upd.userid AND ujx.searchable='YES' AND ujx.status='ACTIVE'
		WHERE upd.hobbies != '';
		

		SELECT upd.userid, upd.profession_custom, 'PROFESSION'
		FROM `USER_PROFILEDATA` upd
		JOIN USER_JOIN_XTRA ujx ON ujx.userid = upd.userid AND ujx.searchable='YES' AND ujx.status='ACTIVE'
		WHERE upd.profession_custom != '';
		

		SELECT upd.userid, message, 'MESSAGE'
		FROM `USER_PROFILEDATA` upd
		JOIN USER_JOIN_XTRA ujx ON ujx.userid = upd.userid AND ujx.searchable='YES' AND ujx.status='ACTIVE'
		WHERE upd.message != '';