[2021-12-13 11:08:11] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2021-12-13 11:08:11] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-04-07 14:38:23] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-04-07 14:38:23] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-04-19 14:27:58] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-04-19 14:27:58] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-04-28 13:10:29] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? and `intervention`.`sta_id` in (?) order by `intervention`.`int_number` desc [2022-04-28 13:10:29] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? and `intervention`.`sta_id` in (?) order by `intervention`.`int_number` desc [2022-04-28 13:10:50] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-04-28 13:10:50] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-17 15:06:18] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-17 15:06:18] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:44:40] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:44:40] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:45:05] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:45:05] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:45:09] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:45:09] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:45:13] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:45:13] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:45:19] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:45:19] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:49:26] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 09:49:26] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 10:05:15] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 10:05:15] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 10:06:29] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? and `intervention`.`cus_id` = ? order by `intervention`.`int_number` desc [2022-06-20 10:06:29] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? and `intervention`.`cus_id` = ? order by `intervention`.`int_number` desc [2022-06-20 10:06:47] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-20 10:06:47] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 11:36:17] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 11:36:17] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 11:36:39] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 11:36:39] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 11:39:25] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 11:39:25] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 13:02:31] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 13:02:31] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 14:33:18] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 14:33:18] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 14:34:59] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-22 14:34:59] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 07:26:08] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 07:26:08] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 09:02:08] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 09:02:08] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 09:41:49] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 09:41:49] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 12:12:48] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 12:12:48] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 12:12:59] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 12:12:59] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 12:14:03] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 12:14:03] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 12:22:59] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? and `intervention`.`cus_id` = ? order by `intervention`.`int_number` desc [2022-06-24 12:22:59] local.INFO: select customer_invoice.*, customer.cus_socialReason, status.sta_nameFr,intervention.int_number, intervention.int_title from `customer_invoice` left join `intervention` on `customer_invoice`.`int_id` = `intervention`.`int_id` left join `customer` on `intervention`.`cus_id` = `customer`.`cus_id` left join `status` on `customer_invoice`.`sta_id` = `status`.`sta_id` where substr(customer_invoice.cusInv_createdDate,1,10) >= ? and substr(customer_invoice.cusInv_createdDate,1,10) <= ? and `intervention`.`cus_id` = ? order by `intervention`.`int_number` desc [2022-06-24 15:20:21] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 15:20:21] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 16:00:48] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 16:00:48] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 16:04:10] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 16:04:10] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 16:05:04] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? and `provider_invoice`.`pro_id` = ? order by `intervention`.`int_number` desc [2022-06-24 16:05:04] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? and `provider_invoice`.`pro_id` = ? order by `intervention`.`int_number` desc [2022-06-24 17:44:53] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:44:53] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:45:02] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:45:02] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:45:20] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:45:20] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:45:22] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:45:22] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:45:53] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:45:53] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:46:01] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:46:01] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:46:26] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:46:26] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:47:36] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:47:36] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:47:59] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:47:59] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:48:50] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:48:50] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:49:32] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:49:32] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:49:38] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:49:38] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:52:34] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 17:52:34] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 18:55:50] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 18:55:50] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 18:57:30] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 18:57:30] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 18:58:46] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 18:58:46] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:02:10] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:02:10] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:03:51] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:03:51] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:04:23] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:04:23] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:05:28] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:05:28] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:06:20] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:06:20] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:07:36] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:07:36] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:07:54] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-24 19:07:54] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-25 22:13:18] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-25 22:13:18] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-25 22:27:40] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-25 22:27:40] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-25 22:28:17] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-25 22:28:17] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-25 22:28:26] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-25 22:28:26] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-27 06:46:04] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc [2022-06-27 06:46:04] local.INFO: select provider_invoice.*, provider.pro_socialReason, status.sta_nameFr, provider_request.proReq_id, provider_request.proReq_number, provider_request.proReq_amountHT,intervention.int_number, intervention.int_title from `provider_invoice` left join `provider` on `provider_invoice`.`pro_id` = `provider`.`pro_id` left join `intervention` on `provider_invoice`.`int_id` = `intervention`.`int_id` left join `status` on `provider_invoice`.`sta_id` = `status`.`sta_id` left join `provider_request` on `provider_invoice`.`proReq_id` = `provider_request`.`proReq_id` where substr(provider_invoice.proInv_createdDate,1,10) >= ? and substr(provider_invoice.proInv_createdDate,1,10) <= ? order by `intervention`.`int_number` desc