=== A1 requete auditeur >30j ===
SELECT rowid, ref, DATE(datef) datef, DATE(datec) datec, DATE(date_valid) dval, total_ttc, total_ht, fk_statut, fk_soc, paye FROM llx_facture WHERE entity=1 AND fk_statut>0 AND DATEDIFF(date_valid,datef)>30 ORDER BY DATEDIFF(date_valid,datef) DESC
rowid=426 | ref=FA2607-0384 | datef=2026-07-01 | datec=2026-10-19 | dval=2026-10-19 | total_ttc=590.40000000 | total_ht=492.00000000 | fk_statut=1 | fk_soc=212 | paye=0
rowid=427 | ref=FA2608-0385 | datef=2026-08-01 | datec=2026-10-19 | dval=2026-10-19 | total_ttc=1478.40000000 | total_ht=1232.00000000 | fk_statut=2 | fk_soc=382 | paye=1
rowid=366 | ref=FA2605-0332 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=619.97000000 | total_ht=516.64000000 | fk_statut=2 | fk_soc=382 | paye=1
rowid=367 | ref=FA2605-0333 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=2464.00000000 | total_ht=2464.00000000 | fk_statut=2 | fk_soc=382 | paye=1
rowid=368 | ref=FA2605-0334 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=554.40000000 | total_ht=462.00000000 | fk_statut=2 | fk_soc=382 | paye=1
rowid=369 | ref=FA2605-0335 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=1848.00000000 | total_ht=1540.00000000 | fk_statut=2 | fk_soc=382 | paye=1
rowid=373 | ref=FA2605-0343 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=247.59000000 | total_ht=206.33000000 | fk_statut=2 | fk_soc=212 | paye=1
rowid=374 | ref=FA2605-0339 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=984.00000000 | total_ht=984.00000000 | fk_statut=2 | fk_soc=212 | paye=1
rowid=375 | ref=FA2605-0340 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=221.40000000 | total_ht=184.50000000 | fk_statut=2 | fk_soc=212 | paye=1
rowid=376 | ref=FA2605-0341 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=738.00000000 | total_ht=615.00000000 | fk_statut=2 | fk_soc=212 | paye=1
rowid=370 | ref=FA2606-0336 | datef=2026-06-01 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=1478.40000000 | total_ht=1232.00000000 | fk_statut=2 | fk_soc=382 | paye=1
rowid=377 | ref=FA2606-0342 | datef=2026-06-01 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=590.40000000 | total_ht=492.00000000 | fk_statut=2 | fk_soc=212 | paye=1
rowid=53 | ref=FA2509-0047 | datef=2025-09-23 | datec=2025-09-23 | dval=2025-11-24 | total_ttc=835.20000000 | total_ht=696.00000000 | fk_statut=1 | fk_soc=249 | paye=0
rowid=371 | ref=FA2606-0337 | datef=2026-06-26 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=858.43000000 | total_ht=715.36000000 | fk_statut=2 | fk_soc=382 | paye=1
rowid=372 | ref=FA2607-0338 | datef=2026-07-01 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=1478.40000000 | total_ht=1232.00000000 | fk_statut=2 | fk_soc=382 | paye=1
-- 15 lignes

=== A2 total requete auditeur ===
SELECT COUNT(*) nb, ROUND(SUM(total_ttc),2) ttc, ROUND(SUM(total_ht),2) ht FROM llx_facture WHERE entity=1 AND fk_statut>0 AND DATEDIFF(date_valid,datef)>30
nb=15 | ttc=14986.99 | ht=13063.83
-- 1 lignes

