<cfquery name="getrecord" datasource="#ds#">
    select name,#tableme#.id,address,phone,website,#tableme#.description,listingsrelated,ccainfo,#tableme#.seo_friendly,trackingpixel,cat,#tableme#.catid,adrankml, ListingsPhotos.photo as thumbnail from #tableme# inner join Cat#tableme# on #tableme#.catid = Cat#tableme#.catid 
    inner join ListingsPhotos on ListingsPhotos.itemid = #tableme#.id
    where #tableme#.hide <> 1
and name <> ''
and thumbnail <> ''
and  ListingsPhotos.tablename='#tableme#'
<Cfif parameterexists(url.subcat)>and #tableme#.catid = #url.subcat#</Cfif>
group by #tableme#.id
    order by adrankml, rand()
</cfquery>


<!--- advertiser desc,---> 

<cfif #getrecord.recordcount# gt 0>
    <cfif #getrecord.listingsrelated# gt 0>
        <cfquery name="getrelated" datasource="cg22">
            select id,linktitle,linktype
            from ListingsRelated
            where tablename='#tableme#' and itemid=#getrecord.id# and (mag =1)
        </cfquery>
    </cfif>

    <Cfquery name="findcoupon" datasource="#ds#">
        select id,expire,description,seo_friendly,trackingpixel
        from ListingsCoupons
        where tablename='#tableme#' and itemid=#getrecord.id# and (mag =1)
        order by id desc
        limit 0,1
    </Cfquery>


    <Cfoutput query="getrecord"  startrow="#url.strt#" maxrows="#url.show#">
  




        <div class="strip_all_tour_list">
            <div class="row">
                <div class="col-lg-4"><!--removed flex center -->
                    <a href="/#getme.dirme#/#seo_friendly#">
                       <cfif #getrecord.thumbnail# is not ''> <img class="image-sizing" src="https://www.cityguideny.com/listingsphotos/#getrecord.thumbnail#" alt="#name#"></cfif></a>
                </div>
                <div class="col-lg-8 side-box">
                <h5><a href="/#getme.dirme#/#seo_friendly#">#name#</a></h5>
                <cfif #url.id# eq 2 or #url.id# eq 3><a href="/category-page.cfm?id=#url.id#&subcat=#catid#">#cat#</a></cfif>
                <p> #phone# | <a href="/linktrack.cfm?id=#id#&table=#tableme#" target="_new">Official
                                    Website</a></p>

                                    <a class="regular" href="/#getme.dirme#/#seo_friendly#">           <div>#getrecord.description#</div>                       </a>


                </div>
            </div>
        </div>

    </cfoutput>
</cfif>