Homes

5213 Aviator Crescent - The Oasis ll $479,900.00

RRHBA New Home Locator - 5213 Aviator Crescent - The Oasis ll

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


3410 E Green Stone Road - The Horizon MH $409,900.00

RRHBA New Home Locator - 3410 E Green Stone Road - The Horizon MH

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


6222 Little Pine Loop

RRHBA New Home Locator - 6222 Little Pine Loop

Style: Bungalow
Bedrooms: 3
Area: Skyview
City: Regina
Builder: Geiger Homes & Developments Ltd.


7802 Sagebrush Crescent - The Hampton $949,000.00

RRHBA New Home Locator - 7802 Sagebrush Crescent - The Hampton

Show Home Hours:
Monday 7:00 pm – 9:00 pm
Tuesday 7:00 pm – 9:00 pm
Wednesday 7:00 pm – 9:00 pm
Thursday 7:00 pm – 9:00 pm
Saturday 1:00 pm – 5:00 pm
Sunday 1:00 pm – 5:00 pm
Style: Bungalow Walk-Out
Bedrooms: 4
Area: Fairways West
City: Regina
Builder: Harmony Builders Ltd.


1110 N Poley Street $382,900.00

RRHBA New Home Locator -  1110 N Poley Street

Show Home Hours:
Monday 5:00 pm – 9:00 pm
Tuesday 5:00 pm – 9:00 pm
Wednesday 5:00 pm – 9:00 pm
Thursday 5:00 pm – 9:00 pm
Saturday 1:01 pm – 5:00 pm
Sunday 1:00 pm – 5:00 pm
By Appointment:
Saturday & Sunday also by appointment.
Style: Two-Storey
Bedrooms: 3
Area: Hawkstone
City: Regina
Builder: Sthamann Homes


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


5400 E. Green Bluebell Road - The Remington $294,900.00

RRHBA New Home Locator - 5400 E. Green Bluebell Road - The Remington

Style: 2 storey duplex
Bedrooms: 2
Area: The Greens on Gardiner
City: Regina
Builder: Pacesetter Homes


5512 Tutor Way - The Kensington $314,900.00

RRHBA New Home Locator - 5512 Tutor Way - The Kensington

Style: 2 Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Pacesetter Homes


727 Third Avenue - The Clarion $540,000.00

RRHBA New Home Locator - 727 Third Avenue - The Clarion

By Appointment:
Please contact Varsity Homes to set up a viewing.
Style: Bi-Level
Bedrooms: 3
Area: Pilot Butte
City: Pilot Butte
Builder: Varsity Homes


138 - 1920 7th Avenue East $289,900.00

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

Show Home Hours:
Monday 6:00 pm – 9:00 pm
Tuesday 6:00 pm – 9:00 pm
Wednesday 6:00 pm – 9:00 pm
Thursday 6:00 pm – 9:00 pm
Saturday 12:00 pm – 5:00 pm
Sunday 12:00 pm – 5:00 pm
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
Builder: Gilroy Homes


3660 East Haughton Road - B3 Design $236,500.00

RRHBA New Home Locator - 3660 East Haughton Road - B3 Design

Show Home Hours:
Tuesday 3:00 pm – 6:00 pm
Wednesday 3:00 pm – 6:00 pm
Friday 3:00 pm – 6:00 pm
Saturday 1:30 pm – 5:30 pm
Sunday 1:30 pm – 5:30 pm
Style: Condo
Bedrooms: 2
Area: Windsor Park
City: Regina
Builder: Deiana General Construction Ltd.


2308 Saunders Crescent $479,000.00

RRHBA New Home Locator - 2308 Saunders Crescent

By Appointment:
Call Brad Gregg @ 306-591-1736
Style: Two-Story
Bedrooms: 3
Area: Kensington Greens
City: Regina
Builder: Sthamann Homes


4501 Child Avenue - Paramount Condominiums $219,900.00

RRHBA New Home Locator - 4501 Child Avenue - Paramount Condominiums

By Appointment:
Contact James Wruth to schedule a viewing
Style: Apartment Condo
Bedrooms: 2
Area: Lakeridge
City: Regina
Builder: North Ridge Development Corporation


3977 Sandhill Crescent - The Bridgewater $499,999.00

RRHBA New Home Locator - 3977 Sandhill Crescent - The Bridgewater

Style: Bungalow
Bedrooms: 1
Area: The Creeks
City: Regina
Builder: Homes by Dream


3902 Goldfinch Way $774,900.00

RRHBA New Home Locator - 3902 Goldfinch Way

Show Home Hours:
Monday 7:00 pm – 9:00 pm
Tuesday 7:00 pm – 9:00 pm
Wednesday 7:00 pm – 9:00 pm
Thursday 7:00 pm – 9:00 pm
Saturday 1:00 pm – 5:00 pm
Sunday 1:00 pm – 5:00 pm
Style: Bungalow
Bedrooms: 2
Area: The Creeks
City: Regina
Builder: Sthamann Homes


