SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 22, 2018 at 06:23 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_stats_newsletters` ORDER BY `emailopens_unique` 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
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
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
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
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
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
39 40 38 1244623433 1244623446 0 0 2 1 1 0 0 0 0 22 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";} 2 1 0 1 1 0 1 1 1 0 0 1 0
43 44 42 1255046550 1255046583 0 0 2 1 1 0 0 0 0 27 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 0 1 0 1 1 1 0 0 0 0
45 46 44 1255047356 1255047366 0 0 2 1 1 0 0 0 0 27 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:"6";}s:6:"Status";s:1:"a";} 2 1 0 0 1 0 1 1 1 0 0 0 0
46 47 45 1255047651 1255047697 0 0 2 1 1 0 0 0 0 27 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";} 2 1 0 0 1 0 1 1 1 0 0 0 0
47 48 46 1255048383 1255048394 0 0 2 1 1 0 0 0 0 27 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";} 2 1 0 0 1 0 1 1 1 0 0 0 0
56 57 55 1258680635 1258680729 0 0 3 1 1 0 0 0 0 28 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:"6";}s:6:"Status";s:1:"a";} 3 1 0 0 1 0 1 1 1 0 0 0 0
59 60 58 1258683509 0 0 0 29 1 0 0 0 0 0 28 PuroParty puroparty@puroparty.com events@puroparty.com puroparty@puroparty.com UTF-8 N; 1139 1 0 0 3 0 1 3 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
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
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
37 37 36 1244022539 1244022558 0 0 2 1 1 0 0 0 0 21 puroparty puroparty@puroparty.com events@puroparty.com puroparty@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 2 3 0 2 3 2 0 0 0 0
44 45 43 1255047016 1255047047 0 0 2 1 1 0 0 0 0 27 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 0 2 0 2 2 2 0 0 0 0
50 51 49 1258677329 1258677344 0 0 2 1 0 0 0 0 0 28 PuroParty puroparty@puroparty.com events@puroparty.com puroparty@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 2 0 2 2 2 0 0 0 0
51 52 50 1258678037 1258678050 0 0 3 1 1 0 0 0 0 28 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";} 3 1 0 0 2 0 2 2 2 0 0 0 0
60 61 59 1258683972 0 0 0 58 1 0 0 0 0 0 28 PuroParty puroparty@puroparty.com events@puroparty.com puroparty@puroparty.com UTF-8 N; 1139 1 0 0 3 0 2 3 2 0 0 0 0