Club District

Loading...

Loading...

Loading...

Loading...

(default) 109 queries took 346 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `db94586_clubdistrict_new`.`club_cake_sessions` AS `Session` WHERE `id` = '3e75704cd6e108cd1fb931acc8bf7ff5' LIMIT 1002
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 1110
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`) 001
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 8882
6SELECT `HomeBlock`.`id`, `HomeBlock`.`title` FROM `db94586_clubdistrict_new`.`club_home_blocks` AS `HomeBlock` WHERE `HomeBlock`.`name` IN ('events', 'galleries', 'starlets', 'musics')442
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)442
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')551
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)551
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)881
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`) 24244
13SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'111
14SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)440
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'111
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`) 664
17SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events'110
18SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1)444
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'112
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`) 660
21SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries'111
22SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)441
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'111
26SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3)441
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'111
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`) 661
29SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog'111
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'114
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`) 662
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)441
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`) 662
37SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'112
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'112
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`) 66205
41SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events'111
42SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1)442
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'112
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`) 661
45SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Galleries'112
46SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)441
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`) 662
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)441
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`) 662
53SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog'110
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'111
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'110
58SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10)442
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'111
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`) 661
61SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'112
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`) 661
65SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events'111
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'112
70SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)442
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'112
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`) 661
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'112
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`) 661
77SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Blog'111
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'111
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`) 661
81SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News'111
82SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10)441
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`) 661
85SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'111
86SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)441
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'111
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`) 662
89SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Events'111
90SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1)441
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)442
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'111
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'111
98SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3)441
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'111
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'111
102SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11)442
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'111
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`) 664
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'112
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 `Event`.`id`, `Event`.`name`, `Event`.`flyer_front` FROM `db94586_clubdistrict_new`.`club_events` AS `Event` WHERE `Event`.`featured` = '1' ORDER BY `Event`.`start_date` ASC330