| 1 |
select people.name, fname, work, grade, |
| 2 |
jobl.start, jobl.end, |
| 3 |
thesisl.title as titre_these, thesisl.dates as soutenance, |
| 4 |
university_teacherl.university, university_teacherl.start as debut_enseignement, |
| 5 |
university_teacherl.end as fin_enseignement, |
| 6 |
university_teacherl.teachtype as type_enseignement, |
| 7 |
organisationl.orgname as organisation, |
| 8 |
organisationl.start as debut_participation_orga, |
| 9 |
organisationl.end as fin_participation_orga, |
| 10 |
academyl.name as academie, |
| 11 |
academyl.datea as date_academie, |
| 12 |
awardsl.title as prix, |
| 13 |
awardsl.datea as date_prix, |
| 14 |
medall.kind as type_medaille, |
| 15 |
medall.datem as date_medaille, |
| 16 |
distinctionsl.name as distinction, |
| 17 |
distinctionsl.dated as date_distinction, |
| 18 |
case when people_infol.death is true then 'décédé ' || |
| 19 |
case when people_infol.death_date is null then '' else people_infol.death_date::text end |
| 20 |
else '' end, |
| 21 |
people_infol.comment, |
| 22 |
addressl.mobile_phone, |
| 23 |
addressl.email, |
| 24 |
addressl.address, |
| 25 |
addressl.postal, |
| 26 |
addressl.city, |
| 27 |
addressl.country |
| 28 |
|
| 29 |
from people left join people_infol |
| 30 |
on people_infol.people = people.id |
| 31 |
left join jobl on people.id = jobl.people |
| 32 |
left join thesisl on thesisl.people = people.id |
| 33 |
left join university_teacherl on university_teacherl.people = people.id |
| 34 |
left join organisationl on organisationl.people = people.id |
| 35 |
left join academyl on academyl.people = people.id |
| 36 |
left join awardsl on awardsl.people = people.id |
| 37 |
left join medall on medall.people = people.id |
| 38 |
left join distinctionsl on distinctionsl.people = people.id |
| 39 |
left join addressl on addressl.people = people.id |
| 40 |
|
| 41 |
order by people.name, fname |
Parent Directory
| 
Revision Log