=== A3 plage 350-380 ===
SELECT rowid, ref, DATE(datef) datef, DATE(datec) datec, DATE(date_valid) dval, total_ttc, total_ht, fk_statut, fk_soc, paye, type FROM llx_facture WHERE entity=1 AND rowid BETWEEN 350 AND 380 ORDER BY rowid
rowid=350 | ref=FA2608-0328 | datef=2026-08-05 | datec=2026-08-05 | dval=2026-08-05 | total_ttc=551.69000000 | total_ht=459.74000000 | fk_statut=2 | fk_soc=222 | paye=1 | type=0
rowid=351 | ref=FA2608-0329 | datef=2026-08-06 | datec=2026-08-06 | dval=2026-08-06 | total_ttc=2280.00000000 | total_ht=1900.00000000 | fk_statut=2 | fk_soc=313 | paye=1 | type=0
rowid=352 | ref=FA2608-0330 | datef=2026-08-07 | datec=2026-08-07 | dval=2026-08-07 | total_ttc=1370.27000000 | total_ht=1141.89000000 | fk_statut=2 | fk_soc=251 | paye=1 | type=0
rowid=353 | ref=FA2608-0331 | datef=2026-08-08 | datec=2026-08-08 | dval=2026-08-08 | total_ttc=113.47000000 | total_ht=94.56000000 | fk_statut=1 | fk_soc=222 | paye=0 | type=0
rowid=366 | ref=FA2605-0332 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=619.97000000 | total_ht=516.64000000 | fk_statut=2 | fk_soc=382 | paye=1 | type=0
rowid=367 | ref=FA2605-0333 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=2464.00000000 | total_ht=2464.00000000 | fk_statut=2 | fk_soc=382 | paye=1 | type=0
rowid=368 | ref=FA2605-0334 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=554.40000000 | total_ht=462.00000000 | fk_statut=2 | fk_soc=382 | paye=1 | type=0
rowid=369 | ref=FA2605-0335 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=1848.00000000 | total_ht=1540.00000000 | fk_statut=2 | fk_soc=382 | paye=1 | type=0
rowid=370 | ref=FA2606-0336 | datef=2026-06-01 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=1478.40000000 | total_ht=1232.00000000 | fk_statut=2 | fk_soc=382 | paye=1 | type=0
rowid=371 | ref=FA2606-0337 | datef=2026-06-26 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=858.43000000 | total_ht=715.36000000 | fk_statut=2 | fk_soc=382 | paye=1 | type=0
rowid=372 | ref=FA2607-0338 | datef=2026-07-01 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=1478.40000000 | total_ht=1232.00000000 | fk_statut=2 | fk_soc=382 | paye=1 | type=0
rowid=373 | ref=FA2605-0343 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=247.59000000 | total_ht=206.33000000 | fk_statut=2 | fk_soc=212 | paye=1 | type=0
rowid=374 | ref=FA2605-0339 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=984.00000000 | total_ht=984.00000000 | fk_statut=2 | fk_soc=212 | paye=1 | type=0
rowid=375 | ref=FA2605-0340 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=221.40000000 | total_ht=184.50000000 | fk_statut=2 | fk_soc=212 | paye=1 | type=0
rowid=376 | ref=FA2605-0341 | datef=2026-05-27 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=738.00000000 | total_ht=615.00000000 | fk_statut=2 | fk_soc=212 | paye=1 | type=0
rowid=377 | ref=FA2606-0342 | datef=2026-06-01 | datec=2026-08-10 | dval=2026-08-10 | total_ttc=590.40000000 | total_ht=492.00000000 | fk_statut=2 | fk_soc=212 | paye=1 | type=0
rowid=378 | ref=(PROV378) | datef=2026-08-19 | datec=2026-08-19 | dval= | total_ttc=197.15000000 | total_ht=164.28000000 | fk_statut=0 | fk_soc=222 | paye=0 | type=0
rowid=379 | ref=(PROV379) | datef=2026-08-19 | datec=2026-08-19 | dval= | total_ttc=921.18000000 | total_ht=767.65000000 | fk_statut=0 | fk_soc=222 | paye=0 | type=0
rowid=380 | ref=FA2608-0344 | datef=2026-08-19 | datec=2026-08-19 | dval=2026-08-19 | total_ttc=132.00000000 | total_ht=110.00000000 | fk_statut=2 | fk_soc=225 | paye=1 | type=0
-- 19 lignes