Residential Property in Langford

$369,000

732 Stonebrook Lane
MLS^® NO: 957355

Photos
Description

Description

Stonebrook Lane, 10 lots to choose from. Ranging in size from 2100 sq ft to over 4000 sq ft, these bare land strata lots are shovel ready with plans attached. Prices from $329,000 plus GST. Close to transportation, shopping, parks and all the wonderful amenities that Langford has to offer, Stonebrook Lane offers the opportunity to build in a safe, quiet neighbourhood only moments away from all that you want.

General

Property Type:Land

Title of Ownership:STRATA LOT 7, PLAN EPS8195, SECTION 109, ESQUIMALT LAND DISTRICT, TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM V

Number of Floors:2

Taxes:$1

Tax Year:2024

Site Influences

Lot SqFt: 2,156

Acres: 0.05

Water: To Lot

Waste: Sewer To Lot

Property Details

Beds: 0

Baths: 0

Sq. Feet:

Year Built:

Property Type: Land

Municipality: Langford

Links

Virtual Tour

Book a Tour

Request More Info

Tell a Friend

Mortgage Calculator

Back To Listings

Listed with:

David Langlois - Macdonald Realty Victoria
Phone: 250-858-5575

Niels Madsen - Macdonald Realty Victoria
Phone: 250-213-7483

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config
  userAgent
  time1714357125
  countdown10
- Users
  User(empty)
====
Request
+
Request

Cake Params
- pluginvreb_listings
- controllervreb_listings
- actionview
- named(empty)
- pass(empty)
- id957355
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys
  0id
- options
  id[a-zA-Z0-9_-]+
- defaults
  pluginvreb_listings
  controllervreb_listings
  actionview
- template/property/:id
====

Sql Log

Sql Logs

default

Total Time: 20 ms
Total Queries: 225 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (957355)	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `controller` = 'vreb_listings' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1	0	0	3	maybe slow
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 `madsenlanglois_db`.`pages` AS `Page` WHERE `controller` = 'vreb_listings' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1	0	0	0
SELECT `MetaKey`.`id`, `MetaKey`.`name`, `MetaKey`.`default`, `MetaKey`.`allow_default` FROM `madsenlanglois_db`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC	5	5	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 `madsenlanglois_db`.`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`.`deleted`, `AttachmentVersion`.`deleted_date` FROM `madsenlanglois_db`.`attachment_versions` AS `AttachmentVersion` WHERE `AttachmentVersion`.`deleted` = '0'	31	31	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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` LIKE 'Site.Contact.%' AND `Setting`.`value` != ''	8	8	1	maybe slow
SELECT `ContentBlock`.`id`, `ContentBlock`.`name` FROM `madsenlanglois_db`.`content_blocks` AS `ContentBlock` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `ContentBlock`.`id` AND `PublishingInformation`.`model` = 'ContentBlock') WHERE NOT (`ContentBlock`.`id` IS NULL) AND `ContentBlock`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-28 15:18:48' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-28 15:18:48'))	1	1	1
SELECT `EmailForm`.`id`, `EmailForm`.`name` FROM `madsenlanglois_db`.`email_forms` AS `EmailForm` LEFT JOIN `madsenlanglois_db`.`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` <= '2024-04-28 15:18:48' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-28 15:18:48')) AND `EmailForm`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	5	5	0
SELECT `Gallery`.`id`, `Gallery`.`name` FROM `madsenlanglois_db`.`galleries` AS `Gallery` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Gallery`.`id` AND `PublishingInformation`.`model` = 'Gallery') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-28 15:18:48' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-28 15:18:48')) AND `Gallery`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	1	1	0
SELECT `VrebListingFeed`.`id`, `VrebListingFeed`.`name` FROM `madsenlanglois_db`.`vreb_listing_feeds` AS `VrebListingFeed` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `VrebListingFeed`.`id` AND `PublishingInformation`.`model` = 'VrebListingFeed') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-28 15:18:48' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-28 15:18:48')) AND `VrebListingFeed`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC	7	7	0
SELECT * FROM prototype_instances AS PrototypeInstance	2	2	3	maybe slow
SELECT PrototypeItem.val AS testimonial FROM prototype_items INNER JOIN publishing_information ON publishing_information.foreign_key = prototype_items.id AND publishing_information.model = 'PrototypeItem' AND publishing_information.published = 1 AND ( publishing_information.start <= NOW() AND ( publishing_information.end IS NULL OR publishing_information.end > NOW() ) ) LEFT JOIN custom_field_values AS PrototypeItem ON PrototypeItem.foreign_key = prototype_items.id AND PrototypeItem.key = 'testimonial' LEFT JOIN attachments AS Image ON Image.foreign_key = prototype_items.id AND Image.model = 'PrototypeItem' AND Image.group = 'Image' LEFT JOIN attachments AS Document ON Document.foreign_key = prototype_items.id AND Document.model = 'PrototypeItem' AND Document.group = 'Document' WHERE prototype_items.prototype_instance_id = 1 AND prototype_items.featured = 1 AND prototype_items.deleted = 0 ORDER BY RAND() LIMIT 1	1	1	3	maybe slow
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 `madsenlanglois_db`.`attachments` AS `HeaderSlideshowImage` WHERE `model` = 'InstalledPlugin' AND `foreign_key` = 27 AND `group` = 'Header Slideshow' AND `deleted` = '0' ORDER BY `HeaderSlideshowImage`.`rank` ASC, `HeaderSlideshowImage`.`rank` ASC	8	8	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'HeaderSlideshowImage' AND `CustomFieldValue`.`foreign_key` IN (95, 91, 92, 94, 96, 102, 103, 104)	0	0	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'VrebListing' AND `CustomFieldValue`.`foreign_key` = (957355)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'VrebListing' AND `MetaValue`.`foreign_key` = (957355)	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.gtm_association_code' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (126) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC	0	0	1	maybe slow
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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (126) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Bing.verification_code' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (20) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (20) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (1) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) ORDER BY `Document`.`rank` ASC	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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Agency.phone' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (75) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (75) ORDER BY `Document`.`rank` ASC	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	5	5	1	maybe slow
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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2)	5	5	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 `madsenlanglois_db`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`navigation_menu_id` = 1 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2024-04-28 15:18:49' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2024-04-28 15:18:49')) AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC	21	21	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	5	5	1	maybe slow
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 293 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `madsenlanglois_db`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (293)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 48 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (1)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (1)	5	5	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 293 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `madsenlanglois_db`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (293)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 48 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 19 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (19)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (19)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 19 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (19)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (19)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 20 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (20)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (20)	8	8	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 20 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (20)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (20)	8	8	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 14 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (14)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (14)	6	6	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 14 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (14)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (14)	6	6	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 45 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (45)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (45)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 45 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (45)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (45)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 41 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (41)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (41)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 41 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (41)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (41)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 24 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (24)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (24)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 24 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (24)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (24)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 40 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (40)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (40)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 40 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (40)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (40)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 31 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (31)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (31)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 31 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (31)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (31)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 33 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (33)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (33)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 33 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (33)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (33)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 15 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (15)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (15)	4	4	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 15 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (15)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (15)	4	4	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 12 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (12)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 12 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (12)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (12)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 13 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (13)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (13)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 13 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (13)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (13)	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`, `PrototypeInstance`.`use_page_banner_images`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `madsenlanglois_db`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 2 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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (2)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 23 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (23)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (23)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 23 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (23)	0	0	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (23)	5	5	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 11 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	5	5	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 292 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `madsenlanglois_db`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (292)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 46 ORDER BY `CustomField`.`rank` ASC LIMIT 1	1	1	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 `madsenlanglois_db`.`pages` AS `Page` WHERE `Page`.`id` = 11 AND `Page`.`deleted` = '0' LIMIT 1	1	1	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11)	1	1	0
SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11)	5	5	0
SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `madsenlanglois_db`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`id` = 292 LIMIT 1	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `madsenlanglois_db`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (292)	0	0	0
SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `madsenlanglois_db`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 46 ORDER BY `CustomField`.`rank` ASC 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`, `PrototypeInstance`.`use_page_banner_images`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `madsenlanglois_db`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `madsenlanglois_db`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`id` = 1 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 `madsenlanglois_db`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` = (1)	5	5	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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.facebook' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (70) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (70) ORDER BY `Document`.`rank` ASC	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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.facebook' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (70) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (70) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.linkedin' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (71) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (71) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.instagram' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (127) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (127) ORDER BY `Document`.`rank` ASC	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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.instagram' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (127) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (127) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.youtube' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (72) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (72) ORDER BY `Document`.`rank` ASC	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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.youtube' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (72) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (72) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.twitter' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (119) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (119) ORDER BY `Document`.`rank` ASC	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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Social_Media.twitter' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (119) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (119) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.phone' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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 `madsenlanglois_db`.`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 `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Agency.phone' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (75) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (75) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Agency.name' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (73) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (73) ORDER BY `Document`.`rank` ASC	0	0	0
SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.address' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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 `madsenlanglois_db`.`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`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.city' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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 `madsenlanglois_db`.`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`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.province_state' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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 `madsenlanglois_db`.`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`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.postal_zip' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_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 `madsenlanglois_db`.`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`.`rank`, `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 `madsenlanglois_db`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Contact.email' ORDER BY `Setting`.`rank` ASC 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`.`is_matrix`, `Image`.`matrix_url`, `Image`.`matrix_num`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `madsenlanglois_db`.`vreb_listing_attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (16) 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 `madsenlanglois_db`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (16) ORDER BY `Document`.`rank` ASC	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 `madsenlanglois_db`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1	1	1	0

