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 'GROUP BY product_id, profile_id' at line 1 (1064)
SELECT item_key, product_id, COUNT(DISTINCT wishlist_id) AS product_total_wishlist FROM cscart_sb_multi_wishlist_products WHERE 1 AND GROUP BY product_id, profile_id
app/Tygh/Database/Connection.php, line: 1712
| File: | app/Tygh/Database/Connection.php |
| Line: | 1489 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 699 |
| Function: | execQuery |
| File: | app/Tygh/Database/Connection.php |
| Line: | 370 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 48 |
| Function: | getHash |
| File: | app/addons/sb_multi_wishlist/func.php |
| Line: | 174 |
| Function: | db_get_hash_array |
| File: | app/addons/sb_multi_wishlist/func.php |
| Line: | 245 |
| Function: | fn_sb_get_product_wishlist |
| File: | app/addons/sb_multi_wishlist/controllers/frontend/init.post.php |
| Line: | 6 |
| Function: | fn_sb_get_compare_state |
| File: | app/functions/fn.control.php |
| Line: | 724 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 458 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |