Panama Sol Realty City and Beach Rentals
Internal error. SELECT SQL_CALC_FOUND_ROWS `tbl_property`.`title_english`, `tbl_property`.`id`, `size_sqft`, `size_m2`, `proId`, `bedroom`, `bathroom`, `tbl_property`.`description_english`, `tprice`, `id_property_status`, `tbl_property_status`.`id` AS 'status', `longitude`, `latitude`, `id_property_status`, `tbl_city`.`city`, `tbl_location`.`location`, `tbl_location`.`id` AS `location_id`, `tbl_property`.`id_city`, `tbl_property`.`id_city` AS `city_id`, `id_category`, #`tbl_rentout`.`start_date`, #`tbl_rentout`.`end_date`, `tbl_property`.`lipc_exclusive` AS lipc_exclusive, `tbl_property`.`lipc_exclusive` AS exclusive, `tbl_property`.`property_flag` AS `property_flag` FROM `tbl_property`, `tbl_location`, `tbl_city`, `tbl_property_status`#, `tbl_rentout` WHERE 1 AND `tbl_property_status`.`id` = `tbl_property`.`id_property_status` AND `tbl_property`.`id_location` = `tbl_location`.`id` AND `tbl_property`.`id_city` = `tbl_city`.`id` AND `tbl_property`.`status` = 1 AND `tbl_property`.`approved` = 1 # AND `tbl_property`.`id` IN (-1) AND `tbl_property`.`lipc_exclusive` = 0 AND `tbl_property`.`tprice` BETWEEN 0 AND 9223372036854775807 AND (`tbl_property`.`tprice_to` BETWEEN 0 AND 9223372036854775807 OR `tbl_property`.`tprice_to` = 0 ) AND NOT FIND_IN_SET('2', `tbl_property`.`id_property_status`) AND NOT FIND_IN_SET('12', `tbl_property`.`id_property_status`) AND ( `tbl_property`.`bedroom` >= 0 AND `tbl_property`.`bedroom` <= 8 ) AND ( (`tbl_property`.`bedroom_to` >= 0 AND (`tbl_property`.`bedroom_to` <= 8) OR `tbl_property`.`bedroom_to` = 0 ) ) AND `tbl_property`.`bathroom` >= 0 AND `tbl_property`.`bathroom` <= 8 AND (`tbl_property`.`bathroom_to` >= 0 AND ( `tbl_property`.`bathroom` <= 8 OR `tbl_property`.`bathroom_to` = 0) ) AND `tbl_property`.`size_m2` BETWEEN 0 AND 10000000000 AND (`tbl_property`.`size_m2_to` BETWEEN 0 AND 10000000000 OR `tbl_property`.`size_m2_to`= 0 ) AND tbl_property.visibility_status!="hidden" GROUP BY `tbl_property`.`id` ORDER BY `tbl_property`.`bedroom` DESC LIMIT 0, 10 Can't create/write to file '/tmp/#sql_2e1_0.MYD' (Errcode: 17)