Javascript Menu by Deluxe-Menu.com
the-events > event videos > Nickelodeon Avatar

Get Flash to see this player.

Nickelodeon Avatar

Nickelodeon Avatar House Party
Flush with enthusiasm from their first House Party, Nickelodeon quickly signed up for another (increasing their order to 1,500 parties). This time the challenge was different: the children's television giant was getting ready to launch Avatar, a dramatic anime-style adventure with lots of mysticism and martial arts. This was a departure for Nick, which was known for silly classics like SpongeBob Squarepants. So House Party found 1,500 rabid fans of both anime and Nick, and then set them loose on houseparty.com, where they set up their parties, invited their guests, and buzzed together with their friends and all the other partygoers about Nickelodeon and the show they were about to preview.

On party day, 1,500 homes rocked with children and parents whooping it up in honor of Nickelodeon, and then sitting down excitedly to watch Avatar. After the screenings, kids dressed up like the characters, spilled out into the street writing "AVATAR" in chalk on sidewalks, and then returned to school buzzing about the amazing new show they'd seen. Said Nick's Pam Kaufman, executive vice president, marketing and worldwide promotions: "Avatar has been a runaway success for us, and House Party helped insure that when the show launched, it hit the ground running!"


Fisher-Price
Fisher-Price Play Date
Kraft
Kraft Hispanic Event
Ice Road Truckers
Series Preview Parties
Ford
Product Launch
House Party
AVEENO®
Product Launch
House Party
The Closer
Product Launch
House Party
Megabrands: NEO Shifters
Product Launch
House Party
Cranium WOW!
First-Look Parties: New Game from Cranium
Friday Night Lights
Season Two Sneak-Peek Viewing Parties
Gerber
New Baby Celebration Parties for Parents
Cartoon Network 3D
Series Preview Parties
Pink Plaid
Better Homes & Gardens Breast Cancer Awareness Cookbook Parties
Nickelodeon Neds
Ned's Declassified and Unfabulous
Nickelodeon Avatar
Nickelodeon Avatar House Party
Biggest Loser
Biggest Loser, Season Two
Cacao Reserve
Cacao Reserve™ by Hershey's™ House Party
Cartoon Network
Cartoon Network House Party Series
(default) 25 queries took 13 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `sitepages`17171
2DESCRIBE `callouts`661
3DESCRIBE `callout_types`220
4DESCRIBE `callouts_sitepages`440
5DESCRIBE `news`16161
6DESCRIBE `news_types`220
7SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE `Sitepages`.`directorypath` = 'the-events/event-videos/nickelodeon-avatar' ORDER BY `Sitepages`.`position` ASC LIMIT 1111
8SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` = 233 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 111
9SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE `Sitepages`.`id` = 113 ORDER BY `Sitepages`.`position` ASC LIMIT 1111
10SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` = 113 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 440
11SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE `Sitepages`.`id` = 2 ORDER BY `Sitepages`.`position` ASC LIMIT 1110
12SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` = 2 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 000
13SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE `Sitepages`.`directorypath` = 'the-events/event-videos/nickelodeon-avatar' ORDER BY `Sitepages`.`position` ASC LIMIT 1110
14SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` = 233 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 110
15SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE `Sitepages`.`directorypath` = 'the-events/event-videos/nickelodeon-avatar' ORDER BY `Sitepages`.`position` ASC LIMIT 1110
16SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` = 233 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 110
17SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE `Sitepages`.`id` = 113 ORDER BY `Sitepages`.`position` ASC LIMIT 1110
18SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` = 113 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 440
19SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE `Sitepages`.`id` = 2 ORDER BY `Sitepages`.`position` ASC LIMIT 1110
20SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` = 2 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 000
21SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE `Sitepages`.`directorypath` = 'the-events/event-videos/nickelodeon-avatar' ORDER BY `Sitepages`.`position` ASC LIMIT 1110
22SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` = 233 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 110
23SELECT `Sitepages`.`id`, `Sitepages`.`title`, `Sitepages`.`metadescription`, `Sitepages`.`blurb`, `Sitepages`.`hidecallouts`, `Sitepages`.`hidenav`, `Sitepages`.`created`, `Sitepages`.`parent_id`, `Sitepages`.`position`, `Sitepages`.`directorypath`, `Sitepages`.`contenttitle`, `Sitepages`.`contentsubtitle`, `Sitepages`.`mainimage`, `Sitepages`.`titleimage`, `Sitepages`.`modified`, `Sitepages`.`is_agency_page`, `Sitepages`.`is_titleimage_bg` FROM `sitepages` AS `Sitepages` WHERE hidenav = 'no' AND is_agency_page = 0 ORDER BY `position` ASC 78783
24SELECT `Callout`.`id`, `Callout`.`callout_type_id`, `Callout`.`title`, `Callout`.`blurb`, `Callout`.`created`, `Callout`.`modified`, `CalloutsSitepage`.`rec_id`, `CalloutsSitepage`.`callout_id`, `CalloutsSitepage`.`sitepage_id`, `CalloutsSitepage`.`position` FROM `callouts` AS `Callout` JOIN `callouts_sitepages` AS `CalloutsSitepage` ON (`CalloutsSitepage`.`sitepage_id` IN (1, 100, 108, 117, 126, 148, 153, 2, 101, 109, 118, 127, 149, 154, 3, 119, 128, 150, 4, 103, 110, 120, 129, 156, 162, 5, 111, 121, 130, 151, 253, 6, 112, 122, 131, 113, 123, 132, 158, 115, 133, 167, 116, 134, 125, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 152, 168, 170, 171, 172, 173, 175, 174, 176, 177, 178, 179, 180, 181, 182, 169, 241, 242, 243, 159) AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 2212212
25SELECT `News`.`id`, `News`.`title`, `News`.`ticker_headline`, `News`.`url`, `News`.`source`, `News`.`blurb`, `News`.`abstract`, `News`.`position`, `News`.`published`, `News`.`expires`, `News`.`active`, `News`.`created`, `News`.`modified`, `News`.`subtitle`, `News`.`news_type_id`, `News`.`titleimage`, `NewsType`.`id`, `NewsType`.`typename` FROM `news` AS `News` LEFT JOIN `news_types` AS `NewsType` ON (`News`.`news_type_id` = `NewsType`.`id`) WHERE `News`.`active` = 'yes' AND `News`.`expires` > '2009-11-20' ORDER BY `position` ASC 33332