Looking for the hottest travel deals? Join the RealAdventures community and get a free travel newsletter full of ideas, hot deals and more.
See latest edition .
Sign-Up Today »
Explore the Canadian Maritimes
location_on St. Martins, New Brunswick | Bed & Breakfasts
This heritage property (circa 1857) in the historic fishing village of St. Martins offers 16 uniquely furnished guest rooms, a licensed restaurant & dining room as well as a Gift Shop.
Explore the nearby St. Martins sea caves & Fundy Trail ParkwayStarting at
USD $107.39 per night
calendar_month Availability & Reservations
Surrounding Areakeyboard_double_arrow_up
Situated in the heart of the magnificent Bay of Fundy, this heritage inn (circa 1857) boasts a commanding view of the Atlantic Ocean in the historic fishing village of St. Martins, New Brunswick. This 4-star heritage property is equipped with a Licensed Restaurant & Dining Room with a wide variety of menu options including many Maritime specialties and other traditional fare. Vaughans Restaurant is open for breakfast, lunch & dinner daily. Dinner reservations recommended.
Map & Directionskeyboard_double_arrow_up
303 Main Street, St. Martins, New Brunswick E5R 1C1
Just 30 minutes drive from the Saint John, New Brunswick airport.
Points of Interest
St. Martins Country Inn / Vaughans Restaurant
303 Main Street, St. Martins, New Brunswick
Fundy Trail Parkway
229 Main St, St. Martins, NB E5R 1B7, Canada
Nearby Attractions and Serviceskeyboard_double_arrow_up
Distance Description 1.5km St. Martins Sea Caves 15km Fundy Trail Parkway 22km Hearst Lodge, Fundy Trail Parkway 32km Saint John, NB Airport 145km Moncton, NB Airport
Rates & Availabilitykeyboard_double_arrow_up
(All rates in USD $) From/To Low High Notes Carriage House Bayview (King) 115 (single or double occupancy) Gardenview (Queen) 107 (single or double occupancy) Premier Gardenview (Queen) 131 (single or double occupancy) Premier Bayview (Queen) 131 (single or double occupancy) Carriage House Bayview (2 Queens) 115 (double occupancy)
Room rates range from $135 CAD plus applicable taxes. Rates include full breakfast. Special packages for families, romantic getaways, adventure and seniors are available as well as packages which include meals and accommodation.
Room rates range from $135 CAD plus applicable taxes. Rates include full breakfast. Special packages for families, romantic getaways, adventure and seniors are available as well as packages which include meals and accommodation.
*Please
contact advertiser for rates & availability for your travel dates.
Amenitieskeyboard_double_arrow_up
Room Amenities check_box Air Conditioningcheck_box Cable/Satellite TVcheck_box Hairdryercheck_box High Speed Internetcheck_box Refrigeratorcheck_box Room Servicecheck_box Telephonecheck_box TelevisionAvailable check_box Barcheck_box Conference Roomscheck_box Internet Accesscheck_box FreeGeneral check_box Reservations Required
Rooms/Suiteskeyboard_double_arrow_up
The St. Martins Country Inn offers 16 uniquely furnished guest rooms with a combination of antiques and contemporary amenities. All rooms have Queen or King beds with private bath, flat screen televisions, free wireless internet, mini-refrigerator and coffeemaker. Some rooms have two Queen Beds. Bay view and Garden view rooms are available.
Policies & Restrictionskeyboard_double_arrow_up
No smoking
Travel Provider's Infokeyboard_double_arrow_up
Starting at
USD $107.39 per night
Explore the Canadian Maritimes
303 Main Street
St. Martins, New Brunswick E5R 1C1 Canada
person_outline Lynette Davis, General Manager
credit_card Reservations
Listing # RA-1285283
Also of Interest Near St. Martins, New Brunswick
Similar Nearby Listings (See All ) keyboard_double_arrow_up
Featured Adventures Nearby (See All ) keyboard_double_arrow_up
Featured Accommodations Nearby (See All ) keyboard_double_arrow_up
Add Your Travel Services and Accommodations
Add a multi-page listing promoting your accommodations, tours or travel services to customers on our network of travel sites. Your listing page includes an interactive map, availability calendar, reviews, photo-gallery and more.
Create Your Listing
Time: 0.07 | Consuming 0.00 kb 0.00 0.00 Trace.class.htm:3 call: (main) (from: setup.htm:33) ... Now consuming 0 kb
0.00 0.00 setup.htm:51 call: (main) (from: listing.htm:9) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing.htm:9 (from: (none):-1)) debug : Opening table common_stats
........ common_miva_database.htm:52 (from: listing.htm:9 (from: (none):-1)) debug : Opening table common_visitor_pages
0.00 0.00 setup_check_admin_user.htm:7 call: (main) (from: setup.htm:59) ... Now consuming 0 kb
0.00 0.00 setup_default.htm:5 call: (main) (from: setup_configuration_variables.htm:11) ... Now consuming 0 kb
0.00 0.00 setup_account_access.htm:2 call: (main) (from: setup.htm:80) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: setup.htm:80 (from: listing.htm:9)) debug : Opening table accounts
0.00 0.00 setup_visitors.htm:5 call: (main) (from: setup.htm:83) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: setup.htm:83 (from: listing.htm:9)) debug : Opening table common_visitors
0.00 0.00 setup_google_ads.htm:2 call: (main) (from: setup.htm:91) ... Now consuming 0 kb
0.00 0.00 setup_google_channel.htm:8 call: (main) (from: setup.htm:94) ... Now consuming 0 kb
0.00 0.00 setup_facebook_promoter.htm:2 call: (main) (from: setup.htm:96) ... Now consuming 0 kb
0.00 0.00 setup.htm:101 call: (main) (from: listing.htm:9) ... Now consuming 0 kb
0.00 0.00 setup.htm:122 call: (main) (from: listing.htm:9) ... Now consuming 0 kb
0.00 0.00 currency_symbol_get.htm:3 call: (main) (from: setup.htm:133) ... Now consuming 0 kb
0.00 0.00 setup.htm:184 call: (main) (from: listing.htm:9) ... Now consuming 0 kb
0.00 0.00 listing.htm:14 call: (main) (from: (none):-1) ... Now consuming 0 kb
0.00 0.00 listing_setup.htm:3 call: (main) (from: listing.htm:18) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing.htm:18 (from: (none):-1)) debug : Opening table listings_listings
0.00 0.00 common_miva_database.htm:454 call: select (from: listing_setup.htm:30) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_setup.htm:30 (from: listing.htm:18)) debug : (0.00) : SELECT * FROM `listings_listings` WHERE `LISTING`=1285283 limit 1
0.00 0.00 common_listing_advertiser_account.htm:3 call: (main) (from: listing_setup.htm:39) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing_setup.htm:39 (from: listing.htm:18)) debug : Opening table accounts1
0.00 0.00 common_miva_database.htm:454 call: select (from: common_listing_advertiser_account.htm:23) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_listing_advertiser_account.htm:23 (from: listing_setup.htm:39)) debug : (0.00) : SELECT * FROM `accounts` WHERE `EMAIL_NO`=383434 limit 1
0.00 0.01 listing_check_show.htm:3 call: (main) (from: listing_setup.htm:46) ... Now consuming 0 kb
0.00 0.01 listing_hitlog.htm:2 call: (main) (from: listing_setup.htm:47) ... Now consuming 0 kb
0.00 0.01 common_listing_tables.htm:3 call: (main) (from: listing_setup.htm:56) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table listings_info
0.00 0.01 common_miva_database.htm:454 call: select (from: common_listing_tables.htm:7) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_listing_tables.htm:7 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `listings_info` WHERE LISTING=1285283 limit 1
........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table type
0.00 0.01 common_miva_database.htm:454 call: select (from: common_listing_tables.htm:23) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_listing_tables.htm:23 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `type` WHERE `TYPE`="Accommodations: Bed & Breakfasts" limit 1
........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table group
0.00 0.01 common_miva_database.htm:454 call: select (from: common_listing_tables.htm:34) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_listing_tables.htm:34 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `group` WHERE `GROUP_ID`=2 limit 1
0.00 0.01 listing_table_variables.htm:3 call: (main) (from: listing_setup.htm:57) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing_setup.htm:57 (from: listing.htm:18)) debug : Opening table accounts1
0.00 0.01 common_miva_database.htm:454 call: select (from: listing_table_variables.htm:79) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_table_variables.htm:79 (from: listing_setup.htm:57)) debug : (0.00) : SELECT * FROM `accounts1` WHERE `EMAIL_NO`=383434 limit 1
0.00 0.01 listing_variables.htm:8 call: (main) (from: listing_setup.htm:58) ... Now consuming 0 kb
0.00 0.01 common_urls.htm:57 call: ProfileLink (from: listing_variables.htm:13) ... Now consuming 0 kb
0.00 0.01 common_urls.htm:15 call: ListingShowLink (from: listing_variables.htm:14) ... Now consuming 0 kb
0.00 0.01 listing_menu.htm:6 call: (main) (from: listing_setup.htm:63) ... Now consuming 0 kb
0.00 0.01 listing_menu.htm:142 call: ListingMenu (from: listing_menu.htm:116) ... Now consuming 0 kb
0.00 0.01 listing_menu.htm:142 call: ListingMenu (from: listing_menu.htm:119) ... Now consuming 0 kb
0.00 0.01 common_urls.htm:259 call: GetWebsiteURL (from: listing_setup.htm:69) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing_setup.htm:69 (from: listing.htm:18)) debug : Opening table websites
0.00 0.01 common_miva_database.htm:454 call: select (from: common_urls.htm:272) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_urls.htm:272 (from: listing_setup.htm:69)) debug : (0.00) : SELECT * FROM `websites` WHERE `WEBSITE_CODE`="RA" limit 1
........ common_miva_database.htm:52 (from: listing_setup.htm:74 (from: listing.htm:18)) debug : Opening table geograph
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar.htm:151) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: navbar.htm:151 (from: listing_setup.htm:74)) debug : Opening table geograph
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:151)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="H"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `REGION`="St. Martins"
and `TYPE`="Accommodations: Bed & Breakfasts"
and `GROUP_ID`=2
LIMIT 1
0.00 0.01 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar.htm:154) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:154)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="H"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `REGION`="St. Martins"
and `TYPE`="Accommodations: Bed & Breakfasts"
and `GROUP_ID`=2
LIMIT 1
0.00 0.01 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar.htm:158) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:158)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Z"
and `GROUP_ID`=2
LIMIT 1
0.00 0.01 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:241) ... Now consuming 0 kb
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar.htm:161) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:161)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Y"
and `TYPE`="Accommodations"
and `GROUP_ID`=2
LIMIT 1
0.00 0.01 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:238) ... Now consuming 0 kb
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar.htm:165) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:165)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="X"
and `TYPE`="Accommodations: Bed & Breakfasts"
and `GROUP_ID`=2
LIMIT 1
0.00 0.01 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 navbar_breadcrumb.htm:8 call: (main) (from: navbar.htm:211) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_breadcrumb.htm:39) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:39)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Z"
LIMIT 1
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 navbar_breadcrumb.htm:222 call: BuildBreadcrumb (from: navbar_breadcrumb.htm:40) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_breadcrumb.htm:45) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:45)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="X"
and `TYPE`="Accommodations: Bed & Breakfasts"
and `GROUP_ID`=2
LIMIT 1
0.00 0.01 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_breadcrumb.htm:90) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:90)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="A"
and `CONTINENT`="North America"
LIMIT 1
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 navbar_breadcrumb.htm:222 call: BuildBreadcrumb (from: navbar_breadcrumb.htm:100) ... Now consuming 0 kb
0.00 0.01 navbar_breadcrumb.htm:271 call: BuildBreadcrumbMeta (from: navbar_breadcrumb.htm:101) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_breadcrumb.htm:106) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:106)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
LIMIT 1
0.00 0.01 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.01 navbar_breadcrumb.htm:222 call: BuildBreadcrumb (from: navbar_breadcrumb.htm:116) ... Now consuming 0 kb
0.00 0.01 navbar_breadcrumb.htm:271 call: BuildBreadcrumbMeta (from: navbar_breadcrumb.htm:117) ... Now consuming 0 kb
0.00 0.01 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_breadcrumb.htm:121) ... Now consuming 0 kb
0.00 0.01 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:121)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="C"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
LIMIT 1
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 navbar_breadcrumb.htm:222 call: BuildBreadcrumb (from: navbar_breadcrumb.htm:128) ... Now consuming 0 kb
0.00 0.02 navbar_breadcrumb.htm:271 call: BuildBreadcrumbMeta (from: navbar_breadcrumb.htm:129) ... Now consuming 0 kb
0.00 0.02 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_breadcrumb.htm:138) ... Now consuming 0 kb
0.00 0.02 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:138)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="D"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `REGION`="St. Martins"
LIMIT 1
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 navbar_breadcrumb.htm:222 call: BuildBreadcrumb (from: navbar_breadcrumb.htm:145) ... Now consuming 0 kb
0.00 0.02 navbar_breadcrumb.htm:271 call: BuildBreadcrumbMeta (from: navbar_breadcrumb.htm:146) ... Now consuming 0 kb
0.00 0.02 navbar_breadcrumb.htm:222 call: BuildBreadcrumb (from: navbar_breadcrumb.htm:180) ... Now consuming 0 kb
0.00 0.02 navbar_breadcrumb.htm:271 call: BuildBreadcrumbMeta (from: navbar_breadcrumb.htm:181) ... Now consuming 0 kb
0.00 0.02 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_select_destination_north_america.htm:19) ... Now consuming 0 kb
0.00 0.02 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:19)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
LIMIT 1
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_select_destination_north_america.htm:39) ... Now consuming 0 kb
0.00 0.02 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:39)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
LIMIT 1
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common.htm:227 call: GetPageURLwDest_Cat (from: navbar_select_destination_north_america.htm:59) ... Now consuming 0 kb
0.00 0.02 common_miva_database.htm:454 call: select (from: common.htm:376) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:59)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="Mexico"
LIMIT 1
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 navbar_select_destination_continents.htm:6 call: (main) (from: navbar_select_destination.htm:17) ... Now consuming 0 kb
0.00 0.02 navbar_select_destination_continents.htm:53 call: (main) (from: navbar_select_destination.htm:17) ... Now consuming 0 kb
0.00 0.02 common_miva_database.htm:454 call: select (from: navbar_select_destination_continents.htm:57) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_destination_continents.htm:57 (from: navbar_select_destination.htm:17)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="A" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `CONTINENT`
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_miva_database.htm:454 call: select (from: navbar_select_destination_states.htm:73) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_destination_states.htm:73 (from: navbar_select_destination.htm:21)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="C" and `CONTINENT`="North America" and `COUNTRY`="Canada" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `STATE`
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 navbar_select_destination_countries.htm:6 call: (main) (from: navbar_select_destination.htm:25) ... Now consuming 0 kb
0.00 0.02 navbar_select_destination_countries.htm:84 call: (main) (from: navbar_select_destination.htm:25) ... Now consuming 0 kb
0.00 0.02 common_miva_database.htm:454 call: select (from: navbar_select_destination_countries.htm:86) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_destination_countries.htm:86 (from: navbar_select_destination.htm:25)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="B" and `CONTINENT`="North America" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `COUNTRY`
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 navbar_select_top_destinations.htm:6 call: (main) (from: navbar.htm:219) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: navbar.htm:219 (from: listing_setup.htm:74)) debug : Opening table geograph
0.00 0.02 common_miva_database.htm:454 call: select (from: navbar_select_top_destinations.htm:184) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_top_destinations.htm:184 (from: navbar.htm:219)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="D"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `REGION`!=""
and `DELETED`=0
and `LISTINGS_SHOW`
ORDER BY `LISTINGS_SHOW` desc
LIMIT 20
0.00 0.02 navbar_select_top_destinations.htm:187 call: (main) (from: navbar.htm:219) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.02 common_scrub_validate.htm:115 call: String2URL (from: common_urls.htm:171) ... Now consuming 0 kb
0.00 0.02 navbar_select_top_destinations.htm:306 call: (main) (from: navbar.htm:219) ... Now consuming 0 kb
0.00 0.02 navbar_select_categories.htm:2 call: (main) (from: navbar.htm:222) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: navbar.htm:222 (from: listing_setup.htm:74)) debug : Opening table geograph
........ common_miva_database.htm:52 (from: navbar.htm:222 (from: listing_setup.htm:74)) debug : Opening table geograph
0.00 0.02 common_miva_database.htm:454 call: select (from: navbar_select_categories.htm:130) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:130 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="G"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `LISTINGS_SHOW`
and `DELETED`=0
ORDER BY `TYPE1`, `TYPE2`
0.00 0.03 common_miva_database.htm:454 call: select (from: navbar_select_categories.htm:218) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=2
and `TYPE1`="Accommodations"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:238) ... Now consuming 0 kb
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.03 common_miva_database.htm:454 call: select (from: navbar_select_categories.htm:218) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=3
and `TYPE1`="Adventure Travel"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:238) ... Now consuming 0 kb
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.03 common_miva_database.htm:454 call: select (from: navbar_select_categories.htm:218) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=4
and `TYPE1`="Cruises"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:238) ... Now consuming 0 kb
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.03 common_miva_database.htm:454 call: select (from: navbar_select_categories.htm:218) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=7
and `TYPE1`="Fishing & Hunting"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:238) ... Now consuming 0 kb
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.03 common_miva_database.htm:454 call: select (from: navbar_select_categories.htm:218) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=12
and `TYPE1`="Nature & Wildlife"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:238) ... Now consuming 0 kb
0.00 0.03 common_scrub_validate.htm:8 call: Text2URL (from: common_urls.htm:235) ... Now consuming 0 kb
0.00 0.03 navbar_tabs.htm:6 call: (main) (from: navbar.htm:228) ... Now consuming 0 kb
0.00 0.03 search_form_simple.htm:3 call: (main) (from: navbar_tabs.htm:49) ... Now consuming 0 kb
0.00 0.03 listing_image_url.htm:29 call: ImageURL (from: listing_setup.htm:82) ... Now consuming 0 kb
0.00 0.03 common_image_functions.htm:142 call: imageDirectory (from: listing_image_url.htm:50) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing_setup.htm:82 (from: listing.htm:18)) debug : Opening table listings_images
0.00 0.03 common_miva_database.htm:454 call: select (from: listing_image_url.htm:63) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_image_url.htm:63 (from: listing_setup.htm:82)) debug : (0.00) : SELECT * FROM `listings_images` WHERE `LISTING`=1285283 and `DELETED`=0 ORDER BY `ORDER_NO`, `IMAGE_NO` LIMIT 999
........ common_miva_database.htm:52 (from: listing.htm:18 (from: (none):-1)) debug : Opening table listings_availability
0.00 0.03 common_miva_database.htm:454 call: select (from: listing_setup.htm:92) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_setup.htm:92 (from: listing.htm:18)) debug : (0.00) : SELECT COUNT(*) as `TOTAL` FROM `listings_availability` WHERE `LISTING`=1285283 and `STATUS`!="available" and `DATE`>= "2022-06-26"
........ common_miva_database.htm:52 (from: listing_setup.htm:124 (from: listing.htm:18)) debug : Opening table listings_map
0.00 0.03 common_miva_database.htm:454 call: select (from: listing_map_json.htm:104) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_map_json.htm:104 (from: listing_setup.htm:124)) debug : (0.00) : SELECT * FROM `listings_map` WHERE `LISTING`=1285283 and `ADDRESS`!='' order by `MAP_ID`
0.00 0.03 common_image_functions.htm:142 call: imageDirectory (from: listing_map_json.htm:137) ... Now consuming 0 kb
0.00 0.03 common_currency_rates.htm:112 call: GetListingRate (from: listing_map_json.htm:149) ... Now consuming 0 kb
0.00 0.03 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_map_json.htm:149)) debug : Opening table common_currencies
0.00 0.04 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.04 common_miva_database.htm:454 call: select (from: listing_map_pins.htm:17) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_map_pins.htm:17 (from: listing_setup.htm:125)) debug : (0.00) : SELECT * FROM `listings_map` WHERE `LISTING`=1285283 AND `DELETED`=0
........ common_miva_database.htm:52 (from: listing_setup.htm:127 (from: listing.htm:18)) debug : Opening table listings_deals
0.00 0.04 common_miva_database.htm:454 call: select (from: listing_hot_deals.htm:6) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_hot_deals.htm:6 (from: listing_setup.htm:127)) debug : (0.00) : SELECT * FROM `listings_deals` WHERE `LISTING`=1285283 and `SHOWINFO`=1 order by `LAST_PAID_TIME` desc
0.00 0.04 common_currency_rates.htm:112 call: GetListingRate (from: listing_hot_deals.htm:81) ... Now consuming 0 kb
0.00 0.04 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_hot_deals.htm:81)) debug : Opening table common_currencies
0.00 0.04 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.04 listing_nearby_options.htm:2 call: (main) (from: listing_setup.htm:135) ... Now consuming 0 kb
0.00 0.04 listing_nearby_options.htm:46 call: (main) (from: listing_setup.htm:135) ... Now consuming 0 kb
0.00 0.04 summary_listings.htm:52 call: (main) (from: listing_nearby_options.htm:49) ... Now consuming 0 kb
0.00 0.04 summary_build_query.htm:287 call: (main) (from: summary_listings.htm:105) ... Now consuming 0 kb
0.00 0.04 summary_listings.htm:112 call: (main) (from: listing_nearby_options.htm:49) ... Now consuming 0 kb
0.00 0.04 common_miva_database.htm:454 call: select (from: summary_listings.htm:167) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: summary_listings.htm:167 (from: listing_nearby_options.htm:49)) debug : (0.00) : SELECT count(*) as `TOTAL`, 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.356262))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-65.538559 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.356262))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Bed & Breakfasts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LATITUDE`
BETWEEN 45.356262 - (250 / 69)
AND 45.356262 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -65.538559 - (250 / (69 * COS(RADIANS(45.356262))))
AND -65.538559 + (250 / (69 * COS(RADIANS(45.356262)))) and `listings_listings`.`LISTING` not in (1019801, 1285283)
0.00 0.04 summary_listings_get.htm:2 call: (main) (from: summary_listings.htm:268) ... Now consuming 0 kb
0.00 0.04 common_miva_database.htm:454 call: select (from: summary_listings_get.htm:25) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:268)) debug : (0.00) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.356262))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-65.538559 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.356262))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Bed & Breakfasts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`PSTATE`="New Brunswick"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 45.356262 - (250 / 69)
AND 45.356262 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -65.538559 - (250 / (69 * COS(RADIANS(45.356262))))
AND -65.538559 + (250 / (69 * COS(RADIANS(45.356262)))) and `listings_listings`.`LISTING` not in (1019801, 1285283)
order by `DISTANCE`
limit 0
, 10
0.00 0.04 summary_listings_get.htm:2 call: (main) (from: summary_listings.htm:295) ... Now consuming 0 kb
0.00 0.04 common_miva_database.htm:454 call: select (from: summary_listings_get.htm:25) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:295)) debug : (0.00) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.356262))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-65.538559 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.356262))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Bed & Breakfasts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LAST_MGR_TIME` > 1561637799
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 45.356262 - (250 / 69)
AND 45.356262 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -65.538559 - (250 / (69 * COS(RADIANS(45.356262))))
AND -65.538559 + (250 / (69 * COS(RADIANS(45.356262)))) and `listings_listings`.`LISTING` not in (1019801, 1285283)
order by `DISTANCE`
limit 0
, 10
0.00 0.04 summary_listings_get.htm:2 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.04 common_miva_database.htm:454 call: select (from: summary_listings_get.htm:25) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:321)) debug : (0.00) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.356262))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-65.538559 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.356262))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Bed & Breakfasts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`LATITUDE`
BETWEEN 45.356262 - (250 / 69)
AND 45.356262 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -65.538559 - (250 / (69 * COS(RADIANS(45.356262))))
AND -65.538559 + (250 / (69 * COS(RADIANS(45.356262)))) and `listings_listings`.`LISTING` not in (1019801, 1285283)
order by `DISTANCE`
limit 0
, 10
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get.htm:61) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:321) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:50) ... Now consuming 0 kb
0.00 0.05 listing_nearby_options.htm:56 call: (main) (from: listing_setup.htm:135) ... Now consuming 0 kb
0.00 0.05 summary_listings.htm:52 call: (main) (from: listing_nearby_options.htm:69) ... Now consuming 0 kb
0.00 0.05 summary_build_query.htm:287 call: (main) (from: summary_listings.htm:105) ... Now consuming 0 kb
0.00 0.05 summary_listings.htm:112 call: (main) (from: listing_nearby_options.htm:69) ... Now consuming 0 kb
0.00 0.05 common_miva_database.htm:454 call: select (from: summary_listings.htm:194) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: summary_listings.htm:194 (from: listing_nearby_options.htm:69)) debug : (0.00) : SELECT count(*) as `TOTAL` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`PSTATE`="New Brunswick"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LISTING` not in (1019801, 1285283, 1212807, 1213325, 1204431, 1226600, 1204410, 1204417, 1025783, 1204391, 1213349, 1213288)
0.00 0.05 summary_listings_get.htm:2 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.05 common_miva_database.htm:454 call: select (from: summary_listings_get.htm:25) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:384)) debug : (0.00) : SELECT * FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`PSTATE`="New Brunswick"
and `listings_listings`.`LISTING` not in (1019801, 1285283, 1212807, 1213325, 1204431, 1226600, 1204410, 1204417, 1025783, 1204391, 1213349, 1213288)
ORDER BY `INDEXKEY`
limit 0
, 10
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.05 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.05 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.05 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.05 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.05 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.05 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:70) ... Now consuming 0 kb
0.00 0.06 listing_nearby_options.htm:76 call: (main) (from: listing_setup.htm:135) ... Now consuming 0 kb
0.00 0.06 summary_listings.htm:52 call: (main) (from: listing_nearby_options.htm:84) ... Now consuming 0 kb
0.00 0.06 summary_build_query.htm:287 call: (main) (from: summary_listings.htm:105) ... Now consuming 0 kb
0.00 0.06 summary_listings.htm:112 call: (main) (from: listing_nearby_options.htm:84) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:2 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 common_miva_database.htm:454 call: select (from: summary_listings_get.htm:25) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:384)) debug : (0.00) : SELECT * FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`!=2
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`PSTATE`="New Brunswick"
and `listings_listings`.`LISTING` not in (1019801, 1285283, 1212807, 1213325, 1204431, 1226600, 1204410, 1204417, 1025783, 1204391, 1213349, 1213288, 1213328, 1213365, 1244657, 1213350, 1212783, 1213086, 1245060, 1213077, 1213071, 1213742)
ORDER BY `INDEXKEY`
limit 0
, 10
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:108 call: GetSummaryImage (from: summary_listings_get_info.htm:149) ... Now consuming 0 kb
0.00 0.06 common_image_functions.htm:142 call: imageDirectory (from: common_image_functions.htm:114) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_get_info.htm:7 call: (main) (from: summary_listings_get.htm:49) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:259 call: GetWebsiteURL (from: summary_listings_get_info.htm:17) ... Now consuming 0 kb
0.00 0.06 common_urls.htm:15 call: ListingShowLink (from: summary_listings_get_info.htm:30) ... Now consuming 0 kb
0.00 0.06 summary_listing_breadcrumb.htm:17 call: SummaryBreadCrumb (from: summary_listings_get_info.htm:108) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:63 call: ConvertRate (from: summary_listings_get_info.htm:116) ... Now consuming 0 kb
0.00 0.06 summary_listings_get.htm:68 call: (main) (from: summary_listings.htm:384) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:76 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 summary_listings_show.htm:133 call: (main) (from: listing_nearby_options.htm:85) ... Now consuming 0 kb
0.00 0.06 listing_nearby_options.htm:91 call: (main) (from: listing_setup.htm:135) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing_setup.htm:135 (from: listing.htm:18)) debug : Opening table listings_listings
0.00 0.06 common_miva_database.htm:454 call: select (from: listing_nearby_options.htm:134) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_nearby_options.htm:134 (from: listing_setup.htm:135)) debug : (0.00) : SELECT * FROM `listings_listings` WHERE `LISTING`=1285283 limit 1
0.00 0.06 listing_nearby_options.htm:140 call: (main) (from: listing_setup.htm:135) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:112 call: GetListingRate (from: listing_starting_at.htm:16) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_starting_at.htm:16)) debug : Opening table common_currencies
0.00 0.06 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.06 common_currency_rates.htm:112 call: GetListingRate (from: listing_setup.htm:170) ... Now consuming 0 kb
0.00 0.06 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_setup.htm:170)) debug : Opening table common_currencies
0.00 0.06 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.06 listing_meta_tags.htm:4 call: (main) (from: listing_setup.htm:200) ... Now consuming 0 kb
0.00 0.06 header.htm:6 call: (main) (from: listing.htm:19) ... Now consuming 0 kb
0.00 0.06 listing_template.htm:4 call: (main) (from: listing.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing_snippet.htm:75 (from: listing_template_full_home.htm:10)) debug : Opening table listings_amenities2
0.00 0.06 common_miva_database.htm:454 call: select (from: listing_key_amenities.htm:8) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_key_amenities.htm:8 (from: listing_snippet.htm:75)) debug : (0.00) : SELECT * FROM `listings_amenities2` inner join `amenities1` using (`AMEN_ID`) WHERE `LISTING`=1285283 and `REQUIRED` ORDER BY `GROUP`,`AMENITY`,`VALUE`
0.00 0.06 inquiry_form.htm:12 call: (main) (from: listing_template_full_home.htm:13) ... Now consuming 0 kb
0.00 0.06 inquiry_default_values.htm:8 call: (main) (from: inquiry_form.htm:15) ... Now consuming 0 kb
0.00 0.06 listing_map.htm:5 call: (main) (from: listing_template_full_home.htm:30) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: listing_template_full_home.htm:32 (from: listing_template.htm:93)) debug : Opening table listings_nearby
0.00 0.06 common_miva_database.htm:454 call: select (from: listing_nearby.htm:9) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_nearby.htm:9 (from: listing_template_full_home.htm:32)) debug : (0.00) : SELECT * FROM `listings_nearby` WHERE `LISTING`=1285283
........ common_miva_database.htm:52 (from: listing_template_full_home.htm:40 (from: listing_template.htm:93)) debug : Opening table listings_ratecard
0.00 0.06 common_miva_database.htm:454 call: select (from: listing_rates.htm:36) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_rates.htm:36 (from: listing_template_full_home.htm:40)) debug : (0.00) : SELECT * FROM `listings_ratecard` WHERE `LISTING`=1285283 AND `DELETED`=0 order by `RECNO`
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:61) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies
0.00 0.07 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:62) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:61) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies
0.00 0.07 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:62) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:61) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies
0.00 0.07 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:62) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:61) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies
0.00 0.07 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:62) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:61) ... Now consuming 0 kb
0.00 0.07 common_currency_rates.htm:9 call: CurrencyConversion (from: common_currency_rates.htm:124) ... Now consuming 0 kb
........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies
0.00 0.07 common_miva_database.htm:454 call: select (from: common_currency_rates.htm:24) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0
0.00 0.07 common_currency_rates.htm:112 call: GetListingRate (from: listing_rates.htm:62) ... Now consuming 0 kb
0.00 0.07 listing_calendar.htm:17 call: (main) (from: listing_template_full_home.htm:42) ... Now consuming 0 kb
0.00 0.07 common_miva_database.htm:454 call: select (from: listing_calendar.htm:56) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_calendar.htm:56 (from: listing_template_full_home.htm:42)) debug : (0.00) : SELECT * FROM `listings_availability` WHERE `LISTING`=1285283 and `DATE`>="2022-06"
........ common_miva_database.htm:52 (from: listing_template_full_home.htm:45 (from: listing_template.htm:93)) debug : Opening table listings_amenities2
0.00 0.07 common_miva_database.htm:454 call: select (from: listing_amenities.htm:15) ... Now consuming 0 kb
........ common_miva_database.htm:186 (from: listing_amenities.htm:15 (from: listing_template_full_home.htm:45)) debug : (0.00) : SELECT * FROM `listings_amenities2` left join `amenities1` using (`AMEN_ID`) WHERE `LISTING`=1285283 and `amenities1`.`ACTIVE` and !`amenities1`.`REQUIRED` ORDER BY `amenities1`.`TYPE` DESC, `amenities1`.`GROUP`, `amenities1`.`SUBGROUP`, `amenities1`.`AMENITY`, `amenities1`.`VALUE`
0.00 0.07 listing_nearby_options.htm:3 call: (main) (from: listing_template.htm:145) ... Now consuming 0 kb
0.00 0.07 footer.htm:12 call: (main) (from: listing.htm:28) ... Now consuming 0 kb
Time: 0.07 | Consuming 0.00 kb
Could not connect to the reCAPTCHA service. Please enable Javascript and reload to get a reCAPTCHA challenge.