| 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 IN (28584,28594,29245,29455,29456,29457,29458,29459,29460,29553,29554,29555,29556,29557,29560,29561,29562,29563,29645,29647,29648,29757,29758,29759,29760,29928,29929,29930,29931,29932,29933,30062,30139,30140,30141,30228,30313,31689,31690,31691,31692,31693,31779,31780,31781,31782,31784,31785,31786,31787,31789,31802,31803,31804,31806,31807,31808,31809,31810,31814,31815,31816,31817,31818,31820,31821,31822,31823,31824,31825,31826,32114,32115,32116,32117,32118,32119,32120,32121,32122,32123,32124,32133,32177,32178,32179,32180,32181,32182,32188,32189,32190,32191,32192,32193,32194,32195,32196,32197,32198,32199,32200,32202,32203,32204,32205,32206,32207,32208,32209,32210,32212,32214,32215,32216,32230,32967,32968,32969,32970,32971,32997,33093,33094,33112,33113,33188,33225,33485,33486,33487,33488,33489,33490,33491,33494,33495,33496,33497,33498,33506,33509,33510,33511,33512,33513,33530,33531,33532,33533,33534,33606,33607,33609,33610,33611,33612,33613,33614,33615,33616,33617,33618,33619,33620,33621,33630,33633,33649,33650,33667,33668,33672,33673,33679,33684,33689,33693,33716,33746,33747,33750,33751,33756,33763,33764,33776,33780,33783,33785,33786,33787,33840,33845,33877,33881,33882,33884,33888,33889,33890,33896,33897,33898,33904,33905,33906,33911,33917,33918,33924,33934,33940,33941,33960,33966,34020,34026,34030,34032,34034,34046,34052,34064,34068,34090,34100,34106,34108,34110,34112,34122,34126,34128,34129,34131,34133,34135,34137,34139,34141,34143,34145,34147,34149,34151,34153,34155,34161,34163,34173,34187,34193,34195,34197,34199,34201,34203,34217,34219,34221,34227,34229,34231,34233,34235,34236,34252,34254,34256,34257,34266,34274,34282,34284,34285,34286,34287,34288,34289,34290,34297,34300,34301,34302,34303,34304,34309,34313,34320,34321,34324,34327,34328,34333,34334,34335,34336,34338,34355,34356,34357,34358,34359,34360,34361,34362,34363,34364,34372,34377,34378,34386,34400,34401,34407,34409,34420,34441,34458,34461,34488,34494,34497,34513,34515,34516,34521,34525,34540) 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_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
|
|
