Please Log In

Please enter your email address and password below.

New to Open Vacation Weeks?

Register Today!
(default) 29 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `site_users`25250
2DESCRIBE `daily_digests`881
3DESCRIBE `listings`36361
4DESCRIBE `payments`14140
5DESCRIBE `auctions`19190
6DESCRIBE `auction_winners`550
7DESCRIBE `bids`11110
8DESCRIBE `listing_images`880
9DESCRIBE `rates`880
10DESCRIBE `saved_listings`330
11DESCRIBE `ratings`660
12DESCRIBE `open_weeks`550
13DESCRIBE `zipcodes`10100
14DESCRIBE `amenities`660
15DESCRIBE `groups`220
16DESCRIBE `amenities_listings`330
17DESCRIBE `saved_searches`770
18DESCRIBE `sent_auction_notifications`220
19DESCRIBE `sent_listing_notifications`440
20DESCRIBE `sent_offer_wall_notifications`330
21DESCRIBE `email_group_users`550
22DESCRIBE `email_groups`440
23DESCRIBE `admin_email_groups`330
24DESCRIBE `offer_wall`25250
25DESCRIBE `tickets`660
26DESCRIBE `promotion_users`440
27DESCRIBE `settings`770
28SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
29SELECT 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