Vacation Rentals - Houses for Rent at Open Vacation Weeks

Code | Context

$sql	=	"SELECT `Listing`.`id` FROM `listings` AS `Listing` right JOIN site_users  ON (`site_users`.`id` = `Listing`.`site_user_id` AND `site_users`.`active` = '1') LEFT JOIN `site_users` AS `SiteUser` ON (`Listing`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `payments` AS `Payment` ON (`Payment`.`listing_id` = `Listing`.`id`)  WHERE  `Listing`.`id` NOT IN () AND `Listing`.`title` != '' AND `Listing`.`calendar_url` = ''   "
$error	=	"1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Listing`.`title` != '' AND `Listing`.`calendar_url` = ''' at line 1"
$out	=	null

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 525
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 336
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 653
Model::find() - CORE/cake/libs/model/model.php, line 1988
ListingsController::sowList() - APP/controllers/listings_controller.php, line 1156
ListingsController::results() - APP/controllers/listings_controller.php, line 978
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88

Code | Context

$toDate	=	"2025-05-09"
$endDate	=	"2025-05-24"
$events	=	array()
$allDays	=	array()
$sow_AvailableArray	=	array()
$options	=	array(
	"fields" => array(
	"Listing.id"
),
	"conditions" => array(
	" Listing.id NOT IN ()",
	"Listing.title != " => "",
	"Listing.calendar_url" => ""
),
	"joins" => array(
	array()
)
)
$sow_list_ovw	=	null
$sow_list_ovw1	=	array()

           // echo "</pre>-->";
//        return array('sow_AvailableArray' => array_unique(array_merge($sow_list_ovw1, $sow_AvailableArray)), 'open_date' => array_unique($flatArray));
        return array('sow_AvailableArray' => array_unique(array_merge($sow_list_ovw1, $sow_AvailableArray)), 'open_date' => $flatArray);

ListingsController::sowList() - APP/controllers/listings_controller.php, line 1163
ListingsController::results() - APP/controllers/listings_controller.php, line 978
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88

Refine Search

Save this search

State

Beach Mountain City Other

Number of Bedrooms

Number of Bathrooms

Choose Amenities

Your search returned 0 items.

(default) 37 queries took 1 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `listings`		36	36	0
2	DESCRIBE `site_users`		25	25	0
3	DESCRIBE `daily_digests`		8	8	0
4	DESCRIBE `auctions`		19	19	0
5	DESCRIBE `auction_winners`		5	5	0
6	DESCRIBE `bids`		11	11	0
7	DESCRIBE `saved_listings`		3	3	0
8	DESCRIBE `saved_searches`		7	7	0
9	DESCRIBE `sent_auction_notifications`		2	2	0
10	DESCRIBE `sent_listing_notifications`		4	4	0
11	DESCRIBE `sent_offer_wall_notifications`		3	3	0
12	DESCRIBE `email_group_users`		5	5	0
13	DESCRIBE `email_groups`		4	4	0
14	DESCRIBE `admin_email_groups`		3	3	0
15	DESCRIBE `offer_wall`		25	25	0
16	DESCRIBE `payments`		14	14	0
17	DESCRIBE `listing_images`		8	8	0
18	DESCRIBE `rates`		8	8	0
19	DESCRIBE `ratings`		6	6	0
20	DESCRIBE `open_weeks`		5	5	0
21	DESCRIBE `zipcodes`		10	10	0
22	DESCRIBE `amenities`		6	6	0
23	DESCRIBE `groups`		2	2	0
24	DESCRIBE `amenities_listings`		3	3	0
25	DESCRIBE `listing_views`		5	5	0
26	DESCRIBE `site_user_owners`		5	5	0
27	DESCRIBE `listing_areas`		12	12	0
28	DESCRIBE `settings`		7	7	0
29	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1		12	12	0
30	SELECT `Auction`.`id`, `Auction`.`listing_id`, `Auction`.`site_user_id`, `Auction`.`reserve`, `Auction`.`buy_it_now`, `Auction`.`purchased`, `Auction`.`vacation_start_date`, `Auction`.`vacation_end_date`, `Auction`.`auction_start_date`, `Auction`.`auction_end_date`, `Auction`.`blind`, `Auction`.`description`, `Auction`.`bid_count`, `Auction`.`awarded`, `Auction`.`closed_notification`, `Auction`.`re_activate`, `Auction`.`display`, `Auction`.`created`, `Auction`.`modified`, `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`payment_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`country`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`seo_url`, `Listing`.`seo_title`, `Listing`.`metatitle`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`getaway_price`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`rating_count`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`latitude`, `Listing`.`longitude`, `Listing`.`management_company`, `Listing`.`area_type_mountain`, `Listing`.`area_type_beach`, `Listing`.`area_type_city`, `Listing`.`area_type_other`, `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`, `AuctionWinner`.`id`, `AuctionWinner`.`auction_id`, `AuctionWinner`.`bid_id`, `AuctionWinner`.`site_user_id`, `AuctionWinner`.`created` 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_start_date` <= '2025-05-09' AND `Auction`.`auction_end_date` >= '2025-05-09'		0	0	0
31	SELECT `SavedSearch`.`id`, `SavedSearch`.`title` FROM `saved_searches` AS `SavedSearch` WHERE `SavedSearch`.`site_user_id` IS NULL		0	0	0
32	SELECT `Amenity`.`id`, `Amenity`.`title` FROM `amenities` AS `Amenity` WHERE id IN (27, 16, 12, 46, 32, 12, 17, 4, 1, 21, 37, 5, 14, 50) ORDER BY `id` DESC		13	13	0
33	SELECT `Listing`.`id` FROM `listings` AS `Listing` right JOIN site_users ON (`site_users`.`id` = `Listing`.`site_user_id` AND `site_users`.`active` = '1') LEFT JOIN `site_users` AS `SiteUser` ON (`Listing`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `payments` AS `Payment` ON (`Payment`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`id` NOT IN () AND `Listing`.`title` != '' AND `Listing`.`calendar_url` = ''	1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `Listing`.`title` != '' AND `Listing`.`calendar_url` = ''' at line 1			0
34	SELECT `Auction`.`id`, `Auction`.`listing_id`, `Auction`.`site_user_id`, `Auction`.`reserve`, `Auction`.`buy_it_now`, `Auction`.`purchased`, `Auction`.`vacation_start_date`, `Auction`.`vacation_end_date`, `Auction`.`auction_start_date`, `Auction`.`auction_end_date`, `Auction`.`blind`, `Auction`.`description`, `Auction`.`bid_count`, `Auction`.`awarded`, `Auction`.`closed_notification`, `Auction`.`re_activate`, `Auction`.`display`, `Auction`.`created`, `Auction`.`modified`, `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`payment_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`country`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`seo_url`, `Listing`.`seo_title`, `Listing`.`metatitle`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`getaway_price`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`rating_count`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`latitude`, `Listing`.`longitude`, `Listing`.`management_company`, `Listing`.`area_type_mountain`, `Listing`.`area_type_beach`, `Listing`.`area_type_city`, `Listing`.`area_type_other`, `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`, `AuctionWinner`.`id`, `AuctionWinner`.`auction_id`, `AuctionWinner`.`bid_id`, `AuctionWinner`.`site_user_id`, `AuctionWinner`.`created` 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_start_date` <= '2025-05-09' AND `Auction`.`auction_end_date` >= '2025-05-09' AND `Auction`.`awarded` = 0 AND `Auction`.`display` = 1 AND `Auction`.`bid_count` > 0		0	0	1
35	SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` right JOIN site_users ON (`site_users`.`id` = `Listing`.`site_user_id` AND `site_users`.`active` = '1') WHERE ((`Listing`.`active` = 1) AND (`Listing`.`id` IS NULL))		1	1	0
36	SELECT `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`payment_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`country`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`seo_url`, `Listing`.`seo_title`, `Listing`.`metatitle`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`getaway_price`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`rating_count`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`latitude`, `Listing`.`longitude`, `Listing`.`management_company`, `Listing`.`area_type_mountain`, `Listing`.`area_type_beach`, `Listing`.`area_type_city`, `Listing`.`area_type_other` FROM `listings` AS `Listing` right JOIN site_users ON (`site_users`.`id` = `Listing`.`site_user_id` AND `site_users`.`active` = '1') WHERE ((`Listing`.`active` = 1) AND (`Listing`.`id` IS NULL)) ORDER BY `Listing`.`city` asc LIMIT 10		0	0	0
37	SELECT 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'		1	1	0

(ownerware) 3 queries took 3 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `events_property`	35	35	0
2	DESCRIBE `listings`	32	32	0
3	SELECT `EventsProperty`.`property_id`, `EventsProperty`.`start_date`, `EventsProperty`.`end_date` FROM `events_property` AS `EventsProperty` WHERE ((((`EventsProperty`.`start_date` >= '2025-05-09') AND (`EventsProperty`.`start_date` <= '2025-05-24'))) OR (((`EventsProperty`.`end_date` >= '2025-05-09') AND (`EventsProperty`.`end_date` <= '2025-05-24'))) OR (((`EventsProperty`.`start_date` >= '2025-05-09') AND (`EventsProperty`.`end_date` <= '2025-05-09')))) ORDER BY `start_date` asc	0	0	3

Simply Open Weeks Search Results - Vacancy In Next Two Weeks

Refine Search

Prize Details