SELECT AVG(a.rating_value) as val FROM cscart_discussion_rating as a LEFT JOIN cscart_discussion_posts as b ON a.post_id = b.post_id WHERE a.thread_id = 31 AND b.status = 'A' AND a.rating_value > 0
| File: | app/Tygh/Database.php |
| Line: | 331 |
| Function: | _error |
| File: | app/Tygh/Database.php |
| Line: | 176 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 66 |
| Function: | getField |
| File: | app/addons/discussion/func.php |
| Line: | 369 |
| Function: | db_get_field |
| File: | app/addons/discussion/func.php |
| Line: | 83 |
| Function: | fn_get_average_rating |
| File: | var/cache/templates/basic/ace8ed99dc2abf07b59510d7754c3261bded736a.tygh.testimonials.tpl.php |
| Line: | 91 |
| Function: | fn_get_discussion |
| File: | app/lib/other/smarty/sysplugins/smarty_internal_templatebase.php |
| Line: | 182 |
| Function: | content_63f7314d473998_60572402 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 70 |
| Function: | fetch |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 409 |
| Function: | fetch |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 309 |
| Function: | renderBlockContent |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 250 |
| Function: | renderBlock |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 212 |
| Function: | renderBlocks |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 174 |
| Function: | _renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 138 |
| Function: | _renderContainer |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 47 |
| Function: | render |
| File: | var/cache/templates/basic/d36447f286902705e87e0174b7490beed87a47f8.tygh.index.tpl.php |
| Line: | 120 |
| Function: | smarty_function_render_location |
| File: | app/lib/other/smarty/sysplugins/smarty_internal_templatebase.php |
| Line: | 182 |
| Function: | content_63f7314aae7198_93342442 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 70 |
| Function: | fetch |
| File: | app/lib/other/smarty/sysplugins/smarty_internal_templatebase.php |
| Line: | 377 |
| Function: | fetch |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 54 |
| Function: | display |
| File: | app/functions/fn.control.php |
| Line: | 541 |
| Function: | display |
| File: | index.php |
| Line: | 25 |
| Function: | fn_dispatch |