<Cfquery name="geter" datasource="#ds#">
    
    select issueguide.*,ParentsListings.name,ParentsListings.region,issueguidecat.* from issueguide
    inner join ParentsListings on issueguide.pkid = ParentsListings.id
        inner join issueguidecat on issueguidecat.issueguideid = issueguide.id

    where (expirationdate like '%2022%' or expirationdate like '%2021%') and issueguide.catid in (253,339,340,341,382,386,492,493,494,495,496,497,498,499,500,501,503,509,522,524,525,526,544,545,546,547,548,549,550,551,552,553,554)
    and (issueguidecat.issuemy like '%2015%' or issueguidecat.issue like '%2015%')
order by issueguide.id
</Cfquery>

<Table border=1 cellpadding=4 cellspacing=0> 
    
<tr><td><B>name</td>
<td><B>issue</td>
<td><B>issue m/y</td>
<td><B>expirationdate</td>
</tr>    
<cfoutput query="Geter">
    <tr>
        <Td>
   <a href="https://admin.nymetroparents.com/addguide.cfm?id=#pkid#">#name#</a></Td>
   
   <td>
   #issue# </td>
   
   <td>
   #dateformat(issuemy,'yyyy-mm-dd')#</td>
   <td>#expirationdate#</td>
   </tr>
    
    
</cfoutput></Table>