Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_segmentsemail_segments
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

InnoDB free: 737280 kB

Showing rows 0 - 9 (10 total, Query took 0.0012 sec)
SQL-query: 
SELECT *
FROM `email_segments`
ORDER BY `ownerid` ASC
LIMIT 0 , 30
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]

   
row(s) starting from record #
in mode and repeat headers after cells
   
Sort by key:  
Partial Texts
segmentid
segmentname
createdate
ownerid Ascending
searchinfo
Edit Delete 2 aol 1244026825 1 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:3:"aol";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:558:"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 '%aol%' ) )";s:10:"countQuery";s:270:"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 '%aol%' ) )";}}
Edit Delete 3 gmail 1244026866 1 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:5:"gmail";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:560:"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 '%gmail%' ) )";s:10:"countQuery";s:272:"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 '%gmail%' ) )";}}
Edit Delete 4 yahoo 1244026908 1 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:5:"yahoo";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:560:"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 '%yahoo%' ) )";s:10:"countQuery";s:272:"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 '%yahoo%' ) )";}}
Edit Delete 5 msn 1244026964 1 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:3:"msn";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:558:"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 '%msn%' ) )";s:10:"countQuery";s:270:"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 '%msn%' ) )";}}
Edit Delete 6 sbcglobal 1244027089 1 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%' ) )";}}
Edit Delete 7 hotmail 1244027141 1 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:7:"hotmail";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:562:"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 '%hotmail%' ) )";s:10:"countQuery";s:274:"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 '%hotmail%' ) )";}}
Edit Delete 8 rr 1244027536 1 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:2:"rr";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:557:"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 '%rr%' ) )";s:10:"countQuery";s:269:"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 '%rr%' ) )";}}
Edit Delete 10 cityofhouston 1244028159 1 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%' ) )";}}
Edit Delete 11 edu 1244028187 1 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:3:"edu";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:558:"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 '%edu%' ) )";s:10:"countQuery";s:270:"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 '%edu%' ) )";}}
Edit Delete 12 swbell 1244028640 1 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:6:"swbell";}}}}}}s:6:"_cache";a:3:{s:12:"cacheVersion";i:20080526;s:11:"selectQuery";s:561:"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 '%swbell%' ) )";s:10:"countQuery";s:273:"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 '%swbell%' ) )";}}
  With selected: Check All  /  Uncheck All   With selected:   

   
row(s) starting from record #
in mode and repeat headers after cells
   
Insert new rowInsert new row   Print viewPrint view   ExportExport