|
|
| Ligne 1 : |
Ligne 1 : |
| − | | + | {{#tag:slippymap| |
| − | | + | |lat=40.69052122695 |
| − | {{Personnes
| + | |lon=-74.039214998645 |
| − | |id=1
| + | |z=12 |
| − | |prenom=Jean
| + | |h=300 |
| − | |nom=Dupont
| + | |w=450 |
| − | |ami=2
| + | |layer=mapnik |
| − | }}
| + | |marker=1 |
| − | {{Personnes
| |
| − | |id=2
| |
| − | |prenom=Jeanne
| |
| − | |nom=Dupont
| |
| − | |ami=1
| |
| − | }}
| |
| − | {{Personnes
| |
| − | |id=3
| |
| − | |prenom=Pierre
| |
| − | |nom=Dupont
| |
| − | |ami=1
| |
| − | }}
| |
| − | {{Personnes
| |
| − | |id=4
| |
| − | |prenom=Pierre
| |
| − | |nom=Dubois
| |
| − | |ami=1
| |
| − | }}
| |
| − | {{Personnes
| |
| − | |id=5
| |
| − | |prenom=Lucien
| |
| − | |nom=Dubois
| |
| − | |ami=4
| |
| − | }}
| |
| − | {{Relations
| |
| − | |id1=1
| |
| − | |id2=2
| |
| − | |nature=epoux
| |
| − | }}
| |
| − | {{Relations
| |
| − | |id1=1
| |
| − | |id2=3
| |
| − | |nature=collegues
| |
| − | }}
| |
| − | {{Relations
| |
| − | |id1=3
| |
| − | |id2=5
| |
| − | |nature=collegues
| |
| − | }}
| |
| − | {{Relations
| |
| − | |id1=4
| |
| − | |id2=5
| |
| − | |nature=collegues
| |
| − | }}
| |
| − | | |
| − | {{#cargo_query:tables=Personnes=P1,Personnes=P2 | |
| − | |join on=P1.id=P2.ami | |
| − | |fields=P2.id,P2.prenom,P2.nom | |
| − | |where=P1.prenom="Jean" | |
| − | |group by=P2.id | |
| − | }}
| |
| − | | |
| − | {{#cargo_query:tables=Personnes=P1,Personnes=P2,Relations
| |
| − | |join on=P1.id=Relations.id1,P2.id=Relations.id2 | |
| − | |fields=P2.id,P2.prenom,P2.nom,Relations.nature,Relations.id1,Relations.id2 | |
| − | |where=Relations.nature="collegues" AND P1.prenom="Lucien" AND P1.id=Relations.id1 AND P2.id=Relations.id2 | |
| − | | |
| | }} | | }} |
Version du 13 septembre 2018 à 17:23
<slippymap lat="40.69052122695" lon="-74.039214998645" z="12" h="300" w="450" layer="mapnik" marker="1">
</slippymap>
