===== 1. Lignes bancaires 590,40 =====
SELECT rowid,dateo,datev,amount,label,num_releve,rappro,fk_type,fk_account,num_chq FROM llx_bank WHERE ABS(amount)=590.40 ORDER BY datev
  rowid=349 | dateo=2026-06-23 | datev=2026-06-23 | amount=590.40000000 | label=Compte courant d'associé | num_releve=202606 | rappro=1 | fk_type=VIR | fk_account=1 | num_chq=NULL
  rowid=469 | dateo=2026-08-18 | datev=2026-08-18 | amount=590.40000000 | label=(AgentCompta) VIREMENT EN VOTRE FAVEUR M JULIEN LAUTOUR EI Loyer Juille Loyer Juillet | num_releve=202608 | rappro=1 | fk_type=VIR | fk_account=1 | num_chq=8323340006656
  (2 lignes)

===== 2. Toutes lignes 'compte courant d associe' =====
SELECT rowid,datev,amount,label,num_releve,rappro,fk_account FROM llx_bank WHERE label LIKE '%courant d%associ%' ORDER BY datev
  rowid=341 | datev=2026-05-18 | amount=118.80000000 | label=Compte courant d'associé | num_releve=202605 | rappro=1 | fk_account=1
  rowid=342 | datev=2026-05-29 | amount=500.00000000 | label=Compte courant d'associé | num_releve=202605 | rappro=1 | fk_account=1
  rowid=343 | datev=2026-05-30 | amount=-500.00000000 | label=Compte courant d'associé | num_releve=202605 | rappro=1 | fk_account=1
  rowid=349 | datev=2026-06-23 | amount=590.40000000 | label=Compte courant d'associé | num_releve=202606 | rappro=1 | fk_account=1
  rowid=350 | datev=2026-06-23 | amount=10000.00000000 | label=Compte courant d'associé | num_releve=202606 | rappro=1 | fk_account=1
  (5 lignes)

===== 3. Tiers ARBRE =====
SELECT s.rowid,s.nom FROM llx_societe s WHERE s.nom LIKE '%ARBRE%'
  rowid=212 | nom=ARBRE DE FER
  (1 lignes)

===== 4. Factures ARBRE DE FER =====
SELECT f.rowid,f.ref,f.datef,f.total_ht,f.total_tva,f.total_ttc,f.fk_statut,f.paye,f.last_main_doc,f.date_creation,COALESCE(SUM(pf.amount),0) AS regle FROM llx_facture f LEFT JOIN llx_paiement_facture pf ON pf.fk_facture=f.rowid WHERE f.fk_soc=(SELECT rowid FROM llx_societe WHERE nom LIKE '%ARBRE%' LIMIT 1) GROUP BY f.rowid ORDER BY f.datef
ERREUR: Unknown column 'f.date_creation' in 'field list'

===== 5. Toutes factures a 590,40 TTC =====
SELECT f.rowid,f.ref,f.datef,f.total_ttc,f.fk_statut,f.paye,f.fk_soc,s.nom FROM llx_facture f LEFT JOIN llx_societe s ON s.rowid=f.fk_soc WHERE f.total_ttc BETWEEN 590.39 AND 590.41
  rowid=377 | ref=FA2606-0342 | datef=2026-06-01 | total_ttc=590.40000000 | fk_statut=2 | paye=1 | fk_soc=212 | nom=ARBRE DE FER
  rowid=426 | ref=FA2607-0384 | datef=2026-07-01 | total_ttc=590.40000000 | fk_statut=1 | paye=0 | fk_soc=212 | nom=ARBRE DE FER
  (2 lignes)

===== 6. Toutes factures impayees validees =====
SELECT f.rowid,f.ref,f.datef,f.total_ttc,f.fk_statut,f.paye,s.nom FROM llx_facture f LEFT JOIN llx_societe s ON s.rowid=f.fk_soc WHERE f.fk_statut=1 AND f.paye=0 AND f.entity=1 ORDER BY f.datef
  rowid=4 | ref=FA2507-0002 | datef=2025-07-16 | total_ttc=141.60000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=24 | ref=FA2507-0020 | datef=2025-07-24 | total_ttc=418.90000000 | fk_statut=1 | paye=0 | nom=SCIADSIMMO 
  rowid=53 | ref=FA2509-0047 | datef=2025-09-23 | total_ttc=835.20000000 | fk_statut=1 | paye=0 | nom=RENAULTS TRUCKS SAS CSP ACHATS FOURNISSEUR CF 59042
  rowid=57 | ref=FA2510-0051 | datef=2025-10-06 | total_ttc=26.20000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=107 | ref=FA2512-0099 | datef=2025-12-22 | total_ttc=185.11000000 | fk_statut=1 | paye=0 | nom=Eudeline Fabien
  rowid=121 | ref=FA2512-0113 | datef=2025-12-23 | total_ttc=128.78000000 | fk_statut=1 | paye=0 | nom=FP Renov
  rowid=134 | ref=FA2601-0120 | datef=2026-01-20 | total_ttc=169.65000000 | fk_statut=1 | paye=0 | nom=Kerimov Nathan
  rowid=223 | ref=FA2604-0203 | datef=2026-04-18 | total_ttc=262.23000000 | fk_statut=1 | paye=0 | nom=Mac Peinture
  rowid=239 | ref=FA2605-0217 | datef=2026-05-12 | total_ttc=258.91000000 | fk_statut=1 | paye=0 | nom=Tendance Menuiserie
  rowid=268 | ref=FA2606-0246 | datef=2026-06-16 | total_ttc=1382.40000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=426 | ref=FA2607-0384 | datef=2026-07-01 | total_ttc=590.40000000 | fk_statut=1 | paye=0 | nom=ARBRE DE FER
  rowid=295 | ref=FA2607-0273 | datef=2026-07-19 | total_ttc=217.06000000 | fk_statut=1 | paye=0 | nom=CRIS RAVALEMENT
  rowid=299 | ref=FA2607-0277 | datef=2026-07-21 | total_ttc=281.59000000 | fk_statut=1 | paye=0 | nom=CRIS RAVALEMENT
  rowid=310 | ref=FA2607-0288 | datef=2026-07-27 | total_ttc=83.45000000 | fk_statut=1 | paye=0 | nom=SAS Raulin
  rowid=311 | ref=FA2607-0289 | datef=2026-07-29 | total_ttc=353.69000000 | fk_statut=1 | paye=0 | nom=CRIS RAVALEMENT
  rowid=321 | ref=FA2608-0299 | datef=2026-08-03 | total_ttc=140.98000000 | fk_statut=1 | paye=0 | nom=SAS Raulin
  rowid=326 | ref=FA2608-0304 | datef=2026-08-03 | total_ttc=310.59000000 | fk_statut=1 | paye=0 | nom=CRIS RAVALEMENT
  rowid=336 | ref=FA2608-0314 | datef=2026-08-03 | total_ttc=726.60000000 | fk_statut=1 | paye=0 | nom=CRIS RAVALEMENT
  rowid=347 | ref=FA2608-0325 | datef=2026-08-05 | total_ttc=1594.96000000 | fk_statut=1 | paye=0 | nom=Tendance Menuiserie
  rowid=353 | ref=FA2608-0331 | datef=2026-08-08 | total_ttc=113.47000000 | fk_statut=1 | paye=0 | nom=Normandie Biologi'K Construction
  rowid=392 | ref=FA2608-0353 | datef=2026-08-31 | total_ttc=601.50000000 | fk_statut=1 | paye=0 | nom=SARL MAC
  rowid=391 | ref=FA2608-0352 | datef=2026-08-31 | total_ttc=2914.67000000 | fk_statut=1 | paye=0 | nom=SARL MAC
  rowid=393 | ref=FA2609-0354 | datef=2026-09-02 | total_ttc=375.14000000 | fk_statut=1 | paye=0 | nom=LEFEVRE R
  rowid=402 | ref=FA2609-0360 | datef=2026-09-08 | total_ttc=1612.80000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=405 | ref=FA2609-0363 | datef=2026-09-21 | total_ttc=1939.72000000 | fk_statut=1 | paye=0 | nom=LEFEVRE R
  rowid=408 | ref=FA2609-0366 | datef=2026-09-23 | total_ttc=485.56000000 | fk_statut=1 | paye=0 | nom=CRIS RAVALEMENT
  rowid=409 | ref=FA2609-0367 | datef=2026-09-24 | total_ttc=112.32000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=410 | ref=FA2609-0368 | datef=2026-09-24 | total_ttc=719.88000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=416 | ref=FA2609-0374 | datef=2026-09-28 | total_ttc=43.54000000 | fk_statut=1 | paye=0 | nom=Eudeline Fabien
  rowid=417 | ref=FA2609-0375 | datef=2026-09-28 | total_ttc=260.01000000 | fk_statut=1 | paye=0 | nom=LEFEVRE R
  rowid=420 | ref=FA2609-0378 | datef=2026-09-28 | total_ttc=467.71000000 | fk_statut=1 | paye=0 | nom=Raulin Emmanuel
  rowid=421 | ref=FA2609-0379 | datef=2026-09-30 | total_ttc=401.76000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=422 | ref=FA2610-0380 | datef=2026-10-02 | total_ttc=2368.80000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=424 | ref=FA2610-0382 | datef=2026-10-07 | total_ttc=167.20000000 | fk_statut=1 | paye=0 | nom=SARL-LMC
  rowid=423 | ref=FA2610-0381 | datef=2026-10-07 | total_ttc=2368.80000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=425 | ref=FA2610-0383 | datef=2026-10-15 | total_ttc=2368.80000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=428 | ref=FA2610-0386 | datef=2026-10-19 | total_ttc=96.00000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=429 | ref=FA2610-0387 | datef=2026-10-19 | total_ttc=960.00000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=430 | ref=FA2610-0388 | datef=2026-10-21 | total_ttc=2544.86000000 | fk_statut=1 | paye=0 | nom=Renault Trucks
  rowid=431 | ref=FA2610-0389 | datef=2026-10-21 | total_ttc=459.89000000 | fk_statut=1 | paye=0 | nom=SRG
  rowid=432 | ref=FA2610-0390 | datef=2026-10-21 | total_ttc=8817.24000000 | fk_statut=1 | paye=0 | nom=SARL MAC
  (41 lignes)

