Column 'currency_id' in where clause is ambiguous (1052)
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = '' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1 AND status IN ('A', 'H') AND currency_id IN (1, 2, 3) ORDER BY a.position
app/Tygh/Database/Connection.php, line: 1139
| File: | app/Tygh/Database/Connection.php |
| Line: | 503 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 261 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 44 |
| Function: | getHash |
| File: | app/functions/fn.common.php |
| Line: | 6157 |
| Function: | db_get_hash_array |
| File: | app/functions/fn.init.php |
| Line: | 471 |
| Function: | fn_get_currencies_list |
| File: | app/functions/fn.init.php |
| Line: | 1085 |
| Function: | fn_init_currency |
| File: | init.php |
| Line: | 217 |
| Function: | fn_init |
| File: | index.php |
| Line: | 24 |
| Function: | require |