Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT `country_name`, `country_region`
FROM `#__comprofiler_countries`
ORDER BY `country_region`, `country_name`
Value Column: country_name
Label Column: country_name
Group Column: country_region
SELECT p.`province_iso_code`, p.`province_name`
FROM `#__comprofiler_provinces` AS p
LEFT JOIN `#__comprofiler_countries` AS c
ON c.`country_iso_code2` = p.`country_iso_code2`
WHERE c.`country_name` = '[cb_billingcountry]'
ORDER BY p.`province_latin_name` asc
Please Log in to join the conversation.