SELECT
CONCAT( IF(a.org_name_display<>'',a.org_name_display,a.org_name),' (',a.org_city,', ',b.name,')') as name,
a.id as id
FROM wukrp_cmd_systems_masterorg as a
LEFT JOIN wukrp_cmd_systems_state as b on a.org_state_id = b.id
WHERE a.org_state_id = '[cb_parish_state]'
ORDER BY a.org_name
SELECT CONCAT(`name`,' (', `abbrev`,')') AS label, id
FROM wukrp_cmd_systems_state
WHERE `country` = '[cb_parish_country]'
ORDER BY `name`
SELECT `name`, id
FROM wukrp_cmd_systems_country
ORDER BY `ordering`, `name`
SELECT
CONCAT(t1.org_name,' (',t1.org_city,', ',t2.abbrev,')') as 'generated_orgname',
t1.id as valueid
FROM wukrp_cmd_systems_organization AS t1
LEFT JOIN wukrp_cmd_systems_state AS t2 ON t1.org_state_id = t2.id
WHERE t1.master_org_id = '[cb_parish_archdiocese]'
ORDER BY t1.org_name
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.
Please Log in to join the conversation.