Cozy Home Surrounded by Nature
menu_home | menu_aboutus | menu_search | BROWSE IMAGES | DIRECTORY | menu_resources | menu_news | SITEMAP | RSS | menu_contactus |
©2008 RealEstatePTY.com
34 queries took 23 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `properties`55553
2DESCRIBE `companies`19191
3DESCRIBE `countries`221
4DESCRIBE `users`771
5DESCRIBE `profiles`19191
6DESCRIBE `categories`441
7DESCRIBE `types`331
8DESCRIBE `locations`661
9DESCRIBE `statuses`331
10DESCRIBE `propertytypes`441
11DESCRIBE `properties_users`331
12DESCRIBE `photos`551
13DESCRIBE `videos`441
14DESCRIBE `notes`771
15DESCRIBE `floorplants`661
16DESCRIBE `ratings`331
17DESCRIBE `comments`551
18DESCRIBE `amenities`221
19DESCRIBE `agents`881
20DESCRIBE `settings`331
21SELECT `Property`.`id`, `Property`.`company_id`, `Property`.`user_id`, `Property`.`type_id`, `Property`.`category_id`, `Property`.`location_id`, `Property`.`status_id`, `Property`.`name`, `Property`.`description`, `Property`.`preconstruction_date`, `Property`.`construction_start`, `Property`.`construction_finish`, `Property`.`year_built`, `Property`.`price_from`, `Property`.`price_to`, `Property`.`maintenance_fee`, `Property`.`price_m2`, `Property`.`rental_cost`, `Property`.`size_from`, `Property`.`size_to`, `Property`.`metric`, `Property`.`floor`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`more_info`, `Property`.`published`, `Property`.`featured`, `Property`.`exclusive`, `Property`.`featured_photo_id`, `Property`.`video`, `Property`.`viewed`, `Property`.`created`, `Property`.`modified`, `Property`.`propertytype_id`, `Property`.`friendlyname`, `Property`.`sfname`, `Property`.`slname`, `Property`.`semail`, `Property`.`saddress`, `Property`.`scity`, `Property`.`sstate`, `Property`.`scountry`, `Property`.`szip`, `Property`.`stelephone`, `Property`.`smobile`, `Property`.`scontactinpanama`, `Property`.`saddressinpanama`, `Property`.`scomments`, `Property`.`sellproperty`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`maplevel`, `Property`.`nombre`, `Property`.`descripcion`, `Property`.`mas_informacion`, `Company`.`id`, `Company`.`name`, `Company`.`address`, `Company`.`city`, `Company`.`state`, `Company`.`country_id`, `Company`.`zip_code`, `Company`.`telephone`, `Company`.`fax`, `Company`.`instant_message`, `Company`.`url`, `Company`.`email`, `Company`.`password`, `Company`.`logo`, `Company`.`map_api`, `Company`.`contact_name`, `Company`.`contact_phone`, `Company`.`contact_billing_address`, `Company`.`type`, `User`.`id`, `User`.`name`, `User`.`password`, `User`.`email`, `User`.`last_login`, `User`.`userlevel`, `User`.`type`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`name`, `Profile`.`address`, `Profile`.`city`, `Profile`.`state`, `Profile`.`country_id`, `Profile`.`zip_code`, `Profile`.`telephone`, `Profile`.`fax`, `Profile`.`instant_message`, `Profile`.`url`, `Profile`.`email`, `Profile`.`logo`, `Profile`.`map_api`, `Profile`.`contact_name`, `Profile`.`contact_phone`, `Profile`.`contact_billing_address`, `Profile`.`listings_allowed`, `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description`, `Location`.`id`, `Location`.`name`, `Location`.`description`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`maplevel`, `Status`.`id`, `Status`.`name`, `Status`.`description`, `Propertytype`.`id`, `Propertytype`.`name`, `Propertytype`.`created`, `Propertytype`.`modified` FROM `properties` AS `Property` LEFT JOIN `companies` AS `Company` ON (`Property`.`company_id` = `Company`.`id`) LEFT JOIN `users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `profiles` AS `Profile` ON (`Property`.`user_id` = `Profile`.`id`) LEFT JOIN `categories` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `locations` AS `Location` ON (`Property`.`location_id` = `Location`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Property`.`status_id` = `Status`.`id`) LEFT JOIN `propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) WHERE `Property`.`id` = 1 LIMIT 1111
22SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (1) 000
23SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (1) 550
24SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (1) 000
25SELECT `Note`.`id`, `Note`.`property_id`, `Note`.`note`, `Note`.`viewed`, `Note`.`created`, `Note`.`modified`, `Note`.`agent_id` FROM `notes` AS `Note` WHERE `Note`.`property_id` IN (1) 110
26SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (1) 000
27SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (1) 110
28SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (1) 220
29SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 1 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 000
30SELECT `Favorite`.`id`, `Favorite`.`name`, `Favorite`.`password`, `Favorite`.`email`, `Favorite`.`last_login`, `Favorite`.`userlevel`, `Favorite`.`type` FROM `users` AS `Favorite` JOIN `properties_users` ON (`properties_users`.`property_id` = 1 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1 000
31SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE 1 = 1 330
32SELECT `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`type_id` IN (3) 440
33SELECT `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`type_id` IN (4) 660
34SELECT `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`type_id` IN (5) 440