· 8 years ago · Jul 18, 2018, 03:02 PM
1mysql> select * from fais;
2+----+---------+----------------+--------------+--------------------------------------------------------------------------------------+----------------+--------------------------+
3| id | nom | quota_pression | quota_sender | domains | quota_campagne | default_planning_percent |
4+----+---------+----------------+--------------+--------------------------------------------------------------------------------------+----------------+--------------------------+
5| 1 | orange | 1 | 0 | orange.fr|wanadoo.fr|voila.fr | 0 | 0 |
6| 2 | free | 1 | 0 | free.fr|freesbee.fr|libertysurf.fr|worldonline.fr|online.fr|alicepro.fr|aliceadsl.fr | 0 | 0 |
7| 3 | gmail | 1 | 0 | gmail.com | 0 | 0 |
8| 4 | sfr | 2 | 0 | sfr.fr|neuf.fr|cegetel.net | 0 | 0 |
9| 5 | laposte | 2 | 0 | laposte.net | 0 | 0 |
10| 6 | autre | 2 | 0 | blabla.com | 0 | 0 |
11| 7 | hotmail | 1 | 0 | hotmail.fr|msn.fr|live.fr|outlook.fr | 0 | 0 |
12| 8 | yahoo | 2 | 0 | yahoo.fr|yahoo.com | 0 | 0 |
13| 9 | aol | 1 | 0 | aol.com | 0 | 0 |
14+----+---------+----------------+--------------+--------------------------------------------------------------------------------------+----------------+--------------------------+
159 rows in set (0.00 sec)
16
17mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 1;
18+----------+
19| count(*) |
20+----------+
21| 6007 |
22+----------+
231 row in set, 1 warning (0.17 sec)
24
25mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 2;
26+----------+
27| count(*) |
28+----------+
29| 3836 |
30+----------+
311 row in set, 1 warning (0.15 sec)
32
33mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 3;
34+----------+
35| count(*) |
36+----------+
37| 0 |
38+----------+
391 row in set, 1 warning (0.23 sec)
40
41mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 4;
42+----------+
43| count(*) |
44+----------+
45| 4328 |
46+----------+
471 row in set, 1 warning (0.15 sec)
48
49mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 5;
50+----------+
51| count(*) |
52+----------+
53| 0 |
54+----------+
551 row in set, 1 warning (0.14 sec)
56
57mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 6;
58+----------+
59| count(*) |
60+----------+
61| 1512 |
62+----------+
631 row in set, 1 warning (0.15 sec)
64
65mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 7;
66+----------+
67| count(*) |
68+----------+
69| 0 |
70+----------+
711 row in set, 1 warning (0.18 sec)
72
73mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 8;
74+----------+
75| count(*) |
76+----------+
77| 0 |
78+----------+
791 row in set, 1 warning (0.16 sec)
80
81mysql> select count(*) from destinataires where base_id = 3 and created_at like '2018-06%' and fai_id = 9;
82+----------+
83| count(*) |
84+----------+
85| 0 |
86+----------+
871 row in set, 1 warning (0.13 sec)