Orders
[abase sql=”select orderId, arrival, departure, tenting, total, phone, email, address, city,state, postalCode, comment from orders where event=’2015AANR-NWCONV'”]
All Visitors
[abase sql=”select orderId, firstname, lastname, email, govtid, cellphone, birthdate, membership, aanr from visitors where orderid in (select o.orderid from orders o where o.event=’2015AANR-NWCONV’)”]
TShirts By Type and Size
Type :10 = Dress Type:12 = T-Shirt
[abase sql=”select firstname, lastname, tshirttype, tshirtsize from visitors where tshirtsize is not null and orderid in (select o.orderid from orders o where o.event=’2015AANR-NWCONV’) order by tshirttype, tshirtsize”]
Meals by Person
[abase sql=”select v.firstname, v.lastname, m.mealdate, m.meal, m.description, m.vegetarian from visitors v, meals m where v.visitorid = m.visitorid and v.orderid in (select o.orderid from orders o where o.event=’2015AANR-NWCONV’) order by v.lastname, v.firstname, m.mealdate”]Meals by Date and Meal
[abase sql=”select v.firstname, v.lastname, m.mealdate, m.meal, m.description, m.vegetarian from visitors v, meals m where v.visitorid = m.visitorid and v.orderid in (select o.orderid from orders o where o.event=’2015AANR-NWCONV’) order by m.mealdate, m.meal”]