Query Explain:

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

vreb_user

Total Time: %s ms
Total Queries: %s queries

Query	Affected	Num. rows	Took (ms)	Actions

Query Explain:

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

vreb_rets

Total Time: 1085 ms
Total Queries: 18 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` INNER JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `Office` ON (`Office`.`office_ID` = `VrebAgent`.`office_ID` AND `Office`.`vreb_idx_opt_in` = 1) WHERE `VrebAgent`.`agent_ID` = ('3742')	1	1	1
SELECT `BootstrapVrebInstance`.`id`, `BootstrapVrebInstance`.`name`, `BootstrapVrebInstance`.`slug` FROM `vrebradarhill_vreb_database`.`prototype_instances` AS `BootstrapVrebInstance` WHERE `id` IN (1, 2)	2	2	0
SELECT `VrebListing`., `PublishingInformation`., (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_summary_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 957355 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	1
SELECT `VrebListing`., `PublishingInformation`., `ListAgent`.`agent_ID`, `ListAgentCoOne`.`agent_ID`, `ListAgentCoTwo`.`agent_ID`, `SellAgent`.`agent_ID`, `SellAgentCoOne`.`agent_ID`, `SellAgentCoTwo`.`agent_ID`, (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_residential_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') LEFT JOIN `vrebradarhill_vreb_database`.`rets_agents` AS `ListAgent` ON (`VrebListing`.`LA_agent_ID` = `ListAgent`.`agent_ID`) LEFT JOIN `vrebradarhill_vreb_database`.`rets_agents` AS `ListAgentCoOne` ON (`VrebListing`.`LACO1_agent_ID` = `ListAgentCoOne`.`agent_ID`) LEFT JOIN `vrebradarhill_vreb_database`.`rets_agents` AS `ListAgentCoTwo` ON (`VrebListing`.`LACO2_agent_ID` = `ListAgentCoTwo`.`agent_ID`) LEFT JOIN `vrebradarhill_vreb_database`.`rets_agents` AS `SellAgent` ON (`VrebListing`.`SA_agent_ID` = `SellAgent`.`agent_ID`) LEFT JOIN `vrebradarhill_vreb_database`.`rets_agents` AS `SellAgentCoOne` ON (`VrebListing`.`SACO1_agent_ID` = `SellAgentCoOne`.`agent_ID`) LEFT JOIN `vrebradarhill_vreb_database`.`rets_agents` AS `SellAgentCoTwo` ON (`VrebListing`.`SACO2_agent_ID` = `SellAgentCoTwo`.`agent_ID`) LEFT JOIN `vrebradarhill_vreb_database`.`aerial_videos` AS `AerialVideo` ON (`AerialVideo`.`foreign_key` = `VrebListing`.`id` AND `AerialVideo`.`foreign_key` = `VrebListing`.`id`) WHERE `VrebListing`.`id` = 957355 AND `VrebListing`.`id` > 900000 AND (NOT (`VrebListing`.`id` IS NULL) AND NOT (`VrebListing`.`LA_agent_ID` IN ('3053', '749', '1669', '4457', '1033', '3738', '682', '1994', '3766', '4248'))) AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) AND ((`PublishingInformation`.`published` IS NULL) OR (`PublishingInformation`.`published` = '1')) LIMIT 1	1	1	5	maybe slow
SELECT `AerialVideo`.`id`, `AerialVideo`.`foreign_model`, `AerialVideo`.`foreign_key`, `AerialVideo`.`description`, `AerialVideo`.`direct_link`, `AerialVideo`.`uri`, `AerialVideo`.`embed_code`, `AerialVideo`.`advanced_embed_code`, `AerialVideo`.`agent_id`, `AerialVideo`.`created`, `AerialVideo`.`ordered` FROM `vrebradarhill_vreb_database`.`aerial_videos` AS `AerialVideo` WHERE `AerialVideo`.`foreign_key` = 957355	0	0	1	maybe slow
SELECT `OpenHouse`.`description`, `OpenHouse`.`foodtype`, `OpenHouse`.`from_date`, `OpenHouse`.`from_time`, `OpenHouse`.`is_active`, `OpenHouse`.`listing_ID`, `OpenHouse`.`matrix_unique_ID`, `OpenHouse`.`mod_date_time`, `OpenHouse`.`openhousetype`, `OpenHouse`.`table_MUI`, `OpenHouse`.`to_date`, `OpenHouse`.`to_time`, `OpenHouse`.`VirtualOpenHouseURL`, `OpenHouse`.`id`, `OpenHouse`.`ListingId` FROM `vrebradarhill_vreb_database`.`rets_open_houses` AS `OpenHouse` WHERE `OpenHouse`.`is_active` = '1' AND `OpenHouse`.`to_date` >= CURDATE() AND `OpenHouse`.`openhousetype` = 'Licensees & Public' AND `OpenHouse`.`listing_ID` = (957355) ORDER BY `OpenHouse`.`from_date` ASC	0	0	0
SELECT `RoomMatrix`.`ListingKeyNumeric`, `RoomMatrix`.`ModificationTimestamp`, `RoomMatrix`.`RoomArea`, `RoomMatrix`.`RoomAreaSource`, `RoomMatrix`.`RoomAreaUnits`, `RoomMatrix`.`RoomDescription`, `RoomMatrix`.`RoomDimensions`, `RoomMatrix`.`RoomDimensionsOrPieces`, `RoomMatrix`.`RoomFeatures`, `RoomMatrix`.`RoomFinishedYN`, `RoomMatrix`.`RoomKeyNumeric`, `RoomMatrix`.`RoomLength`, `RoomMatrix`.`RoomLengthWidthSource`, `RoomMatrix`.`RoomLengthWidthUnits`, `RoomMatrix`.`RoomLevel`, `RoomMatrix`.`RoomType`, `RoomMatrix`.`RoomWidth` FROM `vrebradarhill_vreb_database`.`viva_property_rooms_keep` AS `RoomMatrix` WHERE `ListingKeyNumeric` = 26401384 ORDER BY `RoomLevel` ASC, `RoomType` ASC	0	0	1075	maybe slow
SELECT `VrebListing`., `PublishingInformation`., (CONCAT(CONCAT(`VrebListing`.`unit_no`), IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), CONCAT(`VrebListing`.`street_no`), IF(LENGTH(`VrebListing`.`street_no`), ' ', ''), CONCAT(`VrebListing`.`street`), IF(LENGTH(`VrebListing`.`street`), ' ', ''), `VrebListing`.`street_suffix`)) AS `VrebListing__address`, (CONCAT(`VrebListing`.`street`, ' ', `VrebListing`.`street_no`, IF(LENGTH(`VrebListing`.`unit_no`), ' - ', ''), IF(LENGTH(`VrebListing`.`unit_no`), `VrebListing`.`unit_no`, ''))) AS `VrebListing__address_admin_index`, `VrebListing`.`id` FROM `vrebradarhill_vreb_database`.`rets_residential_properties` AS `VrebListing` LEFT JOIN `vrebradarhill_vreb_database`.`vreb_listing_publishing_information` AS `PublishingInformation` ON (`VrebListing`.`id` = `PublishingInformation`.`foreign_key` AND `PublishingInformation`.`model` = 'VrebListing') WHERE `VrebListing`.`id` = 957355 AND ((`PublishingInformation`.`deleted` = 0) OR (`PublishingInformation`.`deleted` IS NULL)) LIMIT 1	1	1	1
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` WHERE `VrebAgent`.`agent_ID` = '3879' LIMIT 1	1	1	1
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha`, `Office`.`additional_addr`, `Office`.`board_MUI`, `Office`.`BoardList`, `Office`.`city`, `Office`.`contact_person`, `Office`.`crea_code`, `Office`.`email`, `Office`.`fax`, `Office`.`firm_MUI`, `Office`.`latitude`, `Office`.`longitude`, `Office`.`matrix_unique_ID`, `Office`.`MLS`, `Office`.`mod_date_time`, `Office`.`name`, `Office`.`office_ID`, `Office`.`phone`, `Office`.`phone_toll_free`, `Office`.`postal_code`, `Office`.`province`, `Office`.`route_no`, `Office`.`source_board_id`, `Office`.`status`, `Office`.`street_dir`, `Office`.`street_name`, `Office`.`street_no`, `Office`.`street_suffix`, `Office`.`unit_no`, `Office`.`vreb_idx_opt_in`, `Office`.`web` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` LEFT JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `Office` ON (`VrebAgent`.`office_ID` = `Office`.`office_ID`) WHERE `VrebAgent`.`agent_ID` = '3879' LIMIT 1	1	1	0
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha`, `Office`.`additional_addr`, `Office`.`board_MUI`, `Office`.`BoardList`, `Office`.`city`, `Office`.`contact_person`, `Office`.`crea_code`, `Office`.`email`, `Office`.`fax`, `Office`.`firm_MUI`, `Office`.`latitude`, `Office`.`longitude`, `Office`.`matrix_unique_ID`, `Office`.`MLS`, `Office`.`mod_date_time`, `Office`.`name`, `Office`.`office_ID`, `Office`.`phone`, `Office`.`phone_toll_free`, `Office`.`postal_code`, `Office`.`province`, `Office`.`route_no`, `Office`.`source_board_id`, `Office`.`status`, `Office`.`street_dir`, `Office`.`street_name`, `Office`.`street_no`, `Office`.`street_suffix`, `Office`.`unit_no`, `Office`.`vreb_idx_opt_in`, `Office`.`web` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` LEFT JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `Office` ON (`VrebAgent`.`office_ID` = `Office`.`office_ID`) WHERE `VrebAgent`.`agent_ID` = '3879' LIMIT 1	1	1	0
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha`, `Office`.`additional_addr`, `Office`.`board_MUI`, `Office`.`BoardList`, `Office`.`city`, `Office`.`contact_person`, `Office`.`crea_code`, `Office`.`email`, `Office`.`fax`, `Office`.`firm_MUI`, `Office`.`latitude`, `Office`.`longitude`, `Office`.`matrix_unique_ID`, `Office`.`MLS`, `Office`.`mod_date_time`, `Office`.`name`, `Office`.`office_ID`, `Office`.`phone`, `Office`.`phone_toll_free`, `Office`.`postal_code`, `Office`.`province`, `Office`.`route_no`, `Office`.`source_board_id`, `Office`.`status`, `Office`.`street_dir`, `Office`.`street_name`, `Office`.`street_no`, `Office`.`street_suffix`, `Office`.`unit_no`, `Office`.`vreb_idx_opt_in`, `Office`.`web` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` LEFT JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `Office` ON (`VrebAgent`.`office_ID` = `Office`.`office_ID`) WHERE `VrebAgent`.`agent_ID` = '3879' LIMIT 1	1	1	0
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` WHERE `VrebAgent`.`agent_ID` = '3879' LIMIT 1	1	1	0
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` WHERE `VrebAgent`.`agent_ID` = '3742' LIMIT 1	1	1	0
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha`, `Office`.`additional_addr`, `Office`.`board_MUI`, `Office`.`BoardList`, `Office`.`city`, `Office`.`contact_person`, `Office`.`crea_code`, `Office`.`email`, `Office`.`fax`, `Office`.`firm_MUI`, `Office`.`latitude`, `Office`.`longitude`, `Office`.`matrix_unique_ID`, `Office`.`MLS`, `Office`.`mod_date_time`, `Office`.`name`, `Office`.`office_ID`, `Office`.`phone`, `Office`.`phone_toll_free`, `Office`.`postal_code`, `Office`.`province`, `Office`.`route_no`, `Office`.`source_board_id`, `Office`.`status`, `Office`.`street_dir`, `Office`.`street_name`, `Office`.`street_no`, `Office`.`street_suffix`, `Office`.`unit_no`, `Office`.`vreb_idx_opt_in`, `Office`.`web` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` LEFT JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `Office` ON (`VrebAgent`.`office_ID` = `Office`.`office_ID`) WHERE `VrebAgent`.`agent_ID` = '3742' LIMIT 1	1	1	0
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha`, `Office`.`additional_addr`, `Office`.`board_MUI`, `Office`.`BoardList`, `Office`.`city`, `Office`.`contact_person`, `Office`.`crea_code`, `Office`.`email`, `Office`.`fax`, `Office`.`firm_MUI`, `Office`.`latitude`, `Office`.`longitude`, `Office`.`matrix_unique_ID`, `Office`.`MLS`, `Office`.`mod_date_time`, `Office`.`name`, `Office`.`office_ID`, `Office`.`phone`, `Office`.`phone_toll_free`, `Office`.`postal_code`, `Office`.`province`, `Office`.`route_no`, `Office`.`source_board_id`, `Office`.`status`, `Office`.`street_dir`, `Office`.`street_name`, `Office`.`street_no`, `Office`.`street_suffix`, `Office`.`unit_no`, `Office`.`vreb_idx_opt_in`, `Office`.`web` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` LEFT JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `Office` ON (`VrebAgent`.`office_ID` = `Office`.`office_ID`) WHERE `VrebAgent`.`agent_ID` = '3742' LIMIT 1	1	1	0
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha`, `Office`.`additional_addr`, `Office`.`board_MUI`, `Office`.`BoardList`, `Office`.`city`, `Office`.`contact_person`, `Office`.`crea_code`, `Office`.`email`, `Office`.`fax`, `Office`.`firm_MUI`, `Office`.`latitude`, `Office`.`longitude`, `Office`.`matrix_unique_ID`, `Office`.`MLS`, `Office`.`mod_date_time`, `Office`.`name`, `Office`.`office_ID`, `Office`.`phone`, `Office`.`phone_toll_free`, `Office`.`postal_code`, `Office`.`province`, `Office`.`route_no`, `Office`.`source_board_id`, `Office`.`status`, `Office`.`street_dir`, `Office`.`street_name`, `Office`.`street_no`, `Office`.`street_suffix`, `Office`.`unit_no`, `Office`.`vreb_idx_opt_in`, `Office`.`web` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` LEFT JOIN `vrebradarhill_vreb_database`.`rets_offices` AS `Office` ON (`VrebAgent`.`office_ID` = `Office`.`office_ID`) WHERE `VrebAgent`.`agent_ID` = '3742' LIMIT 1	1	1	0
SELECT `VrebAgent`.`agent_class`, `VrebAgent`.`agent_ID`, `VrebAgent`.`board_MUI`, `VrebAgent`.`crea_code`, `VrebAgent`.`credentials`, `VrebAgent`.`email`, `VrebAgent`.`fax`, `VrebAgent`.`firm_MUI`, `VrebAgent`.`first_name`, `VrebAgent`.`initial`, `VrebAgent`.`last_name`, `VrebAgent`.`matrix_unique_ID`, `VrebAgent`.`MLS`, `VrebAgent`.`mod_date_time`, `VrebAgent`.`muc`, `VrebAgent`.`office_ID`, `VrebAgent`.`office_source_board_id`, `VrebAgent`.`phone_beeper`, `VrebAgent`.`phone_toll_free`, `VrebAgent`.`phone_work`, `VrebAgent`.`postal_code`, `VrebAgent`.`PREC`, `VrebAgent`.`ruc`, `VrebAgent`.`source_board_id`, `VrebAgent`.`Specialties`, `VrebAgent`.`status`, `VrebAgent`.`web`, `VrebAgent`.`HashPassword`, `VrebAgent`.`languages`, `VrebAgent`.`full_name`, `VrebAgent`.`facebook`, `VrebAgent`.`instagram`, `VrebAgent`.`linked_in`, `VrebAgent`.`twitter`, `VrebAgent`.`MemberDesignation`, `VrebAgent`.`rank`, (CONCAT(`VrebAgent`.`first_name`, ' ', `VrebAgent`.`initial`, IF(LENGTH(`VrebAgent`.`initial`), ' ', ''), `VrebAgent`.`last_name`)) AS `VrebAgent__name`, (CONCAT(`VrebAgent`.`last_name`, ', ', `VrebAgent`.`first_name`, `VrebAgent`.`initial`)) AS `VrebAgent__name_alpha` FROM `vrebradarhill_vreb_database`.`rets_agents` AS `VrebAgent` WHERE `VrebAgent`.`agent_ID` = '3742' LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 57.77 MB

