| 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.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.uid IN (28597,28782,28790,28935,28937,29455,29461,30315,30316,30534,30833,31215,31506,32133,32143,32147,32151,32152,32153,32165,32171,32183,32184,32186,32187,33110,33236,33323,33441,33507,33508,33606,33607,33608,33609,33626,33627,33628,33629,33638,33642,33645,33646,33647,33648,33657,33659,33661,33675,33676,33682,33683,33689,33690,33691,33696,33699,33706,33707,33708,33716,33723,33742,33755,33775,33778,33779,33782,33784,33791,33792,33799,33800,33801,33804,33805,33806,33807,33810,33813,33814,33816,33817,33820,33822,33824,33828,33830,33836,33837,33838,33839,33844,33846,33847,33849,33851,33853,33854,33855,33859,33861,33864,33865,33870,33873,33880,33886,33887,33888,33889,33890,33891,33892,33893,33894,33896,33897,33898,33902,33906,33908,33909,33910,33912,33913,33916,33919,33920,33922,33924,33925,33926,33931,33934,33937,33941,33949,33950,33951,33956,33957,33958,33959,33962,33965,33980,33982,33983,33984,33985,33987,33989,33991,33992,34000,34002,34003,34010,34018,34022,34024,34028,34030,34042,34046,34052,34058,34060,34062,34064,34084,34090,34092,34157,34159,34163,34171,34177,34181,34203,34207,34209,34215,34221,34227,34235,34236,34240,34242,34244,34251,34256,34257,34259,34260,34266,34267,34271,34273,34274,34275,34276,34281,34288,34290,34291,34292,34293,34294,34295,34302,34305,34309,34321,34322,34326,34328,34329,34337,34339,34340,34342,34343,34344,34346,34349,34351,34354,34365,34372,34373,34374,34375,34380,34381,34387,34388,34391,34394,34395,34396,34403,34406,34410,34441,34442,34454,34463,34464,34469,34470,34471,34473,34474,34501,34507,34514,34528,34544,34546,34547,34548,34549) 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
|
|
