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: | app/addons/discussion/controllers/common/discussion.php |
| Line: | 250 |
| Function: | fn_get_discussion |
| File: | app/functions/fn.control.php |
| Line: | 608 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 391 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 25 |
| Function: | fn_dispatch |