Real Estate Panama City

Buy Properties Sell a Property Rent Properties

Rent

sdsfd

Property Size:

Rental cost:

Rooms:

bedrooms, baths

Type:

Rent

ID:

ada...

View Property Info

vadf

Property Size:

Rental cost:

Rooms:

bedrooms, baths

Type:

Rent

ID:

adfa...

View Property Info

ffs

Property Size:

Rental cost:

Rooms:

bedrooms, baths

Type:

Rent

ID:

ddsasa...

View Property Info

sonu

Property Size:

0 m2

Rental cost:

Rooms:

0 bedrooms, 0 baths

Type:

Rent

ID:

...

View Property Info

Video Prop

Property Size:

0 m2

Rental cost:

Rooms:

0 bedrooms, 0 baths

Type:

Rent

ID:

...

View Property Info

dgdf

Property Size:

0 m2

Rental cost:

Rooms:

0 bedrooms, 0 baths

Type:

Rent

ID:

sdgfdsfd...

View Property Info

user's

Property Size:

Rental cost:

Rooms:

bedrooms, baths

Type:

Rent

ID:

adfsadfsafsf s f weef...

View Property Info

nkjk

Property Size:

Rental cost:

Rooms:

bedrooms, baths

Type:

Rent

ID:

...

View Property Info

ssdssssss

Property Size:

33 m2

Rental cost:

Rooms:

bedrooms, baths

Type:

Rent

ID:

...

View Property Info

Real Name

Property Size:

Rental cost:

Rooms:

bedrooms, baths

Type:

Rent

ID:

Cerro azul, Ciudad de Panama, Cerro azul, Ciudad de Panama......

View Property Info

abc

Property Size:

0 m2

Rental cost:

$1,000

Rooms:

0 bedrooms, 0 baths

Type:

Rent

ID:

adaadadafdasasasaaa d fafasasf a aa...

View Property Info

Lorem Ipsum

Property Size:

0 m2

Rental cost:

Rooms:

0 bedrooms, 0 baths

Type:

Buy

ID:

hiiiiiiiiiiiiiiiiiiiiiiii ...

View Property Info

Quicksearch!

Search Now!

Welcome!

Real Estate PTY is a Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, fugiat nulla pariatur. Excepteur sint occaecat.

