Skip to Content
BC Colleges logo
Accessible. Affordable. Applied.
twitter instagram facebook linkedin
  • Home
  • Our Colleges
  • Student Resources
    • Resources
    • Why Study in BC?
    • College vs. University
    • Indigenous Students
    • International Students
    • Transfer Programs
  • Partnerships
    • Partnership Highlights
    • SkillPlan: EPATT Project
    • Skilled Workforce
    • Strong Communities
    • Competitive Advantage
    • Strong ROI
    • Innovation
  • News
    • In the News
    • Our Future
    • Share Your Story
    • Newsletter Archive
    • Social Media
    • Key Studies
  • About Us
    • About BC Colleges
    • Our Team
    • Our Impact

News

Newsletter Archive - 2017

January 1st, 2017

JUNE 2017
What’s New at BC Colleges: June 2017

MAY 2017
What’s New at BC Colleges: May 2017

APRIL 2017
What’s New at BC Colleges: April 2017

MARCH 2017
What’s New at BC Colleges: March 2017

FEBRUARY 2017
What’s New at BC Colleges: February 2017 | Printable Version - February 2017

JANUARY 2017
What’s New at BC Colleges: January 2017 | Printable Version - January 2017

Categories: What's New
Tags: What's New

Did You Know?

Graduate Transition

Over 90% of BC college students graduate and transition into the workforce within six months.

Newsletter Sign Up Keep up on “What’s New at BC Colleges”

* denotes a required field.

Connect with Us!

twitter instagram facebook linkedin

#201-534 Pandora Avenue
Victoria, BC V8W 1N6
Tel: 250-595-4866

BC Colleges logo
  • Home
  • Our Colleges
  • Student Resources
  • Partnerships
  • News
  • About Us
  • Contact
  • Sitemap
  • Privacy Policy
  • Terms of Use
