Norman García Aguilar dijo [Sat, May 12, 2012 at 01:19:01PM -0600]: > > On Sat, 2012-05-12 at 20:18 +0100, Moray Allan wrote: > > > Can some people work on personalised registration status messages, to go > > > out as soon as possible but certainly before the sponsorship deadline? > > > It's much easier if attendees find their mistakes now, rather than > > > having to make special requests to us after the deadline. > > I'm checking penta and mailing people so they can fix some missing > information.
Sorry for the long-standing inaction in this regard.
I'm leaving here the query to have it handy if (when) it's needed
again, and to be corrected in case I messed anything up when asking
Penta.
pentabarf=> SELECT count(*), participant_category, accom FROM
debconf.dc_conference_person JOIN debconf.dc_accomodation
USING (accom_id,conference_id)
JOIN debconf.dc_participant_mapping
ON (participant_mapping_id=dc_participant_category_id)
JOIN debconf.dc_participant_category
USING (participant_category_id, conference_id)
WHERE attend AND conference_id=6
GROUP BY accom, participant_category
ORDER BY accom;
count | participant_category | accom
-------+----------------------------------------------+------------------------------------
1 | --- Please select one --- | --- Please select one
---
5 | Basic; want sponsored food | --- Please select one
---
2 | Basic; want sponsored food and accommodation | --- Please select one
---
1 | --- Please select one --- | I will arrange my own
accomodation
15 | Basic; no sponsored food or accommodation | I will arrange my own
accomodation
12 | Basic; want sponsored food | I will arrange my own
accomodation
1 | Basic; want sponsored food and accommodation | I will arrange my own
accomodation
1 | Professional registration (US$650) | I will arrange my own
accomodation
2 | --- Please select one --- | Regular DebConf
accomodation
18 | Basic; no sponsored food or accommodation | Regular DebConf
accomodation
11 | Basic; want sponsored accommodation | Regular DebConf
accomodation
5 | Basic; want sponsored food | Regular DebConf
accomodation
123 | Basic; want sponsored food and accommodation | Regular DebConf
accomodation
3 | Corporate registration (US$1300) | Regular DebConf
accomodation
13 | Professional registration (US$650) | Regular DebConf
accomodation
(15 rows)
So our inconsistencies are:
* All of the 8 people who have accom="Please select one"
* The (non-overlapping) 3 people who have "Please select one" for
participant_category
* The one person who has "professional registration" and "I will arrange my own"
* The 18+5 people who have "regular DebConf accomodation" but requested basic
without accomodation
(quite probably, will be just asking, as those last 18+5 might be locals)
signature.asc
Description: Digital signature
_______________________________________________ Debconf-team mailing list Debconf-team@lists.debconf.org http://lists.debconf.org/mailman/listinfo/debconf-team
