SELECTCONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency` FROM `jx1a3_virtuemart_vendors` WHERE `virtuemart_vendor_id`=1

SELECT `virtuemart_currency_id`,CONCAT_WS(" ",`currency_name`,`currency_symbol`) as currency_txt
FROM `jx1a3_virtuemart_currencies` WHERE `virtuemart_currency_id` IN (47,144,47) and (`virtuemart_vendor_id` = "1" OR `shared`="1") AND published = "1" ORDERBY `ordering`,`currency_name`

SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code` FROM `jx1a3_virtuemart_vendors` AS v
LEFTJOIN `jx1a3_virtuemart_currencies` AS c ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"