Copyright © 2017 - 2022 BC Colleges | A post secondary BC Colleges website by Radar Hill Web Design
The content of this website is the responsibility of the website owner.
  • CakePHP
  • History
    +

    Request History

    4 previous requests available
    • Restore to current request
    • news/posts/minutes-(jan-20/14-bcc-presidents-meeting)/272/page:9
    • news/posts/college-to-career-centre-takes-off-in-new-space
    • news/posts/www.nwcc.bc.ca/news/high-school-students-kickstart-their-post-secondary-studies%5C%5C%5C%22/page:21/1/17/284/22/19/%5C%5C%5C%22http:
    • news/posts/www.nwcc.bc.ca/news/student-food-bank-big-success%5C%5C%5C%22/page:261/262/262/%5C%5C%5C%22http:
    ====
  • Session
    +

    Session

    • Config
      • userAgent
      • time1652789959
      • countdown10
    • Users
      • User(empty)
    ====
  • Request
    +

    Request

    Cake Params

    • pluginblog
    • controllerblog_posts
    • actionview
    • named(empty)
    • pass(empty)
    • slugnewsletter-archive-2017
    • isAjax(false)

    Post data

    No post data.

    Query string

    No querystring data.

    Cookie

    • 0(empty)

    Current Route

    • keys
      • 0slug
    • options
      • slug[a-zA-Z0-9_-]+
    • defaults
      • pluginblog
      • controllerblog_posts
      • actionview
    • template/news/posts/:slug/*
    ====
  • Sql Log
    +

    Sql Logs

    default

    Total Time: 7 ms
    Total Queries: 136 queries
    Query Affected Num. rows Took (ms) Actions
    SELECT `BootstrapInstance`.`id`, `BootstrapInstance`.`name`, `BootstrapInstance`.`slug` FROM `bccolleges_database`.`prototype_instances` AS `BootstrapInstance` WHERE 1 = 1 8 8 0
    SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `bccolleges_database`.`permissions` AS `Permission` WHERE `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC 79 79 1
    SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `bccolleges_database`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 0 0 0
    SELECT `BlogPost`.`id`, `BlogPost`.`user_id`, `BlogPost`.`author`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`url`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`allow_commenting`, `BlogPost`.`sticky`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`deleted`, `BlogPost`.`deleted_date`, `BlogPost`.`rank`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`blog_posts` AS `BlogPost` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `BlogPost`.`id` AND `PublishingInformation`.`model` = 'BlogPost') WHERE `PublishingInformation`.`published` = '1' AND `BlogPost`.`deleted` = '0' AND `BlogPost`.`slug` = 'newsletter-archive-2017' LIMIT 1 1 1 4 maybe slow
    SELECT `BlogPostComment`.`id`, `BlogPostComment`.`blog_post_id`, `BlogPostComment`.`name`, `BlogPostComment`.`email`, `BlogPostComment`.`text`, `BlogPostComment`.`approved`, `BlogPostComment`.`created`, `BlogPostComment`.`modified`, `BlogPostComment`.`deleted`, `BlogPostComment`.`deleted_date` FROM `bccolleges_database`.`blog_post_comments` AS `BlogPostComment` WHERE `BlogPostComment`.`deleted` = '0' AND `BlogPostComment`.`blog_post_id` = (14053) ORDER BY `BlogPostComment`.`id` DESC 0 0 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'BlogPost' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (14053) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'BlogPost' AND `MetaValue`.`foreign_key` = (14053) 0 0 0
    SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`deleted`, `BlogCategory`.`deleted_date`, `BlogPostCategory`.`id`, `BlogPostCategory`.`blog_category_id`, `BlogPostCategory`.`blog_post_id` FROM `bccolleges_database`.`blog_categories` AS `BlogCategory` JOIN `bccolleges_database`.`blog_post_categories` AS `BlogPostCategory` ON (`BlogPostCategory`.`blog_post_id` = 14053 AND `BlogPostCategory`.`blog_category_id` = `BlogCategory`.`id`) 1 1 0
    SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`slug`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogTag`.`deleted`, `BlogTag`.`deleted_date`, `BlogPostTag`.`id`, `BlogPostTag`.`blog_tag_id`, `BlogPostTag`.`blog_post_id` FROM `bccolleges_database`.`blog_tags` AS `BlogTag` JOIN `bccolleges_database`.`blog_post_tags` AS `BlogPostTag` ON (`BlogPostTag`.`blog_post_id` = 14053 AND `BlogPostTag`.`blog_tag_id` = `BlogTag`.`id`) 1 1 1
    SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `bccolleges_database`.`pages` AS `Page` WHERE `controller` = 'blog_posts' AND `action` = 'view' AND `extra` = 'newsletter-archive-2017' AND `Page`.`deleted` = '0' LIMIT 1 0 0 0
    SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `bccolleges_database`.`pages` AS `Page` WHERE `controller` = 'blog_posts' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1 0 0 0
    SELECT `MetaKey`.`id`, `MetaKey`.`name`, `MetaKey`.`default`, `MetaKey`.`allow_default` FROM `bccolleges_database`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC 5 5 0
    SELECT `MetaKey`.`id`, `MetaKey`.`created`, `MetaKey`.`modified`, `MetaKey`.`name`, `MetaKey`.`type`, `MetaKey`.`default`, `MetaKey`.`rank`, `MetaKey`.`allow_default` FROM `bccolleges_database`.`meta_keys` AS `MetaKey` WHERE `MetaKey`.`name` = 'og:image' ORDER BY `MetaKey`.`rank` ASC LIMIT 1 1 1 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Blog.commenting_disabled' LIMIT 1 1 1 0
    SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `bccolleges_database`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 1 1 0
    SELECT `AttachmentVersion`.`id`, `AttachmentVersion`.`created`, `AttachmentVersion`.`modified`, `AttachmentVersion`.`model`, `AttachmentVersion`.`foreign_key`, `AttachmentVersion`.`group`, `AttachmentVersion`.`name`, `AttachmentVersion`.`type`, `AttachmentVersion`.`convert`, `AttachmentVersion`.`width`, `AttachmentVersion`.`height`, `AttachmentVersion`.`bgcolour`, `AttachmentVersion`.`gravity`, `AttachmentVersion`.`deleted`, `AttachmentVersion`.`deleted_date` FROM `bccolleges_database`.`attachment_versions` AS `AttachmentVersion` WHERE `AttachmentVersion`.`deleted` = '0' 89 89 0
    SELECT `Setting`.`key`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` LIKE 'Site.Contact.%' AND `Setting`.`value` != '' 7 7 0
    SELECT `ContentBlock`.`id`, `ContentBlock`.`name` FROM `bccolleges_database`.`content_blocks` AS `ContentBlock` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ContentBlock`.`id` AND `PublishingInformation`.`model` = 'ContentBlock') WHERE `ContentBlock`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 01:19:19' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 01:19:19')) 1 1 0
    SELECT `EmailForm`.`id`, `EmailForm`.`name` FROM `bccolleges_database`.`email_forms` AS `EmailForm` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `EmailForm`.`id` AND `PublishingInformation`.`model` = 'EmailForm') WHERE `EmailForm`.`super_admin` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 01:19:19' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 01:19:19')) AND `EmailForm`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC 2 2 0
    SELECT `Gallery`.`id`, `Gallery`.`name` FROM `bccolleges_database`.`galleries` AS `Gallery` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Gallery`.`id` AND `PublishingInformation`.`model` = 'Gallery') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 01:19:19' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 01:19:19')) AND `Gallery`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC 5 5 0
    SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0' 7 7 0
    SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` IN (2, 3, 4, 5, 6, 7, 8) 35 35 0
    SELECT `HeaderSlideshowImage`.`id`, `HeaderSlideshowImage`.`model`, `HeaderSlideshowImage`.`foreign_key`, `HeaderSlideshowImage`.`dirname`, `HeaderSlideshowImage`.`basename`, `HeaderSlideshowImage`.`checksum`, `HeaderSlideshowImage`.`alternative`, `HeaderSlideshowImage`.`group`, `HeaderSlideshowImage`.`created`, `HeaderSlideshowImage`.`modified`, `HeaderSlideshowImage`.`rank`, `HeaderSlideshowImage`.`deleted`, `HeaderSlideshowImage`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `HeaderSlideshowImage__path` FROM `bccolleges_database`.`attachments` AS `HeaderSlideshowImage` WHERE `model` = 'InstalledPlugin' AND `foreign_key` = 28 AND `group` = 'Header Slideshow' ORDER BY `HeaderSlideshowImage`.`rank` ASC, `HeaderSlideshowImage`.`rank` ASC 5 5 0
    SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `bccolleges_database`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'HeaderSlideshowImage' AND `CustomFieldValue`.`foreign_key` IN (728, 179, 729, 176, 180) 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.gtm_association_code' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (64) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (64) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Bing.verification_code' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (21) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (21) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'ReCaptcha.invisible' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (65) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (65) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `bccolleges_database`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.twitter' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.twitter' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.instagram' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.instagram' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.facebook' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (44) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (44) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.facebook' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (44) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (44) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.linkedin' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (43) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (43) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.linkedin' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (43) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (43) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 1 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC 28 28 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 1 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 2 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 3 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 37 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 21 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 22 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 24 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 25 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 35 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 4 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 14 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 38 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 15 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 16 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 17 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 18 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 19 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 5 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 26 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 36 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 27 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 28 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 31 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 30 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 6 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 34 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 32 LIMIT 1 1 1 0
    SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 33 LIMIT 1 1 1 0
    SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 7 AND `PrototypeInstance`.`deleted` = '0' LIMIT 1 1 1 0
    SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (7) 5 5 0
    SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`featured`, `PrototypeItem`.`deleted`, `PrototypeItem`.`deleted_date`, `PrototypeItem`.`head_title`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`prototype_items` AS `PrototypeItem` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeItem`.`id` AND `PublishingInformation`.`model` = 'PrototypeItem') WHERE `PrototypeItem`.`prototype_instance_id` = 7 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2022-05-17 01:19:20' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2022-05-17 01:19:20')) AND `PrototypeItem`.`deleted` = '0' ORDER BY rand() ASC, `PrototypeItem`.`rank` ASC LIMIT 1 1 1 1
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'PrototypeItem' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (26) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'PrototypeItem' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (26) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `bccolleges_database`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'PrototypeItem' AND `CustomFieldValue`.`foreign_key` = (26) 1 1 0
    SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `bccolleges_database`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeItem' AND `MetaValue`.`foreign_key` = (26) 5 5 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.twitter' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.twitter' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (45) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (45) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.instagram' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.instagram' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (46) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (46) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.facebook' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (44) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (44) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.facebook' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (44) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (44) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.linkedin' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (43) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (43) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Social_Media.linkedin' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (43) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (43) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.address' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (9) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (9) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.city' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (10) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (10) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.province_state' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (11) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (11) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.postal_zip' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (12) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (12) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `bccolleges_database`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.phone' LIMIT 1 1 1 0
    SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `bccolleges_database`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (14) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC 0 0 0
    SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `bccolleges_database`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (14) ORDER BY `Document`.`rank` ASC 0 0 0
    SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `bccolleges_database`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `bccolleges_database`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 2 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC 4 4 0
    SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `bccolleges_database`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 0 0 0
    SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `bccolleges_database`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 1 1 0

    Query Explain:

    Click an "Explain" link above, to see the query explanation.

    ====
  • Timer
    +

    Memory

    Peak Memory Use 34.23 MB

    Message Memory use
    Component initialization 12.13 MB
    Controller action start 14.33 MB
    Controller render start 19.86 MB
    View render complete 26.78 MB

    Timers

    Total Request Time: 340 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 62.46
    Component initialization and startup 10.58
    Controller action 23.28
    Render Controller Action 125.86
    » Rendering View 122.85
    » » Rendering APP/Plugin/Blog/View/BlogPosts/view.ctp 0.60
    » » Rendering APP/View/Layouts/default.ctp 93.86
    » » » Rendering APP/View/Elements/layout/header.ctp 48.72
    » » » » Rendering APP/View/Elements/gtm_head.ctp 0.22
    » » » » Rendering CORE/working/lib/Cms/Plugin/Blog/View/Elements/metas.ctp 0.25
    » » » » Rendering APP/View/Elements/gtm_body.ctp 0.15
    » » » » Rendering APP/View/Elements/svg/twitter.ctp 0.15
    » » » » Rendering APP/View/Elements/svg/instagram.ctp 0.20
    » » » » Rendering APP/View/Elements/svg/facebook.ctp 0.15
    » » » » Rendering APP/View/Elements/svg/linkedin.ctp 0.15
    » » » Rendering APP/View/Elements/layout/default-sidebar.ctp 4.65
    » » » Rendering APP/View/Elements/layout/footer.ctp 35.70
    » » » » Rendering APP/View/Elements/enews.ctp 1.40
    » » » » Rendering APP/View/Elements/svg/twitter.ctp #2 0.17
    » » » » Rendering APP/View/Elements/svg/instagram.ctp #2 0.21
    » » » » Rendering APP/View/Elements/svg/facebook.ctp #2 0.16
    » » » » Rendering APP/View/Elements/svg/linkedin.ctp #2 0.17
    ====
  • Log
    +

    Logs

    logins

    Time Message
    2022-05-17 01:19:19 Array ( [successful_login] => false )
    2022-05-17 01:19:19 Array ( [successful_login] => false )
    2022-05-17 01:19:20 Array ( [successful_login] => false )
    ====
  • Variables
    +

    View Variables

    • metas(empty)
    • layout
    • extraFooterCode
    • extraHeaderCode
    • pageIntro
    • paginationLimit25
    • paginationOptions
      • 01
      • 15
      • 210
      • 325
      • 450
      • 5100
      • 6200
      • 7400
    • pageHeadingNews
    • blogPost
      • BlogPost
        • id14053
        • user_id3
        • authorKaren Sequeira
        • titleNewsletter Archive - 2017
        • slugnewsletter-archive-2017
        • url/news/posts/newsletter-archive-2017
        • summaryJUNE 2017What’s New at BC Colleges: June 2017MAY 2017What’s New at BC Colleges: May 2017
        • body<p><strong><sub>JUNE 2017</sub></strong><br /><a href="http://bccolleges.createsend1.com/t/ViewEmail/t/8778850D585BA07A" target="_blank" rel="noopener noreferrer">What’s New at BC Colleges: June 2017</a></p><p><strong><sub>MAY 2017</sub></strong><br /><a href="https://bccolleges.createsend.com/campaigns/reports/viewCampaign.aspx?d=t&amp;c=39F6641CF697EDD7&amp;ID=9E7ADC316D8729E2&amp;temp=False&amp;tx=0" target="_blank" rel="noopener noreferrer">What’s New at BC Colleges: May 2017</a></p><p><strong><sub>APRIL 2017</sub></strong><br /><a href="https://bccolleges.createsend.com/campaigns/reports/viewCampaign.aspx?d=t&amp;c=39F6641CF697EDD7&amp;ID=F56C87DE85F8711E&amp;temp=False&amp;tx=0" target="_blank" rel="noopener noreferrer">What’s New at BC Colleges: April 2017</a></p><p><strong><sub>MARCH 2017</sub></strong><br /><a href="https://bccolleges.createsend.com/campaigns/reports/viewCampaign.aspx?d=t&amp;c=39F6641CF697EDD7&amp;ID=30BA22ECEC4442EE&amp;temp=False&amp;tx=0" target="_blank" rel="noopener noreferrer">What’s New at BC Colleges: March 2017</a></p><p><strong><sub>FEBRUARY 2017</sub></strong><br /><a href="https://bccolleges.createsend.com/campaigns/reports/viewCampaign.aspx?d=t&amp;c=39F6641CF697EDD7&amp;ID=0D2570C0EA2C390D&amp;temp=False&amp;tx=0" target="_blank" rel="noopener noreferrer">What’s New at BC Colleges: February 2017</a> | <a href="/app/webroot/uploads/2017/01/BCColleges_Newsletter_Feb2017.pdf">Printable Version - February 2017</a></p><p><strong><sub>JANUARY 2017</sub></strong><br /><a href="https://bccolleges.createsend.com/campaigns/reports/viewCampaign.aspx?d=t&amp;c=39F6641CF697EDD7&amp;ID=B4DF6741D2E79C82&amp;temp=False&amp;tx=0" target="_blank" rel="noopener noreferrer">What’s New at BC Colleges: January 2017</a> | <a href="/app/webroot/uploads/2017/02/BCColleges_Newsletter_January2017.pdf">Printable Version - January 2017</a>
        • allow_commenting(false)
        • sticky(false)
        • created2017-01-01 18:07:26
        • modified2017-09-26 10:08:16
        • deleted(false)
        • deleted_date(null)
        • rank0
      • PublishingInformation
        • id2427
        • created2017-09-26 10:27:07
        • modified2017-09-26 10:27:07
        • modelBlogPost
        • foreign_key14053
        • start2017-01-01 18:07:26
        • end(null)
        • published(true)
      • BlogPostComment(empty)
      • Image(empty)
      • MetaValue(empty)
      • BlogCategory
        • 0
          • id54
          • parent_id(null)
          • lft2
          • rght3
          • nameWhat's New
          • slugwhat-s-new
          • created(null)
          • modified2017-09-26 10:27:47
          • deleted(false)
          • deleted_date(null)
          • BlogPostCategory
            • id275
            • blog_category_id54
            • blog_post_id14053
          • url/news/categories/what-s-new
      • BlogTag
        • 0
          • id16
          • nameWhat's New
          • slugwhat-s-new
          • created2017-09-26 09:49:29
          • modified2017-09-26 09:49:29
          • deleted(false)
          • deleted_date(null)
          • BlogPostTag
            • id2014
            • blog_tag_id16
            • blog_post_id14053
          • url/news/tags/what-s-new
    • titleTagNewsletter Archive - 2017 • BC Colleges
    • loggedIn(false)
    • superAdmin(false)
    • admin(false)
    • $request->data(empty)
    • $this->validationErrors
      • CmsPlugin(empty)
      • BootstrapInstance(empty)
      • PrototypeInstance(empty)
      • PrototypeCategory(empty)
      • PrototypeItem(empty)
      • EmailFormSubmission(empty)
      • EmailForm(empty)
      • User(empty)
      • Country(empty)
      • Permission(empty)
      • Group(empty)
      • GroupsPermission(empty)
      • BlogPost(empty)
      • BlogCategory(empty)
      • BlogTag(empty)
      • BlogPostComment(empty)
      • Image(empty)
      • MetaValue(empty)
      • PublishingInformation(empty)
      • BlogPostCategory(empty)
      • BlogPostTag(empty)
      • Page(empty)
      • CustomFieldValue(empty)
      • MetaKey(empty)
      • Setting(empty)
    • Loaded Helpers
      • 0Html
      • 1Form
      • 2Session
      • 3Cms
      • 4AssetCompress
      • 5Copyright
      • 6GoogleMap
      • 7SocialMedia
      • 8ReCaptcha
      • 9Text
      • 10Settings
      • 11AdminLink
      • 12AdminNav
      • 13AdminTab
      • 14ContentBlock
      • 15CustomField
      • 16EmailForm
      • 17EmailFormBlock
      • 18GalleryBlock
      • 19ModelLink
      • 20ModelLoad
      • 21MediaVersion
      • 22Media
      • 23Meta
      • 24Navigation
      • 25Prototype
      • 26PrototypeLink
      • 27Publishing
      • 28Responsive
      • 29Theme
      • 30TinyMce
      • 31Users
      • 32Versioning
      • 33Blog
      • 34HeaderSlideshow
      • 35Toolbar
      • 36Number
      • 37SimpleGraph
      • 38HtmlToolbar
    ====
  • Include
    +

    Included Files

    Include Paths

    • 0/usr/local/share/pyramidcms/old/1_5/working/lib/Cms/Plugin/Media/Lib/mm/src
    • 2/opt/alt/php54/usr/share/pear
    • 3/opt/alt/php54/usr/share/php
    • 4/usr/local/share/pyramidcms/old/1_5/vendors
    • 5-> /home/bccolleges/pyramidcms/old/1_5/Cake/

    Included Files

    • core(empty)
    • app
      • Behavior
        • 0APP/Model/Behavior/DynamicValidationBehavior.php
        • 1APP/Model/Behavior/ValidateHabtmBehavior.php
        • 2APP/Model/Behavior/ReCaptchaBehavior.php
        • 3APP/Model/Behavior/SluggableBehavior.php
        • 4APP/Model/Behavior/CopyableBehavior.php
        • 5APP/Model/Behavior/SortableBehavior.php
        • 6APP/Model/Behavior/MultiTreeBehavior.php
        • 7APP/Model/Behavior/AppTreeBehavior.php
      • Component
        • 0APP/Controller/Component/NotifyComponent.php
        • 1APP/Controller/Component/AutoPaginateComponent.php
        • 2APP/Controller/Component/MobileComponent.php
        • 3APP/Controller/Component/AppPaginatorComponent.php
      • Config
        • 0APP/Config/core.php
        • 1APP/Config/pyramid.php
        • 2APP/Config/bootstrap.php
        • 3APP/Config/database.php
        • 4APP/Lib/Configure/JsonReader.php
        • 5APP/Config/routes.php
      • Controller
        • 0APP/Controller/AppController.php
      • Model
        • 0APP/Model/AppModel.php
      • Other
        • 0APP/webroot/index.php
    • plugins
      • Administration
        • Config
          • 0Administration/Config/bootstrap.php
          • 1Administration/Config/events.php
          • 2Administration/Config/routes.php
        • Plugin
          • 0Administration/Event/AdministrationEventListener.php
        • Component
          • 0Administration/Controller/Component/AdminComponent.php
          • 1Administration/Controller/Component/AdminNavComponent.php
          • 2Administration/Controller/Component/AdminTabComponent.php
      • Analytics
        • Config
          • 0Analytics/Config/bootstrap.php
          • 1Analytics/Config/events.php
          • 2Analytics/Config/routes.php
        • Plugin
          • 0Analytics/Event/AnalyticsEventListener.php
      • AssetCompress
        • Config
          • 0AssetCompress/Config/bootstrap.php
      • Blog
        • Config
          • 0Blog/Config/bootstrap.php
          • 1Blog/Config/events.php
          • 2Blog/Config/routes.php
        • Plugin
          • 0Blog/Event/BlogEventListener.php
        • Controller
          • 0Blog/Controller/BlogPostsController.php
          • 1Blog/Controller/BlogAppController.php
        • Model
          • 0Blog/Model/BlogPost.php
          • 1Blog/Model/BlogAppModel.php
          • 2Blog/Model/BlogCategory.php
          • 3Blog/Model/BlogTag.php
      • Caching
        • Config
          • 0Caching/Config/bootstrap.php
          • 1Caching/Config/events.php
          • 2Caching/Config/routes.php
        • Plugin
          • 0Caching/Event/CachingEventListener.php
        • Cache
          • 0Caching/Model/Behavior/CachedBehavior.php
      • Colleges
        • Config
          • 0Colleges/Config/bootstrap.php
          • 1Colleges/Config/events.php
          • 2Colleges/Config/routes.php
        • Plugin
          • 0Colleges/Event/CollegesEventListener.php
      • ContentBlocks
        • Config
          • 0ContentBlocks/Config/bootstrap.php
          • 1ContentBlocks/Config/events.php
          • 2ContentBlocks/Config/routes.php
        • Plugin
          • 0ContentBlocks/Event/ContentBlocksEventListener.php
      • CustomFields
        • Config
          • 0CustomFields/Config/bootstrap.php
          • 1CustomFields/Config/events.php
          • 2CustomFields/Config/routes.php
        • Plugin
          • 0CustomFields/Event/CustomFieldsEventListener.php
        • Behavior
          • 0CustomFields/Model/Behavior/CustomFieldBehavior.php
          • 1CustomFields/Model/Behavior/ExpandableBehavior.php
        • Model
          • 0CustomFields/Model/CustomFieldsAppModel.php
      • Docs
        • Config
          • 0Docs/Config/bootstrap.php
          • 1Docs/Config/events.php
          • 2Docs/Config/routes.php
        • Plugin
          • 0Docs/Event/DocsEventListener.php
      • EmailForms
        • Config
          • 0EmailForms/Config/bootstrap.php
          • 1EmailForms/Config/events.php
          • 2EmailForms/Config/routes.php
        • Plugin
          • 0EmailForms/Event/EmailFormsEventListener.php
        • Component
          • 0EmailForms/Controller/Component/EmailFormsComponent.php
        • Model
          • 0EmailForms/Model/EmailFormSubmission.php
          • 1EmailForms/Model/EmailFormsAppModel.php
          • 2EmailForms/Model/EmailForm.php
      • Galleries
        • Config
          • 0Galleries/Config/bootstrap.php
          • 1Galleries/Config/events.php
          • 2Galleries/Config/routes.php
        • Plugin
          • 0Galleries/Event/GalleriesEventListener.php
      • HeaderSlideshow
        • Config
          • 0HeaderSlideshow/Config/bootstrap.php
          • 1HeaderSlideshow/Config/events.php
          • 2HeaderSlideshow/Config/routes.php
        • Plugin
          • 0HeaderSlideshow/Event/HeaderSlideshowEventListener.php
      • Linking
        • Config
          • 0Linking/Config/bootstrap.php
          • 1Linking/Config/events.php
        • Plugin
          • 0Linking/Event/LinkingEventListener.php
        • Behavior
          • 0Linking/Model/Behavior/LinkableBehavior.php
      • MathCaptcha
        • Config
          • 0MathCaptcha/Config/bootstrap.php
          • 1MathCaptcha/Config/events.php
          • 2MathCaptcha/Config/routes.php
        • Plugin
          • 0MathCaptcha/Event/MathCaptchaEventListener.php
        • Behavior
          • 0MathCaptcha/Model/Behavior/MathCaptchaBehavior.php
      • Media
        • Config
          • 0Media/Config/bootstrap.php
          • 1Media/Config/events.php
          • 2Media/Config/routes.php
        • Plugin
          • 0Media/Event/MediaEventListener.php
        • Model
          • 0Media/Model/Attachment.php
          • 1Media/Model/MediaAppModel.php
        • Behavior
          • 0Media/Model/Behavior/TransferBehavior.php
          • 1Media/Model/Behavior/GeneratorBehavior.php
          • 2Media/Model/Behavior/PolymorphicBehavior.php
          • 3Media/Model/Behavior/CouplerBehavior.php
          • 4Media/Model/Behavior/MetaBehavior.php
      • Messages
        • Config
          • 0Messages/Config/bootstrap.php
          • 1Messages/Config/events.php
          • 2Messages/Config/routes.php
        • Plugin
          • 0Messages/Event/MessagesEventListener.php
      • Metas
        • Config
          • 0Metas/Config/bootstrap.php
          • 1Metas/Config/events.php
          • 2Metas/Config/routes.php
        • Plugin
          • 0Metas/Event/MetasEventListener.php
        • Behavior
          • 0Metas/Model/Behavior/MetaTagBehavior.php
        • Component
          • 0Metas/Controller/Component/MetaComponent.php
        • Model
          • 0Metas/Model/MetaValue.php
          • 1Metas/Model/MetaKey.php
      • Navigation
        • Config
          • 0Navigation/Config/bootstrap.php
          • 1Navigation/Config/events.php
          • 2Navigation/Config/routes.php
        • Plugin
          • 0Navigation/Event/NavigationEventListener.php
      • Pages
        • Config
          • 0Pages/Config/bootstrap.php
          • 1Pages/Config/events.php
          • 2Pages/Config/routes.php
        • Plugin
          • 0Pages/Event/PagesEventListener.php
        • Component
          • 0Pages/Controller/Component/PageSettingsComponent.php
        • Model
          • 0Pages/Model/Page.php
          • 1Pages/Model/PagesAppModel.php
      • PluginTools
        • Config
          • 0PluginTools/Config/events.php
          • 1PluginTools/Config/routes.php
        • Plugin
          • 0PluginTools/Event/PluginToolsEventListener.php
      • Prototype
        • Config
          • 0Prototype/Config/bootstrap.php
          • 1Prototype/Config/events.php
          • 2Prototype/Config/routes.php
        • Plugin
          • 0Prototype/Event/PrototypeEventListener.php
        • Model
          • 0Prototype/Model/PrototypeInstance.php
          • 1Prototype/Model/PrototypeAppModel.php
          • 2Prototype/Model/PrototypeCategory.php
          • 3Prototype/Model/PrototypeItem.php
      • Publishing
        • Config
          • 0Publishing/Config/bootstrap.php
          • 1Publishing/Config/events.php
          • 2Publishing/Config/routes.php
        • Plugin
          • 0Publishing/Event/PublishingEventListener.php
        • Behavior
          • 0Publishing/Model/Behavior/PublishableBehavior.php
        • Model
          • 0Publishing/Model/PublishingInformation.php
          • 1Publishing/Model/PublishingAppModel.php
      • ReCaptcha
        • Config
          • 0ReCaptcha/Config/bootstrap.php
          • 1ReCaptcha/Config/events.php
          • 2ReCaptcha/Config/routes.php
        • Plugin
          • 0ReCaptcha/Event/ReCaptchaEventListener.php
      • Responsive
        • Config
          • 0Responsive/Config/bootstrap.php
          • 1Responsive/Config/events.php
          • 2Responsive/Config/routes.php
        • Plugin
          • 0Responsive/Event/ResponsiveEventListener.php
        • Component
          • 0Responsive/Controller/Component/ResponsiveComponent.php
      • Settings
        • Config
          • 0Settings/Config/bootstrap.php
          • 1Settings/Config/events.php
          • 2Settings/Config/routes.php
        • Plugin
          • 0Settings/Event/SettingsEventListener.php
      • Sitemap
        • Config
          • 0Sitemap/Config/bootstrap.php
          • 1Sitemap/Config/events.php
          • 2Sitemap/Config/routes.php
        • Plugin
          • 0Sitemap/Event/SitemapEventListener.php
      • Theming
        • Config
          • 0Theming/Config/bootstrap.php
          • 1Theming/Config/events.php
          • 2Theming/Config/routes.php
        • Plugin
          • 0Theming/Event/ThemingEventListener.php
        • Behavior
          • 0Theming/Model/Behavior/ThemedBehavior.php
        • Component
          • 0Theming/Controller/Component/ThemingComponent.php
      • TinyMce
        • Config
          • 0TinyMce/Config/bootstrap.php
          • 1TinyMce/Config/events.php
          • 2TinyMce/Config/routes.php
        • Plugin
          • 0TinyMce/Event/TinyMceEventListener.php
      • TreeSort
        • Behavior
          • 0TreeSort/Model/Behavior/TreeSortBehavior.php
      • Users
        • Config
          • 0Users/Config/events.php
          • 1Users/Config/routes.php
        • Plugin
          • 0Users/Event/UsersEventListener.php
        • Component
          • 0Users/Controller/Component/AuthsomeComponent.php
          • 1Users/Controller/Component/AccessControlComponent.php
        • Model
          • 0Users/Model/User.php
          • 1Users/Model/UsersAppModel.php
          • 2Users/Model/Country.php
          • 3Users/Model/Permission.php
          • 4Users/Model/Group.php
      • Versioning
        • Config
          • 0Versioning/Config/bootstrap.php
          • 1Versioning/Config/events.php
          • 2Versioning/Config/routes.php
        • Plugin
          • 0Versioning/Event/VersioningEventListener.php
        • Behavior
          • 0Versioning/Model/Behavior/SoftDeleteBehavior.php
          • 1Versioning/Model/Behavior/RevisionBehavior.php
        • Component
          • 0Versioning/Controller/Component/PreviewComponent.php
    ====