550 queries took 47 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `properties`	55	55	3
2	DESCRIBE `companies`	19	19	1
3	DESCRIBE `countries`	2	2	1
4	DESCRIBE `users`	7	7	1
5	DESCRIBE `profiles`	19	19	1
6	DESCRIBE `categories`	4	4	1
7	DESCRIBE `types`	3	3	1
8	DESCRIBE `locations`	6	6	1
9	DESCRIBE `statuses`	3	3	1
10	DESCRIBE `propertytypes`	4	4	1
11	DESCRIBE `properties_users`	3	3	1
12	DESCRIBE `photos`	5	5	1
13	DESCRIBE `videos`	4	4	1
14	DESCRIBE `notes`	7	7	1
15	DESCRIBE `floorplants`	6	6	1
16	DESCRIBE `ratings`	3	3	1
17	DESCRIBE `comments`	5	5	1
18	DESCRIBE `amenities`	2	2	1
19	DESCRIBE `agents`	8	8	1
20	DESCRIBE `settings`	3	3	1
21	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`name` = 'rent'	1	1	0
22	SELECT `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`type_id` IN (3)	4	4	0
23	SELECT `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`.`published` = 1 AND `Property`.`type_id` = 3 ORDER BY `Property`.`id` DESC	12	12	2
24	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (26)	0	0	0
25	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (25)	0	0	0
26	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (24)	0	0	0
27	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (23)	0	0	0
28	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (22)	0	0	0
29	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (21)	0	0	0
30	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (16)	0	0	0
31	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (15)	0	0	0
32	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (12)	0	0	0
33	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (9)	0	0	0
34	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (8)	0	0	0
35	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (5)	0	0	0
36	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (26)	1	1	0
37	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (25)	1	1	0
38	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (24)	2	2	0
39	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (23)	1	1	0
40	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (22)	1	1	0
41	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (21)	5	5	0
42	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (16)	1	1	0
43	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (15)	1	1	0
44	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (12)	1	1	0
45	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (9)	1	1	0
46	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (8)	12	12	0
47	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (5)	1	1	0
48	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (26)	0	0	0
49	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (25)	0	0	0
50	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (24)	1	1	0
51	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (23)	3	3	0
52	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (22)	1	1	0
53	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (21)	1	1	0
54	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (16)	0	0	0
55	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (15)	0	0	0
56	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (12)	0	0	0
57	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (9)	0	0	0
58	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (8)	0	0	0
59	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (5)	0	0	0
60	SELECT `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 (26)	0	0	0
61	SELECT `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 (25)	0	0	0
62	SELECT `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 (24)	0	0	0
63	SELECT `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 (23)	0	0	0
64	SELECT `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 (22)	0	0	0
65	SELECT `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 (21)	0	0	0
66	SELECT `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 (16)	0	0	0
67	SELECT `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 (15)	0	0	0
68	SELECT `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 (12)	0	0	0
69	SELECT `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 (9)	0	0	0
70	SELECT `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 (8)	0	0	0
71	SELECT `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 (5)	0	0	0
72	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (26)	0	0	0
73	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (25)	0	0	0
74	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (24)	1	1	0
75	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (23)	0	0	0
76	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (22)	0	0	0
77	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (21)	0	0	0
78	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (16)	0	0	0
79	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (15)	0	0	0
80	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (12)	0	0	0
81	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (9)	0	0	0
82	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (8)	0	0	0
83	SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (5)	0	0	0
84	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (26)	0	0	0
85	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (25)	0	0	0
86	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (24)	0	0	0
87	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (23)	3	3	0
88	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (22)	2	2	0
89	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (21)	0	0	0
90	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (16)	2	2	0
91	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (15)	1	1	0
92	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (12)	1	1	0
93	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (9)	2	2	0
94	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (8)	1	1	0
95	SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (5)	0	0	0
96	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (26)	0	0	0
97	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (25)	0	0	0
98	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (24)	1	1	0
99	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (23)	1	1	0
100	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (22)	0	0	0
101	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (21)	0	0	0
102	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (16)	1	1	0
103	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (15)	0	0	0
104	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (12)	0	0	0
105	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (9)	0	0	0
106	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (8)	0	0	0
107	SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (5)	0	0	0
108	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 26 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	5	5	0
109	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 25 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	0	0	0
110	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 24 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	2	2	0
111	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 23 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	0	0	0
112	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 22 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	0	0	0
113	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 21 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	4	4	0
114	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 16 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	0	0	0
115	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 15 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	0	0	0
116	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 12 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	0	0	0
117	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 9 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	4	4	0
118	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 8 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	3	3	0
119	SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 5 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1	0	0	0
120	SELECT `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` = 26 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
121	SELECT `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` = 25 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
122	SELECT `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` = 24 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
123	SELECT `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` = 23 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
124	SELECT `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` = 22 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
125	SELECT `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` = 21 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
126	SELECT `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` = 16 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
127	SELECT `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` = 15 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
128	SELECT `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` = 12 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
129	SELECT `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` = 9 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
130	SELECT `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` = 8 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
131	SELECT `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` = 5 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1	0	0	0
132	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
133	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
134	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
135	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
136	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
137	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
138	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
139	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
140	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
141	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
142	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 3 LIMIT 1	1	1	0
143	SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`id` = 4 LIMIT 1	1	1	0
144	SELECT `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 1 = 1	21	21	2
145	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (1)	0	0	0
146	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (5)	0	0	0
147	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (8)	0	0	0
148	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (9)	0	0	0
149	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (10)	0	0	0
150	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (11)	0	0	0
151	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (12)	0	0	0
152	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (13)	0	0	0
153	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (14)	0	0	0
154	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (15)	0	0	0
155	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (16)	0	0	0
156	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (17)	0	0	0
157	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (18)	0	0	0
158	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (19)	0	0	0
159	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (20)	0	0	0
160	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (21)	0	0	0
161	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (22)	0	0	0
162	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (23)	0	0	0
163	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (24)	0	0	0
164	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (25)	0	0	0
165	SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (26)	0	0	0
166	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (1)	5	5	0
167	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (5)	1	1	0
168	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (8)	12	12	0
169	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (9)	1	1	0
170	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (10)	0	0	0
171	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (11)	0	0	0
172	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (12)	1	1	0
173	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (13)	1	1	0
174	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (14)	1	1	0
175	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (15)	1	1	0
176	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (16)	1	1	0
177	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (17)	1	1	0
178	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (18)	4	4	0
179	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (19)	0	0	0
180	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (20)	1	1	0
181	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (21)	5	5	0
182	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (22)	1	1	0
183	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (23)	1	1	0
184	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (24)	2	2	0
185	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (25)	1	1	0
186	SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (26)	1	1	0
187	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (1)	0	0	0
188	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (5)	0	0	0
189	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (8)	0	0	0
190	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (9)	0	0	0
191	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (10)	0	0	0
192	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (11)	0	0	0
193	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (12)	0	0	0
194	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (13)	0	0	0
195	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (14)	0	0	0
196	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (15)	0	0	0
197	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (16)	0	0	0
198	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (17)	0	0	0
199	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (18)	0	0	0
200	SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (19)	0	0	0

