House Party | Experiential Consumer Activation Programs

Drive direct sales
& customer acquisition

Activate target consumers to become passionate loyal customers

Introduce new products to devoted brand ambassadors

Deliver immersive product trials to generate new customers and sales

(default) 5 queries took 9 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `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	78	78	5
2	SELECT `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	221	221	2
3	SELECT `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-21' ORDER BY `position` ASC	33	33	2
4	SELECT `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` = -1 ORDER BY `Sitepages`.`position` ASC LIMIT 1	1	1	0
5	SELECT `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` = -1 AND `CalloutsSitepage`.`callout_id` = `Callout`.`id`) WHERE 1 = 1 ORDER BY position ASC	3	3	0

(default) 5 queries took 9 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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

SELECT `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

221

SELECT `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-21' ORDER BY `position` ASC

SELECT `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` = -1 ORDER BY `Sitepages`.`position` ASC LIMIT 1