Message	Memory use
Component initialization	14.49 MB
Controller action start	16.97 MB
Controller render start	29.68 MB
View render complete	29.68 MB

Timers

Total Request Time: 4789 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	119.93
Component initialization and startup	22.84
Controller action	2661.60
Render Controller Action	1296.85
» Rendering View	1295.66
» » Rendering APP/Plugin/VrebListings/View/VrebListings/view_1.ctp	986.43
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp	0.30
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #2	0.21
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #3	0.25
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #4	0.21
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #5	0.20
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #6	0.20
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #7	0.20
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #8	0.20
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #9	0.20
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #10	0.26
» » » Rendering CORE/V1/lib/Cms/View/Elements/required.ctp #11	0.20
» » » Rendering CORE/V1/lib/Cms/Plugin/VrebListings/View/Elements/mortgage_calculator.ctp	0.44
» » Rendering APP/View/Layouts/single-column.ctp	239.08
» » » Rendering APP/View/Elements/layout/header.ctp	179.89
» » » » Rendering CORE/V1/lib/Cms/Plugin/VrebListings/View/Elements/header_scripts.ctp	0.44
» » » » Rendering APP/View/Elements/gtm_head.ctp	0.36
» » » » Rendering APP/Plugin/VrebListings/View/Elements/metas.ctp	0.82
» » » » Rendering APP/View/Elements/gtm_body.ctp	0.21
» » » Rendering APP/View/Elements/layout/footer.ctp	44.45

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- metas
  description bed, bath, 2156 sqft Residential in Langford, BC. Stonebrook Lane, 10 lots to choose from. Ranging in size from 2100 sq ft to over 4000 sq ft, these bar...
