Keyword:	ZipCode:

Category List starting with L: View other categories: A B C D E F G H I J K L M N O P R S T U V W X Y
Labels (manufacturers) Labor Contractors Labor Organizations Laboratories Medical Laboratories Research & Development Laboratories Testing Lamps & Lamp Shades Retail Land Companies Landscape Architects Landscape Consultants Landscape Contractors Landscape Designers Landscape Lighting Landscaping Equipment & Supplies Landscaping Service Language Schools Laundries Laundries Self Service Law Firms Lawn & Garden Maintenance Services Lawn Mowers Lawn Mowers Sharpening & Repairing Lawyers & Attorneys At Law		Leasing Service Leather Clothing Retail Legal Service Plans Libraries Public Light Bulbs & Tubes (wholesale) Lighting Fixtures Retail Lighting Systems & Equipment Lightning Protection Equipment Limestone Limousine & Limo Car Service Linen Supply Service Lingerie Liquor Stores Liquors Retail Livestock Breeders Loans Loans Personal Loans Real Estate Locksmiths Long Term Care Insurance Luggage Retail Lumber Retail Lumber Wholesale

sitevars (Records=1, Time=15ms)
SQL = 
select *
		from	sitevars where siteid = 4

GetCity (Records=1, Time=16ms)
SQL = 
SELECT	City, StateCode, GeoCityID
		FROM	ZipCoords
		WHERE	iZip=35801

Categories_6879 (Records=1364, Time=109ms)
SQL = 
SELECT		a.MYCatID, a.CatName, substring(a.CatName,1,1) AS letter, b.ListingCounts
	FROM		listingCategories a INNER JOIN ListingsCountIndex b ON a.MYCatID=b.MYCatID AND b.CityID=6879
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=46, Time=32ms)
SQL = 
SELECT		*
	FROM		Categories_6879
	WHERE		Catname LIKE 'L%'
	ORDER BY	CatName

CatLetters (Records=24, Time=0ms)
SQL = 
SELECT		DISTINCT letter
	FROM		Categories_6879
 	ORDER BY	Letter

187 milliseconds

URL Parameters:

LETTER=L
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=35801

CGI Variables:

AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Websites\ZipsLocal\morecategories.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CACHE_CONTROL=no-cache
HTTP_CONNECTION=close
HTTP_COOKIE=CFID=118156301; CFTOKEN=71317184; CFCLIENT_MAGICYELLOW=CATNAME%3DAutomated%5FTeller%5FMachines%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D2%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A15%3A13%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A14%3A15%27%7D%23
HTTP_HOST=35801.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_L.html
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc03-02
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/morecategories.cfm
PATH_TRANSLATED=D:\Websites\ZipsLocal\morecategories.cfm
QUERY_STRING=Letter=L
REMOTE_ADDR=38.107.191.108
REMOTE_HOST=38.107.191.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=35801.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI