| 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 37
|
| 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,truncate(acos(
cos(radians( user_vacationhomes_housedata.latitude))
* cos(radians( 43.391700 ))
* cos(radians( user_vacationhomes_housedata.longitude ) - radians( 10.748069 ))
+ sin(radians( user_vacationhomes_housedata.latitude ))
* sin(radians( 43.391700 ))
)*6371,2) AS DistanceFromPoint FROM user_vacationhomes_housedata,static_countries,tt_address WHERE (user_vacationhomes_housedata.zip = '56037' OR user_vacationhomes_housedata.zip = '50051' OR user_vacationhomes_housedata.zip = '50050' OR user_vacationhomes_housedata.zip = '50052' OR user_vacationhomes_housedata.zip = '53031' OR user_vacationhomes_housedata.zip = '53037' OR user_vacationhomes_housedata.zip = '56041' OR user_vacationhomes_housedata.zip = '56048' OR user_vacationhomes_housedata.zip = '56030' OR user_vacationhomes_housedata.zip = '56040') AND user_vacationhomes_housedata.latitude > 0 AND user_vacationhomes_housedata.longitude > 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 = 'ITA') 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_content_Case->render#770 // tslib_cObj->cObjGetSingle#53 // tslib_cObj->cObjGetSingle#755 // 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
|
|
