Homes

2817 Elgaard Drive

RRHBA New Home Locator - 2817 Elgaard Drive

Style: Two-Storey
Bedrooms: 3
Area: Hawkstone
City: Regina
Builder: Homes by Dream


2802 Makowsky Crescent

RRHBA New Home Locator - 2802 Makowsky Crescent

Style: Two-Storey
Bedrooms: 3
Area: Hawkstone
City: Regina
Builder: Homes by Dream


4326 E. Green Poplar Lane

RRHBA New Home Locator - 4326 E. Green Poplar Lane

Style: Bungalow
Bedrooms: 3
Area: The Greens on Gardiner
City: Regina
Builder: Homes by Dream


1102 N Poley Street $369,900.00

RRHBA New Home Locator - 1102 N Poley Street

Open House: Monday - Thursday: 5 pm - 9 pm,
Saturday & Sunday: 1 pm - 5 pm or by appointment
Style: Bungalow
Bedrooms: 2
Area: Hawkstone
City: Regina, SK
Builder: Sthamann Homes Inc


1110 N Poley Street $382,900.00

No Image Available

Open House: Monday - Thursday: 5 pm - 9 pm,
Saturday & Sunday: 1 pm - 5pm or by appointment
Style: Two-Storey
Bedrooms: 3
Area: Hawkstone
City: Regina
Builder: Sthamann Homes Inc


5117 Crane Crescent

RRHBA New Home Locator - 5117 Crane Crescent

Style: Two-Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Homes by Dream


5260 Crane Crescent

RRHBA New Home Locator - 5260 Crane Crescent

Style: Two-Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Homes by Dream


5130 Snowbirds Crescent

RRHBA New Home Locator - 5130 Snowbirds Crescent

Style: Two-Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Homes by Dream


5224 Crane Crescent

RRHBA New Home Locator - 5224 Crane Crescent

Style: Two-Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Homes by Dream


4154 Timber Creek Place $699,000.00

RRHBA New Home Locator - 4154 Timber Creek Place

Style: Bungalow
Bedrooms: 1
Area: The Creeks
City: Regina
Builder: Munro Homes Ltd.


3922 Goldfinch Way $889,000.00

RRHBA New Home Locator - 3922 Goldfinch Way

Style: Bungalow
Bedrooms: 5
Area: The Creeks
City: Regina
Builder: Munro Homes Ltd.


5301 Mitchinson Way $420,000.00

RRHBA New Home Locator - 5301 Mitchinson Way

Open House: Monday - Thursday 6pm - 9pm
Saturday, Sunday & Holidays 12pm - 5pm
Style: Two-Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina


727 Third Avenue $540,000.00

RRHBA New Home Locator - 727 Third Avenue

Open House: Saturday & Sunday: 1pm - 5pm
Style: Bi-Level
Bedrooms: 3
Area: Pilot Butte
City: Pilot Butte
Builder: Varsity Homes Ltd.


4105 James Hill Road

RRHBA New Home Locator - 4105 James Hill Road

Style: Two-Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Homes by Dream


4017 James Hill Road

RRHBA New Home Locator - 4017 James Hill Road

Style: Two-Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Homes by Dream


138 - 1920 7th Avenue East $294,900.00

RRHBA New Home Locator - 138 - 1920 7th Avenue East

Open House: Monday - Thursday: 6pm - 9pm
Saturday, Sunday & Holidays: 12pm - 5pm

Style: Townhouse Condo
Bedrooms: 3
Area: Glencarin
City: Regina
Builder: North Ridge Development Corporation


2425 Saunders Crescent $415,900.00

RRHBA New Home Locator - 2425 Saunders Crescent

Style: Two-Storey
Bedrooms: 3
Area: Kensington Greens
City: Regina, SK
Builder: Gilroy Homes Inc.


5317 E Green Silverberry Drive $359,900.00

RRHBA New Home Locator - 5317 E Green Silverberry Drive

Open House: Monday- Thursday from 3pm-9pm
Weekends & Holidays from 12pm-5pm
Style: Duplex
Bedrooms: 3
Area: The Greens on Gardiner
City: Regina
Builder: Alquinn Homes (Saskatchewan) Ltd.


5416 Mckenna Crescent

RRHBA New Home Locator - 5416 Mckenna Crescent

Style: Bungalow
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Varsity Homes Ltd.


5276 Crane Crescent

