Real Estate Panama City - 1,261 Millions Invested in Projects

Buy Properties Sell a Property Rent Properties

1,261 Millions Invested in Projects

By 2008-03-24 - PanamaRealtor.com | Published: March 24, 2008

According to the preliminary numbers of the Contraloría General, an increment of 25.4% was registered of the value of projects for residential constructions and redesigning and non residential in 2007.

Last year there were many different projects that were developed for 1,261 millions, 984 millions for residential constructions and 276 for non residential.

Four districts are completely enjoying the real estate boom: Panama grew 97.8%; Colón, 84.2%; Arraiján, 30.6%; y Santiago, 172.8%.

In December, the constructions reached a value of 116 millions, 80.1% higher than the same month in 2006 which reached 64.4 millions.

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.

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

429 queries took 71 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `news`

DESCRIBE `users`

DESCRIBE `profiles`

DESCRIBE `countries`

DESCRIBE `properties`

DESCRIBE `companies`

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`

SELECT `News`.`id`, `News`.`title`, `News`.`body`, `News`.`author`, `News`.`source`, `News`.`link`, `News`.`published`, `News`.`created`, `News`.`modified` FROM `news` AS `News` WHERE `News`.`id` = 5 LIMIT 1

DESCRIBE `agents`

DESCRIBE `settings`

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

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

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

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

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

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

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 (13)

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

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

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

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

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

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

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

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

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

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

SELECT `Photo`.`id`, `Photo`.`property_id`, `Photo`.`name`, `Photo`.`ext`, `Photo`.`created` FROM `photos` AS `Photo` WHERE `Photo`.`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 (8)

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 (10)

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

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 (13)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 (13)

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

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

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

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

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

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

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

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

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 (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 (1)

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 `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 (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 (10)

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 (11)

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 (13)

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 (14)

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 (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 (17)

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 (18)

100

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 (19)

101

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 (20)

102

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)

103

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)

104

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)

105

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)

106

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)

107

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)

108

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

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

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

130

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

131

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

132

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

133

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

134

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

135

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

136

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

137

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

138

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

139

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

140

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

141

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

142

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

143

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

144

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

145

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

146

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

147

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

148

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

149

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

150

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

151

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

152

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

153

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

154

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

155

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

156

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

157

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

158

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

159

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

160

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

161

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

162

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

163

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

164

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

165

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

166

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

167

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

168

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

169

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

170

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

171

SELECT `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

172

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

173

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

174

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

175

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

176

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

177

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

178

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

179

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

180

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

181

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

182

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

183

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

184

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

185

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

186

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

187

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

188

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

189

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

190

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

191

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

192

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

193

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

194

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

195

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

196

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

197

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

198

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

199

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

200

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