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`