How to use:
1. Click on a form link above, then inside the results (such as CAMP 1 under Dates column)
2. Select under column header to further refine results (such as junior)
3. Remove data you don't want by clicking red x in columns or rows (refresh if you make a mistake)
4. Highlight rows by clicking in blank space on any row (click again to remove highlight)
5. Sort with the pink sort link on any column. First click sorts ascending, second descending.
6. Search box will highlight text

» »

     Show: All Fields | Only Checked Columns

SELECT 
    post_id as pid,
    f.id as hid,
	label as header,
    meta_value as value
	
FROM 
	wp_postmeta pm, 
	wp_nf3_fields f, 
	wp_posts p 

WHERE 
	post_status = 'publish' and 
	pm.post_id = p.id and
	pm.post_id in (    select distinct post_id from wp_postmeta where meta_key='_form_id' 
		and meta_value="" order by post_id ) 
	and	replace(meta_key,'_field_','')=f.id 
	and meta_key like '_field_%' 
	and	f.id not in (1655,1656,1661,1663,1680,1701,1702,1707) #exclude these field ids
	
	#filter
	
	
	#refine
	
	
	
ORDER BY 
	
	field(header,
		'EMERGENCY CONTACT Relationship','EMERGENCY CONTACT Phone','EMERGENCY CONTACT Name',
		'Check #/Transaction ID','Payment Date','Payment Amount','Payment Method','Total Fees',
		'Email','Parent',"Parent's Full Name",
		'School','Phone',
		'Camper Entering Grade','Student Entering Grade','Student Entering Grade/Age',
		'Time','Camp Type','Dates','Gender',
		'Student','Camper',
		"Camper's Full Name","Student's Full Name","Child's Full Name"
		) desc, 
		
	post_id, 	
		
	f.id asc

hlist-