550 queries took 47 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `properties`

DESCRIBE `companies`

DESCRIBE `countries`

DESCRIBE `users`

DESCRIBE `profiles`

DESCRIBE `categories`

DESCRIBE `types`

DESCRIBE `locations`

DESCRIBE `statuses`

DESCRIBE `propertytypes`

DESCRIBE `properties_users`

DESCRIBE `photos`

DESCRIBE `videos`

DESCRIBE `notes`

DESCRIBE `floorplants`

DESCRIBE `ratings`

DESCRIBE `comments`

DESCRIBE `amenities`

DESCRIBE `agents`

DESCRIBE `settings`

SELECT `Type`.`id`, `Type`.`name`, `Type`.`description` FROM `types` AS `Type` WHERE `Type`.`name` = 'rent'

SELECT `Category`.`id`, `Category`.`type_id`, `Category`.`name`, `Category`.`description` FROM `categories` AS `Category` WHERE `Category`.`type_id` IN (3)

SELECT `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`.`published` = 1 AND `Property`.`type_id` = 3 ORDER BY `Property`.`id` DESC

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (26)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (25)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (24)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (23)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (22)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (21)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (16)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (15)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (12)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (9)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (8)

SELECT `PropertyUser`.`id`, `PropertyUser`.`property_id`, `PropertyUser`.`user_id` FROM `properties_users` AS `PropertyUser` WHERE `PropertyUser`.`property_id` IN (5)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (26)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (25)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (24)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (23)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (22)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (21)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (16)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (15)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (12)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (9)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (8)

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`property_id` IN (5)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (26)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (25)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (24)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (23)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (22)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (21)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (16)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (15)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (12)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (9)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (8)

SELECT `Video`.`id`, `Video`.`property_id`, `Video`.`video_url`, `Video`.`created` FROM `videos` AS `Video` WHERE `Video`.`property_id` IN (5)

SELECT `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 (26)

SELECT `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 (25)

SELECT `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 (24)

SELECT `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 (23)

SELECT `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 (22)

SELECT `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 (21)

SELECT `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 (16)

SELECT `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 (15)

SELECT `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 (12)

SELECT `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 (9)

SELECT `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 (8)

SELECT `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 (5)

SELECT `Floorplant`.`id`, `Floorplant`.`property_id`, `Floorplant`.`name`, `Floorplant`.`ext`, `Floorplant`.`description`, `Floorplant`.`created` FROM `floorplants` AS `Floorplant` WHERE `Floorplant`.`property_id` IN (26)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (26)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (25)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (24)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (23)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (22)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (21)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (16)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (15)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (12)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (9)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (8)

SELECT `Rating`.`id`, `Rating`.`property_id`, `Rating`.`rating` FROM `ratings` AS `Rating` WHERE `Rating`.`property_id` IN (5)

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (26)

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (25)

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (24)

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (23)

100

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (22)

101

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (21)

102

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (16)

103

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (15)

104

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (12)

105

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (9)

106

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (8)

107

SELECT `Comment`.`id`, `Comment`.`property_id`, `Comment`.`comment`, `Comment`.`name`, `Comment`.`created` FROM `comments` AS `Comment` WHERE `Comment`.`property_id` IN (5)

108

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 26 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

109

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 25 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

110

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 24 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

111

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 23 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

112

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 22 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

113

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 21 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

114

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 16 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

115

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 15 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

116

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 12 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

117

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 9 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

118

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 8 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

119

SELECT `Amenity`.`id`, `Amenity`.`name` FROM `amenities` AS `Amenity` JOIN `amenities_properties` ON (`amenities_properties`.`property_id` = 5 AND `amenities_properties`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1

120

SELECT `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` = 26 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

121

SELECT `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` = 25 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

122

SELECT `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` = 24 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

123

SELECT `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` = 23 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

124

SELECT `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` = 22 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

125

SELECT `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` = 21 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

126

SELECT `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` = 16 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

127

SELECT `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` = 15 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

128

SELECT `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` = 12 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

129

SELECT `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` = 9 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

130

SELECT `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` = 8 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

131

SELECT `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` = 5 AND `properties_users`.`user_id` = `Favorite`.`id`) WHERE 1 = 1

132