User Page

User Spon ,Invest Projects

SELECT ai_project_id
		,TRUNCATE((SUM(f_spon + f_invest)/f_donate_limit)*100,2) AS 펀딩퍼센트 
		,f_project_name
		,f_etp_name
		,f_thumbnail
		,sys_user_id
FROM tbl_payment AS j_link
RIGHT JOIN(
		SELECT ai_project_id
				,f_project_name
				,f_etp_name
				,f_thumbnail
				,f_donate_limit
		FROM tbl_payment
		LEFT JOIN tbl_project
				ON tbl_payment.sys_project_id = tbl_project.ai_project_id
		LEFT JOIN tbl_enterprise
		N tbl_payment.sys_project_id = tbl_enterprise.sys_project_id
		LEFT JOIN tbl_img
				ON tbl_payment.sys_project_id = tbl_img.sys_project_id
		WHERE sys_user_id = 39 AND (f_asi ='A' OR f_asi = 'S')
		
		GROUP BY f_project_name
		)AS j_invest
		
		ON j_invest.ai_project_id = j_link.sys_project_id
	WHERE sys_user_id = 39	
GROUP BY f_project_name

User Regist Projects

SELECT sys_register_id
		,f_project_name
		,f_donate_limit
		,f_thumbnail
		,f_etp_name
		,TRUNCATE((SUM(f_spon + f_invest)/f_donate_limit)*100,2) AS a_
FROM tbl_project
	LEFT JOIN tbl_img
		ON tbl_project.ai_project_id = tbl_img.sys_project_id
	LEFT JOIN tbl_payment
		ON tbl_project.ai_project_id = tbl_payment.sys_project_id	
	LEFT JOIN tbl_enterprise
		ON tbl_project.ai_project_id = tbl_enterprise.sys_project_id	
WHERE sys_register_id = 39
GROUP BY f_project_name

User Bookmark Projects

SELECT tbl_pj_bookmark.sys_user_id
		,f_project_name
		,f_donate_limit
		,f_thumbnail
		,f_etp_name
		,TRUNCATE((SUM(f_spon + f_invest)/f_donate_limit)*100,2) AS 펀딩퍼센트
FROM tbl_pj_bookmark
LEFT JOIN tbl_project
	ON tbl_pj_bookmark.sys_project_id = tbl_project.ai_project_id
LEFT JOIN tbl_img
	ON tbl_pj_bookmark.sys_project_id = tbl_img.sys_project_id
LEFT JOIN tbl_payment
	ON tbl_pj_bookmark.sys_project_id = tbl_payment.sys_project_id	
LEFT JOIN tbl_enterprise
	ON tbl_pj_bookmark.sys_project_id = tbl_enterprise.sys_project_id	
WHERE tbl_pj_bookmark.sys_user_id = 39	
GROUP BY f_project_name