Notice (8): Undefined index: saved_search [APP/controllers/listings_controller.php, line 697]
Listings
Advanced Search
  1. Location Information
    Distance Search
  2. Auction Only
  3. Property Details
Amenities
  1. Entertainment
  4. Kitchen
  6. Outdoor Features
  21. Communications
  24. Suitability
  31. Activities Available
  37. Other Features
  44. Property Location/View
  59. Payment Method
 

Copyright © 2025 Open Vacation Weeks. All Rights Reserved.
Web Design and Web Development by Atlantic BT. Internet Marketing by Pavya.

(default) 33 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `listings`36360
2DESCRIBE `site_users`25250
3DESCRIBE `daily_digests`880
4DESCRIBE `auctions`19190
5DESCRIBE `auction_winners`550
6DESCRIBE `bids`11110
7DESCRIBE `saved_listings`330
8DESCRIBE `saved_searches`770
9DESCRIBE `sent_auction_notifications`220
10DESCRIBE `sent_listing_notifications`440
11DESCRIBE `sent_offer_wall_notifications`330
12DESCRIBE `email_group_users`550
13DESCRIBE `email_groups`440
14DESCRIBE `admin_email_groups`330
15DESCRIBE `offer_wall`25250
16DESCRIBE `payments`14140
17DESCRIBE `listing_images`880
18DESCRIBE `rates`880
19DESCRIBE `ratings`660
20DESCRIBE `open_weeks`550
21DESCRIBE `zipcodes`10100
22DESCRIBE `amenities`660
23DESCRIBE `groups`220
24DESCRIBE `amenities_listings`330
25DESCRIBE `listing_views`550
26DESCRIBE `site_user_owners`550
27DESCRIBE `listing_areas`12120
28DESCRIBE `settings`770
29SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
30SELECT `SavedSearch`.`id`, `SavedSearch`.`title`, `SavedSearch`.`conditions`, `SavedSearch`.`selected_options`, `SavedSearch`.`site_user_id`, `SavedSearch`.`created`, `SavedSearch`.`modified`, `SiteUser`.`id`, `SiteUser`.`username`, `SiteUser`.`password`, `SiteUser`.`name`, `SiteUser`.`company_name`, `SiteUser`.`address`, `SiteUser`.`city`, `SiteUser`.`state`, `SiteUser`.`zipcode`, `SiteUser`.`phone`, `SiteUser`.`email`, `SiteUser`.`cc_email`, `SiteUser`.`created`, `SiteUser`.`modified`, `SiteUser`.`active`, `SiteUser`.`marketing`, `SiteUser`.`notify_emails`, `SiteUser`.`notify_wall_emails`, `SiteUser`.`search_emails`, `SiteUser`.`group`, `SiteUser`.`accepted_terms`, `SiteUser`.`management`, `SiteUser`.`referral_code`, `SiteUser`.`remote_login_key`, `SiteUser`.`advanced_dashboard` FROM `saved_searches` AS `SavedSearch` LEFT JOIN `site_users` AS `SiteUser` ON (`SavedSearch`.`site_user_id` = `SiteUser`.`id`) WHERE `SavedSearch`.`id` IS NULL LIMIT 1000
31SELECT `Group`.`id`, `Group`.`title` FROM `groups` AS `Group` WHERE 1 = 1 990
32SELECT `Amenity`.`id`, `Amenity`.`title`, `Amenity`.`group_id`, `Amenity`.`show_on_offer_wall`, `Amenity`.`created`, `Amenity`.`modified` FROM `amenities` AS `Amenity` WHERE `Amenity`.`group_id` IN (1, 2, 12, 4, 5, 6, 7, 15, 16) 56560
33SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `listings` AS `Listing` ON (`Auction`.`listing_id` = `Listing`.`id`) LEFT JOIN `site_users` AS `SiteUser` ON (`Auction`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `auction_winners` AS `AuctionWinner` ON (`AuctionWinner`.`auction_id` = `Auction`.`id`) WHERE `Auction`.`auction_end_date` >= '2025-05-09' AND `Auction`.`auction_start_date` <= '2025-05-09' 110
(ownerware) 2 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `events_property`35350
2DESCRIBE `listings`32320