Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and `Property`.`status` = 0' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 527]
$sql = "SELECT COUNT(*) AS `count` FROM `hs_property` AS `Property` LEFT JOIN `hs_category` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `hs_category` AS `Sub_Category` ON (`Property`.`sub_category_id` = `Sub_Category`.`id`) WHERE and `Property`.`status` = 0 "
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and `Property`.`status` = 0' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 527
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 203
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 655
Model::find() - CORE/cake/libs/model/model.php, line 2031
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1077
FrontEndController::property_list() - APP/controllers/front_end_controller.php, line 135
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Query: SELECT COUNT(*) AS `count` FROM `hs_property` AS `Property` LEFT JOIN `hs_category` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `hs_category` AS `Sub_Category` ON (`Property`.`sub_category_id` = `Sub_Category`.`id`) WHERE and `Property`.`status` = 0
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and `Property`.`status` = 0 ORDER BY `Property`.`name` asc LIMIT 12' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 527]
$sql = "SELECT `Property`.`id`, `Property`.`category_id`, `Property`.`sub_category_id`, `Property`.`type`, `Property`.`name`, `Property`.`description`, `Property`.`price`, `Property`.`selling_price`, `Property`.`asking_rent`, `Property`.`inclusive`, `Property`.`email`, `Property`.`phone`, `Property`.`address`, `Property`.`google_map_link`, `Property`.`building`, `Property`.`building_type`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`floor_space`, `Property`.`outside_area`, `Property`.`property_views`, `Property`.`building_age`, `Property`.`condition`, `Property`.`property_feature`, `Property`.`interior_feature`, `Property`.`exterior_feature`, `Property`.`featured_item`, `Property`.`main_image`, `Property`.`property_image_1`, `Property`.`property_image_2`, `Property`.`property_image_3`, `Property`.`property_image_4`, `Property`.`property_image_5`, `Property`.`status`, `Property`.`created`, `Property`.`modified`, `Category`.`id`, `Category`.`name`, `Category`.`level`, `Category`.`parent`, `Category`.`status`, `Category`.`display`, `Category`.`created`, `Category`.`modified`, `Sub_Category`.`id`, `Sub_Category`.`name`, `Sub_Category`.`level`, `Sub_Category`.`parent`, `Sub_Category`.`status`, `Sub_Category`.`display`, `Sub_Category`.`created`, `Sub_Category`.`modified` FROM `hs_property` AS `Property` LEFT JOIN `hs_category` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `hs_category` AS `Sub_Category` ON (`Property`.`sub_category_id` = `Sub_Category`.`id`) WHERE and `Property`.`status` = 0 ORDER BY `Property`.`name` asc LIMIT 12"
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and `Property`.`status` = 0 ORDER BY `Property`.`name` asc LIMIT 12' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 527
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 203
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 655
Model::find() - CORE/cake/libs/model/model.php, line 2031
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1095
FrontEndController::property_list() - APP/controllers/front_end_controller.php, line 135
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Query: SELECT `Property`.`id`, `Property`.`category_id`, `Property`.`sub_category_id`, `Property`.`type`, `Property`.`name`, `Property`.`description`, `Property`.`price`, `Property`.`selling_price`, `Property`.`asking_rent`, `Property`.`inclusive`, `Property`.`email`, `Property`.`phone`, `Property`.`address`, `Property`.`google_map_link`, `Property`.`building`, `Property`.`building_type`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`floor_space`, `Property`.`outside_area`, `Property`.`property_views`, `Property`.`building_age`, `Property`.`condition`, `Property`.`property_feature`, `Property`.`interior_feature`, `Property`.`exterior_feature`, `Property`.`featured_item`, `Property`.`main_image`, `Property`.`property_image_1`, `Property`.`property_image_2`, `Property`.`property_image_3`, `Property`.`property_image_4`, `Property`.`property_image_5`, `Property`.`status`, `Property`.`created`, `Property`.`modified`, `Category`.`id`, `Category`.`name`, `Category`.`level`, `Category`.`parent`, `Category`.`status`, `Category`.`display`, `Category`.`created`, `Category`.`modified`, `Sub_Category`.`id`, `Sub_Category`.`name`, `Sub_Category`.`level`, `Sub_Category`.`parent`, `Sub_Category`.`status`, `Sub_Category`.`display`, `Sub_Category`.`created`, `Sub_Category`.`modified` FROM `hs_property` AS `Property` LEFT JOIN `hs_category` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `hs_category` AS `Sub_Category` ON (`Property`.`sub_category_id` = `Sub_Category`.`id`) WHERE and `Property`.`status` = 0 ORDER BY `Property`.`name` asc LIMIT 12