most-popular-oracle.xql

DB Query file

Related Files

• packages/bookmarks/www/most-popular.xql
• packages/bookmarks/www/most-popular.tcl
• packages/bookmarks/www/most-popular.adp
• packages/bookmarks/www/most-popular-postgresql.xql
• packages/bookmarks/www/most-popular-oracle.xql

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="popular_hosts">      
      <querytext>
      
    select unique host_url,
           $count_select_query as n_bookmarks
    from  bm_urls
    order by n_bookmarks desc

      </querytext>
</fullquery>


<fullquery name="popular_urls">      
      <querytext>
      
    select nvl(url_title, complete_url) as local_title, 
           complete_url, 
           $count_select_query as n_bookmarks
    from   bm_urls
    order by n_bookmarks desc

      </querytext>
</fullquery>

 
</queryset>