- UPPER(pje.name), pa.postalText, pa.long_name AS postal_code, p.email_directory
- FROM (SELECT pa.pid, pa.postalText, pa.jobid, pa.groupid, pa.type, pa.id, pace.long_name
- FROM profile_addresses AS pa
- LEFT JOIN profile_addresses_components AS pac ON (pa.pid = pac.pid
- AND pa.jobid = pac.jobid
- AND pa.groupid = pac.groupid
- AND pa.type = pac.type
- AND pa.id = pac.id)
- LEFT JOIN profile_addresses_components_enum AS pace ON (pac.component_id = pace.id
- AND FIND_IN_SET('postal_code', pace.types))
- WHERE pa.pub IN ('public', 'ax') AND FIND_IN_SET('mail', pa.flags) AND pa.pid IN {?}
- ORDER BY pa.pid, NOT FIND_IN_SET('current', pa.flags),
- FIND_IN_SET('secondary', pa.flags), pa.type = 'job',
- pace.long_name IS NULL) AS pa
+ UPPER(pje.name), pa.postalText, pa.postal_code_fr AS postal_code, p.email_directory
+ FROM (SELECT pid, postalText, jobid, groupid, type, id, postal_code_fr
+ FROM profile_addresses
+ WHERE pub IN ('public', 'ax') AND FIND_IN_SET('mail', flags) AND pid IN {?}
+ ORDER BY pid, NOT FIND_IN_SET('current', flags),
+ FIND_IN_SET('secondary', flags), type = 'job') AS pa