exec_SELECTquery
caller TYPO3\CMS\Core\Database\DatabaseConnection::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 tx_obladyimmo_ads.pid = 21 ORDER BY tx_obladyimmo_ads.crdate DESC' at line 22
lastBuiltQuery SELECT
tx_obladyimmo_ads.*,
tx_obladyimmo_contact_type.title as contact_type_title,
tx_obladyimmo_geographic_sector.title as sector_title,
tx_obladyimmo_geographic_sector.entity,
tx_obladyimmo_entity.name as entity_name,
tx_obladyimmo_ads.entity as entity_uid,
tx_obladyimmo_type.title as type_title,
tx_obladyimmo_city.name as city_name,
tx_obladyimmo_city.zip as city_zip,
tx_obladyimmo_zae.name as zae_name,
tx_obladyimmo_state.title as state_title,
tx_obladyimmo_status.title as status_title FROM tx_obladyimmo_ads
LEFT JOIN tx_obladyimmo_group ON tx_obladyimmo_ads.groups = tx_obladyimmo_group.uid
LEFT JOIN tx_obladyimmo_state ON tx_obladyimmo_ads.state = tx_obladyimmo_state.uid
LEFT JOIN tx_obladyimmo_status ON tx_obladyimmo_ads.status = tx_obladyimmo_status.uid
LEFT JOIN tx_obladyimmo_zae ON tx_obladyimmo_ads.zae = tx_obladyimmo_zae.uid
LEFT JOIN tx_obladyimmo_city ON tx_obladyimmo_ads.city = tx_obladyimmo_city.uid
LEFT JOIN tx_obladyimmo_type ON tx_obladyimmo_ads.type_of_product = tx_obladyimmo_type.uid
LEFT JOIN tx_obladyimmo_entity ON tx_obladyimmo_ads.entity = tx_obladyimmo_entity.uid
LEFT JOIN tx_obladyimmo_contact_type ON tx_obladyimmo_ads.contact_type = tx_obladyimmo_contact_type.uid
LEFT JOIN tx_obladyimmo_geographic_sector ON tx_obladyimmo_ads.geographic_sector = tx_obladyimmo_geographic_sector.uid WHERE tx_obladyimmo_ads.deleted = 0 AND tx_obladyimmo_ads.uid = AND tx_obladyimmo_ads.pid = 21 ORDER BY tx_obladyimmo_ads.crdate DESC
debug_backtrace require(rc-6.2.17/typo3/sysext/cms/tslib/index_ts.php),rc-6.2.17/index.php#28 // TYPO3\CMS\Frontend\Page\PageGenerator::renderContent#212 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#215 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#697 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6665 // TYPO3\CMS\Extbase\Core\Bootstrap->run# // TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest#184 // TYPO3\CMS\Extbase\Mvc\Web\FrontendRequestHandler->handleRequest#195 // TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch#56 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest#69 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod#157 // call_user_func_array#286 // FluidTYPO3\Flux\Controller\AbstractFluxController->renderAction# // FluidTYPO3\Flux\Controller\AbstractFluxController->performSubRendering#217 // TYPO3\CMS\Fluid\View\AbstractTemplateView->render#247 // FluidCache_Sommedopext_Page_layout_Page_c49c83e6fcbb755fd0e2b90ca763f36b575a12b7->render#182 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initializeArgumentsAndRender#54 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->callRenderMethod#230 // call_user_func_array#248 // TYPO3\CMS\Fluid\ViewHelpers\RenderViewHelper->render# // TYPO3\CMS\Fluid\View\AbstractTemplateView->renderSection#90 // FluidCache_Sommedopext_Page_action_index_e95750f23089c93c3ea644395a2eff45da296451->section_62bce9422ff2d14f69ab80a154510232fc8a9afd#222 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initializeArgumentsAndRender#451 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->callRenderMethod#230 // call_user_func_array#248 // FluidTYPO3\Vhs\ViewHelpers\Content\RenderViewHelper->render# // FluidTYPO3\Vhs\ViewHelpers\Content\AbstractContentViewHelper->getContentRecords#45 // FluidTYPO3\Vhs\ViewHelpers\Content\AbstractContentViewHelper->getRenderedRecords#79 // FluidTYPO3\Vhs\ViewHelpers\Content\AbstractContentViewHelper->renderRecord#158 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#190 // TYPO3\CMS\Frontend\ContentObject\RecordsContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#119 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#734 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#45 // TYPO3\CMS\Frontend\ContentObject\ContentObjectArrayContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#40 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#697 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#45 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#734 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6665 // tx_obladyimmo_pi1->main# // tx_obladyimmo_pi1->_view_SINGLE#102 // tx_obladyimmo_ads->_getList#1014 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#277 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305