| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `db94586_clubdistrict_new`.`club_cake_sessions` AS `Session` WHERE `id` = '2d1662053cfc94ebcd4805cbe760c123' LIMIT 1 | | 0 | 0 | 1 |
| 2 | SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`music_file`, `Setting`.`color_id`, `Setting`.`admin_email`, `Setting`.`site_name`, `Setting`.`copyright`, `Setting`.`facebook_url`, `Setting`.`twitter_url`, `Setting`.`youtube_url`, `Setting`.`instagram_url`, `Setting`.`linkedin_url`, `Setting`.`modified_on`, `Color`.`id`, `Color`.`name`, `Color`.`code`, `Color`.`css_file` FROM `db94586_clubdistrict_new`.`club_settings` AS `Setting` LEFT JOIN `db94586_clubdistrict_new`.`club_colors` AS `Color` ON (`Setting`.`color_id` = `Color`.`id`) WHERE `Setting`.`id` = 1 LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `NewsTicker`.`id`, `NewsTicker`.`home_config_id`, `NewsTicker`.`name`, `NewsTicker`.`slug`, `NewsTicker`.`active`, `NewsTicker`.`speed`, `NewsTicker`.`no_of_items`, `NewsTicker`.`created_on`, `NewsTicker`.`modified_on`, `HomeConfig`.`id`, `HomeConfig`.`name`, `HomeConfig`.`extra_command` FROM `db94586_clubdistrict_new`.`club_news_tickers` AS `NewsTicker` LEFT JOIN `db94586_clubdistrict_new`.`club_home_configs` AS `HomeConfig` ON (`NewsTicker`.`home_config_id` = `HomeConfig`.`id` AND NOT (`HomeConfig`.`extra_command` = 'name:asc')) WHERE `NewsTicker`.`slug` = 'news-ticker-default' LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT `News`.`id`, `News`.`user_id`, `News`.`news_category_id`, `News`.`name`, `News`.`slug`, `News`.`image`, `News`.`short_description`, `News`.`body`, `News`.`post_date`, `News`.`active`, `News`.`created_on`, `News`.`modified_on`, `NewsTickerNews`.`id`, `NewsTickerNews`.`news_ticker_id`, `NewsTickerNews`.`news_id` FROM `db94586_clubdistrict_new`.`club_news` AS `News` JOIN `db94586_clubdistrict_new`.`club_news_ticker_news` AS `NewsTickerNews` ON (`NewsTickerNews`.`news_ticker_id` = 1 AND `NewsTickerNews`.`news_id` = `News`.`id`) | | 0 | 0 | 0 |
| 5 | SELECT `News`.`slug`, `News`.`post_date`, `News`.`name` FROM `db94586_clubdistrict_new`.`club_news` AS `News` WHERE `News`.`active` = '1' ORDER BY `News`.`id` DESC LIMIT 8 | | 8 | 8 | 3 |
| 6 | SELECT `HomeBlock`.`id`, `HomeBlock`.`title` FROM `db94586_clubdistrict_new`.`club_home_blocks` AS `HomeBlock` WHERE `HomeBlock`.`name` IN ('events', 'galleries', 'starlets', 'musics') | | 4 | 4 | 0 |
| 7 | SELECT `Home`.`color_code`, `Home`.`id`, `HomeBlock`.`name`, `HomeBlock`.`id` FROM `db94586_clubdistrict_new`.`club_homes` AS `Home` LEFT JOIN `db94586_clubdistrict_new`.`club_home_blocks` AS `HomeBlock` ON (`Home`.`home_block_id` = `HomeBlock`.`id`) WHERE `Home`.`home_block_id` IN (1, 2, 3, 4) | | 4 | 4 | 6 |
| 8 | SELECT `HomeBlock`.`id`, `HomeBlock`.`title` FROM `db94586_clubdistrict_new`.`club_home_blocks` AS `HomeBlock` WHERE `HomeBlock`.`name` IN ('feature_artist', 'hot_or_not', 'club_vines', 'charity_sponsor', 'sponsored') | | 5 | 5 | 0 |
| 9 | SELECT `Home`.`color_code`, `Home`.`no_of_slides`, `Home`.`link`, `HomeBlock`.`name`, `HomeBlock`.`title`, `HomeBlock`.`id`, `Home`.`id` FROM `db94586_clubdistrict_new`.`club_homes` AS `Home` LEFT JOIN `db94586_clubdistrict_new`.`club_home_blocks` AS `HomeBlock` ON (`Home`.`home_block_id` = `HomeBlock`.`id`) WHERE `Home`.`home_block_id` IN (5, 6, 7, 8, 9) | | 5 | 5 | 3 |
| 10 | SELECT `HomeImage`.`name`, `HomeImage`.`home_id` FROM `db94586_clubdistrict_new`.`club_home_images` AS `HomeImage` WHERE `HomeImage`.`is_active` = '1' AND `HomeImage`.`home_id` IN (14, 15, 16, 17, 18) | | 9 | 9 | 1 |
| 11 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE 1 = 1 | | 5 | 5 | 2 |
| 12 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` IN (1, 2, 3, 4, 5) AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 24 | 24 | 0 |
| 13 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home' | | 1 | 1 | 4 |
| 14 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8) | | 4 | 4 | 1 |
| 15 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (4, 3, 1, 2) AND `AdvertisementSize`.`code` = 'leaderboard' | | 1 | 1 | 3 |
| 16 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 1 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 17 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events' | | 1 | 1 | 2 |
| 18 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1) | | 4 | 4 | 2 |
| 19 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'leaderboard' | | 1 | 1 | 1 |
| 20 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 1 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 6 |
| 21 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries' | | 1 | 1 | 0 |
| 22 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2) | | 4 | 4 | 5 |
| 23 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 4, 2, 3) AND `AdvertisementSize`.`code` = 'leaderboard' | | 1 | 1 | 1 |
| 24 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 1 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 25 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Starlets' | | 1 | 1 | 0 |
| 26 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3) | | 4 | 4 | 0 |
| 27 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (3, 1, 2, 4) AND `AdvertisementSize`.`code` = 'leaderboard' | | 1 | 1 | 0 |
| 28 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 1 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 29 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog' | | 1 | 1 | 0 |
| 30 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11) | | 4 | 4 | 1 |
| 31 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'leaderboard' | | 1 | 1 | 1 |
| 32 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 1 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 33 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News' | | 1 | 1 | 1 |
| 34 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10) | | 4 | 4 | 0 |
| 35 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'leaderboard' | | 1 | 1 | 1 |
| 36 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 1 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 37 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home' | | 1 | 1 | 3 |
| 38 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8) | | 4 | 4 | 1 |
| 39 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (4, 3, 1, 2) AND `AdvertisementSize`.`code` = 'medium-rectangle' | | 1 | 1 | 7 |
| 40 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 2 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 4 |
| 41 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events' | | 1 | 1 | 0 |
| 42 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1) | | 4 | 4 | 0 |
| 43 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'medium-rectangle' | | 1 | 1 | 0 |
| 44 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 2 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 45 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries' | | 1 | 1 | 0 |
| 46 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2) | | 4 | 4 | 0 |
| 47 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 4, 2, 3) AND `AdvertisementSize`.`code` = 'medium-rectangle' | | 1 | 1 | 1 |
| 48 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 2 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 49 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Starlets' | | 1 | 1 | 1 |
| 50 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3) | | 4 | 4 | 0 |
| 51 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (3, 1, 2, 4) AND `AdvertisementSize`.`code` = 'medium-rectangle' | | 1 | 1 | 1 |
| 52 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 2 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 53 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog' | | 1 | 1 | 1 |
| 54 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11) | | 4 | 4 | 0 |
| 55 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'medium-rectangle' | | 1 | 1 | 0 |
| 56 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 2 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 57 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News' | | 1 | 1 | 2 |
| 58 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10) | | 4 | 4 | 6 |
| 59 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'medium-rectangle' | | 1 | 1 | 0 |
| 60 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 2 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 61 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home' | | 1 | 1 | 0 |
| 62 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8) | | 4 | 4 | 2 |
| 63 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (4, 3, 1, 2) AND `AdvertisementSize`.`code` = 'sponsored-ad' | | 1 | 1 | 1 |
| 64 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 3 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 65 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events' | | 1 | 1 | 0 |
| 66 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1) | | 4 | 4 | 1 |
| 67 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'sponsored-ad' | | 1 | 1 | 1 |
| 68 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 3 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 69 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries' | | 1 | 1 | 0 |
| 70 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2) | | 4 | 4 | 1 |
| 71 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 4, 2, 3) AND `AdvertisementSize`.`code` = 'sponsored-ad' | | 1 | 1 | 0 |
| 72 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 3 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 73 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Starlets' | | 1 | 1 | 1 |
| 74 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3) | | 4 | 4 | 1 |
| 75 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (3, 1, 2, 4) AND `AdvertisementSize`.`code` = 'sponsored-ad' | | 1 | 1 | 1 |
| 76 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 3 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 77 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog' | | 1 | 1 | 0 |
| 78 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11) | | 4 | 4 | 1 |
| 79 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'sponsored-ad' | | 1 | 1 | 0 |
| 80 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 3 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 81 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News' | | 1 | 1 | 0 |
| 82 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10) | | 4 | 4 | 0 |
| 83 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'sponsored-ad' | | 1 | 1 | 1 |
| 84 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 3 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 85 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home' | | 1 | 1 | 0 |
| 86 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8) | | 4 | 4 | 16 |
| 87 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (4, 3, 1, 2) AND `AdvertisementSize`.`code` = 'wide-skyscraper' | | 1 | 1 | 0 |
| 88 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 4 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 0 |
| 89 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events' | | 1 | 1 | 0 |
| 90 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1) | | 4 | 4 | 0 |
| 91 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'wide-skyscraper' | | 1 | 1 | 2 |
| 92 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 4 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 93 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries' | | 1 | 1 | 1 |
| 94 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2) | | 4 | 4 | 1 |
| 95 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 4, 2, 3) AND `AdvertisementSize`.`code` = 'wide-skyscraper' | | 1 | 1 | 0 |
| 96 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 4 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 97 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Starlets' | | 1 | 1 | 0 |
| 98 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3) | | 4 | 4 | 0 |
| 99 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (3, 1, 2, 4) AND `AdvertisementSize`.`code` = 'wide-skyscraper' | | 1 | 1 | 0 |
| 100 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 4 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 101 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog' | | 1 | 1 | 0 |
| 102 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11) | | 4 | 4 | 0 |
| 103 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'wide-skyscraper' | | 1 | 1 | 0 |
| 104 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 4 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 105 | SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News' | | 1 | 1 | 1 |
| 106 | SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10) | | 4 | 4 | 1 |
| 107 | SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`alias`, `Advertisement`.`advertisement_type_id`, `Advertisement`.`advertisement_size_id`, `Advertisement`.`code`, `Advertisement`.`image`, `Advertisement`.`link`, `Advertisement`.`created_on`, `Advertisement`.`modified_on`, `AdvertisementType`.`id`, `AdvertisementType`.`name`, `AdvertisementType`.`command`, `AdvertisementSize`.`id`, `AdvertisementSize`.`name`, `AdvertisementSize`.`code` FROM `db94586_clubdistrict_new`.`club_advertisements` AS `Advertisement` LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_types` AS `AdvertisementType` ON (`Advertisement`.`advertisement_type_id` = `AdvertisementType`.`id`) LEFT JOIN `db94586_clubdistrict_new`.`club_advertisement_sizes` AS `AdvertisementSize` ON (`Advertisement`.`advertisement_size_id` = `AdvertisementSize`.`id`) WHERE `Advertisement`.`id` IN (1, 2, 3, 4) AND `AdvertisementSize`.`code` = 'wide-skyscraper' | | 1 | 1 | 1 |
| 108 | SELECT `AdPage`.`id`, `AdPage`.`name`, `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id`, `AdvertisementsAdPage`.`page_id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` JOIN `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` ON (`AdvertisementsAdPage`.`advertisement_id` = 4 AND `AdvertisementsAdPage`.`page_id` = `AdPage`.`id`) | | 6 | 6 | 1 |
| 109 | SELECT `BlogCategory`.`slug`, `BlogCategory`.`name`, `BlogCategory`.`blog_count` FROM `db94586_clubdistrict_new`.`club_blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`active` = '1' ORDER BY `BlogCategory`.`name` ASC | | 5 | 5 | 1 |
