Server: mysql.puroparty.com

Database: puroparty

Table: email_stats_newsletters

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 739328 kB

Select fields (at least one): 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 DISTINCT

Number of rows per page :   Display order: 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 Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value statid int(11) = > >= < <= != LIKE NOT LIKE queueid int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL jobid int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL starttime int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL finishtime int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL htmlrecipients int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL textrecipients int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL multipartrecipients int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL trackopens char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL tracklinks char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL bouncecount_soft int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL bouncecount_hard int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL bouncecount_unknown int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL unsubscribecount int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL newsletterid int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL sendfromname varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL sendfromemail varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL bounceemail varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL replytoemail varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL charset varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL sendinformation mediumtext utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL sendsize int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL sentby int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL notifyowner char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL linkclicks int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL emailopens int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL emailforwards int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL emailopens_unique int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL htmlopens int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL htmlopens_unique int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL textopens int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL textopens_unique int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL hiddenby int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL sendtestmode int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL