SELECT WRTYPEID FROM WR_TYPE WHERE RWRTYPEID IS NULL AND WRABBREV = Linguist List | Web Resource Listings

Web Resources



Please choose one of the following Web Resources types:
SELECT WRTYPENAME, WRTYPEID FROM WR_TYPE WHERE HASSUBCATEGORY = N'Y' ORDER BY WRTYPENAME




SELECT WRTYPENAME, WRABBREV, HASSUBCATEGORY FROM WR_TYPE WHERE WRTYPEID = Linguist List | Web Resource Listings

#trim(GetTypeName.WRTypeName)#


SELECT WRTYPEID, WRTYPENAME FROM WR_TYPE WHERE rwrtypeid = ORDER BY WRTYPENAME
SELECT WW.WRTYPEID, WW.WEBRESOURCEID, WL.EDITORAPPROVAL, WL.WEBRESOURCETITLE, WL.URL as wl_url, WL.WEBRESOURCEID, WL.WEBRESOURCEDESCRIP, WT.WRTYPENAME FROM WRLISTING_WRTYPE WW, WR_LISTING WL, WR_TYPE WT WHERE WW.WRTYPEID = AND WL.WEBRESOURCEID = WW.WEBRESOURCEID AND WT.WRTYPEID = WW.WRTYPEID AND UPPER(WL.EDITORAPPROVAL) = N'YES' ORDER BY UPPER(WL.WEBRESOURCETITLE)

#trim(WRTYPENAME)#

·#trim(WebResourceTitle)#: #trim(WebResourceDescrip)#
SELECT WL.WEBRESOURCEID, WL.WEBRESOURCETITLE, WL.URL as wl_url, WL.WEBRESOURCEDESCRIP, WW.WEBRESOURCEID, WW.WRTYPEID FROM WRLISTING_WRTYPE WW, WR_LISTING WL WHERE WW.WRTYPEID = AND UPPER(WL.EDITORAPPROVAL) = N'YES' AND WL.WEBRESOURCEID = WW.WEBRESOURCEID ORDER BY UPPER(WL.WEBRESOURCETITLE)
·#trim(WebResourceTitle)#: #trim(WebResourceDescrip)#