[2022-05-09 12:23:34] local.INFO: select intervention.*, sign.sig_socialReason, site.sit_name, site.sit_code, activity.act_nameFr, users.name as username,  provider.pro_socialReason, status.sta_nameFr, status.sta_sitNameFr, status.sta_proNameFr from `intervention` left join `sign` on `sign`.`sig_id` = `intervention`.`sig_id` left join `status` on `status`.`sta_id` = `intervention`.`sta_id` left join `site` on `site`.`sit_id` = `intervention`.`sit_id` left join `users` on `users`.`id` = `intervention`.`use_idAssigned` left join `activity` on `activity`.`act_id` = `intervention`.`act_id` left join `provider` on `provider`.`pro_id` = `intervention`.`pro_idAssigned` left join `contract` on `contract`.`con_id` = `intervention`.`con_id` where `intervention`.`int_closingDate` is null and `intervention`.`sig_id` = ? and `intervention`.`pro_idAssigned` = ? order by `intervention`.`int_createdDate` desc