sql code

gistfile1.txt

select it.id as 'ID(child)',
it.parent_item_id as 'Parent ID',
parA.meta_value as 'Payment status(parent)',
parB.meta_value as 'Reg phase',

col0.meta_value as 'Attendee status',
colA.meta_value as 'First Name', 
colB.meta_value as 'Last Name', 
colC.meta_value as 'ASI Member', 
COALESCE( 
	unfrm_label(f1021.options,colD1.meta_value),
	unfrm_label(f1022.options,colD2.meta_value),
	unfrm_label(f1023.options,colD3.meta_value),
	unfrm_label(f1024.options,colD4.meta_value),
	unfrm_label(f1025.options,colD5.meta_value),
	unfrm_label(f1026.options,colD6.meta_value)
		)as 'Registration', 
unfrm( parC.meta_value , 'line1') as 'Address 1', 
unfrm( parC.meta_value , 'line2') as 'Address 2', 
unfrm( parC.meta_value , 'city') as 'City', 
unfrm( parC.meta_value , 'state') as 'State', 
unfrm( parC.meta_value , 'zip') as 'Zip', 
unfrm( parC.meta_value , 'country') as 'Country',
colE.meta_value as 'Total'

from asiwpMUOPyFdm.wp_c04792744b_frm_items it
left join asiwpMUOPyFdm.wp_c04792744b_frm_forms ourForm on ourForm.id=it.form_id

left join asiwpMUOPyFdm.wp_c04792744b_frm_items par on par.id=it.parent_item_id
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas parA on parA.item_id=par.id AND parA.field_id=1045
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas parB on parB.item_id=par.id AND parB.field_id=1032
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas parC on parC.item_id=par.id AND parC.field_id=1041

left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas col0 on col0.item_id=it.id AND col0.field_id=1017
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colA on colA.item_id=it.id AND colA.field_id=1018
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colB on colB.item_id=it.id AND colB.field_id=1019
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colC on colC.item_id=it.id AND colC.field_id=1020
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colD1 on colD1.item_id=it.id AND colD1.field_id=1021
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colD2 on colD2.item_id=it.id AND colD2.field_id=1022
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colD3 on colD3.item_id=it.id AND colD3.field_id=1023
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colD4 on colD4.item_id=it.id AND colD4.field_id=1024
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colD5 on colD5.item_id=it.id AND colD5.field_id=1025
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colD6 on colD6.item_id=it.id AND colD6.field_id=1026
left join asiwpMUOPyFdm.wp_c04792744b_frm_item_metas colE on colE.item_id=it.id AND colE.field_id=1029

left join asiwpMUOPyFdm.wp_c04792744b_frm_fields f1021 on f1021.id=1021
left join asiwpMUOPyFdm.wp_c04792744b_frm_fields f1022 on f1022.id=1022
left join asiwpMUOPyFdm.wp_c04792744b_frm_fields f1023 on f1023.id=1023
left join asiwpMUOPyFdm.wp_c04792744b_frm_fields f1024 on f1024.id=1024
left join asiwpMUOPyFdm.wp_c04792744b_frm_fields f1025 on f1025.id=1025
left join asiwpMUOPyFdm.wp_c04792744b_frm_fields f1026 on f1026.id=1026

where it.form_id=72