- $res = XDB::query('SELECT p.*, pe.entry_year, pe.grad_year,
- pns_f.name AS firstname, pns_l.name AS lastname, pns_n.name AS nickname,
- IF(pns_uf.name IS NULL, pns_f.name, pns_uf.name) AS firstname_usual,
- IF(pns_ul.name IS NULL, pns_l.name, pns_ul.name) AS lastname_usual,
+ $res = XDB::query('SELECT p.*, p.sex = \'female\' AS sex, pe.entry_year, pe.grad_year,
+ pn_f.name AS firstname, pn_l.name AS lastname, pn_n.name AS nickname,
+ IF(pn_uf.name IS NULL, pn_f.name, pn_uf.name) AS firstname_usual,
+ IF(pn_ul.name IS NULL, pn_l.name, pn_ul.name) AS lastname_usual,