RRHBA New Home Locator - 5276 Crane Crescent

Style: Two-Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Homes by Dream


Page 1 of 11, showing 20 records out of 215 total, starting on record 1, ending on 20

View Map of Listings

Search Homes

Cake SQL Log
(default) 39 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)Code
1SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `reginaho_rrhba_live`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 97 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
2SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `reginaho_rrhba_live`.`aros` AS `Aro` LEFT JOIN `reginaho_rrhba_live`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Role' AND `Aro0`.`foreign_key` = 3 ORDER BY `Aro`.`lft` DESC220AppController::beforeFilter() - APP/Controller/AppController.php, line 100 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
3SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `reginaho_rrhba_live`.`acos` AS `Aco` LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Homes') LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'index' AND `Aco0`.`id` = `Aco1`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco1`.`lft` AND `Aco`.`rght` >= `Aco1`.`rght`)) ORDER BY `Aco`.`lft` DESC330AppController::beforeFilter() - APP/Controller/AppController.php, line 100 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
4SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `reginaho_rrhba_live`.`aros_acos` AS `Permission` LEFT JOIN `reginaho_rrhba_live`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (165, 142, 1) ORDER BY `Aco`.`lft` desc110AppController::beforeFilter() - APP/Controller/AppController.php, line 100 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
5SELECT `Resource`.`id` FROM `reginaho_rrhba_live`.`resources` AS `Resource` LEFT JOIN `reginaho_rrhba_live`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1000AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 210 AppController::beforeFilter() - APP/Controller/AppController.php, line 126 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
6SELECT `Company`.`id`, `Company`.`name` FROM `reginaho_rrhba_live`.`companies` AS `Company` WHERE EXISTS (SELECT 1 FROM companies_company_roles FindJoinTable LEFT JOIN company_roles FindRole ON `FindJoinTable`.`company_role_id` = `FindRole`.`id` WHERE `FindJoinTable`.`company_id` = `Company`.`id` AND `FindRole`.`name` = 'Builder') ORDER BY `name` ASC49490Company::findByRole() - APP/Model/Company.php, line 139 HomesController::locatorData() - APP/Controller/HomesController.php, line 1018 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
7SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `reginaho_rrhba_live`.`neighborhoods` AS `Neighborhood` WHERE 1 = 1 ORDER BY `name` ASC38380HomesController::locatorData() - APP/Controller/HomesController.php, line 1023 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
8SELECT DISTINCT (`Home`.`style`) as style FROM `reginaho_rrhba_live`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC22220HomesController::locatorData() - APP/Controller/HomesController.php, line 1028 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
9SELECT DISTINCT (`Home`.`city`) as city FROM `reginaho_rrhba_live`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC770HomesController::locatorData() - APP/Controller/HomesController.php, line 1050 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
10SELECT `Home`.`id`, `Home`.`company_id`, `Home`.`user_id`, `Home`.`slug`, `Home`.`status`, `Home`.`delete`, `Home`.`show_home_hours`, `Home`.`summary`, `Home`.`description`, `Home`.`price`, `Home`.`possesion_date`, `Home`.`size`, `Home`.`style`, `Home`.`beds`, `Home`.`model`, `Home`.`address`, `Home`.`city`, `Home`.`province`, `Home`.`postal_code`, `Home`.`neighborhood_id`, `Home`.`contact_name`, `Home`.`contact_phone`, `Home`.`contact_email`, `Home`.`energystar`, `Home`.`r2000`, `Home`.`coordinate_override`, `Home`.`latitude`, `Home`.`longitude`, `Home`.`accuracy`, `Home`.`tour`, (FORMAT(`Home`.`price`,0)) AS `Home__price_nice`, `Neighborhood`.`name`, `Company`.`name`, `Company`.`slug` FROM `reginaho_rrhba_live`.`homes` AS `Home` LEFT JOIN `reginaho_rrhba_live`.`neighborhoods` AS `Neighborhood` ON (`Home`.`neighborhood_id` = `Neighborhood`.`id`) LEFT JOIN `reginaho_rrhba_live`.`companies` AS `Company` ON (`Home`.`company_id` = `Company`.`id`) WHERE `Home`.`status` >= 1 LIMIT 2020200HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
11SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1016) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
12SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1017) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
13SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (413) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
14SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (996) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
15SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (994) ORDER BY `order` ASC LIMIT 1000HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
16SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1044) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
17SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1045) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
18SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1046) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
19SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1047) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
20SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (500) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
21SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (586) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
22SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (937) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
23SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (919) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
24SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1029) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
25SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1030) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
26SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (983) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
27SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1050) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
28SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1129) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
29SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1055) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
30SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `reginaho_rrhba_live`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1008) ORDER BY `order` ASC LIMIT 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
31SELECT COUNT(*) AS `count` FROM `reginaho_rrhba_live`.`homes` AS `Home` LEFT JOIN `reginaho_rrhba_live`.`neighborhoods` AS `Neighborhood` ON (`Home`.`neighborhood_id` = `Neighborhood`.`id`) LEFT JOIN `reginaho_rrhba_live`.`companies` AS `Company` ON (`Home`.`company_id` = `Company`.`id`) WHERE `Home`.`status` >= 1110HomesController::index() - APP/Controller/HomesController.php, line 197 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
32SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `reginaho_rrhba_live`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 97 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
33SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `reginaho_rrhba_live`.`aros` AS `Aro` LEFT JOIN `reginaho_rrhba_live`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Role' AND `Aro0`.`foreign_key` = 3 ORDER BY `Aro`.`lft` DESC220AppController::beforeFilter() - APP/Controller/AppController.php, line 100 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
34SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `reginaho_rrhba_live`.`acos` AS `Aco` LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Posts') LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'index' AND `Aco0`.`id` = `Aco1`.`parent_id`) WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco1`.`lft` AND `Aco`.`rght` >= `Aco1`.`rght`)) ORDER BY `Aco`.`lft` DESC330AppController::beforeFilter() - APP/Controller/AppController.php, line 100 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
35SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `reginaho_rrhba_live`.`aros_acos` AS `Permission` LEFT JOIN `reginaho_rrhba_live`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `reginaho_rrhba_live`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (218, 213, 1) ORDER BY `Aco`.`lft` desc110AppController::beforeFilter() - APP/Controller/AppController.php, line 100 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
36SELECT `Resource`.`id` FROM `reginaho_rrhba_live`.`resources` AS `Resource` LEFT JOIN `reginaho_rrhba_live`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1000AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 210 AppController::beforeFilter() - APP/Controller/AppController.php, line 126 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
37SELECT `Post`.`id`, `Post`.`title`, `Post`.`date`, `Post`.`summary`, `Post`.`post`, `Post`.`created`, `Post`.`updated`, `Post`.`status`, `Post`.`user_id`, `Post`.`featured`, `Post`.`post_category_id`, `User`.`id`, `User`.`name`, `User`.`username`, `User`.`email` FROM `reginaho_rrhba_live`.`posts` AS `Post` LEFT JOIN `reginaho_rrhba_live`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`status` = '1' AND `Post`.`post_category_id` = 1 ORDER BY `Post`.`date` DESC37370PostsController::index() - APP/Controller/PostsController.php, line 31 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
38SELECT `PostPhoto`.`id`, `PostPhoto`.`post_id`, `PostPhoto`.`image_path`, `PostPhoto`.`file_name`, `PostPhoto`.`order` FROM `reginaho_rrhba_live`.`post_photos` AS `PostPhoto` WHERE `PostPhoto`.`post_id` IN (54, 53, 50, 49, 48, 47, 46, 45, 42, 44, 43, 41, 40, 38, 39, 36, 37, 35, 34, 29, 28, 30, 31, 32, 9, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) ORDER BY `order` ASC 37370PostsController::index() - APP/Controller/PostsController.php, line 31 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
39SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `ObjectsTag`.`id`, `ObjectsTag`.`tag_id`, `ObjectsTag`.`model`, `ObjectsTag`.`foreign_key`, `ObjectsTag`.`created` FROM `reginaho_rrhba_live`.`tags` AS `Tag` JOIN `reginaho_rrhba_live`.`objects_tags` AS `ObjectsTag` ON (`ObjectsTag`.`foreign_key` IN (54, 53, 50, 49, 48, 47, 46, 45, 42, 44, 43, 41, 40, 38, 39, 36, 37, 35, 34, 29, 28, 30, 31, 32, 9, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) AND `ObjectsTag`.`tag_id` = `Tag`.`id`) WHERE `ObjectsTag`.`model` = 'Post' 000PostsController::index() - APP/Controller/PostsController.php, line 31 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92