Club District

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

(default) 112 queries took 66 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `db94586_clubdistrict_new`.`club_cake_sessions` AS `Session` WHERE `id` = '90ae38414372afe300d07850d2e1e76c' LIMIT 1003
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 8880
6SELECT `HomeBlock`.`id`, `HomeBlock`.`title` FROM `db94586_clubdistrict_new`.`club_home_blocks` AS `HomeBlock` WHERE `HomeBlock`.`name` IN ('events', 'galleries', 'starlets', 'musics')441
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)440
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)550
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 = 1551
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`) 24242
13SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'Home'110
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'110
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`) 660
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)440
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'110
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'110
22SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)440
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'110
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`) 660
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'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'117
30SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11)440
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'110
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'110
34SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10)442
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'111
38SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)440
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'111
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`) 662
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)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'111
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'110
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'113
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`) 660
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)441
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`) 661
57SELECT `AdPage`.`id` FROM `db94586_clubdistrict_new`.`club_ad_pages` AS `AdPage` WHERE `AdPage`.`name` = 'News'111
58SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (10)441
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'110
62SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)441
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'110
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'111
66SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (1)440
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`) 660
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)440
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'110
74SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (3)440
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'110
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'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`) 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'111
86SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (8)440
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`) 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'110
94SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (2)440
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`) 660
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)442
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'110
102SELECT `AdvertisementsAdPage`.`id`, `AdvertisementsAdPage`.`advertisement_id` FROM `db94586_clubdistrict_new`.`club_advertisements_ad_pages` AS `AdvertisementsAdPage` WHERE `AdvertisementsAdPage`.`page_id` = (11)441
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'112
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`) 660
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`) 662
109SELECT `StarletActivation`.`activation_year` FROM `db94586_clubdistrict_new`.`club_starlet_activations` AS `StarletActivation` WHERE 1 = 1 GROUP BY `StarletActivation`.`activation_year` ORDER BY `StarletActivation`.`activation_year` desc660
110SELECT `Starlet`.`id`, `Starlet`.`firstname`, `Starlet`.`lastname`, `StarletActivation`.`activation_year`, `StarletActivation`.`activation_month` FROM `db94586_clubdistrict_new`.`club_starlets` AS `Starlet` LEFT JOIN `db94586_clubdistrict_new`.`club_starlet_activations` AS `StarletActivation` ON (`StarletActivation`.`starlet_id` = `Starlet`.`id`) WHERE `Starlet`.`is_active` = '1' AND `Starlet`.`featured` = '1' ORDER BY `Starlet`.`id` DESC220
111SELECT `StarletPhoto`.`name`, `StarletPhoto`.`starlet_id` FROM `db94586_clubdistrict_new`.`club_starlet_photos` AS `StarletPhoto` WHERE `StarletPhoto`.`starlet_id` = (107) LIMIT 1111
112SELECT `StarletPhoto`.`name`, `StarletPhoto`.`starlet_id` FROM `db94586_clubdistrict_new`.`club_starlet_photos` AS `StarletPhoto` WHERE `StarletPhoto`.`starlet_id` = (98) LIMIT 1110