| function/mode |
Pg100 exec_SELECT_mm_query(tx_itacademyis_domain_model_kurz,tx_itacademyis_kurz_termin_mm,tx_itacademyis_domain_model_termin) - class.tx_typo3eshop_pi1.php#186->eshop_basket_show // class.tx_typo3eshop_pi2.php#112->exec_SELECT_mm_query // class.ux_t3lib_db.php#289->exec_SELECTquery
|
| $query |
SELECT tx_itacademyis_domain_model_termin.uid AS uid,
tx_itacademyis_domain_model_termin.state AS state,
tx_itacademyis_domain_model_termin.start_date AS start_date,
tx_itacademyis_domain_model_termin.end_date AS end_date,
tx_itacademyis_domain_model_termin.name AS term_name,
tx_itacademyis_domain_model_kurz.uid AS course_uid,
tx_itacademyis_domain_model_kurz.name AS course_name,
tx_itacademyis_domain_model_kurz.short_name AS course_short_name,
tx_itacademyis_domain_model_kurz.image AS course_image,
tx_itacademyis_domain_model_kurz.duration AS course_duration,
tx_itacademyis_domain_model_kurz.price AS price,
TIMESTAMPDIFF(HOUR,NOW(), FROM_UNIXTIME(tx_itacademyis_domain_model_termin.start_date)) AS course_due_date_hours,
TIMESTAMPDIFF(DAY, NOW(), FROM_UNIXTIME(tx_itacademyis_domain_model_termin.start_date)) AS course_due_date,
TIMESTAMPDIFF(DAY, DATE(NOW()), DATE(FROM_UNIXTIME(tx_itacademyis_domain_model_termin.start_date))) AS course_due_date_days,
tx_itacademyis_domain_model_termin.type AS type,
tx_itacademyis_domain_model_termin.flags AS flags,
tx_itacademyis_domain_model_kurz.price*(100-tx_itacademyis_domain_model_termin.discount)*0.01 as price_after_discount,
tx_itacademyis_domain_model_termin.discount as discount,
tx_itacademyis_domain_model_termin.final_price as final_price
FROM tx_itacademyis_domain_model_kurz,tx_itacademyis_kurz_termin_mm,tx_itacademyis_domain_model_termin
WHERE
tx_itacademyis_domain_model_kurz.uid=tx_itacademyis_kurz_termin_mm.uid_local AND tx_itacademyis_domain_model_termin.uid=tx_itacademyis_kurz_termin_mm.uid_foreign AND tx_itacademyis_domain_model_termin.uid=vzdelavanie
ORDER BY tx_itacademyis_domain_model_termin.start_date DESC
LIMIT 1
|
| SQL ERROR = |
Unknown column 'vzdelavanie' in 'where clause'
|
| lastBuiltQuery |
SELECT tx_itacademyis_domain_model_termin.uid AS uid,
tx_itacademyis_domain_model_termin.state AS state,
tx_itacademyis_domain_model_termin.start_date AS start_date,
tx_itacademyis_domain_model_termin.end_date AS end_date,
tx_itacademyis_domain_model_termin.name AS term_name,
tx_itacademyis_domain_model_kurz.uid AS course_uid,
tx_itacademyis_domain_model_kurz.name AS course_name,
tx_itacademyis_domain_model_kurz.short_name AS course_short_name,
tx_itacademyis_domain_model_kurz.image AS course_image,
tx_itacademyis_domain_model_kurz.duration AS course_duration,
tx_itacademyis_domain_model_kurz.price AS price,
TIMESTAMPDIFF(HOUR,NOW(), FROM_UNIXTIME(tx_itacademyis_domain_model_termin.start_date)) AS course_due_date_hours,
TIMESTAMPDIFF(DAY, NOW(), FROM_UNIXTIME(tx_itacademyis_domain_model_termin.start_date)) AS course_due_date,
TIMESTAMPDIFF(DAY, DATE(NOW()), DATE(FROM_UNIXTIME(tx_itacademyis_domain_model_termin.start_date))) AS course_due_date_days,
tx_itacademyis_domain_model_termin.type AS type,
tx_itacademyis_domain_model_termin.flags AS flags,
tx_itacademyis_domain_model_kurz.price*(100-tx_itacademyis_domain_model_termin.discount)*0.01 as price_after_discount,
tx_itacademyis_domain_model_termin.discount as discount,
tx_itacademyis_domain_model_termin.final_price as final_price
FROM tx_itacademyis_domain_model_kurz,tx_itacademyis_kurz_termin_mm,tx_itacademyis_domain_model_termin
WHERE
tx_itacademyis_domain_model_kurz.uid=tx_itacademyis_kurz_termin_mm.uid_local AND tx_itacademyis_domain_model_termin.uid=tx_itacademyis_kurz_termin_mm.uid_foreign AND tx_itacademyis_domain_model_termin.uid=vzdelavanie
ORDER BY tx_itacademyis_domain_model_termin.start_date DESC
LIMIT 1
|
| debug_backtrace |
require(typo3/sysext/cms/tslib/index_ts.php),index.php#79 // include(typo3/sysext/cms/tslib/pagegen.php),typo3/sysext/cms/tslib/index_ts.php#353 // TSpagegen::renderContent#74 // tslib_cObj->cObjGet#259 // tslib_cObj->cObjGetSingle#562 // tslib_content_Template->render#615 // tslib_cObj->cObjGetSingle#189 // tslib_content_ContentObjectArray->render#615 // tslib_cObj->cObjGet#48 // tslib_cObj->cObjGetSingle#562 // tslib_content_Content->render#615 // tslib_cObj->cObjGetSingle#140 // tslib_content_Case->render#615 // tslib_cObj->cObjGetSingle#52 // tslib_content_ContentObjectArray->render#615 // tslib_cObj->cObjGet#48 // tslib_cObj->cObjGetSingle#562 // tslib_content_Case->render#615 // tslib_cObj->cObjGetSingle#52 // tslib_cObj->cObjGetSingle#600 // tslib_content_User->render#615 // tslib_cObj->callUserFunction#55 // call_user_func_array#6584 // tx_typo3eshop_pi1->main# // tx_typo3eshop_pi1->eshop_basket#143 // tx_typo3eshop_pi2->eshop_basket_show#186 // ux_t3lib_DB->exec_SELECT_mm_query#112 // ux_t3lib_DB->exec_SELECTquery#289 // ux_t3lib_DB->myDebug#247
|
| miliseconds |
1.546
|