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') ORDER BY a.position
| File: | app/Tygh/Database.php |
| Line: | 333 |
| Function: | _error |
| File: | app/Tygh/Database.php |
| Line: | 136 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 42 |
| Function: | getHash |
| File: | app/functions/fn.common.php |
| Line: | 5443 |
| Function: | db_get_hash_array |
| File: | app/functions/fn.init.php |
| Line: | 421 |
| Function: | fn_get_currencies_list |
| File: | app/functions/fn.init.php |
| Line: | 928 |
| Function: | fn_init_currency |
| File: | init.php |
| Line: | 131 |
| Function: | fn_init |
| File: | index.php |
| Line: | 24 |
| Function: | require |