CLIENT: Santa Fe Reporter
Ad series for Hip Hop Voter Project, a collaboration between the Reporter, the local alternative news weekly, and a popular local DJ team, with the mission of registering young hispanic voters. The irreverent ads were wildly successful.

(default) 8 queries took 223 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `projects`11111
2DESCRIBE `project_types`221
3DESCRIBE `images`550
4SELECT `ProjectType`.`id` FROM `project_types` AS `ProjectType` WHERE `name` = 'Advertising' LIMIT 111101
5SELECT `ProjectType`.`id` FROM `project_types` AS `ProjectType` WHERE `name` LIKE 'advertising' LIMIT 111101
6SELECT `Project`.`slug` FROM `projects` AS `Project` WHERE `Project`.`project_type_id` = 1 AND `Project`.`active` = 1 ORDER BY `Project`.`order_nbr` ASC 303018
7SELECT `Project`.`id`, `Project`.`project_type_id`, `Project`.`active`, `Project`.`title`, `Project`.`slug`, `Project`.`description`, `Project`.`description_html`, `Project`.`paypal_id`, `Project`.`order_nbr`, `Project`.`created`, `Project`.`modified` FROM `projects` AS `Project` WHERE `Project`.`project_type_id` = 1 AND `Project`.`active` = 1 ORDER BY `Project`.`order_nbr` ASC LIMIT 1111
8SELECT `Image`.`id`, `Image`.`project_id`, `Image`.`filename`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`project_id` = (142) 110