SACS Idol 2005 revisited
14 May 2005It was good. Better-than-last-year good, but that was sort of anticipated. There were 19 performers all up, ranging from skits to musical performances to stand-up comedy to political-campaign style baby wielding.
The voting was a success, with about 160 people throwing in their voice – but primarily just via standard voting terminals, with SMS voting not being heavily used. I don’t think it was the result of people’s hesitance to use SMS, but rather incorrect promotion – the programme should have featured SMS codes for all acts, as well as instructions on how to vote on the back cover. We were going to do a brief “how to vote” video, but ran out of time to cut it together, which also didn’t help things.
The ticketing system was also partially to blame – there were two types of ticket; standard voting tokens (for use at the terminals) and SMS tickets, which featured a unique code. More than a few audience members were looking for the non-existant SMS code on their ticket – more signage outside was required, and I didn’t get a chance to talk to the ticket sellers, so it’s possible they weren’t asking people how they’d like to vote.
Anyway, SMS voting was barely used, but needed a query that was stupidly complicated to figure out who voted for what (at least compared to last year’s system). I hadn’t thought about how the votes would be returned that hard, thinking I’d be able to quickly cook up some SQL to do it, as per last year… so at about 4pm (FOH opened at 6:30pm) I realised that it was a little more complicated than anticipated, and I made a slightly-anxious phone call to Michael, who managed to cook up the following over the phone.
SELECT participants.name, count( votes.For_ID ) AS count
FROM participants
LEFT JOIN votes ON participants.ID = votes.For_ID
GROUP BY participants.ID
ORDER BY `count` DESC
Dale, you’re a freak, but thankyou!
Learning how to use LEFT JOIN is now high on my to-learn list.
Anyway, the results themselves were wonderfully controversial – the winner was The Aaron Carter Tribute Band, of Year 11, which was in direct competition with The Backstreet Toys of Year 12 all night — and Backstreet Toys came in second place with just one vote between them!
Third place was Jack Wright, who was a mere three votes from the winner – and all three were leap frogging each other for the duration of the voting period. Exciting stuff to watch!
Thanks to all who went on the night, you helped raise over $700 for Assistance Dogs, and hopefully had a lot of fun in doing so! Special thanks also to Ben for his ability to keep driving in the small hours of the morning, to Steve and Guy for coming back and cooking up vision, and to Digihire for reduced-rate hire of a MX-50 vision mixer!
