Results > Jul 30, 2010 11:15 AM
(3 seconds and 949 milliseconds)
View Settings| : | 40 |
|---|---|
| : | 40 |
| : | false |
| : | false |
| : | ro_ebird |
| : | |
| : | 1.0E-10 |
| : | Oracle |
| : | |
| : | <?xml version='1.0' ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:date="http://exslt.org/dates-and-times" extension-element-prefixes="date"> <xsl:output method="xml"/> <xsl:template match="/"> <rss version="2.0"> <channel> <title>Most Checklists Submitted for Current Month</title> <description>Monthly Checklist Totals</description> <link/> <language>en-us</language> <pubDate> <xsl:value-of select="date:date-time()"/> </pubDate> <lastBuildDate> <xsl:value-of select="date:date-time()"/> </lastBuildDate> <xsl:for-each select="result/row"> <xsl:if test="position() < 31"> <item> <title> <xsl:value-of select="NAME"/> -- <xsl:value-of select="CNT"/> </title> <link>http://ebird.org/go/GuideMe?source=changeLocation&reportType=location&bMonth=01&bYear=2010&eMonth=12&eYear=2010&getLocations=states&states=<xsl:value-of select="CODE"/>&continue=Continue </link> </item> </xsl:if> </xsl:for-each> </channel> </rss> </xsl:template> </xsl:stylesheet> |
| : | 1 |
| : | text/xml |
| : | <schema> <ta... |
| : | XML |
| : | 10 |
| : | 10 |
| : | WITH X AS ( SELECT COUNT(*) CNT, SUBNATIONAL1_CODE_S FROM SUB_OUT WHERE TO_CHAR(CREATION_DT, 'Mon YYYY') = TO_CHAR(SYSDATE, 'Mon YYYY') GROUP BY SUBNATIONAL1_CODE_S ) SELECT X.CNT AS CNT, TX.SUBNATIONAL1_CODE AS CODE, TX.NAME AS NAME FROM X, TX_SUBNATIONAL1 TX WHERE TX.SUBNATIONAL1_CODE = X.SUBNATIONAL1_CODE_S ORDER BY CNT DESC |
| : | false |
| : | false |
| : | false |
| : | jdbc:oracle:thin:@swift.ornith.cornell.edu:1521:sw2 |
| : | 0 |
| : | false |
| : | true |
| : | 0.0 |
| : | text/plain |
| : |
