menu_home | menu_aboutus | menu_search | BROWSE IMAGES | DIRECTORY | menu_resources | menu_news | SITEMAP | RSS | menu_contactus |
©2008 RealEstatePTY.com
25 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `properties`55552
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` = 4 LIMIT 1001
22SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE 1 = 1 330
23SELECT `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`type_id` IN (3) 440
24SELECT `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`type_id` IN (4) 660
25SELECT `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`type_id` IN (5) 440