Feedback

Search Properties

Sponsored Properties

Sponsored properties are viewed by most of the property seekers. You can tag your property citywide, regionwide or countrywide and attract the audience. Your property would be displayed above the featured listing.

Store your search

Just fill the search form only once. Select the set of search criteria and give it a name. Use "Save & Search" button to store permanently this set of search criteria so when you come next time, you get the pre defined list of searches. Have a freedom from filling search forms every time for the same criteria.

Retail Properties for Sale

For Sale (15) |  For Lease (0) 

MUST GO- Brand new shop 24x26
Retail
Parkhill, Ontario, Canada

 13,502 Sq. Ft.

4 br Northern Heights home- price lowered for immediate sale
Retail
Rochester, Minnesota, United States
(default) 96 queries took 61 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'admin_contact_no' LIMIT 1111
2SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'ContactEmail' LIMIT 1110
3SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'SiteDomain' LIMIT 1110
4SELECT `Property`.`id`, `Property`.`propertytype_id`, `Property`.`othertype`, `Property`.`propertyowner_id`, `Property`.`package_id`, `Property`.`order_id`, `Property`.`looking_for`, `Property`.`name`, `Property`.`url`, `Property`.`email`, `Property`.`address1`, `Property`.`address2`, `Property`.`country_id`, `Property`.`region_id`, `Property`.`city_id`, `Property`.`zipcode`, `Property`.`lon`, `Property`.`lat`, `Property`.`phone`, `Property`.`fax`, `Property`.`min_price`, `Property`.`max_price`, `Property`.`min_deposit`, `Property`.`max_deposit`, `Property`.`isnegotiable`, `Property`.`icon`, `Property`.`description`, `Property`.`currency`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`garage`, `Property`.`livesquare`, `Property`.`landsquare`, `Property`.`totalsquare`, `Property`.`area_unit`, `Property`.`floorno`, `Property`.`floortotal`, `Property`.`subway_min`, `Property`.`construction_year`, `Property`.`is_furnished`, `Property`.`is_new`, `Property`.`keywords_generated`, `Property`.`status`, `Property`.`is_disclaimer`, `Property`.`is_sold`, `Property`.`created`, `Property`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `Region`.`description`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country`, `City`.`description`, `Propertytype`.`id`, `Propertytype`.`parent_id`, `Propertytype`.`name`, `Propertytype`.`status`, `Propertytype`.`operation`, `Propertytype`.`created`, `Propertytype`.`modified`, `Propertyowner`.`id`, `Propertyowner`.`firstname`, `Propertyowner`.`lastname`, `Propertyowner`.`email`, `Propertyowner`.`password`, `Propertyowner`.`companyname`, `Propertyowner`.`confirm`, `Propertyowner`.`status`, `Propertyowner`.`address1`, `Propertyowner`.`address2`, `Propertyowner`.`country_id`, `Propertyowner`.`region_id`, `Propertyowner`.`city_id`, `Propertyowner`.`zipcode`, `Propertyowner`.`phone`, `Propertyowner`.`fax`, `Propertyowner`.`skype`, `Propertyowner`.`logo`, `Propertyowner`.`aboutme`, `Propertyowner`.`type`, `Propertyowner`.`notification`, `Propertyowner`.`iagreed`, `Propertyowner`.`lastlogin`, `Propertyowner`.`lastlogin2`, `Propertyowner`.`ipaddress`, `Propertyowner`.`created`, `Propertyowner`.`modified`, `Package`.`id`, `Package`.`name`, `Package`.`shortdescription`, `Package`.`property`, `Package`.`photo`, `Package`.`video`, `Package`.`free_lead`, `Package`.`display_contact`, `Package`.`trial_term`, `Package`.`validity`, `Package`.`term_unit`, `Package`.`amount`, `Package`.`status`, `Package`.`is_free`, `Package`.`created`, `Package`.`modified` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertyowners` AS `Propertyowner` ON (`Property`.`propertyowner_id` = `Propertyowner`.`id`) LEFT JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Property`.`package_id` = `Package`.`id`) WHERE `Property`.`id` in ('')001
5SELECT `Property`.`id`, `Property`.`propertytype_id`, `Property`.`othertype`, `Property`.`propertyowner_id`, `Property`.`package_id`, `Property`.`order_id`, `Property`.`looking_for`, `Property`.`name`, `Property`.`url`, `Property`.`email`, `Property`.`address1`, `Property`.`address2`, `Property`.`country_id`, `Property`.`region_id`, `Property`.`city_id`, `Property`.`zipcode`, `Property`.`lon`, `Property`.`lat`, `Property`.`phone`, `Property`.`fax`, `Property`.`min_price`, `Property`.`max_price`, `Property`.`min_deposit`, `Property`.`max_deposit`, `Property`.`isnegotiable`, `Property`.`icon`, `Property`.`description`, `Property`.`currency`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`garage`, `Property`.`livesquare`, `Property`.`landsquare`, `Property`.`totalsquare`, `Property`.`area_unit`, `Property`.`floorno`, `Property`.`floortotal`, `Property`.`subway_min`, `Property`.`construction_year`, `Property`.`is_furnished`, `Property`.`is_new`, `Property`.`keywords_generated`, `Property`.`status`, `Property`.`is_disclaimer`, `Property`.`is_sold`, `Property`.`created`, `Property`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `Region`.`description`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country`, `City`.`description`, `Propertytype`.`id`, `Propertytype`.`parent_id`, `Propertytype`.`name`, `Propertytype`.`status`, `Propertytype`.`operation`, `Propertytype`.`created`, `Propertytype`.`modified`, `Propertyowner`.`id`, `Propertyowner`.`firstname`, `Propertyowner`.`lastname`, `Propertyowner`.`email`, `Propertyowner`.`password`, `Propertyowner`.`companyname`, `Propertyowner`.`confirm`, `Propertyowner`.`status`, `Propertyowner`.`address1`, `Propertyowner`.`address2`, `Propertyowner`.`country_id`, `Propertyowner`.`region_id`, `Propertyowner`.`city_id`, `Propertyowner`.`zipcode`, `Propertyowner`.`phone`, `Propertyowner`.`fax`, `Propertyowner`.`skype`, `Propertyowner`.`logo`, `Propertyowner`.`aboutme`, `Propertyowner`.`type`, `Propertyowner`.`notification`, `Propertyowner`.`iagreed`, `Propertyowner`.`lastlogin`, `Propertyowner`.`lastlogin2`, `Propertyowner`.`ipaddress`, `Propertyowner`.`created`, `Propertyowner`.`modified`, `Package`.`id`, `Package`.`name`, `Package`.`shortdescription`, `Package`.`property`, `Package`.`photo`, `Package`.`video`, `Package`.`free_lead`, `Package`.`display_contact`, `Package`.`trial_term`, `Package`.`validity`, `Package`.`term_unit`, `Package`.`amount`, `Package`.`status`, `Package`.`is_free`, `Package`.`created`, `Package`.`modified` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertyowners` AS `Propertyowner` ON (`Property`.`propertyowner_id` = `Propertyowner`.`id`) LEFT JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Property`.`package_id` = `Package`.`id`) WHERE `Property`.`id` in ('')001
6SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0'221
7SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC14141
8SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa8c1-7dc8-4258-b249-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC10100
9SELECT `Region`.`id`, `Region`.`name`, `Region`.`country_id`, `Country`.`id`, `Country`.`name` FROM `prod_propertyclustercom`.`regions` AS `Region` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Region`.`country_id` = `Country`.`id`) WHERE `Region`.`country_id` = '226' GROUP BY `Region`.`id`62621
10SELECT `Property`.`id`, `Property`.`status`, `Property`.`looking_for`, `Property`.`region_id` FROM `prod_propertyclustercom`.`properties` AS `Property` WHERE `Property`.`status` = 1 AND `Property`.`region_id` IN (4085, 4086, 4087, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4095, 4096, 4097, 4098, 4099, 4100, 4101, 4102, 4103, 4104, 4105, 4106, 4107, 4108, 4109, 4110, 4111, 4112, 4113, 4114, 4115, 4116, 4117, 4118, 4119, 4120, 4121, 4122, 4123, 4124, 4125, 4126, 4127, 4128, 4129, 4130, 4131, 4132, 4133, 4134, 4135, 4136, 4137, 4138, 4139, 4140, 4141, 4142, 4143, 4144, 4145, 4146)87871
11SELECT `Faqcategory`.`id`, `Faqcategory`.`name`, `Faqcategory`.`status`, `Faqcategory`.`created`, `Faqcategory`.`modified` FROM `prod_propertyclustercom`.`faqcategories` AS `Faqcategory` WHERE `status` = 1 LIMIT 1110
12SELECT `Propertytype`.`id`, `Propertytype`.`parent_id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`name` = 'retail' AND `Propertytype`.`status` = 1 LIMIT 1111
13SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0'220
14SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC14141
15SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa8c1-7dc8-4258-b249-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC10101
16SELECT `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Zone`.`id`, `Zone`.`name`, `Zone`.`created`, `Zone`.`modified` FROM `prod_propertyclustercom`.`countries` AS `Country` LEFT JOIN `prod_propertyclustercom`.`zones` AS `Zone` ON (`Country`.`zone_id` = `Zone`.`id`) WHERE 1 = 1 ORDER BY `Country`.`name` ASC2252251
17SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0'221
18SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC14140
19SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa8c1-7dc8-4258-b249-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC10100
20SELECT `Region`.`name`, `Country`.`name`, `Property`.`id` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) WHERE `Property`.`country_id` = 226 AND `Property`.`propertytype_id` = '5350aee9-d304-4911-bb7a-07ec6281e16b' AND `Property`.`looking_for` = 'To Sale' AND `Property`.`status` = 1 GROUP BY `Region`.`id` ORDER BY rand() ASC LIMIT 10991
21SELECT `Propertyalert`.`id`, `Propertyalert`.`property_id`, `Propertyalert`.`name`, `Propertyalert`.`phone`, `Propertyalert`.`email`, `Propertyalert`.`description`, `Propertyalert`.`ipaddress`, `Propertyalert`.`created`, `Propertyalert`.`modified` FROM `prod_propertyclustercom`.`propertyalerts` AS `Propertyalert` WHERE `Propertyalert`.`property_id` IN ('5416b50c-bd1c-4f87-a042-047cc0a8010d', '5422b47d-b728-4a80-b69c-047cc0a8010d', '541af8e0-2120-4783-9358-047cc0a8010d', '5422bb96-e0b8-418b-9d26-047cc0a8010d', '54202f4a-2dd0-4d31-8ce4-047cc0a8010d', '541c0856-dae4-4eac-a9bb-047cc0a8010d', '54202cdc-e6fc-45bc-a07c-047cc0a8010d', '5447b62f-8254-4a24-b840-155cc0a8010d', '541d8e6f-1e4c-4e86-a384-047cc0a8010d')001
22SELECT `Propertyspamreport`.`id`, `Propertyspamreport`.`property_id`, `Propertyspamreport`.`name`, `Propertyspamreport`.`phone`, `Propertyspamreport`.`email`, `Propertyspamreport`.`description`, `Propertyspamreport`.`ipaddress`, `Propertyspamreport`.`created`, `Propertyspamreport`.`modified` FROM `prod_propertyclustercom`.`propertyspamreports` AS `Propertyspamreport` WHERE `Propertyspamreport`.`property_id` IN ('5416b50c-bd1c-4f87-a042-047cc0a8010d', '5422b47d-b728-4a80-b69c-047cc0a8010d', '541af8e0-2120-4783-9358-047cc0a8010d', '5422bb96-e0b8-418b-9d26-047cc0a8010d', '54202f4a-2dd0-4d31-8ce4-047cc0a8010d', '541c0856-dae4-4eac-a9bb-047cc0a8010d', '54202cdc-e6fc-45bc-a07c-047cc0a8010d', '5447b62f-8254-4a24-b840-155cc0a8010d', '541d8e6f-1e4c-4e86-a384-047cc0a8010d')000
23SELECT `Vasorder`.`id`, `Vasorder`.`order_number`, `Vasorder`.`propertyowner_id`, `Vasorder`.`valueaddedservice_id`, `Vasorder`.`discount`, `Vasorder`.`coupon_discount`, `Vasorder`.`coupon_code`, `Vasorder`.`taxe`, `Vasorder`.`subtotal`, `Vasorder`.`grandtotal`, `Vasorder`.`first_name`, `Vasorder`.`last_name`, `Vasorder`.`card_holder_name`, `Vasorder`.`street_address`, `Vasorder`.`email`, `Vasorder`.`street_address2`, `Vasorder`.`city`, `Vasorder`.`state`, `Vasorder`.`country`, `Vasorder`.`ip_country`, `Vasorder`.`zip`, `Vasorder`.`phone`, `Vasorder`.`status`, `Vasorder`.`response`, `Vasorder`.`expiry_date`, `Vasorder`.`created`, `Vasorder`.`modified` FROM `prod_propertyclustercom`.`vasorders` AS `Vasorder` WHERE UNIX_TIMESTAMP(`Vasorder`.`expiry_date`)>'1618263260' ORDER BY `Vasorder`.`modified` desc001
24SELECT `Property`.*, `Country`.`name`, `Region`.`name`, `City`.`name`, `Propertytype`.*, `Package`.`amount`, `Package`.`name`, `Property`.`id` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) left JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Package`.`id` = `Property`.`package_id`) left JOIN (SELECT Vasorderdetail.property_id AS vpid, Vasorder.id AS vid FROM `vasorders` AS `Vasorder` LEFT JOIN `vasorderdetails` AS `Vasorderdetail` ON (`Vasorder`.`id` = `Vasorderdetail`.`vasorder_id`) WHERE UNIX_TIMESTAMP(`Vasorder`.`expiry_date`)>'1618263260' GROUP BY `Vasorderdetail`.`property_id`) AS `Vas` ON (`Vas`.`vpid` = `Property`.`id`) WHERE `Property`.`propertytype_id` in ('5350af55-20d8-4554-ae43-07ec6281e16b', '5350af0a-7030-444a-83fa-07ec6281e16b', '5350af81-a3a0-4984-92af-07ec6281e16b', '5350af2c-d248-446c-af3b-07ec6281e16b', '5350af17-d000-4aa0-bd85-07ec6281e16b', '5350af46-24ac-4d3c-b9b8-07ec6281e16b', '5350abe4-5550-42cb-a392-07ec6281e16b', '5350aef8-a244-42e2-871e-07ec6281e16b', '5350b01a-a96c-49c3-b337-07ec6281e16b', '5350aee9-d304-4911-bb7a-07ec6281e16b', '5350afe1-6b5c-4a34-bf61-07ec6281e16b', '5350afd5-b274-4363-b53c-07ec6281e16b', '5350afa2-6fac-464f-914d-07ec6281e16b', '5350af39-0398-4732-8f5a-07ec6281e16b', 'commercialother') AND `Property`.`status` = 1 AND `Property`.`looking_for` = 'To Sale' AND `Property`.`propertytype_id` = '5350aee9-d304-4911-bb7a-07ec6281e16b' GROUP BY `Property`.`id` ORDER BY `Package`.`amount` Desc, `Property`.`min_price` Desc LIMIT 1212122
25SELECT `Propertyimage`.`id`, `Propertyimage`.`property_id`, `Propertyimage`.`name`, `Propertyimage`.`namemedium`, `Propertyimage`.`is_default`, `Propertyimage`.`created`, `Propertyimage`.`modified` FROM `prod_propertyclustercom`.`propertyimages` AS `Propertyimage` WHERE `Propertyimage`.`property_id` IN ('5447b62f-8254-4a24-b840-155cc0a8010d', '5420301b-7108-492f-bc32-047cc0a8010d', '541af50c-7c88-4a24-8703-047cc0a8010d', '541c0856-dae4-4eac-a9bb-047cc0a8010d', '5422bb96-e0b8-418b-9d26-047cc0a8010d', '541ae9e5-2a58-42a4-bd6f-047cc0a8010d', '541af64a-0494-4584-a535-047cc0a8010d', '54202f4a-2dd0-4d31-8ce4-047cc0a8010d', '5422b47d-b728-4a80-b69c-047cc0a8010d', '5416b50c-bd1c-4f87-a042-047cc0a8010d', '56996488-c4ec-491c-ba57-0d680a14812a', '54202dd2-eb7c-4f65-8ec5-047cc0a8010d')40401
26SELECT `Review`.`id`, `Review`.`property_id`, `Review`.`user_id`, `Review`.`propertyowner_id`, `Review`.`star`, `Review`.`description`, `Review`.`created`, `Review`.`modified` FROM `prod_propertyclustercom`.`reviews` AS `Review` WHERE `Review`.`property_id` IN ('5447b62f-8254-4a24-b840-155cc0a8010d', '5420301b-7108-492f-bc32-047cc0a8010d', '541af50c-7c88-4a24-8703-047cc0a8010d', '541c0856-dae4-4eac-a9bb-047cc0a8010d', '5422bb96-e0b8-418b-9d26-047cc0a8010d', '541ae9e5-2a58-42a4-bd6f-047cc0a8010d', '541af64a-0494-4584-a535-047cc0a8010d', '54202f4a-2dd0-4d31-8ce4-047cc0a8010d', '5422b47d-b728-4a80-b69c-047cc0a8010d', '5416b50c-bd1c-4f87-a042-047cc0a8010d', '56996488-c4ec-491c-ba57-0d680a14812a', '54202dd2-eb7c-4f65-8ec5-047cc0a8010d')000
27SELECT `Propertyvideo`.`id`, `Propertyvideo`.`property_id`, `Propertyvideo`.`name`, `Propertyvideo`.`status`, `Propertyvideo`.`created`, `Propertyvideo`.`modified` FROM `prod_propertyclustercom`.`propertyvideos` AS `Propertyvideo` WHERE `Propertyvideo`.`property_id` IN ('5447b62f-8254-4a24-b840-155cc0a8010d', '5420301b-7108-492f-bc32-047cc0a8010d', '541af50c-7c88-4a24-8703-047cc0a8010d', '541c0856-dae4-4eac-a9bb-047cc0a8010d', '5422bb96-e0b8-418b-9d26-047cc0a8010d', '541ae9e5-2a58-42a4-bd6f-047cc0a8010d', '541af64a-0494-4584-a535-047cc0a8010d', '54202f4a-2dd0-4d31-8ce4-047cc0a8010d', '5422b47d-b728-4a80-b69c-047cc0a8010d', '5416b50c-bd1c-4f87-a042-047cc0a8010d', '56996488-c4ec-491c-ba57-0d680a14812a', '54202dd2-eb7c-4f65-8ec5-047cc0a8010d')111
28SELECT `Leadweightage`.`id`, `Leadweightage`.`property_id`, `Leadweightage`.`requirement_id`, `Leadweightage`.`user_id`, `Leadweightage`.`weightage`, `Leadweightage`.`status`, `Leadweightage`.`created`, `Leadweightage`.`modified` FROM `prod_propertyclustercom`.`leadweightages` AS `Leadweightage` WHERE `Leadweightage`.`property_id` IN ('5447b62f-8254-4a24-b840-155cc0a8010d', '5420301b-7108-492f-bc32-047cc0a8010d', '541af50c-7c88-4a24-8703-047cc0a8010d', '541c0856-dae4-4eac-a9bb-047cc0a8010d', '5422bb96-e0b8-418b-9d26-047cc0a8010d', '541ae9e5-2a58-42a4-bd6f-047cc0a8010d', '541af64a-0494-4584-a535-047cc0a8010d', '54202f4a-2dd0-4d31-8ce4-047cc0a8010d', '5422b47d-b728-4a80-b69c-047cc0a8010d', '5416b50c-bd1c-4f87-a042-047cc0a8010d', '56996488-c4ec-491c-ba57-0d680a14812a', '54202dd2-eb7c-4f65-8ec5-047cc0a8010d')000
29SELECT `Propertyalert`.`id`, `Propertyalert`.`property_id`, `Propertyalert`.`name`, `Propertyalert`.`phone`, `Propertyalert`.`email`, `Propertyalert`.`description`, `Propertyalert`.`ipaddress`, `Propertyalert`.`created`, `Propertyalert`.`modified` FROM `prod_propertyclustercom`.`propertyalerts` AS `Propertyalert` WHERE `Propertyalert`.`property_id` IN ('5447b62f-8254-4a24-b840-155cc0a8010d', '5420301b-7108-492f-bc32-047cc0a8010d', '541af50c-7c88-4a24-8703-047cc0a8010d', '541c0856-dae4-4eac-a9bb-047cc0a8010d', '5422bb96-e0b8-418b-9d26-047cc0a8010d', '541ae9e5-2a58-42a4-bd6f-047cc0a8010d', '541af64a-0494-4584-a535-047cc0a8010d', '54202f4a-2dd0-4d31-8ce4-047cc0a8010d', '5422b47d-b728-4a80-b69c-047cc0a8010d', '5416b50c-bd1c-4f87-a042-047cc0a8010d', '56996488-c4ec-491c-ba57-0d680a14812a', '54202dd2-eb7c-4f65-8ec5-047cc0a8010d')110
30SELECT `Propertyspamreport`.`id`, `Propertyspamreport`.`property_id`, `Propertyspamreport`.`name`, `Propertyspamreport`.`phone`, `Propertyspamreport`.`email`, `Propertyspamreport`.`description`, `Propertyspamreport`.`ipaddress`, `Propertyspamreport`.`created`, `Propertyspamreport`.`modified` FROM `prod_propertyclustercom`.`propertyspamreports` AS `Propertyspamreport` WHERE `Propertyspamreport`.`property_id` IN ('5447b62f-8254-4a24-b840-155cc0a8010d', '5420301b-7108-492f-bc32-047cc0a8010d', '541af50c-7c88-4a24-8703-047cc0a8010d', '541c0856-dae4-4eac-a9bb-047cc0a8010d', '5422bb96-e0b8-418b-9d26-047cc0a8010d', '541ae9e5-2a58-42a4-bd6f-047cc0a8010d', '541af64a-0494-4584-a535-047cc0a8010d', '54202f4a-2dd0-4d31-8ce4-047cc0a8010d', '5422b47d-b728-4a80-b69c-047cc0a8010d', '5416b50c-bd1c-4f87-a042-047cc0a8010d', '56996488-c4ec-491c-ba57-0d680a14812a', '54202dd2-eb7c-4f65-8ec5-047cc0a8010d')110
31SELECT COUNT(*) AS `count` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) left JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Package`.`id` = `Property`.`package_id`) left JOIN (SELECT Vasorderdetail.property_id AS vpid, Vasorder.id AS vid FROM `vasorders` AS `Vasorder` LEFT JOIN `vasorderdetails` AS `Vasorderdetail` ON (`Vasorder`.`id` = `Vasorderdetail`.`vasorder_id`) WHERE UNIX_TIMESTAMP(`Vasorder`.`expiry_date`)>'1618263260' GROUP BY `Vasorderdetail`.`property_id`) AS `Vas` ON (`Vas`.`vpid` = `Property`.`id`) WHERE `Property`.`propertytype_id` in ('5350af55-20d8-4554-ae43-07ec6281e16b', '5350af0a-7030-444a-83fa-07ec6281e16b', '5350af81-a3a0-4984-92af-07ec6281e16b', '5350af2c-d248-446c-af3b-07ec6281e16b', '5350af17-d000-4aa0-bd85-07ec6281e16b', '5350af46-24ac-4d3c-b9b8-07ec6281e16b', '5350abe4-5550-42cb-a392-07ec6281e16b', '5350aef8-a244-42e2-871e-07ec6281e16b', '5350b01a-a96c-49c3-b337-07ec6281e16b', '5350aee9-d304-4911-bb7a-07ec6281e16b', '5350afe1-6b5c-4a34-bf61-07ec6281e16b', '5350afd5-b274-4363-b53c-07ec6281e16b', '5350afa2-6fac-464f-914d-07ec6281e16b', '5350af39-0398-4732-8f5a-07ec6281e16b', 'commercialother') AND `Property`.`status` = 1 AND `Property`.`looking_for` = 'To Sale' AND `Property`.`propertytype_id` = '5350aee9-d304-4911-bb7a-07ec6281e16b' GROUP BY `Property`.`id`15151
32SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
33SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
34SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
35SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
36SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
37SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
38SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
39SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
40SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
41SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
42SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
43SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
44SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
45SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
46SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
47SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
48SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
49SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
50SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
51SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
52SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
53SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
54SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
55SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
56SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
57SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
58SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
59SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
60SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
61SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
62SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
63SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
64SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
65SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
66SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
67SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
68SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
69SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
70SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
71SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
72SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1111
73SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
74SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
75SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
76SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
77SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
78SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
79SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
80SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
81SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
82SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
83SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
84SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
85SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
86SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
87SELECT `Propertytype`.`name`, `Propertytype`.`id` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`id` = '534fa65f-8328-48f0-9334-07ec6281e16b' LIMIT 1110
88SELECT `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` WHERE `PropertytypesRequirement`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')001
89SELECT `PropertytypesSearchpreferences`.`id`, `PropertytypesSearchpreferences`.`propertytype_id`, `PropertytypesSearchpreferences`.`searchpreference_id` FROM `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreferences` WHERE `PropertytypesSearchpreferences`.`propertytype_id` = ('534fa65f-8328-48f0-9334-07ec6281e16b')000
90SELECT `Requirement`.`id`, `Requirement`.`user_id`, `Requirement`.`title`, `Requirement`.`country_id`, `Requirement`.`region_id`, `Requirement`.`city_id`, `Requirement`.`minprice`, `Requirement`.`maxprice`, `Requirement`.`description`, `Requirement`.`bedrooms`, `Requirement`.`bathrooms`, `Requirement`.`garage`, `Requirement`.`totalarea`, `Requirement`.`area_unit`, `Requirement`.`constyear`, `Requirement`.`furnished`, `Requirement`.`floortotal`, `Requirement`.`type`, `Requirement`.`status`, `Requirement`.`created`, `Requirement`.`modified`, `PropertytypesRequirement`.`id`, `PropertytypesRequirement`.`propertytype_id`, `PropertytypesRequirement`.`requirement_id` FROM `prod_propertyclustercom`.`requirements` AS `Requirement` JOIN `prod_propertyclustercom`.`propertytypes_requirements` AS `PropertytypesRequirement` ON (`PropertytypesRequirement`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesRequirement`.`requirement_id` = `Requirement`.`id`) 001
91SELECT `Searchpreference`.`id`, `Searchpreference`.`user_id`, `Searchpreference`.`name`, `Searchpreference`.`parentproptype`, `Searchpreference`.`searchstat`, `Searchpreference`.`country_id`, `Searchpreference`.`region_id`, `Searchpreference`.`city_id`, `Searchpreference`.`minprice`, `Searchpreference`.`maxprice`, `Searchpreference`.`maxdeposite`, `Searchpreference`.`bedrooms`, `Searchpreference`.`bathrooms`, `Searchpreference`.`garage`, `Searchpreference`.`totalarea`, `Searchpreference`.`area_unit`, `Searchpreference`.`constyear`, `Searchpreference`.`furnished`, `Searchpreference`.`floortotal`, `Searchpreference`.`video`, `Searchpreference`.`photo`, `Searchpreference`.`type`, `Searchpreference`.`status`, `Searchpreference`.`created`, `Searchpreference`.`modified`, `PropertytypesSearchpreference`.`id`, `PropertytypesSearchpreference`.`propertytype_id`, `PropertytypesSearchpreference`.`searchpreference_id` FROM `prod_propertyclustercom`.`searchpreferences` AS `Searchpreference` JOIN `prod_propertyclustercom`.`propertytypes_searchpreferences` AS `PropertytypesSearchpreference` ON (`PropertytypesSearchpreference`.`propertytype_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `PropertytypesSearchpreference`.`searchpreference_id` = `Searchpreference`.`id`) 001
92SELECT `Propertyowner`.`firstname`, `Propertyowner`.`lastname`, `Propertyowner`.`id` FROM `prod_propertyclustercom`.`propertyowners` AS `Propertyowner` LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Propertyowner`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Propertyowner`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Propertyowner`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`usersimages` AS `Usersimage` ON (`Usersimage`.`user_id` = `Propertyowner`.`id`) WHERE `Propertyowner`.`id` = '54415991-cc30-4842-bb7b-155cc0a8010d' LIMIT 1111
93SELECT COUNT(*) AS `count` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) left JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Package`.`id` = `Property`.`package_id`) left JOIN (SELECT Vasorderdetail.property_id AS vpid, Vasorder.id AS vid FROM `vasorders` AS `Vasorder` LEFT JOIN `vasorderdetails` AS `Vasorderdetail` ON (`Vasorder`.`id` = `Vasorderdetail`.`vasorder_id`) WHERE UNIX_TIMESTAMP(`Vasorder`.`expiry_date`)>'1618263260' GROUP BY `Vasorderdetail`.`property_id`) AS `Vas` ON (`Vas`.`vpid` = `Property`.`id`) WHERE `Property`.`propertytype_id` in ('5350af55-20d8-4554-ae43-07ec6281e16b', '5350af0a-7030-444a-83fa-07ec6281e16b', '5350af81-a3a0-4984-92af-07ec6281e16b', '5350af2c-d248-446c-af3b-07ec6281e16b', '5350af17-d000-4aa0-bd85-07ec6281e16b', '5350af46-24ac-4d3c-b9b8-07ec6281e16b', '5350abe4-5550-42cb-a392-07ec6281e16b', '5350aef8-a244-42e2-871e-07ec6281e16b', '5350b01a-a96c-49c3-b337-07ec6281e16b', '5350aee9-d304-4911-bb7a-07ec6281e16b', '5350afe1-6b5c-4a34-bf61-07ec6281e16b', '5350afd5-b274-4363-b53c-07ec6281e16b', '5350afa2-6fac-464f-914d-07ec6281e16b', '5350af39-0398-4732-8f5a-07ec6281e16b', 'commercialother') AND `Property`.`status` = 1 AND `Property`.`looking_for` = 'To Lease' AND `Property`.`propertytype_id` = '5350aee9-d304-4911-bb7a-07ec6281e16b' GROUP BY `Property`.`id`001
94SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0'221
95SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC14141
96SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa8c1-7dc8-4258-b249-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC10100