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 Y
Labor Contractors
Labor Organizations
Laboratories Medical
Laboratories Testing
Laminations Plastic Paper
Landscape Architects
Landscape Consultants
Landscape Contractors
Landscape Designers
Landscape Lighting
Landscaping Service
Laundries
Laundromats Self Service
Law Firms
Lawn Installation & Maintenance
Lawn Mowers Parts & Supplies
Lawyers & Attorneys At Law
Leather Goods Dealers
Libraries Public
Lighting Fixtures Wholesale
Lighting Systems & Equipment
Limousine & Limo Car Service
Linen Supply Service
Linens
Lingerie
Liquor Stores
Loans
Loans Personal
Loans Real Estate
Locksmiths
Logistics
Luggage Retail
Lumber Retail
Lumber Wholesale

HOME  MAJOR CITIES  CATEGORIES  ABOUT US 

6


Queries

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

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

Categories_7622 (Records=815, Time=16ms)
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=7622
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=34, Time=15ms)
SQL = 
SELECT		*
	FROM		Categories_7622
	WHERE		Catname LIKE 'L%'
	ORDER BY	CatName

CatLetters (Records=23, Time=16ms)
SQL = 
SELECT		DISTINCT letter
	FROM		Categories_7622
 	ORDER BY	Letter


Execution Time

63 milliseconds
16 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
0 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
47 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=06040

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=117259947; CFTOKEN=11836560; CFCLIENT_MAGICYELLOW=CATNAME%3DAutomobile%5FRoad%5FService%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D5%23LASTVISIT%3D%7Bts+%272010%2D09%2D07+08%3A28%3A57%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D07+08%3A07%3A41%27%7D%23
HTTP_HOST=06040.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.109
REMOTE_HOST=38.107.191.109
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=06040.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI