exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('64011','64018','64025','64020','64029','65123','65013','65015','65016','66010','66026','66054','64026','65020','64010')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip = '85010') AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('87020','87028','87029','87030','87033','89861','89865','88030','88038','88036','89866','89863','89032','89047','88060')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('80075','80074','80076','80070','80077','80100','80127','80041','80067','80063','80065','80062','80057','80061','80064','80073','84010','84011','80051','84017','84019','84063','84047','84040','84076','84050','84048','84072','84060','84070','84077','84030','80084','84046','84021','84051','80071','84043')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('29013','43039','43034','44024','44029','48020','48100','47023','47812','47900','47045','47831','47040','47842','47838','47036','47843','44034','47033','47841','47923','48123','47855','47521','48121','47921')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip = '34100' OR user_vacationhomes_housedata.zip = '34121' OR user_vacationhomes_housedata.zip = '34073' OR user_vacationhomes_housedata.zip = '33053' OR user_vacationhomes_housedata.zip = '33050' OR user_vacationhomes_housedata.zip = '33054' OR user_vacationhomes_housedata.zip = '34125' OR user_vacationhomes_housedata.zip = '34132') AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip = '28040' OR user_vacationhomes_housedata.zip = '25010' OR user_vacationhomes_housedata.zip = '37011' OR user_vacationhomes_housedata.zip = '37019' OR user_vacationhomes_housedata.zip = '25087' OR user_vacationhomes_housedata.zip = '38066' OR user_vacationhomes_housedata.zip = '25019' OR user_vacationhomes_housedata.zip = '25088' OR user_vacationhomes_housedata.zip = '25015' OR user_vacationhomes_housedata.zip = '28838') AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('01020','02010','01028','00068','02042','02040','00020','00012','00055','00058','00052','00063','00061','00069','01010','00040','00124','01033','00186','00184','00185','00100','00165','00187','00195','00192','00193','00152','00145','00146','00162','00183','00154','00198','00153','00196','00156','00189','00197','00173','00166','00136','00168','00123','00134','00159','00176','00167','00164','00013','01032','01037','01030','00047','00036','04021','04017','04019','04022','04029','04020','04024','04023','02047','00178','00045','00131','01027','00062','05018')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('18039','18014','18012','18038','18011','18017','18020','18100','18013','17051','17020','17031','17025','17027','17024','17022','17012','17019','16032','16038','16035','16043','16033','16039','16030','19013','19011','19020','19100','19133','19025','19032','19036','19031','19034','16036','18030','19033','18032','17021','19015')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('21020','21012','21014','21010','21016','21030','21037','21050','21059','22010','22018','22026','22020','22019','22021','22017','22022','22015','22013','23822','22030','23841','23816','23868','25010','25015','25019','25029','25080','25087','25088','23023','23030','23032','23034','20125','20141','20124','22070','23020','22036','40100','21018','22039','46044','20123','23826','20143','22025','20154','20122','20121','25046')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('61012','61010','61100','61030','61024','60036','60030','60020','63019','62030','62032','63029','63030','63016','63033','63039','61049','62020','62026','62010','61121','61025','60019','62012')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip = '86036') AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip = '97138') AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('12051','28838','28831','28900','28924','28016','28011','28028','28010','28017','28891','28040')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('12051','12037','12041','18039','18014','18012','18038','18011','18017','18020','18100','18013','12043','18030','14018','12068','17020','12060','12050')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('74010','74020','74024','73048','73014','73054','73050','73039','73030','73020','73028','73026','73100','73023','72100','72012','72019','72017','74015','72013','72014','70031','70044','71030','71019','71010','71018','70010','73059','73057','73010','73032','70013','70043','73040')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('07040','70040','07037','07021','07039','07038','07030','07028','07020','07024','07026','08020','08022','08040','08044','08047','09040','09043','09049','09048','09046','09045','09018','09010','09017','09031','08019','07041','07031','09014','09019')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('94010','90100','90031','90141','90045','90146','90040','90041','91011','91010','91015','91025','91022','92013','92019','92016','92023','92027','97017','97100','97016','97015','97010','93118','97014','96010','96017','96012','96100','96101','98100','96014','96011','96016','95045','95024','95014','95016','95021','95023','95010','95019','95030','95015','95036','95017','98035','98030','98039','98037','98023','98040','98063','90015','90010','98070','90020','90012','98055','97018','98164','90013','90151','90134','90017')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('55060','54027','54010','54011','54012','54013','55011','54037','54100','54038','55042','55022','55021','55045','56017','50067','55012','55100','55014','55064','55018','55056','55010','55050','55015','55046','55031','55051','55053','55020','55043','55054','55041','55068','55049','55048','51017','51030','51100','51036','52046','50053','50060','50050','51035','50059','50135','51034','59015','50034','52037','52033','52020','50052','52021','58022','56041','56048','50021','50028','53040','56030','50020','50051','53011','53036','53035','50065','50031','50030','50063','53037','53030','56045','50041','50066','52026','52024','52025','56020','56036','53018','50022','50027','50100','50018','50125','50134','50019','50010','50123','50061','50129','50121','50122','50055','53031','53100','53010','50025','50026','52022','52027','53019','52100','52040','52010','52023','50012','50023','52016','52014','50054','50015','52043','53013','53017','50033','50032','50038','52048','56128','57016','57023','56027','53049','53045','53023','53020','52028','53024','56032','57012','57020','58024','57025','57022','56043','58036','52015','50068','57021','58037','53015','53012','58020','53047','58016','58015','50064','58043','58100','58044','58038','58033','58042','58046','58014','58054','58019','58017','50039','50056','52044','53043','57031','57039','57037','57010','55047','52047','50062','56046','52041','53048','56035','53034','50139','53014','53041','57027','54033','50136','51015','56025','56028','56037','58010','51011','55062','55013','51010','58051','53026','53022','53042','57128','52035','56034','58023','56040','56042','52045','50240','52031','06010','58011','50014','55040','56038')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('38060','38066','39046','39040','39048','39049','39030','38054','38035','38032','38024','38020','38025','38022','38021','38018','38078','38070','38057','38086','38080','39010','39039','38026','39054')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('06084','05026','06012','06050','06053','05010','06068','05023','06057','06059','06060','06061','06066','06019','06014','06069','06065','06064','06072','06125','06024','06062','06010','05017','05018','05011','06045','05027','06049','06040','06083','06081','06030','06063','05020','06080','06035','06031','06029','06132','05022','05035','05016','06034','05028','05025','06100')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip = '11010' OR user_vacationhomes_housedata.zip = '11012' OR user_vacationhomes_housedata.zip = '11011' OR user_vacationhomes_housedata.zip = '11016' OR user_vacationhomes_housedata.zip = '11013' OR user_vacationhomes_housedata.zip = '11020' OR user_vacationhomes_housedata.zip = '11021' OR user_vacationhomes_housedata.zip = '11018') AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 16
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND (user_vacationhomes_housedata.zip IN ('37060','37010','37019','37018','32022','32040','30020','30021','30017','30016','30010','30100','30124','30123','30121','30122','30012','30030','30173','30125','30135','31021','37129','37121','31015','31058','31022','37138','30034','30035','36020','45010','35017','30013','35030','35031','35038','31039','37011','46044','30133')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_Records->render#770 // tslib_cObj->cObjGetSingle#125 // tslib_cObj->cObjGetSingle#755 // tslib_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_content_ContentObjectArray->render#770 // tslib_cObj->cObjGet#49 // tslib_cObj->cObjGetSingle#717 // tslib_cObj->cObjGetSingle#755 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main# // tx_templavoila_pi1->renderElement#70 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->createSearchForm#144 // vacation_interface->getZoneList#1065 // vacation_interface->searchHouses#1636 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR 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 user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.e' at line 31
lastBuiltQuery SELECT distinct(user_vacationhomes_housedata.uid) as Id,
user_vacationhomes_housedata.name as Name,
user_vacationhomes_housedata.groupcode as GroupCode,
user_vacationhomes_housedata.address as Address,
user_vacationhomes_housedata.town as Town,
user_vacationhomes_housedata.zip as ZipCode,
user_vacationhomes_housedata.country as Country,
user_vacationhomes_housedata.maxpax as MaxSleeps,
user_vacationhomes_housedata.latitude as Latitude,
user_vacationhomes_housedata.longitude as Longitude,
user_vacationhomes_housedata.margin as Margin,
user_vacationhomes_housedata.available_days as AvailableDays,user_vacationhomes_housedata.state as StateProvince,
static_countries.cn_short_local as CountryName,
user_vacationhomes_housedata.minpax as MinSleeps,
user_vacationhomes_housedata.totalbedrooms as TotalBedrooms,
user_vacationhomes_housedata.doublebedrooms as DoubleBedrooms,
user_vacationhomes_housedata.singlebedrooms as SingleBedrooms,
user_vacationhomes_housedata.bathrooms as Bathrooms,
user_vacationhomes_housedata.bathroomsshower as BathroomsShower,
user_vacationhomes_housedata.provhousecode as ProviderHouseCode,
user_vacationhomes_housedata.provhouseurl as ProviderHouseUrl,
user_vacationhomes_housedata.pageviews as PageViews,
user_vacationhomes_housedata.father_and_son as FatherAndSon,
user_vacationhomes_housedata.tstamp as LastUpdate,
user_vacationhomes_housedata.conditions as Conditions,
user_vacationhomes_housedata.ignore_avail_ha as IgnoreAvailHa,
tt_address.user_vacationhomes_logo as OwnerLogo FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.uid = '33638') AND user_vacationhomes_housedata.show_in_home > 0 AND (user_vacationhomes_housedata.owner NOT IN ('71')) AND (user_vacationhomes_housedata.uid NOT IN ('33639','30230','30232','33634','33635','33636','33637','28476','28578','28579','28580','28581','28582','31586','31587','31588','33614','33615','33611','33616','33617','33612','28474','28572','28574','28575','28576','31691','33619','28592','28593','33533','33534')) AND user_vacationhomes_housedata.country = static_countries.cn_iso_3
AND user_vacationhomes_housedata.deleted = 0
AND (user_vacationhomes_housedata.latitude > 0 OR user_vacationhomes_housedata.longitude > 0
OR user_vacationhomes_housedata.latitude < 0 OR user_vacationhomes_housedata.longitude < 0 )
AND tt_address.uid=user_vacationhomes_housedata.owner AND user_vacationhomes_housedata.uid in () AND user_vacationhomes_housedata.hidden = 0 AND user_vacationhomes_housedata.export = 1
debug_backtrace require(rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php),rc-4.5.40/index.php#93 // include(rc-4.5.40/typo3/sysext/cms/tslib/pagegen.php),rc-4.5.40/typo3/sysext/cms/tslib/index_ts.php#451 // TSpagegen::renderContent#76 // tslib_cObj->cObjGet#320 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // tx_templavoila_pi1->main_page# // tx_templavoila_pi1->renderElement#196 // tx_templavoila_pi1->processDataValues#331 // tslib_cObj->cObjGet#605 // tslib_cObj->cObjGetSingle#717 // tslib_content_User->render#770 // tslib_cObj->callUserFunction#56 // call_user_func_array#6428 // user_pluginsmanager_pi1->main# // vacation_interface->searchHouses#144 // vacation_interface->callVHMAPI#763 // call_user_func_array#3033 // vhm_api->listProp# // t3lib_DB->exec_SELECTquery#2123 // t3lib_DB->debug#247
Vacavilla 2019 - Vacavilla 2019

Loading

Great locations in Tuscany and in the more beautiful italian destinations, 40 years of experience, and a very passionate team ready to answer to all your questions make VacaVilla the best villa rentals specialist for booking your holiday in Italy. VacaVilla is an Italian villa rentals specialist that will support you in finding holiday villas and country houses in Italy, in the marvellous regions of Tuscany, Umbria, the Amalfi Coast, Liguria, Veneto, the Garda's, the lakes' region and Sicily.

All our proposals

Holiday villas in Tuscany


Tuscany is one of the most interesting Italian region and one of the main touristic world destinations, thanks to its history, food, wine and medieval villages. The main city is Florence, worldwide famous for its artistic heritage. It is easy to explore it by staying in well-located apartments and villas. Exploring Tuscany means also visiting Pisa and its Leaning Tower, the Chianti region with its renowned wines, Piazza del Campo in Siena, where the historic Palio takes place, and so much more. A variety of Tuscany villas located in the countrysideor near the beaches is the best way to start exploring this amazing region!

Our proposals in Tuscany

Holiday villas on the Amalfi Coast


The Amalfi Coast is one of the most extraordinary locations in Italy, and one of our many UNESCO World Heritage sites. It includes some real gems like Amalfi, the marvellous cathedral of Positano, and Ravello. The Sorrento Peninsula is the best location where you can have a truly Italian experience, by staying in a luxury villa for rent, a nice apartment, or a holiday home, and sipping the delightful Limoncello. This is the land of desserts such as the baba al rum, the delizia al limone (a lemon cream sponge cake) and Pastiera that is usually eaten for Easter. The dreamy Capri Island, located in front of Sorrento, is a great location for an unforgettable trip.

Our proposals on The Amalfi Coast

Holiday villas in Umbria

Located in the heart of the Italian peninsula, the region of Umbria is mainly hill and mountainous, with town and settlements enriched by history and traditions. It is an excellent choice for those who want to try fine wines, while tasting the cuisine that uses farm and natural products. The countryside is a lovely place to relax, especially by staying in a beautiful villa surrounded by a calming nature. There is, however, much to see and discover in Umbria’s main city, Perugia, where a selection of apartment is available to offer tourists a pleasant stay. Of religious and artistic importance is also Assisi, the hometown of the famous Saint Francis.

Our proposals in Umbria

Chianti

The Chianti region extends between the provinces of Florence, Siena and Arezzo and mark the East border of this area with Valdarno and Valdichiana. The region is mainly hilly and the municipalities belonging to this area are part of the production area of the Chianti, a red DOCG wine.

Our proposals in Chianti

San Gimignano - Volterra

The beautiful medieval town is on a hill at 344 m above sea level, It dominates the Val d'Elsa in the province of Siena. Famous for the many high towers which characterize the historic center it is today an international touristic destination and part of it is cultural and natural UNESCO heritage..

Our proposals in San Gimignano - Volterra

Our selections

Pet friendly accomodationPet friendly accomodation

Art citiesArt cities

Seaside holidaysSeaside holidays

Large villasLarge villas

Top quality villaTop quality villa

Our services

Our proposals

This property is not available in the specified period

You may be interested in:

Loading...

About us

VacaVilla is a passionate team, born from the desire to continue on our own a 20 year experience in the holiday home rentals. Our skills, together with the knowledge of the market needs, enable us to offer you a quality, personally picked up selection of villas, apartments, famhouses in the most beautiful Italian destinations.Discover the marvels of Tuscany, from its countryside full of tradition and culture to its uncontaminated sea and the historical cities like Florence, Siena and Pisa rich of works of art.You can even choose many other destinations including Venice, the Amalfi Coast, the Garda Lake and Umbria. Search on line the perfect home for your holidays or contact us if you wish our personal suggestion.

-> To contact us by email click here: info@vacavilla.com

-> If you have a property to offer click here: proprietari@vacavilla.com

If you want to know more about us and what we do visit our blog

Condividi