4342 Sage Drive $899,900.00

RRHBA New Home Locator - 4342 Sage Drive

Show Home Hours:
Monday 7:00 pm – 9:00 pm
Tuesday 7:00 pm – 9:00 pm
Wednesday 7:00 pm – 9:00 pm
Thursday 7:00 pm – 9:00 pm
Saturday 1:00 pm – 4:00 pm
Sunday 1:00 pm – 4:00 pm
Style: Two Storey
Bedrooms: 5
Area: The Creeks
City: Regina
Builder: Kratz Homes


5229 Squires Road - The Lexi $349,900.00

RRHBA New Home Locator - 5229 Squires Road - The Lexi

Style: 2 Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Pacesetter Homes


5406 Tutor Way - The Yukon

RRHBA New Home Locator - 5406 Tutor Way - The Yukon

Show Home Hours:
Monday 4:00 pm – 8:00 pm
Tuesday 4:00 pm – 8:00 pm
Wednesday 4:00 pm – 8:00 pm
Thursday 4:00 pm – 8:00 pm
Saturday 12:00 pm – 5:00 pm
Sunday 12:00 pm – 5:00 pm
Style: Two - Storey
Bedrooms: 3
Area: Harbour Landing
City: Regina
Builder: Homes by Dream


4826 E Green Rock Road - The Christopher $322,900.00

RRHBA New Home Locator - 4826 E Green Rock Road - The Christopher

Style: Duplex
Bedrooms: 3
Area: The Greens on Gardiner
City: Regina
Builder: Glenrose Master Builder


Page 1 of 10, showing 20 records out of 191 total, starting on record 1, ending on 20

View Map of Listings

Search Homes

Cake SQL Log
(default) 61 queries took 3706 ms
NrQueryErrorAffectedNum. rowsTook (ms)Code
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `rrhba`.`cake_sessions` AS `Session` WHERE `id` = '2mgqpetdgm13gjr45bc9mekja3' LIMIT 1001session_start - [internal], line ?? AppController::beforeFilter() - APP/Controller/AppController.php, line 82 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
2SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1110AppController::beforeFilter() - APP/Controller/AppController.php, line 98 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
3SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`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` DESC221AppController::beforeFilter() - APP/Controller/AppController.php, line 101 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
4SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Homes') LEFT JOIN `rrhba`.`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` DESC33431AppController::beforeFilter() - APP/Controller/AppController.php, line 101 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
5SELECT `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 `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`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` desc111AppController::beforeFilter() - APP/Controller/AppController.php, line 101 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
6SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`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 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 30 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
7SELECT `Company`.`id`, `Company`.`name` FROM `rrhba`.`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` ASC51511Company::findByRole() - APP/Model/Company.php, line 139 HomesController::locatorData() - APP/Controller/HomesController.php, line 1108 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
8SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `rrhba`.`neighborhoods` AS `Neighborhood` WHERE 1 = 1 ORDER BY `name` ASC42421HomesController::locatorData() - APP/Controller/HomesController.php, line 1113 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
9SELECT DISTINCT (`Home`.`style`) as style FROM `rrhba`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC32321HomesController::locatorData() - APP/Controller/HomesController.php, line 1118 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
10SELECT DISTINCT (`Home`.`city`) as city FROM `rrhba`.`homes` AS `Home` WHERE `Home`.`status` >= 1 ORDER BY `style` ASC551HomesController::locatorData() - APP/Controller/HomesController.php, line 1140 HomesController::beforeFilter() - APP/Controller/HomesController.php, line 31 call_user_func - [internal], line ?? [main] - APP/webroot/index.php, line 92
11SELECT `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`, `Home`.`show_open`, `Home`.`show_appointment`, `Home`.`show_open_monday`, `Home`.`show_open_tuesday`, `Home`.`show_open_wednesday`, `Home`.`show_open_thursday`, `Home`.`show_open_friday`, `Home`.`show_open_saturday`, `Home`.`show_open_sunday`, `Home`.`show_open_monday_start`, `Home`.`show_open_monday_end`, `Home`.`show_open_tuesday_start`, `Home`.`show_open_tuesday_end`, `Home`.`show_open_wednesday_start`, `Home`.`show_open_wednesday_end`, `Home`.`show_open_thursday_start`, `Home`.`show_open_thursday_end`, `Home`.`show_open_friday_start`, `Home`.`show_open_friday_end`, `Home`.`show_open_saturday_start`, `Home`.`show_open_saturday_end`, `Home`.`show_open_sunday_start`, `Home`.`show_open_sunday_end`, `Home`.`show_appointment_instructions`, (FORMAT(`Home`.`price`,0)) AS `Home__price_nice`, `Neighborhood`.`name`, `Company`.`name`, `Company`.`slug` FROM `rrhba`.`homes` AS `Home` LEFT JOIN `rrhba`.`neighborhoods` AS `Neighborhood` ON (`Home`.`neighborhood_id` = `Neighborhood`.`id`) LEFT JOIN `rrhba`.`companies` AS `Company` ON (`Home`.`company_id` = `Company`.`id`) WHERE `Home`.`status` >= 1 LIMIT 2020202HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1244) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1245) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1195) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1227) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (994) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (500) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1324) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1216) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (919) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (983) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1050) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1364) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1366) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (502) ORDER BY `order` ASC LIMIT 1111HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1028) ORDER BY `order` ASC LIMIT 1113HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (632) ORDER BY `order` ASC LIMIT 1113HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1184) ORDER BY `order` ASC LIMIT 1113HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1388) ORDER BY `order` ASC LIMIT 1113HomesController::index() - APP/Controller/HomesController.php, line 229 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 `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (908) ORDER BY `order` ASC LIMIT 1114HomesController::index() - APP/Controller/HomesController.php, line 229 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
31SELECT `Photo`.`id`, `Photo`.`home_id`, `Photo`.`image_path`, `Photo`.`order`, `Photo`.`visible` FROM `rrhba`.`photos` AS `Photo` WHERE `Photo`.`visible` = '1' AND `Photo`.`home_id` = (1331) ORDER BY `order` ASC LIMIT 1113HomesController::index() - APP/Controller/HomesController.php, line 229 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
32SELECT COUNT(*) AS `count` FROM `rrhba`.`homes` AS `Home` LEFT JOIN `rrhba`.`neighborhoods` AS `Neighborhood` ON (`Home`.`neighborhood_id` = `Neighborhood`.`id`) LEFT JOIN `rrhba`.`companies` AS `Company` ON (`Home`.`company_id` = `Company`.`id`) WHERE `Home`.`status` >= 1113HomesController::index() - APP/Controller/HomesController.php, line 229 ReflectionMethod::invokeArgs() - [internal], line ?? [main] - APP/webroot/index.php, line 92
33SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1111AppController::beforeFilter() - APP/Controller/AppController.php, line 98 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 177 [main] - APP/webroot/index.php, line 92
34SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`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` DESC223AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 177 [main] - APP/webroot/index.php, line 92
35SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Menus') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'display' 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` DESC33763AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 177 [main] - APP/webroot/index.php, line 92
36SELECT `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 `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (77, 76, 1) ORDER BY `Aco`.`lft` desc111AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 177 [main] - APP/webroot/index.php, line 92
37SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`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 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 177 [main] - APP/webroot/index.php, line 92
38SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`alias`, `Menu`.`url`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`created`, `Menu`.`modified` FROM `rrhba`.`menus` AS `Menu` WHERE `alias` = 'public_top' LIMIT 1110MenusController::display() - APP/Controller/MenusController.php, line 19 ReflectionMethod::invokeArgs() - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 177 [main] - APP/webroot/index.php, line 92
39SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`alias`, `Menu`.`url`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`created`, `Menu`.`modified` FROM `rrhba`.`menus` AS `Menu` WHERE `Menu`.`lft` > 1 AND `Menu`.`rght` < 6 ORDER BY `Menu`.`lft` asc221MenusController::display() - APP/Controller/MenusController.php, line 28 ReflectionMethod::invokeArgs() - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 177 [main] - APP/webroot/index.php, line 92
40SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1111AppController::beforeFilter() - APP/Controller/AppController.php, line 98 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 238 [main] - APP/webroot/index.php, line 92
41SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`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` DESC221AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 238 [main] - APP/webroot/index.php, line 92
42SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Menus') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'display' 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` DESC33877AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 238 [main] - APP/webroot/index.php, line 92
43SELECT `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 `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (77, 76, 1) ORDER BY `Aco`.`lft` desc115AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 238 [main] - APP/webroot/index.php, line 92
44SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1001AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 238 [main] - APP/webroot/index.php, line 92
45SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`alias`, `Menu`.`url`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`created`, `Menu`.`modified` FROM `rrhba`.`menus` AS `Menu` WHERE `alias` = 'public_main' LIMIT 1113MenusController::display() - APP/Controller/MenusController.php, line 19 ReflectionMethod::invokeArgs() - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 238 [main] - APP/webroot/index.php, line 92
46SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`alias`, `Menu`.`url`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`created`, `Menu`.`modified` FROM `rrhba`.`menus` AS `Menu` WHERE `Menu`.`lft` > 7 AND `Menu`.`rght` < 326 ORDER BY `Menu`.`lft` asc1591598MenusController::display() - APP/Controller/MenusController.php, line 28 ReflectionMethod::invokeArgs() - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 238 [main] - APP/webroot/index.php, line 92
47SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1111AppController::beforeFilter() - APP/Controller/AppController.php, line 98 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 278 [main] - APP/webroot/index.php, line 92
48SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`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` DESC221AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 278 [main] - APP/webroot/index.php, line 92
49SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Menus') LEFT JOIN `rrhba`.`acos` AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`alias` = 'display' 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` DESC33898AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 278 [main] - APP/webroot/index.php, line 92
50SELECT `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 `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 3 AND `Permission`.`aco_id` IN (77, 76, 1) ORDER BY `Aco`.`lft` desc111AppController::beforeFilter() - APP/Controller/AppController.php, line 101 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 278 [main] - APP/webroot/index.php, line 92
51SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1004AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 MenusController::beforeFilter() - APP/Controller/MenusController.php, line 8 call_user_func - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 278 [main] - APP/webroot/index.php, line 92
52SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`alias`, `Menu`.`url`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`created`, `Menu`.`modified` FROM `rrhba`.`menus` AS `Menu` WHERE `alias` = 'quick_links' LIMIT 1112MenusController::display() - APP/Controller/MenusController.php, line 19 ReflectionMethod::invokeArgs() - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 278 [main] - APP/webroot/index.php, line 92
53SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`alias`, `Menu`.`url`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`created`, `Menu`.`modified` FROM `rrhba`.`menus` AS `Menu` WHERE `Menu`.`lft` > 327 AND `Menu`.`rght` < 352 ORDER BY `Menu`.`lft` asc12123MenusController::display() - APP/Controller/MenusController.php, line 28 ReflectionMethod::invokeArgs() - [internal], line ?? MenuHelper::draw() - APP/View/Helper/MenuHelper.php, line 8 include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 278 [main] - APP/webroot/index.php, line 92
54SELECT `Role`.`id`, `Role`.`name`, `Role`.`public`, `Role`.`superuser`, `Role`.`created`, `Role`.`modified`, `Role`.`parent_id`, `Role`.`lft`, `Role`.`rght` FROM `rrhba`.`roles` AS `Role` WHERE `public` = '1' LIMIT 1111AppController::beforeFilter() - APP/Controller/AppController.php, line 98 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
55SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `rrhba`.`aros` AS `Aro` LEFT JOIN `rrhba`.`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` DESC221AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
56SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `rrhba`.`acos` AS `Aco` LEFT JOIN `rrhba`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Posts') LEFT JOIN `rrhba`.`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` DESC33634AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
57SELECT `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 `rrhba`.`aros_acos` AS `Permission` LEFT JOIN `rrhba`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `rrhba`.`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` desc117AppController::beforeFilter() - APP/Controller/AppController.php, line 101 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
58SELECT `Resource`.`id` FROM `rrhba`.`resources` AS `Resource` LEFT JOIN `rrhba`.`users` AS `User` ON (`Resource`.`user_id` = `User`.`id`) WHERE 1 = 1001AppModel::fetchAllPermissions() - APP/Model/AppModel.php, line 150 AppController::cacheObjectPermissionsForView() - APP/Controller/AppController.php, line 211 AppController::beforeFilter() - APP/Controller/AppController.php, line 127 call_user_func - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
59SELECT `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 `rrhba`.`posts` AS `Post` LEFT JOIN `rrhba`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`status` = '1' AND `Post`.`post_category_id` = 1 ORDER BY `Post`.`date` DESC49497PostsController::index() - APP/Controller/PostsController.php, line 32 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
60SELECT `PostPhoto`.`id`, `PostPhoto`.`post_id`, `PostPhoto`.`image_path`, `PostPhoto`.`file_name`, `PostPhoto`.`order` FROM `rrhba`.`post_photos` AS `PostPhoto` WHERE `PostPhoto`.`post_id` IN (68, 67, 66, 63, 61, 62, 60, 59, 58, 57, 56, 55, 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 49491PostsController::index() - APP/Controller/PostsController.php, line 32 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92
61SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`created`, `ObjectsTag`.`id`, `ObjectsTag`.`tag_id`, `ObjectsTag`.`model`, `ObjectsTag`.`foreign_key`, `ObjectsTag`.`created` FROM `rrhba`.`tags` AS `Tag` JOIN `rrhba`.`objects_tags` AS `ObjectsTag` ON (`ObjectsTag`.`foreign_key` IN (68, 67, 66, 63, 61, 62, 60, 59, 58, 57, 56, 55, 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' 003PostsController::index() - APP/Controller/PostsController.php, line 32 ReflectionMethod::invokeArgs() - [internal], line ?? include - APP/View/Themed/Rrhba/Layouts/common.ctp, line 285 [main] - APP/webroot/index.php, line 92