| 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 (15065,28468,28470,28472,28476,28569,28578,28579,28580,28581,28582,28585,28588,28590,28595,28597,28782,28783,28785,28786,28789,28790,28791,28935,28936,28937,29231,29235,29236,29237,29238,29239,29240,29241,29242,29244,29461,29463,29651,29654,30229,30230,30231,30232,30315,30316,30434,30534,30833,30834,30835,30836,30952,31163,31164,31165,31166,31213,31214,31215,31261,31262,31263,31264,31265,31266,31267,31268,31269,31270,31271,31407,31433,31434,31435,31436,31437,31438,31439,31448,31508,31557,31616,31617,31618,31619,31719,31720,31721,31722,31812,32125,32126,32127,32128,32129,32130,32131,32132,32133,32134,32135,32136,32137,32138,32139,32140,32141,32142,32143,32152,32153,32154,32157,32158,32159,32160,32176,32183,32184,32186,32187,32188,32189,32191,32192,32193,32194,32195,32196,32197,32198,32199,32200,32202,32204,32206,32207,32208,32209,32210,32211,32213,32214,32215,32216,32224,32225,32226,32227,32228,32229,32230,32967,32968,32969,32970,32971,32973,32974,32998,33053,33094,33095,33096,33104,33110,33111,33112,33145,33146,33147,33148,33188,33225,33236,33256,33266,33271,33273,33274,33323,33428,33441,33459,33467,33485,33486,33487,33488,33489,33490,33491,33494,33495,33496,33497,33498,33500,33501,33502,33503,33506,33509,33510,33511,33512,33513,33515,33516,33517,33518,33519,33520,33521,33522,33523,33524,33525,33526,33527,33528,33529,33530,33531,33532,33533,33534,33537,33538,33619,33620,33623,33624,33625,33626,33627,33628,33629,33638,33641,33642,33643,33647,33650,33659,33660,33661,33674,33676,33677,33679,33681,33682,33683,33685,33686,33687,33688,33690,33691,33694,33695,33696,33705,33706,33707,33708,33709,33710,33711,33712,33713,33714,33715,33717,33718,33719,33720,33721,33722,33723,33724,33725,33726,33727,33728,33729,33730,33731,33732,33733,33734,33735,33736,33737,33738,33739,33740,33742,33748,33749,33753,33754,33755,33756,33758,33763,33764,33765,33768,33769,33770,33771,33772,33774,33775,33776,33777,33778,33782,33783,33784,33785,33786,33787,33788,33789,33790,33791,33792,33793,33795,33796,33797,33798,33799,33800,33801,33802,33803,33804,33805,33807,33808,33809,33810,33811,33812,33813,33816,33817,33818,33819,33820,33821,33822,33823,33824,33825,33826,33827,33828,33829,33830,33831,33832,33833,33834,33835,33836,33838,33839,33842,33843,33844,33846,33847,33848,33849,33850,33851,33852,33853,33854,33855,33856,33857,33858,33859,33860,33861,33862,33863,33864,33865,33866,33867,33868,33869,33870,33871,33872,33873,33874,33875,33876,33877,33878,33879,33881,33882,33883,33884,33885,33886,33887,33888,33889,33890,33891,33892,33893,33894,33895,33896,33897,33898,33899,33900,33901,33902,33903,33904,33905,33906,33907,33908,33910,33911,33912,33913,33914,33915,33916,33917,33918,33919,33920,33921,33922,33924,33925,33926,33927,33928,33929,33930,33931,33932,33934,33935,33936,33937,33939,33940,33942,33944,33945,33946,33947,33948,33949,33950,33951,33952,33953,33954,33955,33956,33957,33958,33959,33960,33961,33962,33963,33964,33966,33967,33968,33980,33981,33982,33983,33984,33985,33986,33987,33988,33989,33990,33991,33992,33993,33994,33995,33996,33997,33998,33999,34000,34001,34002,34003,34004,34006,34008,34010,34040,34042,34046,34050,34052,34054,34056,34058,34060,34068,34070,34072,34074,34076,34078,34080,34082,34084,34086,34088,34094,34096,34098,34100,34102,34104,34114,34116,34118,34120,34121,34157,34161,34165,34167,34177,34179,34181,34187,34203,34207,34209,34211,34213,34215,34221,34223,34225,34227,34229,34231,34233,34234,34235,34236,34237,34239,34242,34243,34245,34246,34247,34248,34249,34250,34251,34252,34253,34254,34255,34256,34257,34258,34259,34260,34261,34262,34263,34264,34265,34266,34267,34268,34269,34270,34271,34272,34273,34274,34275,34276,34277,34278,34279,34280,34281,34282,34289,34290,34292,34293,34294,34295,34296,34298,34299,34305,34306,34307,34308,34309,34310,34312,34313,34314,34315,34316,34317,34318,34319,34322,34323,34324,34325,34326,34327,34328,34329,34330,34331,34332,34333,34334,34335,34336,34337,34338,34339,34340,34341,34342,34343,34344,34345,34346,34347,34348,34349,34350,34351,34352,34353,34354,34365,34366,34367,34372,34373,34375,34376,34377,34378,34379,34380,34381,34382,34383,34384,34385,34386,34387,34388,34389,34390,34391,34392,34393,34394,34395,34396,34397,34398,34399,34400,34401,34402,34403,34404,34408,34409,34410,34411,34412,34413,34414,34415,34416,34417,34418,34419,34420,34421,34423,34424,34426,34427,34428,34429,34430,34432,34433,34434,34435,34436,34437,34438,34439,34440,34441,34443,34449,34450,34451,34453,34456,34457,34458,34459,34460,34461,34462,34463,34464,34465,34466,34467,34469,34470,34471,34473,34474,34475,34476,34477,34478,34480,34481,34482,34483,34484,34485,34486,34487,34488,34489,34490,34491,34492,34495,34496,34498,34499,34500,34501,34503,34504,34505,34506,34508,34512,34513,34514,34515,34516,34517,34519,34520,34521,34522,34523,34524,34525,34526,34527,34529,34530,34534,34535,34536,34541,34543,34544,34545,34546,34547,34548,34549,34550,34551,34552,34553,34554,34555,34556,34557,34558,34559,34560,34562,34563,34565) 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
|
|
