SQL result

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

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.extcal_2events.id 6 32 1 2 0 0 19.4615 7.5663 ENUM('6','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32') NOT NULL
puroparty.extcal_2events.title BBQ Cook Off Tourney Tuesday 5 85 0 0 21.2692 NULL ENUM('BBQ Cook Off','Beas Friday','Benefit Dance','CRAWFISH BOIL','emis-r ramos','Fiesta in San Antonio TX','Go Tejano Committee Mariachi Invitational','Gran Final Mujer Extraordinaria Dawn','H&H Icehouse','Hump Wednesday','Jacinto City Cook-off','Jimmy Edwards','Latina magazine Hosts Free “Your Quinces” Beauty & Fashion Event Sponsored by Finesse','Little Joe','My Sis\'s B-day','One of a Kind Cookers Benefit Dance','Pio Y Majic','Robert Medel Party','Rodeo','S.A. Tejano Conjunto Festival','San Antonio Rodeo','St.Patrick\'s Day','The Voice-Jay Perez','Thirsty Thursday','Tourney Tuesday') NOT NULL
puroparty.extcal_2events.description                     One of A Kind Cookers\r\n                            Is having a\r\n                           Benefit Dance\r\n                                    At\r\n                      The Drinking Room\r\n                                 with\r\n                            Impozzible\r\nDate:  April 14th 2007\r\nAddress: 510 F. M. 1092\r\n                 Stafford, Texas\r\nTime: 7:00pm til close\r\nTickets: Presale: $6.00    At Door: $8.00 (per person)\r\nFor Presale ticket they are available with Team Members and\r\nThe Drinking Room\r\n\r\nRaffle:\r\n1)    Ice Chest with goodies( a $50.00 value)\r\n2)    Margarita Basket\r\n3)    2 Buckets of beer (domestic)\r\n4)    Basket w/bottle\r\n\r\nRaffle tickets are also available to purchase\r\n   1 for $3.00\r\n   2 for $5.00\r\n\r\nFor further information please contact:\r\nMartin Olivarez   c)713-397-0408\r\nRuben Mendiola   c)832-721-8029\r\nMargie Olivarez   c)713-397-9158\r\n [I][CENTER]The Houston Livestock Show & Rodeo and The Go Tejano Committee present their 16th Annual Mariachi Inviational\r\nSaturday, March 10th at Verizon Wireless Theater\r\n520 Texas Ave.\r\nDoors open at 6 p.m.\r\nPre-show entertainment at 6:30 p.m.\r\nCompetition starts at 7 p.m.\r\n\r\nTickets available: \r\nwww.verizonwireless.com \r\nor \r\nVerizon Wirelss Theater Box Office\r\nor\r\nany Fiesta Ticketmaster outlet\r\n\r\n\r\nTicket prices are: $20, $25 & $30[/CENTER][/I] 7 1149 0 0 249.8077 NULL ENUM('                     One of A Kind Cookers\r\n                            Is having a\r\n                           Benefit Dance\r\n                                    At\r\n                      The Drinking Room\r\n                                 with\r\n                            Impozzible\r\nDate:  April 14th 2007\r\nAddress: 510 F. M. 1092\r\n                 Stafford, Texas\r\nTime: 7:00pm til close\r\nTickets: Presale: $6.00    At Door: $8.00 (per person)\r\nFor Presale ticket they are available with Team Members and\r\nThe Drinking Room\r\n\r\nRaffle:\r\n1)    Ice Chest with goodies( a $50.00 value)\r\n2)    Margarita Basket\r\n3)    2 Buckets of beer (domestic)\r\n4)    Basket w/bottle\r\n\r\nRaffle tickets are also available to purchase\r\n   1 for $3.00\r\n   2 for $5.00\r\n\r\nFor further information please contact:\r\nMartin Olivarez   c)713-397-0408\r\nRuben Mendiola   c)832-721-8029\r\nMargie Olivarez   c)713-397-9158\r\n','Beas Island Club\r\ndrink specials 8pm-10pm\r\n$2 well drinks\r\n$2 margaritas\r\n$2 domestic beer','Beas Island Club\r\ndrinks specials til 11pm\r\n$1.50 well drinks\r\n$1.50 margaritas\r\n$1.50 domestic beer\r\n$2.00 after','Come party with the owners of H&H Icehouse\r\nSilber off of I-1-.','concert','Concurso local para todas las mujeres Hispanas de Houston. \r\nEl concurso, patrocinado por Dawn, esta abierto a Houstonianas Latinas (madres, hijas, abuelas, tias, hermanas, etc); lo único que hay que hacer para participar es enviar una descripción de la persona con la categoria a esta direccion:\r\n \r\n“Mujer Extraordinaria Dawn” \r\nP.O. Box 460371 \r\nHouston, TX 77056\r\n \r\nO por email a mujerdawn@fleishman.com.\r\n \r\nLa premiación se llevará a cabo el 31 de marzo en Almeda Mall con jueces que decidirán quien es la "Mujer Extraordinaria" de Houston. Hay $1,500 en premios para la ganadora, incluyendo un tratameinto de lujo de spa; para consentir a las mujeres de nuestra vida.','Don\'t miss the Jacinto City/Galena Park Go Texan  Cookoff! Lot\'s of fun every year. FREE Food, Music and FUN at the Bull\'s Bunch, PC Cookers, and Big Bertha tents!','Fiesta block party in San Antonio Tx','Firefighter, Robert Medel\'s Birthday Party\r\n \r\nDJ - ICEMAN\r\n\r\nH&H Ice House (Hotrods & Harleys)\r\n1109 Silber\r\nI-10 West exit Silber to the right\r\n\r\n','Good Friday Crawfish Boil Cooked by Lil Rick @ Westcott Drive-Inn, starts @ 11:00am until it\'s all gone!  Come during lunch, or during your break, but just don\'t be late!','Houston Livestock Show & Rodeo\r\nLive on stage\r\nPesado & Emilio\r\ntickets available at\r\nrodeohouston.com & ticketmaster locations\r\nand by phone 1-800-726-1313','INTOCABLE!!!    What began as two friends playing together for fun has evolved into one of the hottest bands in Tejano and Norteno history. Intocable has won at least 8 of Univision\'s Premio Lo Nuestro Awards, and a Grammy. This is their second appearance at the SA Rodeo. ','Latina Magazine and Finesse® present a free opportunity to plan the perfect quinceañera including hair styling, beauty makeovers, tips for choosing the perfect dress, mini-spa and beauty treatments, party planning ideas, free gift bags, prizes, and much, much more.  \r\n\r\nCome with family or with friends and leave with a fabulous gift bag! \r\n','Live On Stage\r\nBeas Island Club\r\ndrink specials 8pm-10pm\r\n$2 well drinks\r\n$2 margaritas\r\n$2 domestic beer','Live On Stage\r\nPio Trevino Y Majic\r\ndrink specials 8pm-10pm\r\nwell drinks $2\r\nmargaritas $2\r\ndomestic beer $2\r\n','MadCow Cooker`s\r\nMadCow Cooker`s will be at the 51st annual Cook off at Sylvan Beach  April 27th and 28th ','One of A Kind Cookers\r\nIs having a\r\nBenefit Dance\r\nAt\r\nThe Drinking Room\r\nwith\r\nImpozzible\r\nDate: April 14th 2007\r\nAddress: 510 F. M. 1092\r\nStafford, Texas\r\nTime: 7:00pm til close\r\nTickets: Presale: $6.00 At Door: $8.00\r\n(per person)\r\nFor Presale ticket they are available with Team Members,\r\nThe Drinking Room and Tejano Headquarters\r\n\r\nRaffle:\r\n1) Ice Chest with goodies( a $50.00 value)\r\n2) Margarita Basket\r\n3) 2 Buckets of beer (domestic)\r\n4) Basket w/bottle\r\n\r\nRaffle tickets are also available to purchase\r\n1 for $3.00\r\n2 for $5.00\r\n\r\nFor further information please contact:\r\nMartin Olivarez c)713-397-0408\r\nRuben Mendiola c)832-721-8029\r\nMargie Olivarez c)713-397-9158\r\n \r\n','Original Neighborhood Bar\r\n$1.50 domestic beer\r\n4pm-7pm','Original Neighborhood Bar\r\ndj music\r\n$1.25 domestic beer\r\n8pm-2am','Original Neighborhood Bar\r\npool tournament\r\n1st place-$125\r\n2nd place-$75\r\n3rd place-$50\r\n$1.50 domestic beer\r\n2pm-2am','Party......................[B][/B]o yeah....','San Antonio Tejano Conjunto Festival, Rosedale Park\r\n\r\nThursday, May 10\r\n5:00-5:20 pm TCF Poster Contest Awards\r\n5:35-6:45 pm Bene Medina y el Conjunto Aguila\r\n7:00-8:10 pm Oscar Hernandez & the Tuff Band\r\n8:25-9:35 pm Paulino Bernal y el Conjunto Bernal\r\n9:50-11:00 pm Joel Guzmán y Los Aztex featuring Sarah Fox\r\n\r\nFriday, May 11\r\n5:00-6:15 pm Gilberto Perez y sus Compadres\r\n6:35-7:50 pm Los Fantasmas del Valle\r\n8:10-9:25 pm Ruben Vela y su Conjunto\r\n9:45-11:00pm Los Dos Gilbertos\r\n\r\nSaturday, May 12\r\n11:00-11:50 am Student Recital: GCAC/Conjunto Heritage Taller/Palo Alto College\r\n12:05-12:55 pm Los D Boyz\r\n1:10-2:00 pm Los Conjunto Kings de Flavio Longoria\r\n2:15-3:05 pm Nick Villarreal y su Conjunto\r\n3:20-4:10 pm Bernardo y sus Compadres\r\n4:25-5:15 pm Linda Escobar y su Conjunto\r\n5:30-6:20 pm Los Texmaniacs de Max Baca\r\n6:35-7:25 pm Ricky Naranjo y Los Gamblers\r\n7:30-7:50 pm Conjunto Music Hall of Fame Ceremony\r\n8:00-8:50 pm Eva Ybarra y su Conjunto\r\n9:05-9:55 pm Los Pavos Reales/Salvador Garcia y Eddie "Lalo" Torres\r\n10:10-11:00 pm Mingo Saldivar y sus Tremendos Cuatro Espadas\r\n11:15-12:05 pm Flaco Jimenez y su Conjunto','Six Mariachi groups will compete "Live" on stage, at Verizon Wireless Theatre - 520 Texas Ave. Downtown, to perform in the Finals on Go Tejano Day at the Houston Livestock Show & Rodeo. Tickets can be purchased at any Fiesta Mart, Ticket Master and Verizon Wireless Theatre.\r\n','St.Patrick\'s Day Party\r\nDJ-ICEMAN\r\n1109 Silber\r\nI-10 West exit Silber ,Right on Silber\r\n','[I][CENTER]The Houston Livestock Show & Rodeo and The Go Tejano Committee present their 16th Annual Mariachi Inviational\r\nSaturday, March 10th at Verizon Wireless Theater\r\n520 Texas Ave.\r\nDoors open at 6 p.m.\r\nPre-show entertainment at 6:30 p.m.\r\nCompetition starts at 7 p.m.\r\n\r\nTickets available: \r\nwww.verizonwireless.com \r\nor \r\nVerizon Wirelss Theater Box Office\r\nor\r\nany Fiesta Ticketmaster outlet\r\n\r\n\r\nTicket prices are: $20, $25 & $30[/CENTER][/I]') NOT NULL
puroparty.extcal_2events.contact 1-800-726-1313 Shirley 713-828-8551\r\nButch 281-228-3423 12 140 3 0 33.6154 NULL ENUM('','1-800-726-1313','713-645-8400','713-910-3004','713-944-2720','719-944-2720','Emily Arcos 713-434-9474 or Mike Martinez 713-598-1656','For further information please contact:\r\nMartin Olivarez   c)713-397-0408\r\nRuben Mendiola   c)832-721-8029\r\nMargie Olivarez   c)713-397-9158','Guadalupe Cultural Arts, San Antonio','H & H Icehouse\r\nRobert or Gilbert\r\n713-681-4191','Joe....You No JOe Mama...haha....','Lil Rick 832-830-2836 or\r\nMelissa Garza-Fuentes 832-275-4514','Martin Olivarez 713)397-0408 \r\nRuben Mendiola 832)721-8029 \r\nMargie Olivarez 713)397-9158 Email: ','Mike Martinez\r\n713.598.1656\r\n\r\nMary Closner\r\n281.300.9932\r\n\r\nEmily L. Arcos\r\n713.494.9474','Mujer Extraordinaria Dawn \r\nP.O. Box 460371 \r\nHouston, TX 77056','Owners: Robert Medel or Gilbert Castillo\r\n713-681-4191','Phone: (210) 225-5851','Quinces at Latina ','Shirley 713-828-8551\r\nButch 281-228-3423') NOT NULL
puroparty.extcal_2events.url PuroParty www.sarodeo.com/ 9 33 13 0 7.2308 NULL ENUM('','PuroParty','puroparty.com','puroparty.com/jaccity','www.guadalupeculturalarts.org','www.myspace.com/oneofakindcookers','www.sarodeo.com/') NOT NULL
puroparty.extcal_2events.email   quinces@latina.com 0 27 16 0 8.3846 NULL ENUM('','dude_21@hotmail.com','emilylarcos@yahoo.com','hicspanick@aol.com','htownplayers@sbcglobal.net','lilrickcrawfish@hotmail.com','mujerdawn@fleishman.com','ppcru@puroparty.com','quinces@latina.com') NOT NULL
puroparty.extcal_2events.picture   4a57_JimmyEdwardItsAllRight2.jpg 0 32 24 0 1.9231 NULL ENUM('','2529_littlejoe.jpg','4a57_JimmyEdwardItsAllRight2.jpg') NOT NULL
puroparty.extcal_2events.cat 1 3 1 1 0 0 2.0769 0.3846 ENUM('1','2','3') NOT NULL
puroparty.extcal_2events.day 3 31 1 2 0 0 14.7308 7.3983 ENUM('3','5','6','9','10','11','12','13','14','17','19','20','24','25','27','31') NOT NULL
puroparty.extcal_2events.month 1 5 1 1 0 0 2.6538 1.2071 ENUM('1','2','3','4','5') NOT NULL
puroparty.extcal_2events.year 2007 2007 4 4 0 0 2007.0000 0.0000 ENUM('2007') NOT NULL
puroparty.extcal_2events.approved 1 1 1 1 8 0 0.6923 0.4615 ENUM('0','1') NOT NULL
puroparty.extcal_2events.start_date 2007-01-09 08:00:00 2007-05-10 05:00:00 19 19 0 0 19.0000 NULL ENUM('2007-01-09 08:00:00','2007-01-10 08:00:00','2007-01-11 08:00:00','2007-01-12 08:00:00','2007-01-13 08:00:00','2007-01-19 05:00:00','2007-01-20 08:00:00','2007-02-03 08:00:00','2007-02-10 08:00:00','2007-02-11 07:30:00','2007-03-05 04:15:00','2007-03-10 06:00:00','2007-03-11 08:00:00','2007-03-17 09:00:00','2007-03-24 08:00:00','2007-03-25 12:00:00','2007-03-31 01:00:00','2007-04-06 11:00:00','2007-04-10 08:00:00','2007-04-14 07:00:00','2007-04-27 08:00:00','2007-05-10 05:00:00') NOT NULL
puroparty.extcal_2events.end_date 2007-01-09 23:59:59 2007-05-12 23:59:59 19 19 0 0 19.0000 NULL ENUM('2007-01-09 23:59:59','2007-01-10 23:59:59','2007-01-11 09:00:00','2007-01-12 09:00:00','2007-01-13 23:59:59','2007-01-19 05:00:00','2007-01-20 09:00:00','2007-02-03 08:00:00','2007-02-10 08:00:00','2007-02-11 08:30:00','2007-03-05 10:15:00','2007-03-10 07:00:00','2007-03-11 09:00:00','2007-03-17 10:00:00','2007-03-24 09:00:00','2007-03-25 17:00:00','2007-03-31 02:00:00','2007-04-06 23:59:59','2007-04-10 09:00:00','2007-04-14 08:00:00','2007-04-14 14:00:00','2007-04-27 09:00:00','2007-04-28 23:59:59','2007-05-12 23:59:59') NOT NULL
puroparty.extcal_2events.recur_type   week 0 4 21 0 0.7308 NULL ENUM('','day','week') NOT NULL
puroparty.extcal_2events.recur_val 0 1 1 1 21 0 0.1923 0.3941 ENUM('0','1') NOT NULL
puroparty.extcal_2events.recur_end_type 0 2 1 1 19 0 0.4231 0.7428 ENUM('0','1','2') NOT NULL
puroparty.extcal_2events.recur_count 1 4 1 1 0 0 1.2308 0.7994 ENUM('1','4') NOT NULL
puroparty.extcal_2events.recur_until 2007-01-08 2007-04-10 10 10 0 0 10.0000 NULL ENUM('2007-01-08','2007-01-15','2007-01-26','2007-01-27','2007-01-31','2007-02-01','2007-02-15','2007-02-20','2007-02-21','2007-02-27','2007-03-05','2007-03-11','2007-03-12','2007-03-13','2007-03-20','2007-03-25','2007-03-29','2007-04-03','2007-04-05','2007-04-10') NOT NULL
puroparty.extcal_2events.user_id 0 3 1 1 19 0 0.6538 1.1748 ENUM('0','1','3') NOT NULL
puroparty.extcal_2events.group_id 0 5 1 1 19 0 0.8077 1.6177 ENUM('0','1','2','5') NOT NULL
puroparty.extcal_2events.showevent 3 3 1 1 13 0 0.5000 NULL ENUM('','3') NOT NULL