SQL result

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

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.ads_system.id 2 92 1 2 0 0 47.0000 26.5518 ENUM('2','4','6','8','10','12','14','16','18','20','22','24','26','28','30','32','34','36','38','40','42','44','46','48','50','52','54','56','58','60','62','64','66','68','70','72','74','76','78','80','82','84','86','88','90','92') NOT NULL
puroparty.ads_system.item allow_anon useGeo 3 17 0 0 9.9130 NULL ENUM('allow_anon','allow_bold','allow_color','allow_featured','allow_italic','auto_approve','banned_emails','banner','cat_columns','counts','css','display','expired_check','fee_bold','fee_color','fee_featured','fee_images','fee_italic','from_email','integration','language','list_columns','max_size','max_size_orig','meta_desc','meta_key','numrss','num_images','page_footer','page_header','page_width','panel_bottom','panel_top','payment_modules','spider','subcats','time_1','time_1_multiplier','time_2','time_2_multiplier','time_3','time_3_multiplier','time_4','time_4_multiplier','title','useGeo') NOT NULL
puroparty.ads_system.value +1 day uus 1 5636 1 0 137.4130 NULL ENUM('','+1 day','+1 month','+1 week','+3 months','0','0.00','1','1|0.00','1||1||puroparty@puroparty.com||||\n2||0||||||\n3||0||||||\n4||0||||||\n5||0||||||\n6||0||||||\n7||0||||||\n8||0||||||\n9||0||||||\n10||0||||||\n','2','2000','2007-09-21','265','3','32','5','500','750','<head>\r\n<META name="description" content="Welcome to Puro Party, \'Texas\' Premier Hispanic-Latino Entertainment Magazine\'! The latest in Tejano, Latin, Mexican norteno, hip-hop and the reggaeton scene. Concert and event Promotions and Bookings including DJs, Bands, and Mariachis. World\'s largest galeria of latin concert pictures and Spanish lyrics! PuroParty.com...REACHING HISPANICS!">\r\n\r\n<META name="keywords" content="puroparty, puro party, puro, party, concerts, promotions, events, entertainment, booking agent, djs, musicians, artists, singers, bands, grupos, conjunto, mariachis, wedding, quinceanera, bodas, sound, sonido, clubs, bars, club search, pool halls, beer bars, night scene, night life, music, venues, party on the plaza, pop, fiesta, fan fare, fan fair, cookoff, rodeo, hlsr, tejano music awards, houston livestock show and rodeo, strawberry fest, houston international festival, ifest, sports, houston, h-town, pasadena, south houston, san antonio,  texas, tx, mexico, lyrics, spanish lyrics, letras, canciones, radio, musica, mp3, clips, music videos, international, latin pop, latin rock, \r\nnortena, norteno, salsa, merengue, norteno,  hip-hop, grupero, la onda, onda, cumbia, mambo, ritmo, flamenco, pachanga, tango, tropical, reggaeton, banda, conjunto, regional,rancheras, tejano, tejana, mexican, spanish, latin, latino, latina, hispanic, hispano,">\r\n\r\n</head>\r\n\r\n<body topmargin="0" leftmargin="0" background="http://www.puroparty.com/graphics/bg44.jpg">\r\n\r\n<table border="0" bordercolor=red cellpadding="0" cellspacing="0" width="770" align=center>\r\n   <tr>\r\n    <td valign=top><img src="http://www.puroparty.com/graphics/1d.jpg"></td>\r\n    <td width="100%" background="http://www.puroparty.com/graphics/bg.jpg" valign=top></td>\r\n    <td>\r\n\r\n\r\n<table border="0" bordercolor=blue cellpadding="0" cellspacing="0">\r\n  <tr>\r\n    <td colspan="3" valign=top><img src="http://www.puroparty.com/graphics/2.jpg"></td>\r\n  </tr>\r\n  <tr>\r\n    <td valign=top><img src="http://www.puroparty.com/graphics/3.jpg"></td>\r\n\r\n\r\n<td width="468" height=60 bgcolor="#606060"></td>\r\n        <td valign=top><img src="http://www.puroparty.com/graphics/4.jpg"></td></tr>\r\n   <tr>\r\n    <td colspan="3" valign=top><img src="http://www.puroparty.com/graphics/5.jpg"></td>\r\n   </tr>\r\n</table>\r\n\r\n\r\n    </td>\r\n   </tr>\r\n\r\n\r\n\r\n\r\n<tr>\r\n    <td width="100%" colspan=3 height=23 bgcolor="maroon">\r\n<table width=100% bgcolor="maroon" align=center valign=top border=0 bordercolor=yellow cellpadding=5 cellspacing=0>\r\n\r\n   <tr valign=top>\r\n    <td>\r\n    <a href=http://www.puroparty.com/index.php class=link3><font size=2 color=white>home</a><br>\r\n    <a href=http://www.puroparty.com/lagaleria.php?year=2007 class=link3><font size=2 color=white>la galeria</a><br>\r\n    <a href=http://www.puroparty.com/lyric.php class=link3><font size=2 color=white>lyrics</a><br>\r\n    </td>\r\n\r\n    <td>\r\n    <a href=http://www.puroparty.com/pizarra.php class=link3><font size=2 color=white>tagboard</a><br>\r\n    <a href=http://www.puroparty.com/calendario class=link3><font size=2 color=white>calendario</a><br>\r\n    <a href=http://www.puroparty.com/djs.php class=link3><font size=2 color=white>djs</a>\r\n    </td>\r\n\r\n    <td>\r\n    <a href=http://www.puroparty.com/clubs.php class=link3><font size=2 color=white>clubs & events</a><br>\r\n    <a href=http://www.puroparty.com/videos.php class=link3><font size=2 color=white>music videos</a><br>\r\n    <a href=http://www.puroparty.com/artists.php class=link3><font size=2 color=white>artists</a><br>\r\n    </td>\r\n\r\n    <td>\r\n    <a href=http://www.puroparty.com/charts.php class=link3><font size=2 color=white>radio charts</a><br>\r\n\r\n    <A HREF="javascript:popUp3(\'http://www.puroparty.us/ppjuke_popup.php\')" class=link3><font size=2 color=white>jukebox</a><br>\r\n<a href=http://www.puroparty.com/services.php class=link3><font size=2 color=white>services</a><br>\r\n\r\n    \r\n    <td>\r\n    \r\n\r\n    </td>\r\n\r\n    <!--<td>\r\n    <a href=http://www.puroparty.com/represent.html class=link3><font size=2 color=white>where u from?<br><img src=http://www.puroparty.com/images/repbut.jpg border=0 height=18></a>\r\n    </td>-->\r\n\r\n\r\n    <td>\r\n<form method="POST" action="http://puroparty.com/cgi-bin/mmf/sub.pl">\r\n<font color=white>Subscribe to the PP Newsletter<br>\r\n<input type="text" name="email" style="width:150px;height:18px;font-size:10px" value="type your email here" email?" onclick="clearText(this)">\r\n<input type="hidden" name="task" value="subscribe">\r\n<input type="hidden" name="list" value="ppnew">\r\n<input type="hidden" name="language" value="eng">\r\n<input type="image" src="http://www.puroparty.com/graphics/submit_butt.jpg" value="Submit" alt="Submit">\r\n</form>\r\n    </td>\r\n   </tr>\r\n</table>    \r\n    </td>\r\n   </tr>\r\n   <tr>\r\n    <td colspan="3">\r\n<table border="0" bordercolor=green cellpadding="0" cellspacing="0">\r\n\r\n\r\n  <tr>\r\n    <td valign=top><img src="http://www.puroparty.com/graphics/6.jpg"></td>\r\n      <td valign=top width="100%" background="http://www.puroparty.com/graphics/bg2.jpg"></td>\r\n      <td valign=top><img src="http://www.puroparty.com/graphics/7.jpg"></td>\r\n</table>\r\n\r\n\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n    <td colspan="3" width="100%" valign=top>\r\n\r\n\r\n<table border="0" bordercolor=black cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">\r\n  <tr>\r\n    <td width="100%" valign="top">\r\n\r\n\r\n\r\n<table border="0" bordercolor=magenta cellpadding="0" cellspacing="0" width="100%" bgcolor="#FFFFFF">\r\n    <tr><td>\r\n\r\n\r\n</table>\r\n</table>\r\n</table>\r\n\r\n\r\n\r\n\r\n<table border=0 bordercolor=blue width=770 align=center cellspacing=0 cellpadding=0 topmargin=0 rightmargin=0 bgcolor=white>\r\n      <tr>\r\n        <td align=center valign=top>\r\n\r\n\r\n    \r\n\r\n        <table width=100% cellpadding=0 cellspacing=0 border=0>\r\n        \r\n                  <tr>\r\n                    <td>\r\n\r\n\r\n</head>','Copyright PuroParty (r) 1999 - 2007<br>\r\nAll Rights Reserved<br>\r\nWebsite by Cyber One Systems','english','PP Events List','ppbanwpp468x60.gif','ppcru@puroparty.com','puroparty, puro, party, clubs, events, concerts, hispanic, latino, tejano, latin, entertainment, houston, san antonio, bands, djs','style.css','The PuroParty Ads system will allow your visitors to post, and look at ads for clubs, concerts, events. They can also browse for items for sale.','uus') NOT NULL