1 |
SELECT `Intro`.*, `I18n__title`.`content`, `I18n__body`.`content` FROM `intros` AS `Intro` LEFT JOIN `i18n` AS `I18n__title` ON (`Intro`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Intro' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__body` ON (`Intro`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Intro' AND `I18n__body`.`field` = 'body') WHERE `Intro`.`model` = 'Programme' AND `I18n__title`.`locale` = 'eng' AND `I18n__body`.`locale` = 'eng' LIMIT 1 |
|
0 |
0 |
0 |
2 |
SELECT `Setting`.`id`, `Setting`.`website_name`, `Setting`.`website_url`, `Setting`.`logo_path`, `Setting`.`contact_form_email`, `Setting`.`orders_email`, `Setting`.`front_end_pagination_limit`, `Setting`.`back_end_pagination_limit`, `Setting`.`phone_1`, `Setting`.`phone_2`, `Setting`.`mobile`, `Setting`.`fax`, `Setting`.`email_address_1`, `Setting`.`email_address_2`, `Setting`.`address_line_1`, `Setting`.`address_line_2`, `Setting`.`city`, `Setting`.`state_province`, `Setting`.`country`, `Setting`.`business_hours`, `Setting`.`zip_postal_code`, `Setting`.`region`, `Setting`.`copyright` FROM `settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 |
|
1 |
1 |
0 |
3 |
SELECT `Programme`.*, `ProgrammeGroup`.*, `I18n__title`.`content`, `I18n__sections_title`.`content`, `I18n__mission_statement`.`content`, `I18n__description`.`content`, `Programme`.`id` FROM `programmes` AS `Programme` LEFT JOIN `i18n` AS `I18n__title` ON (`Programme`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Programme' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__sections_title` ON (`Programme`.`id` = `I18n__sections_title`.`foreign_key` AND `I18n__sections_title`.`model` = 'Programme' AND `I18n__sections_title`.`field` = 'sections_title') LEFT JOIN `i18n` AS `I18n__mission_statement` ON (`Programme`.`id` = `I18n__mission_statement`.`foreign_key` AND `I18n__mission_statement`.`model` = 'Programme' AND `I18n__mission_statement`.`field` = 'mission_statement') LEFT JOIN `i18n` AS `I18n__description` ON (`Programme`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Programme' AND `I18n__description`.`field` = 'description') LEFT JOIN `programme_groups` AS `ProgrammeGroup` ON (`Programme`.`programme_group_id` = `ProgrammeGroup`.`id`) WHERE `Programme`.`enabled` = 1 AND `Programme`.`programme_group_id` = 4 AND `I18n__title`.`locale` = 'eng' AND `I18n__sections_title`.`locale` = 'eng' AND `I18n__mission_statement`.`locale` = 'eng' AND `I18n__description`.`locale` = 'eng' |
|
3 |
3 |
0 |
4 |
SELECT `ProgrammeSection`.`id`, `ProgrammeSection`.`programme_id`, `ProgrammeSection`.`title`, `ProgrammeSection`.`description`, `ProgrammeSection`.`additional_resources`, `ProgrammeSection`.`main_photo_id`, `ProgrammeSection`.`logo_path` FROM `programme_sections` AS `ProgrammeSection` WHERE `ProgrammeSection`.`programme_id` IN (58, 57, 56) |
|
4 |
4 |
0 |
5 |
SELECT `Resource`.`id`, `Resource`.`description`, `Resource`.`title`, `Resource`.`resource_category_id`, `Resource`.`filepath`, `Resource`.`webpath`, `Resource`.`size`, `Resource`.`created`, `Resource`.`modified`, `Resource`.`dcount`, `Resource`.`filename`, `Resource`.`type`, `Resource`.`enabled`, `ProgrammesResource`.`id`, `ProgrammesResource`.`programme_id`, `ProgrammesResource`.`resource_id` FROM `resources` AS `Resource` JOIN `programmes_resources` AS `ProgrammesResource` ON (`ProgrammesResource`.`programme_id` IN (58, 57, 56) AND `ProgrammesResource`.`resource_id` = `Resource`.`id`) WHERE `Resource`.`enabled` = 1 |
|
2 |
2 |
0 |
6 |
SELECT `Album`.`id`, `Album`.`title`, `Album`.`web-title`, `Album`.`description`, `Album`.`parent_id`, `Album`.`lft`, `Album`.`rght`, `Album`.`main_photo_id`, `Album`.`copyright`, `Album`.`enabled`, `Album`.`created`, `Album`.`modified`, `AlbumsProgramme`.`id`, `AlbumsProgramme`.`album_id`, `AlbumsProgramme`.`programme_id` FROM `albums` AS `Album` JOIN `albums_programmes` AS `AlbumsProgramme` ON (`AlbumsProgramme`.`programme_id` IN (58, 57, 56) AND `AlbumsProgramme`.`album_id` = `Album`.`id`) WHERE `Album`.`enabled` = 1 |
|
1 |
1 |
0 |
7 |
SELECT `Intro`.*, `I18n__title`.`content`, `I18n__body`.`content` FROM `intros` AS `Intro` LEFT JOIN `i18n` AS `I18n__title` ON (`Intro`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Intro' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__body` ON (`Intro`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Intro' AND `I18n__body`.`field` = 'body') WHERE `Intro`.`model` = 'ProgrammeSection' AND `I18n__title`.`locale` = 'eng' AND `I18n__body`.`locale` = 'eng' LIMIT 1 |
|
0 |
0 |
0 |
8 |
SELECT `Setting`.`id`, `Setting`.`website_name`, `Setting`.`website_url`, `Setting`.`logo_path`, `Setting`.`contact_form_email`, `Setting`.`orders_email`, `Setting`.`front_end_pagination_limit`, `Setting`.`back_end_pagination_limit`, `Setting`.`phone_1`, `Setting`.`phone_2`, `Setting`.`mobile`, `Setting`.`fax`, `Setting`.`email_address_1`, `Setting`.`email_address_2`, `Setting`.`address_line_1`, `Setting`.`address_line_2`, `Setting`.`city`, `Setting`.`state_province`, `Setting`.`country`, `Setting`.`business_hours`, `Setting`.`zip_postal_code`, `Setting`.`region`, `Setting`.`copyright` FROM `settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 |
|
1 |
1 |
0 |
9 |
SELECT `ProgrammeSection`.*, `Programme`.*, `I18n__title`.`content`, `I18n__description`.`content`, `ProgrammeSection`.`id` FROM `programme_sections` AS `ProgrammeSection` LEFT JOIN `i18n` AS `I18n__title` ON (`ProgrammeSection`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'ProgrammeSection' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__description` ON (`ProgrammeSection`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'ProgrammeSection' AND `I18n__description`.`field` = 'description') LEFT JOIN `programmes` AS `Programme` ON (`ProgrammeSection`.`programme_id` = `Programme`.`id`) WHERE `ProgrammeSection`.`programme_id` = 49 AND `I18n__title`.`locale` = 'eng' AND `I18n__description`.`locale` = 'eng' |
|
5 |
5 |
0 |
10 |
SELECT `SectionPhoto`.`id`, `SectionPhoto`.`title`, `SectionPhoto`.`description`, `SectionPhoto`.`path`, `SectionPhoto`.`programme_section_id`, `SectionPhoto`.`filename`, `SectionPhoto`.`webpath`, `SectionPhoto`.`size`, `SectionPhoto`.`created` FROM `section_photos` AS `SectionPhoto` WHERE `SectionPhoto`.`programme_section_id` IN (29, 28, 27, 25, 26) |
|
0 |
0 |
0 |
11 |
SELECT `ProgrammeSubsection`.`id`, `ProgrammeSubsection`.`programme_section_id`, `ProgrammeSubsection`.`title`, `ProgrammeSubsection`.`description`, `ProgrammeSubsection`.`additional_resources`, `ProgrammeSubsection`.`main_photo_id`, `ProgrammeSubsection`.`logo_path` FROM `programme_subsections` AS `ProgrammeSubsection` WHERE `ProgrammeSubsection`.`programme_section_id` IN (29, 28, 27, 25, 26) |
|
3 |
3 |
0 |
12 |
SELECT `Resource`.`id`, `Resource`.`description`, `Resource`.`title`, `Resource`.`resource_category_id`, `Resource`.`filepath`, `Resource`.`webpath`, `Resource`.`size`, `Resource`.`created`, `Resource`.`modified`, `Resource`.`dcount`, `Resource`.`filename`, `Resource`.`type`, `Resource`.`enabled`, `ProgrammeSectionsResource`.`id`, `ProgrammeSectionsResource`.`programme_section_id`, `ProgrammeSectionsResource`.`resource_id` FROM `resources` AS `Resource` JOIN `programme_sections_resources` AS `ProgrammeSectionsResource` ON (`ProgrammeSectionsResource`.`programme_section_id` IN (29, 28, 27, 25, 26) AND `ProgrammeSectionsResource`.`resource_id` = `Resource`.`id`) WHERE `Resource`.`enabled` = 1 |
|
2 |
2 |
0 |
13 |
SELECT `Album`.`id`, `Album`.`title`, `Album`.`web-title`, `Album`.`description`, `Album`.`parent_id`, `Album`.`lft`, `Album`.`rght`, `Album`.`main_photo_id`, `Album`.`copyright`, `Album`.`enabled`, `Album`.`created`, `Album`.`modified`, `AlbumsProgrammeSection`.`id`, `AlbumsProgrammeSection`.`album_id`, `AlbumsProgrammeSection`.`programme_section_id` FROM `albums` AS `Album` JOIN `albums_programme_sections` AS `AlbumsProgrammeSection` ON (`AlbumsProgrammeSection`.`programme_section_id` IN (29, 28, 27, 25, 26) AND `AlbumsProgrammeSection`.`album_id` = `Album`.`id`) WHERE `Album`.`enabled` = 1 |
|
4 |
4 |
0 |
14 |
SELECT `Intro`.*, `I18n__title`.`content`, `I18n__body`.`content` FROM `intros` AS `Intro` LEFT JOIN `i18n` AS `I18n__title` ON (`Intro`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Intro' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__body` ON (`Intro`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Intro' AND `I18n__body`.`field` = 'body') WHERE `Intro`.`model` = 'Programme' AND `I18n__title`.`locale` = 'eng' AND `I18n__body`.`locale` = 'eng' LIMIT 1 |
|
0 |
0 |
0 |
15 |
SELECT `Setting`.`id`, `Setting`.`website_name`, `Setting`.`website_url`, `Setting`.`logo_path`, `Setting`.`contact_form_email`, `Setting`.`orders_email`, `Setting`.`front_end_pagination_limit`, `Setting`.`back_end_pagination_limit`, `Setting`.`phone_1`, `Setting`.`phone_2`, `Setting`.`mobile`, `Setting`.`fax`, `Setting`.`email_address_1`, `Setting`.`email_address_2`, `Setting`.`address_line_1`, `Setting`.`address_line_2`, `Setting`.`city`, `Setting`.`state_province`, `Setting`.`country`, `Setting`.`business_hours`, `Setting`.`zip_postal_code`, `Setting`.`region`, `Setting`.`copyright` FROM `settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 |
|
1 |
1 |
0 |
16 |
SELECT `Programme`.*, `ProgrammeGroup`.*, `I18n__title`.`content`, `I18n__sections_title`.`content`, `I18n__mission_statement`.`content`, `I18n__description`.`content`, `Programme`.`id` FROM `programmes` AS `Programme` LEFT JOIN `i18n` AS `I18n__title` ON (`Programme`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Programme' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__sections_title` ON (`Programme`.`id` = `I18n__sections_title`.`foreign_key` AND `I18n__sections_title`.`model` = 'Programme' AND `I18n__sections_title`.`field` = 'sections_title') LEFT JOIN `i18n` AS `I18n__mission_statement` ON (`Programme`.`id` = `I18n__mission_statement`.`foreign_key` AND `I18n__mission_statement`.`model` = 'Programme' AND `I18n__mission_statement`.`field` = 'mission_statement') LEFT JOIN `i18n` AS `I18n__description` ON (`Programme`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Programme' AND `I18n__description`.`field` = 'description') LEFT JOIN `programme_groups` AS `ProgrammeGroup` ON (`Programme`.`programme_group_id` = `ProgrammeGroup`.`id`) WHERE `Programme`.`enabled` = 1 AND `Programme`.`programme_group_id` = 3 AND `I18n__title`.`locale` = 'eng' AND `I18n__sections_title`.`locale` = 'eng' AND `I18n__mission_statement`.`locale` = 'eng' AND `I18n__description`.`locale` = 'eng' |
|
6 |
6 |
0 |
17 |
SELECT `ProgrammeSection`.`id`, `ProgrammeSection`.`programme_id`, `ProgrammeSection`.`title`, `ProgrammeSection`.`description`, `ProgrammeSection`.`additional_resources`, `ProgrammeSection`.`main_photo_id`, `ProgrammeSection`.`logo_path` FROM `programme_sections` AS `ProgrammeSection` WHERE `ProgrammeSection`.`programme_id` IN (55, 54, 49, 50, 53, 52) |
|
11 |
11 |
0 |
18 |
SELECT `Resource`.`id`, `Resource`.`description`, `Resource`.`title`, `Resource`.`resource_category_id`, `Resource`.`filepath`, `Resource`.`webpath`, `Resource`.`size`, `Resource`.`created`, `Resource`.`modified`, `Resource`.`dcount`, `Resource`.`filename`, `Resource`.`type`, `Resource`.`enabled`, `ProgrammesResource`.`id`, `ProgrammesResource`.`programme_id`, `ProgrammesResource`.`resource_id` FROM `resources` AS `Resource` JOIN `programmes_resources` AS `ProgrammesResource` ON (`ProgrammesResource`.`programme_id` IN (55, 54, 49, 50, 53, 52) AND `ProgrammesResource`.`resource_id` = `Resource`.`id`) WHERE `Resource`.`enabled` = 1 |
|
6 |
6 |
0 |
19 |
SELECT `Album`.`id`, `Album`.`title`, `Album`.`web-title`, `Album`.`description`, `Album`.`parent_id`, `Album`.`lft`, `Album`.`rght`, `Album`.`main_photo_id`, `Album`.`copyright`, `Album`.`enabled`, `Album`.`created`, `Album`.`modified`, `AlbumsProgramme`.`id`, `AlbumsProgramme`.`album_id`, `AlbumsProgramme`.`programme_id` FROM `albums` AS `Album` JOIN `albums_programmes` AS `AlbumsProgramme` ON (`AlbumsProgramme`.`programme_id` IN (55, 54, 49, 50, 53, 52) AND `AlbumsProgramme`.`album_id` = `Album`.`id`) WHERE `Album`.`enabled` = 1 |
|
5 |
5 |
0 |
20 |
SELECT `Intro`.*, `I18n__title`.`content`, `I18n__body`.`content` FROM `intros` AS `Intro` LEFT JOIN `i18n` AS `I18n__title` ON (`Intro`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Intro' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__body` ON (`Intro`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Intro' AND `I18n__body`.`field` = 'body') WHERE `Intro`.`model` = 'PressRelease' AND `I18n__title`.`locale` = 'eng' AND `I18n__body`.`locale` = 'eng' LIMIT 1 |
|
0 |
0 |
0 |
21 |
SELECT `Setting`.`id`, `Setting`.`website_name`, `Setting`.`website_url`, `Setting`.`logo_path`, `Setting`.`contact_form_email`, `Setting`.`orders_email`, `Setting`.`front_end_pagination_limit`, `Setting`.`back_end_pagination_limit`, `Setting`.`phone_1`, `Setting`.`phone_2`, `Setting`.`mobile`, `Setting`.`fax`, `Setting`.`email_address_1`, `Setting`.`email_address_2`, `Setting`.`address_line_1`, `Setting`.`address_line_2`, `Setting`.`city`, `Setting`.`state_province`, `Setting`.`country`, `Setting`.`business_hours`, `Setting`.`zip_postal_code`, `Setting`.`region`, `Setting`.`copyright` FROM `settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 |
|
1 |
1 |
0 |
22 |
SELECT `PressRelease`.*, `I18n__title`.`content`, `I18n__summary`.`content`, `I18n__body`.`content` FROM `press_releases` AS `PressRelease` LEFT JOIN `i18n` AS `I18n__title` ON (`PressRelease`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'PressRelease' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__summary` ON (`PressRelease`.`id` = `I18n__summary`.`foreign_key` AND `I18n__summary`.`model` = 'PressRelease' AND `I18n__summary`.`field` = 'summary') LEFT JOIN `i18n` AS `I18n__body` ON (`PressRelease`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'PressRelease' AND `I18n__body`.`field` = 'body') WHERE `PressRelease`.`enabled` = 1 AND `I18n__title`.`locale` = 'eng' AND `I18n__summary`.`locale` = 'eng' AND `I18n__body`.`locale` = 'eng' ORDER BY `published` DESC, `id` DESC LIMIT 1 |
|
1 |
1 |
0 |