SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 03:35 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_stats_newsletters` ORDER BY `newsletterid` ASC LIMIT 0, 30;
Rows: 30

statid queueid jobid starttime finishtime htmlrecipients textrecipients multipartrecipients trackopens tracklinks bouncecount_soft bouncecount_hard bouncecount_unknown unsubscribecount newsletterid sendfromname sendfromemail bounceemail replytoemail charset sendinformation sendsize sentby notifyowner linkclicks emailopens emailforwards emailopens_unique htmlopens htmlopens_unique textopens textopens_unique hiddenby sendtestmode
2 2 1 1219292572 1219292608 0 0 1 1 1 0 0 0 0 1 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 1 1 0 0 1 0 1 1 1 0 0 0 0
3 3 2 1219293710 1219293739 0 0 2 1 1 0 0 0 0 1 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 2 1 0 0 3 0 2 3 2 0 0 0 0
4 4 3 1220653564 1220653593 0 0 2 1 1 0 0 0 1 2 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 2 1 0 2 3 0 2 3 2 0 0 0 0
5 5 4 1220654564 1220654581 0 0 2 1 1 0 0 0 0 2 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 2 1 0 1 2 0 2 2 2 0 0 0 0
6 6 5 1220654786 0 0 0 5779 1 1 0 0 0 6 2 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"2";}s:6:"Status";s:1:"a";} 19151 1 0 234 753 0 587 753 587 0 0 0 0
7 7 6 1220857895 1220857911 0 0 4 1 1 0 0 0 0 3 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 4 1 0 3 3 0 3 3 3 0 0 0 0
8 8 7 1224237621 1224278516 0 0 19145 1 1 0 0 0 0 4 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"2";}s:6:"Status";s:1:"a";} 19145 1 0 232 2131 0 1107 2131 1107 0 0 0 0
9 9 8 1224890135 1224914530 0 0 19145 1 1 0 0 0 4 7 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"2";}s:6:"Status";s:1:"a";} 19145 1 0 190 1641 0 1028 1641 1028 0 0 0 0
10 10 9 1228988083 1229004870 0 0 19142 1 1 0 0 0 5 9 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"2";}s:6:"Status";s:1:"a";} 19142 1 0 319 2432 0 1766 2431 1765 0 0 0 0
11 11 10 1237430383 1237430413 0 0 4 1 1 0 0 0 1 10 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 4 1 0 0 2 0 2 2 2 0 0 0 0
12 12 11 1237438435 1237438448 0 0 4 1 1 0 0 0 0 10 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 4 1 0 0 2 0 2 2 2 0 0 0 0
13 13 12 1237438807 1237438815 0 0 4 1 1 0 0 0 0 10 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 4 1 0 0 2 0 2 2 2 0 0 0 0
15 15 14 1237445819 1237445868 0 0 4 1 1 0 0 0 0 10 pp ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"5";}s:6:"Status";s:1:"a";} 4 1 0 0 8 0 4 8 4 0 0 0 0
16 16 15 1237455183 1237455211 0 0 1 1 1 0 0 0 0 10 robert ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 1 1 0 1 1 0 1 1 1 0 0 0 0
17 17 16 1237460758 1237460768 0 0 1 1 1 0 0 0 0 10 robert ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 1 1 0 0 1 0 1 1 1 0 0 0 0
18 18 17 1237460974 1237460988 0 0 1 1 1 0 0 0 0 10 robert ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 1 1 0 2 1 0 1 1 1 0 0 0 0
19 19 18 1237461300 0 0 0 456 1 1 0 0 0 0 10 PuroParty Events ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:4:{i:0;s:1:"5";i:1;s:1:"6";i:2;s:1:"2";i:3;s:1:"1";}s:6:"Status";s:1:"a";} 19139 1 0 5 39 0 33 39 33 0 0 0 0
21 21 20 1237462623 1237508445 0 0 19138 1 1 0 0 0 46 10 PuroParty Events ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:2:{i:0;s:1:"5";i:1;s:1:"2";}s:6:"Status";s:1:"a";} 19138 1 0 526 3206 0 1770 3206 1770 0 0 0 0
22 22 21 1237984807 0 0 0 43 1 1 0 0 0 0 11 PuroParty Events ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"2";}s:6:"Status";s:1:"a";} 19091 1 0 0 8 0 8 8 8 0 0 0 0
25 25 24 1237988064 1237988074 0 0 4 1 1 0 0 0 0 12 PuroParty Events ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 4 1 0 0 1 0 1 1 1 0 0 0 0
26 26 25 1237988322 1237988346 0 0 4 1 1 0 0 0 0 12 PuroParty Events ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"1";}s:6:"Status";s:1:"a";} 4 1 0 0 2 0 1 2 1 0 0 0 0
27 27 26 1237988500 1238023609 0 0 19091 1 1 0 0 0 51 12 PuroParty Events ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"2";}s:6:"Status";s:1:"a";} 19091 1 0 239 3758 0 1716 3758 1716 0 0 0 0
28 28 27 1240303688 1240303703 0 0 1 1 1 0 0 0 0 13 robert ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 1 1 0 0 1 0 1 1 1 0 0 0 0
29 29 28 1240304605 1240304617 0 0 1 1 1 0 0 0 0 13 robert ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 1 1 0 0 1 0 1 1 1 0 0 0 0
30 30 29 1240304806 0 0 0 1527 1 1 0 0 0 1 13 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"2";}s:6:"Status";s:1:"a";} 19040 1 0 16 301 0 179 301 179 0 0 0 0
33 33 32 1241596924 1241596950 0 0 1 1 1 0 0 0 0 14 ppevents events@puroparty.com events@puroparty.com events@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 1 1 0 3 1 0 1 1 1 0 0 0 0
34 34 33 1241597458 1241597489 0 0 2 1 1 0 0 0 0 14 ppevents events@puroparty.com events@puroparty.com events@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 2 1 0 0 1 0 1 1 1 0 0 0 0
31 31 30 1240356588 1240356606 0 0 1 1 1 0 0 0 0 15 robert ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 1 1 0 5 1 0 1 1 1 0 0 0 0
32 32 31 1240356848 1240386172 0 0 19040 1 1 0 0 0 38 15 PuroParty ppcru@puroparty.com ppcru@puroparty.com ppcru@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:2:{i:0;s:1:"5";i:1;s:1:"2";}s:6:"Status";s:1:"a";} 19040 1 0 838 2981 0 1609 2981 1609 0 0 0 0
35 35 34 1241604792 1241604812 0 0 2 1 1 0 0 0 0 17 PuroParty events@puroparty.com events@puroparty.com events@puroparty.com UTF-8 a:3:{s:12:"CustomFields";a:0:{}s:4:"List";a:1:{i:0;s:1:"6";}s:6:"Status";s:1:"a";} 2 1 0 5 3 0 2 3 2 0 0 0 0