SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 11:43 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bos_ad_types` ORDER BY `def_option3` ASC LIMIT 0, 30;
Rows: 8

type_id type_title type_required type_use option1 def_option1 option2 def_option2 option3 def_option3 option4 def_option4 option5 def_option5 option6 def_option6 option7 def_option7 option8 def_option8 option9 def_option9 option10 def_option10 template
22 Artist Ad 116249 124697 state 3|1|1|Texas group name 1|||         genre 1||| # members 1||| booking contact 1||| booking # 1|||         <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
12 Fundraiser Ad 3609 7961 state 3|1|1|Texas beneficiary 2||| contact #1 1||| contact #2 1|||                        
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
24 Mariachis 7705 7961 state 3|1|1|Texas group name 1||| # members 1||| group gender 4|2|2|all male|all female|mixed                        
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
25 Halls 5657 7961 state 3|1|1|Texas contact# 1 1||| contact #2 1||| max capacity 1|||                         <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
23 Clubs/Bars 423449 524057 state 3|1|1|Texas| cover charge 1|||| contact # 1|||| drink selection 5|4||beer|draft|wine|liquor food avail? 4|2|2|yes|no patio seating? 4|2|2|yes|no music 5|5||piped|jukebox|karaoke|dj|band other stuff 5|2|pool|big screens event mo 3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec| event date 1|||| <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
21 Happy Hour Ad! 249369 257817 State 3|1|1|Texas| Cover Charge 1|||| Phone 1||||     Drinks Avail 5|4||beer|draft|wine|liquor Food Avail? 4|2|2|yes|no Patio Seating? 4|2|2|yes|no music 5|5||piped|jukebox|karaoke|dj|band other stuff 5|2||pool|big screens     <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
19 Concert/Festival Ad 32281 32537 state 3|1|1|Texas ticket price 2||| headliner 2||| venue name 1||| seating 4|3|2|indoor|outdoor|both event month 3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec|                 <table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>
20 DJ Ad 129049 523545 state 3|1|1|Texas company name 1||| dj name(s) 2||| genre types 2||| genre specialties 1||| equip 5|2|sound|lights available area 1||| contact #1 1||| contact #2 1||| other comments 2|||

<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
 <td class="headtd" width="50%">%adTitle%</td>
 <td class="headtd" width="50%" align="right">%adNumber%</td>
</tr>
<tr>
 <td valign="top" width="50%">

  <!--%adSeller%-------------------rrs----------------->
  %adDescription% <!-- added rrs -->
  %adPrice%
  %adCondition%
  %adCity%
  %adState%
  %adPostal%
  %adCountry%
  %adTypeOpt1%
  %adTypeOpt2%
  %adTypeOpt3%
  %adTypeOpt4%
  %adTypeOpt5%
  %adTypeOpt6%
  %adTypeOpt7%
  %adTypeOpt8%
  %adTypeOpt9%
  %adTypeOpt10%
  %adCatOpt1%
  %adCatOpt2%
  %adCatOpt3%
  %adCatOpt4%
  %adCatOpt5%
 </td>
 <td valign="top" width="50%">
  %adImages%
 </td>
</tr>
<!-- rrs
<tr>
 <td colspan=&quot;2&quot;>
  %adDescription%
 </td>
</tr>
-->
</table>