===== 1. Requete auditeur (top 10 ecarts clients) =====
SELECT p.rowid AS pay_rowid, p.ref, DATE(p.datep) AS datep, f.rowid AS fac_rowid, f.ref AS fref, DATE(f.datef) AS datef,
 DATEDIFF(f.datef,p.datep) AS jours, b.rowid AS bank_rowid, b.fk_account, b.rappro, b.num_releve, p.amount AS pay_amount,
 pf.amount AS pf_amount, b.amount AS bank_amount, p.entity
 FROM llx_paiement p JOIN llx_paiement_facture pf ON pf.fk_paiement=p.rowid
 JOIN llx_facture f ON f.rowid=pf.fk_facture JOIN llx_bank b ON b.rowid=p.fk_bank
 WHERE DATE(p.datep)<DATE(f.datef) ORDER BY DATEDIFF(f.datef,p.datep) DESC LIMIT 10
-----
pay_rowid=15 | ref=PAY2507-0015 | datep=2025-07-08 | fac_rowid=49 | fref=FA2509-0043 | datef=2025-09-18 | jours=72 | bank_rowid=16 | fk_account=2 | rappro=0 | num_releve=NULL | pay_amount=438.00000000 | pf_amount=438.00000000 | bank_amount=438.00000000 | entity=1
pay_rowid=14 | ref=PAY2505-0014 | datep=2025-05-17 | fac_rowid=17 | fref=FA2507-0013 | datef=2025-07-23 | jours=67 | bank_rowid=15 | fk_account=2 | rappro=0 | num_releve=NULL | pay_amount=59.04000000 | pf_amount=59.04000000 | bank_amount=59.04000000 | entity=1
pay_rowid=115 | ref=PAY2606-0110 | datep=2026-06-22 | fac_rowid=293 | fref=FA2607-0271 | datef=2026-07-19 | jours=27 | bank_rowid=362 | fk_account=1 | rappro=1 | num_releve=202606 | pay_amount=7000.00000000 | pf_amount=328.45000000 | bank_amount=7000.00000000 | entity=1
pay_rowid=115 | ref=PAY2606-0110 | datep=2026-06-22 | fac_rowid=294 | fref=FA2607-0272 | datef=2026-07-19 | jours=27 | bank_rowid=362 | fk_account=1 | rappro=1 | num_releve=202606 | pay_amount=7000.00000000 | pf_amount=652.84000000 | bank_amount=7000.00000000 | entity=1
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fac_rowid=319 | fref=FA2607-0297 | datef=2026-07-31 | jours=16 | bank_rowid=363 | fk_account=1 | rappro=1 | num_releve=202607 | pay_amount=7000.00000000 | pf_amount=2528.27000000 | bank_amount=7000.00000000 | entity=1
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fac_rowid=312 | fref=FA2607-0290 | datef=2026-07-29 | jours=14 | bank_rowid=363 | fk_account=1 | rappro=1 | num_releve=202607 | pay_amount=7000.00000000 | pf_amount=139.80000000 | bank_amount=7000.00000000 | entity=1
pay_rowid=114 | ref=PAY2605-0109 | datep=2026-05-19 | fac_rowid=254 | fref=FA2605-0232 | datef=2026-05-30 | jours=11 | bank_rowid=361 | fk_account=1 | rappro=1 | num_releve=202605 | pay_amount=7000.00000000 | pf_amount=433.02000000 | bank_amount=7000.00000000 | entity=1
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fac_rowid=306 | fref=FA2607-0284 | datef=2026-07-24 | jours=9 | bank_rowid=363 | fk_account=1 | rappro=1 | num_releve=202607 | pay_amount=7000.00000000 | pf_amount=137.81000000 | bank_amount=7000.00000000 | entity=1
pay_rowid=115 | ref=PAY2606-0110 | datep=2026-06-22 | fac_rowid=277 | fref=FA2606-0255 | datef=2026-06-29 | jours=7 | bank_rowid=362 | fk_account=1 | rappro=1 | num_releve=202606 | pay_amount=7000.00000000 | pf_amount=957.44000000 | bank_amount=7000.00000000 | entity=1
pay_rowid=115 | ref=PAY2606-0110 | datep=2026-06-22 | fac_rowid=278 | fref=FA2606-0256 | datef=2026-06-29 | jours=7 | bank_rowid=362 | fk_account=1 | rappro=1 | num_releve=202606 | pay_amount=7000.00000000 | pf_amount=540.99000000 | bank_amount=7000.00000000 | entity=1
(10 lignes)

===== 2. Sans jointure banque (tous paiements clients en avance) =====
SELECT p.rowid AS pay_rowid, p.ref, DATE(p.datep) AS datep, f.ref AS fref, DATE(f.datef) AS datef,
 DATEDIFF(f.datef,p.datep) AS jours, p.fk_bank, pf.amount
 FROM llx_paiement p JOIN llx_paiement_facture pf ON pf.fk_paiement=p.rowid
 JOIN llx_facture f ON f.rowid=pf.fk_facture
 WHERE DATE(p.datep)<DATE(f.datef) ORDER BY DATEDIFF(f.datef,p.datep) DESC LIMIT 15
-----
pay_rowid=15 | ref=PAY2507-0015 | datep=2025-07-08 | fref=FA2509-0043 | datef=2025-09-18 | jours=72 | fk_bank=16 | amount=438.00000000
pay_rowid=14 | ref=PAY2505-0014 | datep=2025-05-17 | fref=FA2507-0013 | datef=2025-07-23 | jours=67 | fk_bank=15 | amount=59.04000000
pay_rowid=115 | ref=PAY2606-0110 | datep=2026-06-22 | fref=FA2607-0271 | datef=2026-07-19 | jours=27 | fk_bank=362 | amount=328.45000000
pay_rowid=115 | ref=PAY2606-0110 | datep=2026-06-22 | fref=FA2607-0272 | datef=2026-07-19 | jours=27 | fk_bank=362 | amount=652.84000000
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fref=FA2607-0297 | datef=2026-07-31 | jours=16 | fk_bank=363 | amount=2528.27000000
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fref=FA2607-0290 | datef=2026-07-29 | jours=14 | fk_bank=363 | amount=139.80000000
pay_rowid=114 | ref=PAY2605-0109 | datep=2026-05-19 | fref=FA2605-0232 | datef=2026-05-30 | jours=11 | fk_bank=361 | amount=433.02000000
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fref=FA2607-0284 | datef=2026-07-24 | jours=9 | fk_bank=363 | amount=137.81000000
pay_rowid=115 | ref=PAY2606-0110 | datep=2026-06-22 | fref=FA2606-0255 | datef=2026-06-29 | jours=7 | fk_bank=362 | amount=957.44000000
pay_rowid=115 | ref=PAY2606-0110 | datep=2026-06-22 | fref=FA2606-0256 | datef=2026-06-29 | jours=7 | fk_bank=362 | amount=540.99000000
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fref=FA2607-0281 | datef=2026-07-21 | jours=6 | fk_bank=363 | amount=707.02000000
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fref=FA2607-0278 | datef=2026-07-21 | jours=6 | fk_bank=363 | amount=2344.28000000
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fref=FA2607-0280 | datef=2026-07-21 | jours=6 | fk_bank=363 | amount=72.79000000
pay_rowid=136 | ref=PAY2609-0131 | datep=2026-09-02 | fref=FA2609-0355 | datef=2026-09-07 | jours=5 | fk_bank=466 | amount=103.83000000
pay_rowid=116 | ref=PAY2607-0111 | datep=2026-07-15 | fref=FA2607-0272 | datef=2026-07-19 | jours=4 | fk_bank=363 | amount=337.59000000
(15 lignes)

===== 3. Paiements rowid 14 et 15 (detail brut) =====
SELECT p.rowid, p.ref, p.datec, p.datep, p.amount, p.multicurrency_amount, p.fk_bank, p.fk_user_creat, p.note, p.num_paiement, p.statut, p.entity,
 c.code AS mode_code, c.libelle AS mode_lib
 FROM llx_paiement p LEFT JOIN llx_c_paiement c ON c.id=p.fk_paiement
 WHERE p.rowid IN (14,15)
-----
rowid=14 | ref=PAY2505-0014 | datec=2025-10-08 16:13:59 | datep=2025-05-17 12:00:00 | amount=59.04000000 | multicurrency_amount=59.04000000 | fk_bank=15 | fk_user_creat=87 | note= | num_paiement= | statut=0 | entity=1 | mode_code=CHQ | mode_lib=Cheque
rowid=15 | ref=PAY2507-0015 | datec=2025-10-08 16:16:07 | datep=2025-07-08 12:00:00 | amount=438.00000000 | multicurrency_amount=438.00000000 | fk_bank=16 | fk_user_creat=87 | note= | num_paiement= | statut=0 | entity=1 | mode_code=VIR | mode_lib=Credit Transfer
(2 lignes)

===== 3b. Ventilation paiement->facture =====
SELECT pf.rowid, pf.fk_paiement, pf.fk_facture, pf.amount, pf.multicurrency_amount FROM llx_paiement_facture pf WHERE pf.fk_paiement IN (14,15)
-----
rowid=34 | fk_paiement=14 | fk_facture=17 | amount=59.04000000 | multicurrency_amount=59.04000000
rowid=35 | fk_paiement=15 | fk_facture=49 | amount=438.00000000 | multicurrency_amount=438.00000000
(2 lignes)

===== 3c. Factures visees =====
SELECT f.rowid, f.ref, f.ref_client, f.type, f.fk_statut, f.paye, f.datec, f.datef, f.date_valid, f.total_ht, f.total_tva, f.total_ttc, f.fk_soc, f.close_code, f.entity
 FROM llx_facture f WHERE f.ref IN ('FA2507-0013','FA2509-0043')
-----
rowid=17 | ref=FA2507-0013 | ref_client=Couvertine pour un salarié | type=0 | fk_statut=2 | paye=1 | datec=2025-07-23 15:16:58 | datef=2025-07-23 | date_valid=2025-07-23 | total_ht=49.19000000 | total_tva=9.85000000 | total_ttc=59.04000000 | fk_soc=236 | close_code=NULL | entity=1
rowid=49 | ref=FA2509-0043 | ref_client=Crayon ALU | type=0 | fk_statut=2 | paye=1 | datec=2025-09-18 06:37:14 | datef=2025-09-18 | date_valid=2025-09-18 | total_ht=365.00000000 | total_tva=73.00000000 | total_ttc=438.00000000 | fk_soc=243 | close_code=NULL | entity=1
(2 lignes)

===== 3d. Lignes banque 15 et 16 =====
SELECT b.rowid, b.datev, b.dateo, b.amount, b.label, b.fk_account, b.rappro, b.num_releve, b.fk_type, b.num_chq, b.datec
 FROM llx_bank b WHERE b.rowid IN (15,16)
-----
rowid=15 | datev=2025-05-17 | dateo=2025-05-17 | amount=59.04000000 | label=(CustomerInvoicePayment) | fk_account=2 | rappro=0 | num_releve=NULL | fk_type=CHQ | num_chq=NULL | datec=2025-10-08 16:14:00
rowid=16 | datev=2025-07-08 | dateo=2025-07-08 | amount=438.00000000 | label=(CustomerInvoicePayment) | fk_account=2 | rappro=0 | num_releve=NULL | fk_type=VIR | num_chq=NULL | datec=2025-10-08 16:16:07
(2 lignes)

===== 4. Comptes bancaires =====
SELECT rowid, ref, label, bank, clos, courant, entity, date_solde, solde FROM llx_bank_account ORDER BY rowid
-----
ERREUR SQL: Unknown column 'date_solde' in 'field list'

===== 5. Soldes par compte (somme llx_bank) =====
SELECT fk_account, COUNT(*) AS nb, ROUND(SUM(amount),2) AS solde, MIN(DATE(dateo)) AS premier, MAX(DATE(dateo)) AS dernier,
 SUM(CASE WHEN rappro=1 THEN 1 ELSE 0 END) AS nb_rappro
 FROM llx_bank GROUP BY fk_account
-----
fk_account=1 | nb=429 | solde=16033.9 | premier=2025-12-31 | dernier=2026-10-17 | nb_rappro=425
fk_account=2 | nb=44 | solde=119828.66 | premier=2025-01-01 | dernier=2025-12-31 | nb_rappro=0
(2 lignes)

===== 6. Integralite du compte 2 (HIST25) =====
SELECT b.rowid, DATE(b.dateo) AS dateo, DATE(b.datev) AS datev, b.amount, b.label, b.rappro, b.num_releve, b.fk_type
 FROM llx_bank b WHERE b.fk_account=2 ORDER BY b.dateo, b.rowid
-----
rowid=401 | dateo=2025-01-01 | datev=2025-01-01 | amount=0.00000000 | label=(InitialBankBalance) | rappro=0 | num_releve=NULL | fk_type=SOLD
rowid=15 | dateo=2025-05-17 | datev=2025-05-17 | amount=59.04000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=CHQ
rowid=16 | dateo=2025-07-08 | datev=2025-07-08 | amount=438.00000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=3 | dateo=2025-07-22 | datev=2025-07-22 | amount=5344.17000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=5 | dateo=2025-07-25 | datev=2025-07-25 | amount=10333.87000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=4 | dateo=2025-08-21 | datev=2025-08-21 | amount=478.80000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=1 | dateo=2025-09-06 | datev=2025-09-06 | amount=3790.83000000 | label=(Solde initial) | rappro=0 | num_releve=NULL | fk_type=SOLD
rowid=2 | dateo=2025-09-09 | datev=2025-09-09 | amount=4085.45000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=6 | dateo=2025-09-17 | datev=2025-09-17 | amount=2740.47000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=7 | dateo=2025-09-17 | datev=2025-09-17 | amount=4899.73000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=8 | dateo=2025-09-19 | datev=2025-09-19 | amount=5476.03000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=11 | dateo=2025-09-22 | datev=2025-09-22 | amount=77.23000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=9 | dateo=2025-09-23 | datev=2025-09-23 | amount=452.74000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=12 | dateo=2025-09-24 | datev=2025-09-24 | amount=2954.39000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=10 | dateo=2025-09-28 | datev=2025-09-28 | amount=360.00000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=13 | dateo=2025-10-04 | datev=2025-10-04 | amount=5958.77000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=14 | dateo=2025-10-07 | datev=2025-10-07 | amount=1761.17000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=17 | dateo=2025-10-09 | datev=2025-10-09 | amount=3702.96000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=18 | dateo=2025-10-14 | datev=2025-10-14 | amount=684.35000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=19 | dateo=2025-10-14 | datev=2025-10-14 | amount=21.91000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=20 | dateo=2025-10-14 | datev=2025-10-14 | amount=456.42000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=21 | dateo=2025-10-21 | datev=2025-10-21 | amount=2223.85000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=22 | dateo=2025-10-23 | datev=2025-10-23 | amount=960.00000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=23 | dateo=2025-10-23 | datev=2025-10-23 | amount=2775.50000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=24 | dateo=2025-10-23 | datev=2025-10-23 | amount=8884.06000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=25 | dateo=2025-11-04 | datev=2025-11-04 | amount=3600.00000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=32 | dateo=2025-11-06 | datev=2025-11-06 | amount=24.00000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=29 | dateo=2025-11-13 | datev=2025-11-13 | amount=391.20000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=31 | dateo=2025-11-20 | datev=2025-11-20 | amount=432.00000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=28 | dateo=2025-11-24 | datev=2025-11-24 | amount=149.34000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=27 | dateo=2025-11-27 | datev=2025-11-27 | amount=710.64000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=26 | dateo=2025-12-05 | datev=2025-12-05 | amount=10082.97000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=33 | dateo=2025-12-05 | datev=2025-12-05 | amount=2725.90000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=40 | dateo=2025-12-11 | datev=2025-12-11 | amount=4934.76000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=34 | dateo=2025-12-23 | datev=2025-12-23 | amount=208.51000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=36 | dateo=2025-12-23 | datev=2025-12-23 | amount=720.00000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=37 | dateo=2025-12-23 | datev=2025-12-23 | amount=7282.93000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=35 | dateo=2025-12-29 | datev=2025-12-29 | amount=204.10000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=38 | dateo=2025-12-29 | datev=2025-12-29 | amount=1288.09000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=39 | dateo=2025-12-29 | datev=2025-12-29 | amount=1369.58000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=41 | dateo=2025-12-30 | datev=2025-12-30 | amount=5272.56000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=44 | dateo=2025-12-30 | datev=2025-12-30 | amount=92.22000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
rowid=42 | dateo=2025-12-31 | datev=2025-12-31 | amount=137.60000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=CB
rowid=43 | dateo=2025-12-31 | datev=2025-12-31 | amount=11282.52000000 | label=(CustomerInvoicePayment) | rappro=0 | num_releve=NULL | fk_type=VIR
(44 lignes)

