Club District
(default) 109 queries took 119 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `db94586_clubdistrict_new`.`club_cake_sessions` AS `Session` WHERE `id` = '2d1662053cfc94ebcd4805cbe760c123' LIMIT 1001
2SELECT `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 1111
3SELECT `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 1111
4SELECT `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`) 000
5SELECT `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 8883
6SELECT `HomeBlock`.`id`, `HomeBlock`.`title` FROM `db94586_clubdistrict_new`.`club_home_blocks` AS `HomeBlock` WHERE `HomeBlock`.`name` IN ('events', 'galleries', 'starlets', 'musics')440
7SELECT `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)446
8SELECT `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')550
9SELECT `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)553
10SELECT `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)991
11SELECT `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 = 1552
12SELECT `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`) 24240
13SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'114
14SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)441
15SELECT `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'113
16SELECT `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`) 661
17SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events'112
18SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1)442
19SELECT `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'111
20SELECT `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`) 666
21SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries'110
22SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)445
23SELECT `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'111
24SELECT `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`) 661
25SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Starlets'110
26SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3)440
27SELECT `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'110
28SELECT `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`) 660
29SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog'110
30SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11)441
31SELECT `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'111
32SELECT `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`) 660
33SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News'111
34SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10)440
35SELECT `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'111
36SELECT `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`) 661
37SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'113
38SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)441
39SELECT `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'117
40SELECT `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`) 664
41SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events'110
42SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1)440
43SELECT `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'110
44SELECT `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`) 660
45SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries'110
46SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)440
47SELECT `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'111
48SELECT `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`) 660
49SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Starlets'111
50SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3)440
51SELECT `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'111
52SELECT `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`) 661
53SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog'111
54SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11)440
55SELECT `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'110
56SELECT `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`) 660
57SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News'112
58SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10)446
59SELECT `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'110
60SELECT `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`) 660
61SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'110
62SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)442
63SELECT `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'111
64SELECT `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`) 660
65SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events'110
66SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1)441
67SELECT `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'111
68SELECT `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`) 661
69SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries'110
70SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)441
71SELECT `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'110
72SELECT `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`) 660
73SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Starlets'111
74SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3)441
75SELECT `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'111
76SELECT `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`) 660
77SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog'110
78SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11)441
79SELECT `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'110
80SELECT `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`) 660
81SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News'110
82SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10)440
83SELECT `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'111
84SELECT `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`) 660
85SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'110
86SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)4416
87SELECT `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'110
88SELECT `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`) 660
89SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events'110
90SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1)440
91SELECT `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'112
92SELECT `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`) 661
93SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries'111
94SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)441
95SELECT `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'110
96SELECT `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`) 661
97SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Starlets'110
98SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3)440
99SELECT `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'110
100SELECT `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`) 661
101SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog'110
102SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11)440
103SELECT `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'110
104SELECT `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`) 661
105SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News'111
106SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10)441
107SELECT `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'111
108SELECT `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`) 661
109SELECT `BlogCategory`.`slug`, `BlogCategory`.`name`, `BlogCategory`.`blog_count` FROM `db94586_clubdistrict_new`.`club_blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`active` = '1' ORDER BY `BlogCategory`.`name` ASC551