MariaDB [siv1_apres]> select * from clients_factures_lignes where facture = 868598;
+---------+---------+----------------------------------------------------------------------------------------------------------------------------------+-----------------+---------+--------+----------+-------+--------------------+--------+----------------+------------------+-----------------------+---------------------+-------------------------+-----------------------+--------------------+------------------------+----------------------+------------------------+-------------+-----------------+
| id      | facture | libelle                                                                                                                          | client_materiel | prix    | remise | quantite | tva   | type               | inclus | client_service | client_reduction | service_periode_debut | service_periode_fin | reduction_periode_debut | reduction_periode_fin | ligneservicetel_id | consotel_periode_debut | consotel_periode_fin | clients_factures_types | ajoutee_par | reference       |
+---------+---------+----------------------------------------------------------------------------------------------------------------------------------+-----------------+---------+--------+----------+-------+--------------------+--------+----------------+------------------+-----------------------+---------------------+-------------------------+-----------------------+--------------------+------------------------+----------------------+------------------------+-------------+-----------------+
| 5011309 |  868598 | Téléphonie France + 50 destinations période du 01/10/2019 au 31/10/2019                                                          |               0 |   5.000 | 100.00 |     1.00 | 20.00 | mensuel            |      0 |         312026 |                0 | 2019-10-01            | 2019-10-31          | 0000-00-00              | 0000-00-00            |               NULL | NULL                   | NULL                 |                      5 |        NULL | 16TEM01G        |
| 5011310 |  868598 | Forfait Fibre Optique 100M période du 01/10/2019 au 31/10/2019                                                                   |               0 |  28.330 |  62.94 |     1.00 | 20.00 | mensuel            |      0 |         403659 |                0 | 2019-10-01            | 2019-10-31          | 0000-00-00              | 0000-00-00            |               NULL | NULL                   | NULL                 |                      4 |        NULL | 2019-ABMINT100M |
| 5011311 |  868598 | Flux TV TNT période du 01/10/2019 au 31/10/2019                                                                                  |               0 |  30.900 |  62.94 |     1.00 | 10.00 | mensuel            |      0 |         403660 |                0 | 2019-10-01            | 2019-10-31          | 0000-00-00              | 0000-00-00            |               NULL | NULL                   | NULL                 |                     21 |        NULL | 2019-ABMTVTNT   |
| 5011312 |  868598 | Réduction Parrainage - Internet 100M                                                                                             |               0 | -28.330 |  62.94 |     1.00 | 20.00 | unique             |      0 |              0 |           138497 | 0000-00-00            | 0000-00-00          | 0000-00-00              | 0000-00-00            |               NULL | NULL                   | NULL                 |                      4 |        NULL | NULL            |
| 5011313 |  868598 | Réduction Parrainage - TV TNT                                                                                                    |               0 | -33.000 |  62.94 |     1.00 | 10.00 | unique             |      0 |              0 |           138498 | 0000-00-00            | 0000-00-00          | 0000-00-00              | 0000-00-00            |               NULL | NULL                   | NULL                 |                     21 |        NULL | NULL            |
| 5011314 |  868598 | Appels pour la ligne 0972157012 (Téléphonie France + 50 destinations) <br />Période du 01/08/2019 au 31/08/2019 (aucun appel)    |               0 |   0.000 |   0.00 |     1.00 | 20.00 | conso-telephonique |      0 |              0 |                0 | 0000-00-00            | 0000-00-00          | 0000-00-00              | 0000-00-00            |              29997 | 2019-08-01             | 2019-08-31           |                      5 |        NULL | NULL            |
+---------+---------+----------------------------------------------------------------------------------------------------------------------------------+-----------------+---------+--------+----------+-------+--------------------+--------+----------------+------------------+-----------------------+---------------------+-------------------------+-----------------------+--------------------+------------------------+----------------------+------------------------+-------------+-----------------+
6 rows in set (0.01 sec)