===== 7. llx_bank_url des lignes 15/16 =====
SELECT bu.fk_bank, bu.url_id, bu.type, bu.label FROM llx_bank_url bu WHERE bu.fk_bank IN (15,16) ORDER BY bu.fk_bank
-----
fk_bank=15 | url_id=14 | type=payment | label=(paiement)
fk_bank=15 | url_id=236 | type=company | label=BCBD
fk_bank=16 | url_id=15 | type=payment | label=(paiement)
fk_bank=16 | url_id=243 | type=company | label=SAS Balder
(4 lignes)

===== 8. Toutes les factures des deux tiers concernes =====
SELECT f.rowid, f.ref, DATE(f.datef) AS datef, f.total_ttc, f.paye, f.fk_statut, f.fk_soc, s.nom
 FROM llx_facture f LEFT JOIN llx_societe s ON s.rowid=f.fk_soc
 WHERE f.fk_soc IN (SELECT fk_soc FROM llx_facture WHERE ref IN ('FA2507-0013','FA2509-0043'))
 ORDER BY f.fk_soc, f.datef
-----
rowid=17 | ref=FA2507-0013 | datef=2025-07-23 | total_ttc=59.04000000 | paye=1 | fk_statut=2 | fk_soc=236 | nom=BCBD
rowid=49 | ref=FA2509-0043 | datef=2025-09-18 | total_ttc=438.00000000 | paye=1 | fk_statut=2 | fk_soc=243 | nom=SAS Balder
(2 lignes)

===== 9. Reglement total par facture =====
SELECT f.ref, f.total_ttc, ROUND(SUM(pf.amount),2) AS total_regle, f.paye, f.fk_statut
 FROM llx_facture f JOIN llx_paiement_facture pf ON pf.fk_facture=f.rowid
 WHERE f.ref IN ('FA2507-0013','FA2509-0043') GROUP BY f.rowid, f.ref, f.total_ttc, f.paye, f.fk_statut
-----
ref=FA2507-0013 | total_ttc=59.04000000 | total_regle=59.04 | paye=1 | fk_statut=2
ref=FA2509-0043 | total_ttc=438.00000000 | total_regle=438 | paye=1 | fk_statut=2
(2 lignes)

===== 10. Volumetrie =====
SELECT COUNT(*) AS nb_pf_total,
 SUM(CASE WHEN DATE(p.datep)<DATE(f.datef) THEN 1 ELSE 0 END) AS nb_en_avance,
 SUM(CASE WHEN DATE(p.datep)<DATE(f.datef) AND DATEDIFF(f.datef,p.datep)>60 THEN 1 ELSE 0 END) AS nb_gt_60j
 FROM llx_paiement p JOIN llx_paiement_facture pf ON pf.fk_paiement=p.rowid JOIN llx_facture f ON f.rowid=pf.fk_facture
-----
nb_pf_total=352 | nb_en_avance=21 | nb_gt_60j=2
(1 lignes)

===== 11. Fournisseurs en avance (comparatif) =====
SELECT p.rowid, p.ref, DATE(p.datep) AS datep, f.ref AS fref, DATE(f.datef) AS datef, DATEDIFF(f.datef,p.datep) AS jours, b.fk_account, b.rappro
 FROM llx_paiementfourn p JOIN llx_paiementfourn_facturefourn pf ON pf.fk_paiementfourn=p.rowid
 JOIN llx_facture_fourn f ON f.rowid=pf.fk_facturefourn LEFT JOIN llx_bank b ON b.rowid=p.fk_bank
 WHERE DATE(p.datep)<DATE(f.datef) ORDER BY DATEDIFF(f.datef,p.datep) DESC LIMIT 5
-----
rowid=234 | ref=SPAY2609-0189 | datep=2026-09-09 | fref=SI2609-0268 | datef=2026-09-30 | jours=21 | fk_account=1 | rappro=1
rowid=67 | ref=SPAY2603-0022 | datep=2026-03-09 | fref=SI2603-0196 | datef=2026-03-23 | jours=14 | fk_account=1 | rappro=1
rowid=248 | ref=SPAY2610-0203 | datep=2026-10-04 | fref=SI2610-0299 | datef=2026-10-13 | jours=9 | fk_account=1 | rappro=1
rowid=61 | ref=SPAY2601-0016 | datep=2026-01-07 | fref=SI2601-0035 | datef=2026-01-14 | jours=7 | fk_account=1 | rappro=1
rowid=116 | ref=SPAY2601-0071 | datep=2026-01-05 | fref=SI2601-0108 | datef=2026-01-12 | jours=7 | fk_account=1 | rappro=1
(5 lignes)