SELECT 
			dpr.`dpr_id`, 
			dpr.`mat_id`, 
			dpr.`mit_id`, 
			dpr.`mki_id`, 
			dpr.`product_code`, 
			dpr.`product_name`, 
			dpr.`catchcopy`, 
			dpr.`lead`, 
			dpr.`area`, 
			dpr.`image_file`, 
			dpr.`shop_url`, 
			dpr.`sale_text`, 
			dpr.`display_product`, 
			dpr.`display_online`, 
			dpr.`display_shop`, 
			dpr.`product_series`, 
			dpr.`mic_id`, 
			mit.`mfa_id`, 
			mit.`mge_id`, 
			mit.`mba_id`, 
			mit.`mca_id`, 
			mit.`item1_name`, 
			mit.`item2_name`, 
			mit.`item3_name`, 
			mit.`item4_name`, 
			mki.`kind_name`, 
			mat.`attribute_name`, 
			mat.`attribute_alpha`,
			mic.`icon_name`,
			mic.`icon_alpha`,
			mfa.`family_name`,
			mba.`branch_alpha`
		FROM 01product_d_product AS dpr 
		LEFT OUTER JOIN 01product_m_item AS mit 
		ON dpr.`mit_id`=mit.`mit_id` 
		LEFT OUTER JOIN 01product_m_kind AS mki 
		ON dpr.`mki_id`=mki.`mki_id` 
		LEFT OUTER JOIN 01product_m_attribute AS mat 
		ON dpr.`mat_id`=mat.`mat_id` 
		LEFT OUTER JOIN 01product_m_icon AS mic 
		ON dpr.`mic_id`=mic.`mic_id` 
		LEFT OUTER JOIN 01product_m_family AS mfa 
		ON mit.`mfa_id`=mfa.`mfa_id` 
		LEFT OUTER JOIN 01product_m_branch AS mba  
		ON mit.`mba_id`=mba.`mba_id` 
		WHERE 
			dpr.`product_code`="00215301" AND 
			dpr.`display_product`="1" AND 
			mfa.`del`=0 AND 
			mic.`del`=0 AND 
			mat.`del`=0 AND 
			mki.`del`=0 AND 
			mit.`del`=0 AND 
			mba.`del`=0 AND 
			dpr.`del`=0 
		;