===== 7. Lignes banque 349/341/96 + nb liens =====
SELECT b.rowid,b.datev,b.amount,b.label,b.num_releve,b.rappro, (SELECT COUNT(*) FROM llx_bank_url u WHERE u.fk_bank=b.rowid) AS nb_url FROM llx_bank b WHERE b.rowid IN (349,341,96)
  rowid=96 | datev=2026-06-23 | amount=217.44000000 | label=(CustomerInvoicePayment) | num_releve=202606 | rappro=1 | nb_url=2
  rowid=341 | datev=2026-05-18 | amount=118.80000000 | label=Compte courant d'associé | num_releve=202605 | rappro=1 | nb_url=1
  rowid=349 | datev=2026-06-23 | amount=590.40000000 | label=Compte courant d'associé | num_releve=202606 | rappro=1 | nb_url=1
  (3 lignes)

===== 8. Liens bank_url =====
SELECT * FROM llx_bank_url WHERE fk_bank IN (349,341,96)
  rowid=189 | fk_bank=96 | url_id=95 | url=/compta/paiement/card.php?id= | label=(paiement) | type=payment
  rowid=190 | fk_bank=96 | url_id=212 | url=/comm/card.php?socid= | label=ARBRE DE FER | type=company
  rowid=640 | fk_bank=341 | url_id=48 | url=/compta/bank/various_payment/card.php?id= | label=(VariousPayment) | type=payment_various
  rowid=648 | fk_bank=349 | url_id=56 | url=/compta/bank/various_payment/card.php?id= | label=(VariousPayment) | type=payment_various
  (4 lignes)

===== 9. Paiements sur ces lignes banque =====
SELECT p.rowid,p.ref,p.datep,p.amount,p.fk_bank,p.num_paiement,p.note FROM llx_paiement p WHERE p.fk_bank IN (349,341,96)
  rowid=95 | ref=PAY2606-0090 | datep=2026-06-23 12:00:00 | amount=217.44000000 | fk_bank=96 | num_paiement= | note=
  (1 lignes)

===== 10. Paiements de 590,40 =====
SELECT rowid,ref,datep,amount,fk_bank FROM llx_paiement WHERE amount BETWEEN 590.39 AND 590.41
  rowid=138 | ref=PAY2608-0133 | datep=2026-08-18 00:00:00 | amount=590.40000000 | fk_bank=469
  (1 lignes)

===== 10b. Paiements de 118,80 =====
SELECT rowid,ref,datep,amount,fk_bank FROM llx_paiement WHERE amount BETWEEN 118.79 AND 118.81
  (0 lignes)

===== 11. PDF facture 377 =====
SELECT rowid,filename,filepath,src_object_type,src_object_id FROM llx_ecm_files WHERE src_object_type='facture' AND src_object_id=377
  rowid=2288 | filename=FA2606-0342.pdf | filepath=facture/FA2606-0342 | src_object_type=facture | src_object_id=377
  (1 lignes)

===== 12. Encaissements sans lien (orphelins) =====
SELECT b.rowid,b.datev,b.amount,b.label,b.num_releve,b.rappro FROM llx_bank b LEFT JOIN llx_bank_url u ON u.fk_bank=b.rowid WHERE u.rowid IS NULL AND b.amount>0 AND b.fk_account=1 ORDER BY b.datev
  rowid=402 | datev=2025-12-31 | amount=37001.25000000 | label=Solde au 31/12/2025 — comptes annuels signés TACHER ACOGEX, poste 512 (confirmé par le relevé : 29 521,40 au 09/08/2026 + 7 479,85 de flux) | num_releve=202512 | rappro=1
  (1 lignes)