gistfile1.txt

<?php
    header("Content-type: application/vnd.ms-excel");
    header("Content-Disposition: attachment; filename=registrants.csv");
    header("Pragma: no-cache");
    header("Expires: 0");
?>
{exp:query sql="select * from exp_channel_data cd INNER JOIN exp_channel_titles ct ON cd.entry_id=ct.entry_id WHERE cd.channel_id = '8' AND cd.field_id_138 LIKE '%{segment_3}'"}
Count, Status, Date, Event Name, Title, First Name, Surname, Position, Job Title, Organisation, Company, Address 1, Address 2, Town, Postcode, County, Country, Telephone, Extension, Fax, Email, Website, Gender, Committee Member, Stay Event Duration, Stay Details, Attending Breakfast, Attending Lunch, Special Requirements, Special Access Requirements, Special Dietary Requirements, Other Invites, Travel Assistance Needed, Other Info, Contact Required, Evaluation Participation, Further Communication, Company Profile, Goods & Services, Market Visit Locations, Mission Objectives, Market Representation, Workshop Selection - Day 1, Workshop Selection - Day 2, Workshop Selection - Day 3, Event Date, Event Location, Event URL, Unique ID, 1:1 Selection - Day 1, 1:1 Selection - Day 2, 1:1 Selection - Day 3, 1:1 Selection - Day 4, 1:1 Selection - Day 5
{count}, {status}, {entry_date {gv_date_full}}, {field_id_138}, {field_id_141}, {field_id_142}, {field_id_143}, {field_id_145}, {field_id_146}, {field_id_147}, {field_id_148}, {field_id_151}, {field_id_199}, {field_id_152}, {field_id_153}, {field_id_154}, {field_id_155}, {field_id_156}, {field_id_157}, {field_id_159}, {field_id_160}, {field_id_161}, {field_id_163}, {field_id_164}, {field_id_168}, {field_id_169}, {field_id_170}, {field_id_171}, {field_id_174}, {field_id_175}, {field_id_198}, {field_id_182}, {field_id_184}, {field_id_193}, {field_id_194}, {field_id_195}, {field_id_197}, {field_id_188}, {field_id_189}, {field_id_190}, {field_id_191}, {field_id_192}, {field_id_126}, {field_id_127}, {field_id_128}, {field_id_139}, {field_id_140}, {field_id_131}, {field_id_137}, {field_id_132}, {field_id_133}, {field_id_134}, {field_id_135}, {field_id_136}
{/exp:query}
<? exit; ?>