SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 12:59 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_newsletters` PROCEDURE ANALYSE();
Rows: 10

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.email_newsletters.newsletterid 1 30 1 2 0 0 15.1364 9.1914 ENUM('1','2','3','4','7','8','9','10','11','12','13','14','15','17','21','22','24','26','27','28','29','30') NOT NULL
puroparty.email_newsletters.name 80s & 90s Fest Test 1 Campaign 5 37 0 0 21.6364 NULL ENUM('80s & 90s Fest','Alejandra, Little Texas at Arena','Census Expo','Census Expo 2010','chuly hush n old school hr','chuly hush n old school hr fin2','chuly old school n hush fin','Copy of Presidential Poll','Copy of Roberto Pulido at Las Rosas','Fito, Chuly, Joe Soto','fito, yo mtv - linked','Friday Night Accordian Concert Series','jimmy','Las Rosas 10-18-08','POP - Hobbs, Ayala','POP - Hobbs, Ayala - linked','Presidential Poll','Roberto Pulido at Las Rosas','Smokin Tejanos','Smokin Tejanos Frontier Fiesta','Stampede1','Test 1 Campaign') NOT NULL
puroparty.email_newsletters.format b b 1 1 0 0 1.0000 NULL ENUM('b') NOT NULL
puroparty.email_newsletters.subject Census Expo! Prizes and Entertainment! Smokin Tejanos at Frontier Fiesta Cook-off 20 50 0 0 29.5455 NULL ENUM('Census Expo! Prizes and Entertainment!','Jaime y Los Chamacos at Las Rosas','New Friday Night Concert Series','Presidential Poll - Be Counted','Puro Party Hot Events','Puro Party Hot Events - POP','Puro Party Hot Events - Stampede, Mazz, Ram, Aviso','PuroParty Events - Jimmy Gonzales y Mazz','PuroParty Hot Events','Roberto Pulido at Las Rosas','Smokin Tejanos at Frontier Fiesta Cook-off') NOT NULL
puroparty.email_newsletters.textbody %%unsubscribelink%%Your email client cannot read this email.\r\nTo view it online, please go here: %%webversion%%\r\n\r\n\r\nTo stop receiving these emails:%%unsubscribelink%% Your email client cannot read this email.\r\nTo view it online, please go here: %%webversion%%\r\n\r\n\r\nTo stop receiving these emails:%%unsubscribelink%% 148 167 0 0 149.7273 NULL ENUM('%%unsubscribelink%%Your email client cannot read this email.\r\nTo view it online, please go here: %%webversion%%\r\n\r\n\r\nTo stop receiving these emails:%%unsubscribelink%%','Your email client cannot read this email.\r\nTo view it online, please go here: %%webversion%%\r\n\r\n\r\nTo stop receiving these emails:%%unsubscribelink%%') NOT NULL
puroparty.email_newsletters.htmlbody <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"                   />\r\n<html xmlns="http://www.w3.org/1999/xhtml"><head>\r\n\r\n\r\n<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>\r\n<meta content="en-us" http-equiv="Content-Language"/>\r\n<meta name="GENERATOR" content="MSHTML 8.00.6001.18372"/></head>\r\n<body>\r\n<table width="100%" bgcolor="#aaaaaa" description="lightestBgcolor" name="tid">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<div style="PADDING-BOTTOM: 30px; MARGIN: 0px; PADDING-LEFT: 30px; PADDING-RIGHT: 30px; PADDING-TOP: 30px">\r\n<table style="FONT-FAMILY: 'Verdana'" cellspacing="0" cellpadding="0" width="600" align="center">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<table border="0" cellspacing="0" cellpadding="0" width="100%">\r\n<tbody>\r\n<tr>\r\n<td height="25" width="10"><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/c1.gif" width="10" height="25"/></td>\r\n<td bgcolor="#ffffff" colspan="2">&nbsp;</td>\r\n<td height="25" width="10"><img src="http://puroparty.com/emailmark5/admin/resources/email_templates/Music/Brass%20Drums/c2.gif" width="10" height="25"/></td></tr>\r\n<tr bgcolor="#ffffff">\r\n<td valign="top" align="left">&nbsp;</td>\r\n<td style="BORDER-BOTTOM: rgb(51,8,0) 3px solid; PADDING-BOTTOM: 15px; PADDING-LEFT: 10px; PADDING-RIGHT: 0px; FONT-WEIGHT: bold; PADDING-TOP: 50px" valign="top" width="256" align="left">\r\n<h1 style="PADDING-BOTTOM: 2px; LINE-HEIGHT: 26px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: 'Arial'; LETTER-SPACING: -1px; COLOR: rgb(85,85,85); FONT-SIZE: 28px; FONT-WEIGHT: normal; PADDING-TOP: 2px" description="mediumColor" name="tid"><span style="FONT-SIZE: 24pt"><span style="FONT-WEIGHT: bold"><span style="FONT-SIZE: 24pt">Smokin' Tejanos Party Tent</span></span></span><br/></h1><br/><span style="PADDING-BOTTOM: 2px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: 'Verdana'; COLOR: rgb(102,102,102); FONT-SIZE: 11px; PADDING-TOP: 2px"><strong><font color="#ff0000" size="5">Frontier Fiesta Cook-off 2009<br/></font>Thurs March 26 - Sat March 28<br/></strong></span></td>\r\n<td style="BORDER-BOTTOM: rgb(51,8,0) 3px solid; TEXT-ALIGN: center" valign="top" width="324"><img style="WIDTH: 260px; HEIGHT: 156px" title="" border="0" alt="" align="baseline" src="http://puroparty.com/emailmark5/admin/temp/newsletters/11/puroparty_logo_450x271.jpg"/><br/>\r\n<center><font color="black" size="3"><b>Upcoming Hot Events</b></font><br/><br/><font color="blue" size="2"><b>Clubs, Concerts, DJs, Bands, Mariachis<br/>Place Your Ad on the <br/><a href="http://www.puroparty.com/xcorkboard.php" target="_blank">PuroParty CorkBoard</a></b><br/><br/></font></center></td>\r\n<td>&nbsp;</td></tr></tbody></table></td></tr>\r\n<tr>\r\n<td style="PADDING-BOTTOM: 7px; PADDING-LEFT: 7px; PADDING-RIGHT: 7px; PADDING-TOP: 7px" bgcolor="#ffffff">\r\n<table style="WIDTH: 580px; HEIGHT: 103px" border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff">\r\n<tbody>\r\n<tr>\r\n<td style="PADDING-LEFT: 15px" valign="top" colspan="2">\r\n<div style="TEXT-ALIGN: center; FONT-SIZE: 24pt">FRONTIER FIESTA<br/>Cook-off 2009<br/><br/><font style="FONT-SIZE: 36pt" color="#ff0000">SMOKIN' TEJANOS<br/>PARTY TENT<br/></font><font color="#000000"><span style="FONT-SIZE: 12pt"><span style="FONT-SIZE: 18pt">at the University of Houston<br/></span>(Robertson Stadium Parking Lot - Scott @ Wheeler St.)<br/></span><br/></font><font color="#0000ff">THUR MARCH 26 - SAT MARCH 28<br/><br/></font><span style="FONT-SIZE: 18pt">Music By: <font color="#ff0000">DJ Gabe & Jammin' Frickin' J<br/><br/></font></span><span style="FONT-SIZE: 18pt">Fiesta City Concerts:<br/>Fri - <font color="#ff0000">FRANKIE J<br/></font>Sat - <font color="#ff0000">RECKLESS KELLY<br/></font></span><br/><font color="#ff0000">FREE FOOD - FREE BEER<br/></font><span style="FONT-SIZE: 14pt">with $10 Entry Donation</span><br/><br/><br/><br/></div></td></tr></tbody></table></td></tr></tbody></table></div></td></tr></tbody></table></body></html> <html><head>\r\n<meta content="MSHTML 6.00.6000.16711" name="GENERATOR"/></head>\r\n<body>\r\n<table bordercolor="black" cellspacing="0" cellpadding="0" width="640" border="1">\r\n<tbody>\r\n<tr>\r\n<td>\r\n<table bordercolor="white" cellspacing="0" cellpadding="0" width="640" border="0">\r\n<tbody>\r\n<tr>\r\n<td valign="center"><a href="http://www.puroparty.com/"><img src="http://www.puroparty.com/emails/logo2.jpg" width="180" border="0"/></a> </td>\r\n<td>\r\n<center><font color="black" size="6"><b>Upcoming Hot Events</b></font><br/><br/><font color="blue" size="3"><b>Clubs, Concerts, DJs, Bands, Mariachis<br/></b><br/><br/></font></center></td></tr></tbody></table>\r\n<hr width="95%" size="1"/>\r\n\r\n<table bordercolor="white" cellspacing="0" cellpadding="0" width="630" align="center" bgcolor="#262525" border="0">\r\n<tbody>\r\n<tr>\r\n<td width="300"><img src="http://www.puroparty.com/emails/lasrosas101808.jpg"/> </td>\r\n<td valign="top" height="250"><font face="arial" color="yellow" size="4">\r\n<center><br/>Jaime y Los Chamacos<br/><font face="arial" color="white" size="3">Las Rosas Mexican Restaurant<br/>Saturday, October 18, 2008 <br/><br/><font face="arial" color="white" size="2">Las Rosas Mexican Restaurant brings you a live performances by Jaime y Los Chamacos this Saturday, October 18.<br/><br/>Get there early for great seating and enjoy great food & drinks.<br/><br/><font color="yellow" size="3"><b>FREE - NO COVER</b> <br/><b>INTERNATIONAL BAR/MIXED DRINKS<br/>PLENTY OF PARKING</b><br/></font><br/>6425 Broadway, Pearland, TX <br/><br/>Make Your Reservations Now!<br/>281-412-3663<br/><br/><a href="http://www.puroparty.com"><font face="arial" color="yellow" size="2"><b>Visit PuroParty.com</b></font></a><font face="arial" color="yellow" size="2"><b> <br/><br/></b></font></font></font></center></font></td></tr></tbody></table>\r\n</td></tr></tbody></table></body></html> 1450 7018 0 0 3972.6364 NULL TEXT NOT NULL
puroparty.email_newsletters.createdate 1219291610 1269577689 10 10 0 0 1235124513.0909 0.0000 ENUM('1219291610','1220652505','1224237249','1224889224','1228987607','1237423648','1240293769','1269577689') NOT NULL
puroparty.email_newsletters.active 0 1 1 1 21 0 0.0455 0.2083 ENUM('0','1') NOT NULL
puroparty.email_newsletters.archive 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.email_newsletters.ownerid 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL