ZIPS Local Home
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

HOME  MAJOR CITIES  CATEGORIES  ABOUT US 

6


Queries

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


Execution Time

187 milliseconds
15 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
0 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
172 msD:\WEBSITES\ZIPSLOCAL\MORECATEGORIES.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SEARCHBOX.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SERVERID.CFM
0 msSTARTUP, PARSING, & SHUTDOWN


Parameters
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