- layout
- extraFooterCode
- extraHeaderCode
- pageIntro
- paginationLimit24
- paginationOptions
  024
  148
  296
- listing
  VrebListing
  accessibility_feature
  addnl_accom
  age_notes
  age_youngest_allowed0
  agent_information_feature
  agr_land_reserve
  annual_income
  appliances_included_feature
  appoint_phone
  appoint_remarks
  area_estimated
  assess_roll_no7394021
  assess_value378000
  assess_yr2024
  basement_description_feature
  baths_2p0
  baths_3p0
  baths_4p0
  baths_5p0
  baths_e2p0
  baths_e3p0
  baths_e4p0
  BBQ_Notes
  BBQs_allowed_YN1
  bed_breakfast
  bedrooms0
  bldg_scheme
  bldgs_in_cmplx10
  blg_warranty
  block
  board_information_feature
  bsmnt_hgt_feet
  bsmnt_hgt_inches
  building_style_feature
  building_type_feature
  business_type_feature
  buyer_name
  buzzer_code
  common_strata_items_feature
  complex
  construction_material_feature
  cooling_feature
  coop_agent_comm
  covered_parking_feature
  csa_cert
  date_cancelled
  date_entered2024-03-26 20:07:24
  date_expire
  date_inactive
  date_list2024-03-26 00:00:00
  date_mod_date_time2024-03-26 20:07:24
  date_p_mod_date_time2024-03-26 20:07:24
  date_pending
  date_price_list_changed
  date_projected_close
  date_sale_collapse0000-00-00 00:00:00
  date_sale_entry0000-00-00 00:00:00
  date_sold
  date_status_mod2024-03-26 20:07:24
  date_with0000-00-00 00:00:00
  directions
  districtLangford
  district_lot
  dom0
  driveway_feature
  duc
  elem_school
  ex_total
  exclusions_feature
  exterior_features
  exterior_finish_feature
  financing_notes
  financing_options_feature
  fini_room1
  fini_room1_level1
  fini_room1_level2
  fini_room1_level3
  fini_room1_level4
  fini_room1_other
  fini_room10
  fini_room10_level1
  fini_room10_level2
  fini_room10_level3
  fini_room10_level4
  fini_room10_other
  fini_room11
  fini_room11_level1
  fini_room11_level2
  fini_room11_level3
  fini_room11_level4
  fini_room11_other
  fini_room12
  fini_room12_level1
  fini_room12_level2
  fini_room12_level3
  fini_room12_level4
  fini_room12_other
  fini_room13
  fini_room13_level1
  fini_room13_level2
  fini_room13_level3
  fini_room13_level4
  fini_room13_other
  fini_room14
  fini_room14_level1
  fini_room14_level2
  fini_room14_level3
  fini_room14_level4
  fini_room14_other
  fini_room15
  fini_room15_level1
  fini_room15_level2
  fini_room15_level3
  fini_room15_level4
  fini_room15_other
  fini_room2
  fini_room2_level1
  fini_room2_level2
  fini_room2_level3
  fini_room2_level4
  fini_room2_other
  fini_room3
  fini_room3_level1
  fini_room3_level2
  fini_room3_level3
  fini_room3_level4
  fini_room3_other
  fini_room4
  fini_room4_level1
  fini_room4_level2
  fini_room4_level3
  fini_room4_level4
  fini_room4_other
  fini_room5
  fini_room5_level1
  fini_room5_level2
  fini_room5_level3
  fini_room5_level4
  fini_room5_other
  fini_room6
  fini_room6_level1
  fini_room6_level2
  fini_room6_level3
  fini_room6_level4
  fini_room6_other
  fini_room7
  fini_room7_level1
  fini_room7_level2
  fini_room7_level3
  fini_room7_level4
  fini_room7_other
  fini_room8
  fini_room8_level1
  fini_room8_level2
  fini_room8_level3
  fini_room8_level4
  fini_room8_other
  fini_room9
  fini_room9_level1
  fini_room9_level2
  fini_room9_level3
  fini_room9_level4
  fini_room9_other
  finished_room_CNT
  fireplaces
  fireplaces_featurestype
  flrs_in_bldg2
  foreign_board_ID
  foreign_mls
  foundation_feature
  front_faces
  fuel_feature
  Google_Street_View
  gross_income
  ground_level
  has_searched_title
  heating_feature
  hot_water_feature
  id957355
  inclusions_feature
  interior_features
  internet_remarksStonebrook Lane, 10 lots to choose from. Ranging in size from 2100 sq ft to over 4000 sq ft, these bare land strata lots are shovel ready with plans attached. Prices from 9,000 plus GST. Close to transportation, shopping, parks and all the wonderful amenities that Langford has to offer, Stonebrook Lane offers the opportunity to build in a safe, quiet neighbourhood only moments away from all that you want.
  Is_Revenue_Property
  Is_Solicitation_Permitted
  junior_school
  jurisdictionCity of Langford
  kitchens0
  LA_agent_ID3879
  LA_board_MUI
  LA_credentials
  LA_firm_MUI
  LA_firm_name
  LA_first_nameDavid Langlois
  LA_initial
  LA_last_name
  LA_MUI
  LA_office_ID292
  LA_office_MUI
  LA_office_nameMacdonald Realty Victoria
  LA_office_phone250-388-5882
  LA_PREC
  LA_web
  LACO1_agent_ID3742
  LACO1_board_MUI
  LACO1_credentials
  LACO1_firm_MUI
  LACO1_firm_nameNiels Madsen
  LACO1_first_nameNiels Madsen
  LACO1_initial
  LACO1_last_name
  LACO1_MUI
  LACO1_office_ID292
  LACO1_office_MUI
  LACO1_office_nameMacdonald Realty Victoria
  LACO1_office_phone250-388-5882
  LACO1_PREC
  LACO1_web
  LACO2_agent_ID
  LACO2_board_MUI
  LACO2_credentials
  LACO2_firm_MUI
  LACO2_firm_name
  LACO2_first_name
  LACO2_initial
  LACO2_last_name
  LACO2_MUI
  LACO2_office_ID
  LACO2_office_MUI
  LACO2_office_name
  LACO2_office_phone
  LACO2_PREC
  LACO2_web
  land_district21
  latitude48.454474
  laundry_features
  laundry_location_feature
  layout
  lease_heldby
  lease_yrs_rem
  leased_equipment_feature
  legal_fformSTRATA LOT 7, PLAN EPS8195, SECTION 109, ESQUIMALT LAND DISTRICT, TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM V
  legal_non_conf
  levels_in_suites
  listing_subtypeLand
  listing_typeResidential
  location_features
  lock_box_loc
  longitude-123.494408
  lot
  lot_depth
  lot_features
  Lot_frontage
  lot_shape
  lot_size_acres0.05
  lot_size_sqft2156
  main_level
  managed_by
  managed_by_phone
  map_areaLa Mill Hill
  matrix_unique_ID26401384
  Meridian
  mhr_no
  monthly_assess1
  monthly_assess_year2023
  net_income
  no_units_1bed
  no_units_2bed
  no_units_3bed
  no_units_4bed
  no_units_studio
  no_units_total
  on_idx
  openhouse_CNT
  parking_type_feature
  PermitReciprocityYN1
  pet_notes
  Pets
  photo_count20
  pid_no032-073-844
  possessionImmediate
  postal_codeV9B 3N9
  postal_district
  pr_planEPS8195
  price_current369000
  price_ext_lease_sold
  price_list369000
  price_original369000
  price_selling
  prkng_common_spaces0
  prkng_lot2
  prkng_other0
  prkng_tot_spaces2
  range
  ratio_sell_by_original
  rear_faces
  remarksStonebrook Lane, 10 lots to choose from. Ranging in size from 2100 sq ft to over 4000 sq ft, these bare land strata lots are shovel ready with plans attached. Prices from 9,000 plus GST. Close to transportation, shopping, parks and all the wonderful amenities that Langford has to offer, Stonebrook Lane offers the opportunity to build in a safe, quiet neighbourhood only moments away from all that you want.
  rent_allowedUnrestricted
  rent_includes_feature
  rent_notes
  roof_feature
  rooms_main_level_feature
  rooms_overall_feature
  SA_agent_ID
  SA_credentials
  SA_firm_MUI
  SA_firm_name
  SA_first_name
  SA_initial
  SA_last_name
  SA_MUI
  SA_office_ID
  SA_office_MUI
  SA_office_name
  SA_office_phone
  SA_PREC
  SACO1_agent_ID
  SACO1_credentials
  SACO1_firm_MUI
  SACO1_firm_name
  SACO1_first_name
  SACO1_initial
  SACO1_last_name
  SACO1_MUI
  SACO1_office_ID
  SACO1_office_MUI
  SACO1_office_name
  SACO1_office_phone
  SACO1_PREC
  SACO2_agent_ID
  SACO2_credentials
  SACO2_firm_MUI
  SACO2_firm_name
  SACO2_first_name
  SACO2_initial
  SACO2_last_name
  SACO2_MUI
  SACO2_office_ID
  SACO2_office_MUI
  SACO2_office_name
  SACO2_office_phone
  SACO2_PREC
  section109
  seller_name
  seller_phone
  senior_school
  services_available_feature
  shared_amenities_feature
  sqft_balcony
  sqft_level1
  sqft_level2
  sqft_level3
  sqft_level4
  sqft_other
  sqft_patio
  sqft_prkng
  sqft_storage
  statusCurrent
  strata_assess_includes_feature
  strata_lot_includes_feature
  streetStonebrook
  street_dir
  street_MUI
  street_no732
  street_suffixLane
  suites_in_bldg1
  suites_in_cmplx10
  tax_MUI
  tax_yr2024
  taxes1.00
  tenant_phone
  titleFreehold/Strata
  top_level
  tot_sqft_finished
  tot_sqft_unfinished
  total_baths0
  township
  unfini_room1
  unfini_room1_level1
  unfini_room1_level2
  unfini_room1_level3
  unfini_room1_level4
  unfini_room1_other
  unfini_room2
  unfini_room2_level1
  unfini_room2_level2
  unfini_room2_level3
  unfini_room2_level4
  unfini_room2_other
  unfini_room3
  unfini_room3_level1
  unfini_room3_level2
  unfini_room3_level3
  unfini_room3_level4
  unfini_room3_other
  unfini_room4
  unfini_room4_level1
  unfini_room4_level2
  unfini_room4_level3
  unfini_room4_level4
  unfini_room4_other
  unfini_room5
  unfini_room5_level1
  unfini_room5_level2
  unfini_room5_level3
  unfini_room5_level4
  unfini_room5_other
  unfinished_room_CNT0
  unit_no
  unit1_notes
  unit1_tot_baths
  unit1_tot_beds
  unit1_tot_fp
  unit2_notes
  unit2_tot_baths
  unit2_tot_beds
  unit2_tot_fp
  unit3_notes
  unit3_tot_baths
  unit3_tot_beds
  unit3_tot_fp
  unit4_notes
  unit4_tot_baths
  unit4_tot_beds
  unit4_tot_fp
  URL_additional_photos
  URL_feature_sheet
  URL_sales_brochure
  URL_sound_bite
  URL_Virtual_Tourhttps://www.rockinghamrise.com/
  Waste_featureSewer To Lot
  waterTo Lot
  year_built
  zoning
  zoning_classResidential
  basement_development0
  youtube_embedding_code
  youtube_video_code
  tot_sqft
  ListingId957355
  ListingKeyNumeric26401384
  address732 Stonebrook Lane
  address_admin_indexStonebrook 732
  matrixPhotos
  0https://www.vreb.radarhill.ca/img/properties/957/355/1.jpg
  1https://www.vreb.radarhill.ca/img/properties/957/355/2.jpg
  2https://www.vreb.radarhill.ca/img/properties/957/355/3.jpg
  3https://www.vreb.radarhill.ca/img/properties/957/355/4.jpg
  4https://www.vreb.radarhill.ca/img/properties/957/355/5.jpg
  5https://www.vreb.radarhill.ca/img/properties/957/355/6.jpg
  6https://www.vreb.radarhill.ca/img/properties/957/355/7.jpg
  7https://www.vreb.radarhill.ca/img/properties/957/355/8.jpg
  8https://www.vreb.radarhill.ca/img/properties/957/355/9.jpg
  9https://www.vreb.radarhill.ca/img/properties/957/355/10.jpg
  10https://www.vreb.radarhill.ca/img/properties/957/355/11.jpg
  11https://www.vreb.radarhill.ca/img/properties/957/355/12.jpg
  12https://www.vreb.radarhill.ca/img/properties/957/355/13.jpg
  13https://www.vreb.radarhill.ca/img/properties/957/355/14.jpg
  14https://www.vreb.radarhill.ca/img/properties/957/355/15.jpg
  15https://www.vreb.radarhill.ca/img/properties/957/355/16.jpg
  16https://www.vreb.radarhill.ca/img/properties/957/355/17.jpg
  17https://www.vreb.radarhill.ca/img/properties/957/355/18.jpg
  18https://www.vreb.radarhill.ca/img/properties/957/355/19.jpg
  19https://www.vreb.radarhill.ca/img/properties/957/355/20.jpg
  PublishingInformation
  id
  created
  modified
  model
  foreign_key
  start
  end
  published
  featured
  deleted
  photo_count
  ListAgent
  agent_ID3879
  ListAgentCoOne
  agent_ID3742
  ListAgentCoTwo
  agent_ID
  SellAgent
  agent_ID
  SellAgentCoOne
  agent_ID
  SellAgentCoTwo
  agent_ID
  AerialVideo(empty)
  Document(empty)
  Image(empty)
  Link(empty)
  OpenHouse(empty)
  CustomFieldValue(empty)
  MetaValue(empty)
  metaDefaults
  description bed, bath, 2156 sqft Residential in Langford, BC. Stonebrook Lane, 10 lots to choose from. Ranging in size from 2100 sq ft to over 4000 sq ft, these bare land strata lots are shovel ready with plans attached. Prices from 9,000 plus GST. Close to transportation, shopping, parks and all the wonderful amenities that Langford has to offer, Stonebrook Lane offers the opportunity to build in a safe, quiet neighbourhood only moments away from all that you want.
  RoomMatrix(empty)
- vrebListing
  VrebListing
  accessibility_feature
  addnl_accom
  age_notes
  age_youngest_allowed0
  agent_information_feature
  agr_land_reserve
  annual_income
  appliances_included_feature
  appoint_phone
  appoint_remarks
  area_estimated
  assess_roll_no7394021
  assess_value378000
  assess_yr2024
  basement_description_feature
  baths_2p0
  baths_3p0
  baths_4p0
  baths_5p0
  baths_e2p0
  baths_e3p0
  baths_e4p0
  BBQ_Notes
  BBQs_allowed_YN1
  bed_breakfast
  bedrooms0
  bldg_scheme
  bldgs_in_cmplx10
  blg_warranty
  block
  board_information_feature
  bsmnt_hgt_feet
  bsmnt_hgt_inches
  building_style_feature
  building_type_feature
  business_type_feature
  buyer_name
  buzzer_code
  common_strata_items_feature
  complex
  construction_material_feature
  cooling_feature
  coop_agent_comm
  covered_parking_feature
  csa_cert
  date_cancelled
  date_entered2024-03-26 20:07:24
  date_expire
  date_inactive
  date_list2024-03-26 00:00:00
  date_mod_date_time2024-03-26 20:07:24
  date_p_mod_date_time2024-03-26 20:07:24
  date_pending
  date_price_list_changed
  date_projected_close
  date_sale_collapse0000-00-00 00:00:00
  date_sale_entry0000-00-00 00:00:00
  date_sold
  date_status_mod2024-03-26 20:07:24
  date_with0000-00-00 00:00:00
  directions
  districtLangford
  district_lot
  dom0
  driveway_feature
  duc
  elem_school
  ex_total
  exclusions_feature
  exterior_features
  exterior_finish_feature
  financing_notes
  financing_options_feature
  fini_room1
  fini_room1_level1
  fini_room1_level2
  fini_room1_level3
  fini_room1_level4
  fini_room1_other
  fini_room10
  fini_room10_level1
  fini_room10_level2
  fini_room10_level3
  fini_room10_level4
  fini_room10_other
  fini_room11
  fini_room11_level1
  fini_room11_level2
  fini_room11_level3
  fini_room11_level4
  fini_room11_other
  fini_room12
  fini_room12_level1
  fini_room12_level2
  fini_room12_level3
  fini_room12_level4
  fini_room12_other
  fini_room13
  fini_room13_level1
  fini_room13_level2
  fini_room13_level3
  fini_room13_level4
  fini_room13_other
  fini_room14
  fini_room14_level1
  fini_room14_level2
  fini_room14_level3
  fini_room14_level4
  fini_room14_other
  fini_room15
  fini_room15_level1
  fini_room15_level2
  fini_room15_level3
  fini_room15_level4
  fini_room15_other
  fini_room2
  fini_room2_level1
  fini_room2_level2
  fini_room2_level3
  fini_room2_level4
  fini_room2_other
  fini_room3
  fini_room3_level1
  fini_room3_level2
  fini_room3_level3
  fini_room3_level4
  fini_room3_other
  fini_room4
  fini_room4_level1
  fini_room4_level2
  fini_room4_level3
  fini_room4_level4
  fini_room4_other
  fini_room5
  fini_room5_level1
  fini_room5_level2
  fini_room5_level3
  fini_room5_level4
  fini_room5_other
  fini_room6
  fini_room6_level1
  fini_room6_level2
  fini_room6_level3
  fini_room6_level4
  fini_room6_other
  fini_room7
  fini_room7_level1
  fini_room7_level2
  fini_room7_level3
  fini_room7_level4
  fini_room7_other
  fini_room8
  fini_room8_level1
  fini_room8_level2
  fini_room8_level3
  fini_room8_level4
  fini_room8_other
  fini_room9
  fini_room9_level1
  fini_room9_level2
  fini_room9_level3
  fini_room9_level4
  fini_room9_other
  finished_room_CNT
  fireplaces
  fireplaces_featurestype
  flrs_in_bldg2
  foreign_board_ID
  foreign_mls
  foundation_feature
  front_faces
  fuel_feature
  Google_Street_View
  gross_income
  ground_level
  has_searched_title
  heating_feature
  hot_water_feature
  id957355
  inclusions_feature
  interior_features
  internet_remarksStonebrook Lane, 10 lots to choose from. Ranging in size from 2100 sq ft to over 4000 sq ft, these bare land strata lots are shovel ready with plans attached. Prices from 9,000 plus GST. Close to transportation, shopping, parks and all the wonderful amenities that Langford has to offer, Stonebrook Lane offers the opportunity to build in a safe, quiet neighbourhood only moments away from all that you want.
  Is_Revenue_Property
  Is_Solicitation_Permitted
  junior_school
  jurisdictionCity of Langford
  kitchens0
  LA_agent_ID3879
  LA_board_MUI
  LA_credentials
  LA_firm_MUI
  LA_firm_name
  LA_first_nameDavid Langlois
  LA_initial
  LA_last_name
  LA_MUI
  LA_office_ID292
  LA_office_MUI
  LA_office_nameMacdonald Realty Victoria
  LA_office_phone250-388-5882
  LA_PREC
  LA_web
  LACO1_agent_ID3742
  LACO1_board_MUI
  LACO1_credentials
  LACO1_firm_MUI
  LACO1_firm_nameNiels Madsen
  LACO1_first_nameNiels Madsen
  LACO1_initial
  LACO1_last_name
  LACO1_MUI
  LACO1_office_ID292
  LACO1_office_MUI
  LACO1_office_nameMacdonald Realty Victoria
  LACO1_office_phone250-388-5882
  LACO1_PREC
  LACO1_web
  LACO2_agent_ID
  LACO2_board_MUI
  LACO2_credentials
  LACO2_firm_MUI
  LACO2_firm_name
  LACO2_first_name
  LACO2_initial
  LACO2_last_name
  LACO2_MUI
  LACO2_office_ID
  LACO2_office_MUI
  LACO2_office_name
  LACO2_office_phone
  LACO2_PREC
  LACO2_web
  land_district21
  latitude48.454474
  laundry_features
  laundry_location_feature
  layout
  lease_heldby
  lease_yrs_rem
  leased_equipment_feature
  legal_fformSTRATA LOT 7, PLAN EPS8195, SECTION 109, ESQUIMALT LAND DISTRICT, TOGETHER WITH AN INTEREST IN THE COMMON PROPERTY IN PROPORTION TO THE UNIT ENTITLEMENT OF THE STRATA LOT AS SHOWN ON FORM V
  legal_non_conf
  levels_in_suites
  listing_subtypeLand
  listing_typeResidential
  location_features
  lock_box_loc
  longitude-123.494408
  lot
  lot_depth
  lot_features
  Lot_frontage
  lot_shape
  lot_size_acres0.05
  lot_size_sqft2156
  main_level
  managed_by
  managed_by_phone
  map_areaLa Mill Hill
  matrix_unique_ID26401384
  Meridian
  mhr_no
  monthly_assess1
  monthly_assess_year2023
  net_income
  no_units_1bed
  no_units_2bed
  no_units_3bed
  no_units_4bed
  no_units_studio
  no_units_total
  on_idx
  openhouse_CNT
  parking_type_feature
  PermitReciprocityYN1
  pet_notes
  Pets
  photo_count20
  pid_no032-073-844
  possessionImmediate
  postal_codeV9B 3N9
  postal_district
  pr_planEPS8195
  price_current369000
  price_ext_lease_sold
  price_list369000
  price_original369000
  price_selling
  prkng_common_spaces0
  prkng_lot2
  prkng_other0
  prkng_tot_spaces2
  range
  ratio_sell_by_original
  rear_faces
  remarksStonebrook Lane, 10 lots to choose from. Ranging in size from 2100 sq ft to over 4000 sq ft, these bare land strata lots are shovel ready with plans attached. Prices from 9,000 plus GST. Close to transportation, shopping, parks and all the wonderful amenities that Langford has to offer, Stonebrook Lane offers the opportunity to build in a safe, quiet neighbourhood only moments away from all that you want.
  rent_allowedUnrestricted
  rent_includes_feature
  rent_notes
  roof_feature
  rooms_main_level_feature
  rooms_overall_feature
  SA_agent_ID
  SA_credentials
  SA_firm_MUI
  SA_firm_name
  SA_first_name
  SA_initial
  SA_last_name
  SA_MUI
  SA_office_ID
  SA_office_MUI
  SA_office_name
  SA_office_phone
  SA_PREC
  SACO1_agent_ID
  SACO1_credentials
  SACO1_firm_MUI
  SACO1_firm_name
  SACO1_first_name
  SACO1_initial
  SACO1_last_name
  SACO1_MUI
  SACO1_office_ID
  SACO1_office_MUI
  SACO1_office_name
  SACO1_office_phone
  SACO1_PREC
  SACO2_agent_ID
  SACO2_credentials
  SACO2_firm_MUI
  SACO2_firm_name
  SACO2_first_name
  SACO2_initial
  SACO2_last_name
  SACO2_MUI
  SACO2_office_ID
  SACO2_office_MUI
  SACO2_office_name
  SACO2_office_phone
  SACO2_PREC
  section109
  seller_name
  seller_phone
  senior_school
  services_available_feature
  shared_amenities_feature
  sqft_balcony
  sqft_level1
  sqft_level2
  sqft_level3
  sqft_level4
  sqft_other
  sqft_patio
  sqft_prkng
  sqft_storage
  statusCurrent
  strata_assess_includes_feature
  strata_lot_includes_feature
  streetStonebrook
  street_dir
  street_MUI
  street_no732
  street_suffixLane
  suites_in_bldg1
  suites_in_cmplx10
  tax_MUI
  tax_yr2024
  taxes1.00
  tenant_phone
  titleFreehold/Strata
  top_level
  tot_sqft_finished
  tot_sqft_unfinished
  total_baths0
  township
  unfini_room1
  unfini_room1_level1
  unfini_room1_level2
  unfini_room1_level3
  unfini_room1_level4
  unfini_room1_other
  unfini_room2
  unfini_room2_level1
  unfini_room2_level2
  unfini_room2_level3
  unfini_room2_level4
  unfini_room2_other
  unfini_room3
  unfini_room3_level1
  unfini_room3_level2
  unfini_room3_level3
  unfini_room3_level4
  unfini_room3_other
  unfini_room4
  unfini_room4_level1
  unfini_room4_level2
  unfini_room4_level3
  unfini_room4_level4
  unfini_room4_other
  unfini_room5
  unfini_room5_level1
  unfini_room5_level2
  unfini_room5_level3
  unfini_room5_level4
  unfini_room5_other
  unfinished_room_CNT0
  unit_no
  unit1_notes
  unit1_tot_baths
  unit1_tot_beds
  unit1_tot_fp
  unit2_notes
  unit2_tot_baths
  unit2_tot_beds
  unit2_tot_fp
  unit3_notes
  unit3_tot_baths
  unit3_tot_beds
  unit3_tot_fp
  unit4_notes
  unit4_tot_baths
  unit4_tot_beds
  unit4_tot_fp
  URL_additional_photos
  URL_feature_sheet
  URL_sales_brochure
  URL_sound_bite
  URL_Virtual_Tourhttps://www.rockinghamrise.com/
  Waste_featureSewer To Lot
  waterTo Lot
  year_built
  zoning
  zoning_classResidential
  basement_development0
  youtube_embedding_code
  youtube_video_code
  tot_sqft
  ListingId957355
  ListingKeyNumeric26401384
  address732 Stonebrook Lane
  address_admin_indexStonebrook 732
  matrixPhotos
  0https://www.vreb.radarhill.ca/img/properties/957/355/1.jpg
  1https://www.vreb.radarhill.ca/img/properties/957/355/2.jpg
  2https://www.vreb.radarhill.ca/img/properties/957/355/3.jpg
  3https://www.vreb.radarhill.ca/img/properties/957/355/4.jpg
  4https://www.vreb.radarhill.ca/img/properties/957/355/5.jpg
  5https://www.vreb.radarhill.ca/img/properties/957/355/6.jpg
  6https://www.vreb.radarhill.ca/img/properties/957/355/7.jpg
  7https://www.vreb.radarhill.ca/img/properties/957/355/8.jpg
  8https://www.vreb.radarhill.ca/img/properties/957/355/9.jpg
  9https://www.vreb.radarhill.ca/img/properties/957/355/10.jpg
  10https://www.vreb.radarhill.ca/img/properties/957/355/11.jpg
  11https://www.vreb.radarhill.ca/img/properties/957/355/12.jpg
  12https://www.vreb.radarhill.ca/img/properties/957/355/13.jpg
  13https://www.vreb.radarhill.ca/img/properties/957/355/14.jpg
  14https://www.vreb.radarhill.ca/img/properties/957/355/15.jpg
  15https://www.vreb.radarhill.ca/img/properties/957/355/16.jpg
  16https://www.vreb.radarhill.ca/img/properties/957/355/17.jpg
  17https://www.vreb.radarhill.ca/img/properties/957/355/18.jpg
  18https://www.vreb.radarhill.ca/img/properties/957/355/19.jpg
  19https://www.vreb.radarhill.ca/img/properties/957/355/20.jpg
  PublishingInformation
  id
  created
  modified
  model
  foreign_key
  start
  end
  published
  featured
  deleted
  photo_count
  ListAgent
  agent_ID3879
  ListAgentCoOne
  agent_ID3742
  ListAgentCoTwo
  agent_ID
  SellAgent
  agent_ID
  SellAgentCoOne
  agent_ID
  SellAgentCoTwo
  agent_ID
  AerialVideo(empty)
  Document(empty)
  Image(empty)
  Link(empty)
  OpenHouse(empty)
  CustomFieldValue(empty)
  MetaValue(empty)
  metaDefaults
  description bed, bath, 2156 sqft Residential in Langford, BC. Stonebrook Lane, 10 lots to choose from. Ranging in size from 2100 sq ft to over 4000 sq ft, these bare land strata lots are shovel ready with plans attached. Prices from 9,000 plus GST. Close to transportation, shopping, parks and all the wonderful amenities that Langford has to offer, Stonebrook Lane offers the opportunity to build in a safe, quiet neighbourhood only moments away from all that you want.
  RoomMatrix(empty)
- pageHeadingResidential Property in Langford
- titleTagResidential Property in Langford • Madsen Langlois Real Estate • Victoria BC
- loggedIn(false)
- superAdmin(false)
- admin(false)
- $request->data(empty)
- $this->validationErrors
  CmsPlugin(empty)
  Setting(empty)
  BootstrapInstance(empty)
  VrebAgent(empty)
  PrototypeInstance(empty)
  PublishingInformation(empty)
  MetaValue(empty)
  PrototypeCategory(empty)
  CustomFieldValue(empty)
  PrototypeItem(empty)
  BootstrapVrebInstance(empty)
  VrebListing(empty)
  EmailFormSubmission(empty)
  EmailForm(empty)
  User(empty)
  Country(empty)
  Permission(empty)
  LoginToken(empty)
  Group(empty)
  GroupsPermission(empty)
  Document(empty)
  AerialVideo(empty)
  Image(empty)
  Link(empty)
  OpenHouse(empty)
  ListAgent(empty)
  Office(empty)
  ListAgentCoOne(empty)
  ListAgentCoTwo(empty)
  SellAgent(empty)
  SellAgentCoOne(empty)
  SellAgentCoTwo(empty)
  RoomMatrix(empty)
  Page(empty)
  MetaKey(empty)
- Loaded Helpers
  0Html
  1Form
  2Session
  3Cms
  4AssetCompress
  5Copyright
  6GoogleMap
  7SocialMedia
  8ReCaptcha
  9MathCaptcha
  10PageBlock
  11Settings
  12AdminLink
  13AdminNav
  14AdminTab
  15ContentBlock
  16CustomField
  17EmailForm
  18EmailFormBlock
  19GalleryBlock
  20ModelLink
  21ModelLoad
  22MediaVersion
  23Media
  24Meta
  25Navigation
  26Prototype
  27PrototypeLink
  28Publishing
  29Responsive
  30Theme
  31TinyMce
  32Users
  33Versioning
  34Property
  35Vreb
  36VrebListingFeedBlock
  37VrebSideCar
  38HeaderSlideshow
  39Blog
  40Toolbar
  41Number
  42SimpleGraph
  43Recaptcha
  44Text
  45App
  46HtmlToolbar
====
Include
+
Included Files

Include Paths
- 0/usr/local/share/pyramidcms/V1/lib/Cms/Plugin/Media/Lib/mm/src
- 2/opt/alt/php56/usr/share/pear
- 3/opt/alt/php56/usr/share/php
- 4/usr/local/share/pyramidcms/vendors
- 5-> /home/madsenlanglois/pyramidcms/Cake/
Included Files
- core(empty)
- app
  Behavior
  0APP/Model/Behavior/DynamicValidationBehavior.php
  1APP/Model/Behavior/ValidateHabtmBehavior.php
  2APP/Model/Behavior/SortableBehavior.php
  3APP/Model/Behavior/SluggableBehavior.php
  4APP/Model/Behavior/CopyableBehavior.php
  5APP/Model/Behavior/MultiTreeBehavior.php
  6APP/Model/Behavior/ReCaptchaBehavior.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
  4APP/Controller/Component/ControllerToolsComponent.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
  1APP/Model/Token.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
  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
  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
  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/CustomFieldValue.php
  1CustomFields/Model/CustomFieldsAppModel.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
  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
  Model
  0Metas/Model/MetaValue.php
  1Metas/Model/MetaKey.php
  Component
  0Metas/Controller/Component/MetaComponent.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
  Model
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.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/LoginToken.php
  5Users/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
  VrebListings
  Config
  0VrebListings/Config/bootstrap.php
  1VrebListings/Config/events.php
  2VrebListings/Config/routes.php
  Plugin
  0VrebListings/Lib/Vreb.php
  1VrebListings/Event/VrebListingsEventListener.php
  Model
  0VrebListings/Model/VrebAgent.php
  1VrebListings/Model/VrebListingsAppModel.php
  2VrebListings/Model/VrebListing.php
  3VrebListings/Model/VrebListingAttachment.php
  4VrebListings/Model/VrebListingLink.php
  5VrebListings/Model/VrebOpenHouse.php
  6VrebListings/Model/VrebOffice.php
  7VrebListings/Model/RoomMatrix.php
  Controller
  0VrebListings/Controller/VrebListingsController.php
  1VrebListings/Controller/VrebListingsAppController.php
  Behavior
  0VrebListings/Model/Behavior/VrebPublishableBehavior.php
  1VrebListings/Model/Behavior/VrebCouplerBehavior.php
====

Residential Property in Langford

$369,000

732 Stonebrook Lane
MLS^® NO: 957355