1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT dos.id AS "did dossier client",
ent.id AS "eid dossier entretien",
prs.id AS "peid prestation",
prs.prestation_name,
rel.collab_id
FROM client.cli_dossier
AS dos
INNER JOIN client.cli_dossier_prestation_rel
AS rel
ON rel.dossier_id = dos.id
INNER JOIN client.cli_prestation
AS prs
ON prs.id = rel.prestation_id
LEFT OUTER JOIN client.cli_dossier_entretien
AS ent
ON ent.dossier_id = dos.id
WHERE rel.collab_id = 236
AND prs.id = 5
AND (ent.mode_id = 1 OR ent.mode_id is null)
AND ( ent.entretien_date BETWEEN '2015-01-01' AND '2015-07-31'
OR ent.entretien_date is null) |
Partager