Registered Teams

[tablemaster datatables=”true” buttons=”true” sql=”select ans.reg_id as ‘ID’, ans.ans_value as ‘Team’, concat(a.att_fname, ‘ ‘, a.att_lname) as ‘Team Captain’, a.att_email as ‘E-Mail’, if(r.sts_id = ‘RAP’, ‘Paid’, ‘Pending Payment’), t.tkt_name as ‘Division’ from wif_esp_attendee_meta a, wif_esp_ticket t, wif_esp_registration r, wif_esp_answer ans where t.tkt_id = r.tkt_id and r.sts_id in (‘RAP’,’RPP’) and a.att_id = r.att_id and ans.reg_id = r.reg_id and ans.qst_id = 11 and t.tkt_name not like ‘%NOT%'”] [tablemaster datatables=”false” buttons=”true” sql=”select ans.reg_id as ‘ID’, ans.ans_value as ‘Team’, concat(a.att_fname, ‘ ‘, a.att_lname) as ‘Team Captain’, a.att_email as ‘E-Mail’, min(ans2.ans_value) as ‘Min Age’, avg(ans2.ans_value) as ‘Avg Age’, max(ans2.ans_value) as ‘Max Age’, if(r.sts_id = ‘RAP’, ‘Paid’, ‘Pending Payment’), t.tkt_name as ‘Division’ from wif_esp_attendee_meta a, wif_esp_ticket t, wif_esp_registration r, wif_esp_answer ans, wif_esp_answer ans2 where t.tkt_id = r.tkt_id and r.sts_id in (‘RAP’,’RPP’) and a.att_id = r.att_id and ans.reg_id = r.reg_id and ans.qst_id = 11 and t.tkt_name not like ‘%NOT%’ and r.reg_id = ans2.reg_id and ans2.qst_id in (19,20,21,22,23,24) and 0 = 1″]