Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 16, 2024 at 06:48 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_segments` PROCEDURE ANALYSE();
Rows: 5
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.email_segments.segmentid | 2 | 12 | 1 | 2 | 0 | 0 | 6.8000 | 3.2496 | ENUM('2','3','4','5','6','7','8','10','11','12') NOT NULL |
| puroparty.email_segments.segmentname | aol | yahoo | 2 | 13 | 0 | 0 | 5.6000 | NULL | ENUM('aol','cityofhouston','edu','gmail','hotmail','msn','rr','sbcglobal','swbell','yahoo') NOT NULL |
| puroparty.email_segments.createdate | 1244026825 | 1244028640 | 10 | 10 | 0 | 0 | 1244027431.5000 | 0.0000 | ENUM('1244026825','1244026866','1244026908','1244026964','1244027089','1244027141','1244027536','1244028159','1244028187','1244028640') NOT NULL |
| puroparty.email_segments.ownerid | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
| puroparty.email_segments.searchinfo | a:3:{s:5:"Lists";a:1:{i:0;s:1:"2";}s:5:"Rules";a:1:{i:0;a:3:{s:4:"type";s:5:"group";s:9:"connector";s:3:"and";s:5:"rules";a:1:{i:0;a:3:{s:4:"type";s:4:"rule";s:9:"connector";s:3:"and";s:5:"rules";a:3:{s:8:"ruleName";s:5:"email";s:12:"ruleOperator";s:7:"equalto";s:10:"ruleValues";a:1:{i:0;s:13:"cityofhouston";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:568:"SELECT DISTINCT subscribers.subscriberid AS subscriberid , subscribers.emailaddress AS emailaddress , subscribers.subscribedate AS subscribedate , subscribers.format AS format , subscribers.unsubscribed AS unsubscribed , subscribers.bounced AS bounced , subscribers.confirmed AS confirmed , subscribers.listid AS listid , lists.name AS listname FROM email_list_subscribers AS subscribers JOIN email_lists AS lists ON lists.listid = subscribers.listid AND lists.listid IN (2) WHERE subscribers.listid IN (2) AND ( ( subscribers.emailaddress LIKE '%cityofhouston%' ) )";s:10:"countQuery";s:280:"SELECT COUNT(DISTINCT subscribers.subscriberid) AS count FROM email_list_subscribers AS subscribers JOIN email_lists AS lists ON lists.listid = subscribers.listid AND lists.listid IN (2) WHERE subscribers.listid IN (2) AND ( ( subscribers.emailaddress LIKE '%cityofhouston%' ) )";}} | a:3:{s:5:"Lists";a:1:{i:0;s:1:"2";}s:5:"Rules";a:1:{i:0;a:3:{s:4:"type";s:5:"group";s:9:"connector";s:3:"and";s:5:"rules";a:1:{i:0;a:3:{s:4:"type";s:4:"rule";s:9:"connector";s:3:"and";s:5:"rules";a:3:{s:8:"ruleName";s:5:"email";s:12:"ruleOperator";s:7:"equalto";s:10:"ruleValues";a:1:{i:0;s:9:"sbcglobal";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:564:"SELECT DISTINCT subscribers.subscriberid AS subscriberid , subscribers.emailaddress AS emailaddress , subscribers.subscribedate AS subscribedate , subscribers.format AS format , subscribers.unsubscribed AS unsubscribed , subscribers.bounced AS bounced , subscribers.confirmed AS confirmed , subscribers.listid AS listid , lists.name AS listname FROM email_list_subscribers AS subscribers JOIN email_lists AS lists ON lists.listid = subscribers.listid AND lists.listid IN (2) WHERE subscribers.listid IN (2) AND ( ( subscribers.emailaddress LIKE '%sbcglobal%' ) )";s:10:"countQuery";s:276:"SELECT COUNT(DISTINCT subscribers.subscriberid) AS count FROM email_list_subscribers AS subscribers JOIN email_lists AS lists ON lists.listid = subscribers.listid AND lists.listid IN (2) WHERE subscribers.listid IN (2) AND ( ( subscribers.emailaddress LIKE '%sbcglobal%' ) )";}} | 1236 | 1270 | 0 | 0 | 1246.9000 | NULL | TEXT NOT NULL |