Aren't we all facy with non-flat DB elements.LantisEscudo wrote:BasharOfTheAges wrote:I got your table flips right here!
Spoiler :Try "SELECT V.* FROM videos V, in_contest C WHERE C.contestname='AWA Pro 2012' AND C.vidid=V.vidid ORDER BY V.vidid DESC;" instead.Code: Select all
Error 42X05: Table 'AWA_pro_list' does not exist.
AWA pro thoughts/followups?
Forum rules
Coordinators who fail to maintain necessary communication with entrants, or provide timey updates on results may be barred from announcing future events.
Coordinators who fail to maintain necessary communication with entrants, or provide timey updates on results may be barred from announcing future events.
- BasharOfTheAges
- Just zis guy, you know?
- Joined: Tue Sep 14, 2004 11:32 pm
- Status: Breathing
- Location: Merrimack, NH
Re: AWA pro thoughts/followups?
Anime Boston Fan Creations Coordinator (2019-2023)
Anime Boston Fan Creations Staff (2016-2018)
Another Anime Convention AMV Contest Coordinator 2008-2016
| | |
Anime Boston Fan Creations Staff (2016-2018)
Another Anime Convention AMV Contest Coordinator 2008-2016
| | |
- SailorDeath
- Joined: Tue Dec 26, 2000 4:39 pm
- Status: Active
- Location: Northwest Indiana
- Contact:
Re: AWA pro thoughts/followups?
l33tmeatwad wrote: I realize you said that, but you were making it sound like only ONE person submitted a video that had won before and acting all angry about it
Nah, I'm not angry if I were angry I'd actually be bitching up a storm, but not on the forums but to the contest organizers in private e-mails. Truthfully, if it's not a rule then they're allowed to do it, which means that while it's frowned upon it's by no means a call for disqualification.
Gimme a minute, I'll make a cool one....
- l33tmeatwad
- Joined: Wed Feb 16, 2005 3:22 pm
- Location: Christiansburg, VA
- Contact:
Re: AWA pro thoughts/followups?
Well at least some of the troll videos are newer, as there are a few videos that are upwards of 6 months old...I feel like the stats are much better than last year concerning videos that competed elsewhere before (or were posted online already)...SailorDeath wrote:l33tmeatwad wrote: I realize you said that, but you were making it sound like only ONE person submitted a video that had won before and acting all angry about it
Nah, I'm not angry if I were angry I'd actually be bitching up a storm, but not on the forums but to the contest organizers in private e-mails. Truthfully, if it's not a rule then they're allowed to do it, which means that while it's frowned upon it's by no means a call for disqualification.
...and I'm only 50% troll this year
Software & Guides: AMVpack | AMV 101 | AviSynth 101 | VapourSynth 101
PixelBlended Studios: Website | Twitter | YouTube
PixelBlended Studios: Website | Twitter | YouTube
- Rider4Z
- The Machine
- Joined: Sun Dec 14, 2003 3:55 am
- Status: Larger than life.
- Contact:
- l33tmeatwad
- Joined: Wed Feb 16, 2005 3:22 pm
- Location: Christiansburg, VA
- Contact:
Re: AWA pro thoughts/followups?
They do, it's called the VCAs...lol, jkRider4Z wrote:maybe the org should support a troll contest....
Software & Guides: AMVpack | AMV 101 | AviSynth 101 | VapourSynth 101
PixelBlended Studios: Website | Twitter | YouTube
PixelBlended Studios: Website | Twitter | YouTube
- BasharOfTheAges
- Just zis guy, you know?
- Joined: Tue Sep 14, 2004 11:32 pm
- Status: Breathing
- Location: Merrimack, NH
Re: AWA pro thoughts/followups?
OK - Really quick since I'm swamped with stuff for my own contest tonight...
Spoiler :
Anime Boston Fan Creations Coordinator (2019-2023)
Anime Boston Fan Creations Staff (2016-2018)
Another Anime Convention AMV Contest Coordinator 2008-2016
| | |
Anime Boston Fan Creations Staff (2016-2018)
Another Anime Convention AMV Contest Coordinator 2008-2016
| | |
- jingoro
- Joined: Fri Apr 13, 2001 10:46 pm
- Status: What do YOU want in Pro 2017?
- Location: Atlanta, GA
Re: AWA pro thoughts/followups?
Minor delay on voting website...
Expect instructions via email tonight on getting access, and participating in category nominations.
Video nominations will be active ASAP but will not be active tonight. Have fun making categories.
Expect instructions via email tonight on getting access, and participating in category nominations.
Video nominations will be active ASAP but will not be active tonight. Have fun making categories.
- JudgeHolden
- Joined: Mon Mar 14, 2005 8:49 am
- Status: Looking at you through your window!
- Location: The great white north (Minneapolis)
Re: AWA pro thoughts/followups?
But who would run it? Shin, Brad Demoss, or Castor Troy?Rider4Z wrote:maybe the org should support a troll contest....
- Rider4Z
- The Machine
- Joined: Sun Dec 14, 2003 3:55 am
- Status: Larger than life.
- Contact:
- Shin-AMV
- Joined: Mon Mar 15, 2010 10:15 pm
- Status: Ching Chong Dumpling Princess
Re: AWA pro thoughts/followups?
If I run a troll contest, I can't troll the troll contest. Or can I?