Javascript Menu by Deluxe-Menu.com

Site Map

services

overview 

experiential events

AfterParty

In-Box sampling

 

the events

overview

process

participants

party packs

event microsites

event videos

event calendar

HouseEvents

    Kids in the Kitchen

    Fabulous Over Forty

    Family Game Night

    Financial Tune-up

    I Love My Cat

    I Love My Dog

    Me & My Mommy

    Back To School

    Summer BBQ

    Slumber Party

    Ultimate Tailgating

    Pre-Holiday Bash

 

solutions

overview

by business need

    drive direct sales & customer acquisition

    drive online sign-ups

    drive tv viewership & build viewership

    activate consumers

    introduce new products

    deliver immersive product trial

    develop consumer advocacy & WOM

by industry

    apparel & jewelry

    automotive

    beer, wine & spirits

    consumer electronics

    consumer package goods (cpg)

    financial services

    food & beverage

    health & wellness

    in-home

    multi-cultural

    music

    non-profit

    pets

    pharmaceuticals

    publishing

    retail

    sports

    telecom

    television & film

    toys & games

    travel

    video games

 

results

overview

consumer activation & house party

womm & house party

measurement

    reach methodology

    PartyReach calculator

industry resources

consumer activation & womm glossary

 

about us

overview

clients

testimonials

management teams

careers

 

news

recent news

 

 


(default) 21 queries took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `sitepages`17171
2DESCRIBE `callouts`661
3DESCRIBE `callout_types`220
4DESCRIBE `callouts_sitepages`440
5DESCRIBE `news`16162
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` = 'sitemap' 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` = 161 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 000
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`.`directorypath` = 'sitemap' ORDER BY `Sitepages`.`position` ASC LIMIT 1110
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` = 161 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 000
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`.`directorypath` = 'sitemap' 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` = 161 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` = 'sitemap' 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` = 161 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 000
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` = 'sitemap' 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` = 161 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 000
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` = 161 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` = 161 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC 000
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 hidenav = 'no' AND is_agency_page = 0 ORDER BY `position` ASC 78783
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` 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
21SELECT `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-07' ORDER BY `position` ASC 32322