ZIPS Local Home
Keyword:  ZipCode:

Category List starting with G:


View other categories: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Galvanizing (manufacturers)
Games & Game Supplies
Garage Builders
Garage Doors & Openers
Garages
Garden Centers
Gardeners
Gas Companies
Gas Detectors
Gas Industrial Medical Cylinder & Bulk
Gas Liquefied Petroleum Bottled Bulk
Gas Propane Wholesale
Gas Wholesale & Distributors
Gasoline & Oil Wholesale
Gastroenterology
Gates
Gay & Lesbian Organizations
Gears & Gear Cutting Manufacturers
General Contractors
Generators Electric Wholesale
Generators Installation
Geologists
German Food
Gift Baskets & Parcels
Gift Shops
Gift Wholesalers
Gifts Wholesale & Manufacturers
Giftwares Wholesale
Glass Beveled Carved Ornamental
Glass Blocks
Glass Carved Ornamental Beveled Etc
Glass Stained & Leaded
Glass Wholesale
Gloves Work & Industrial
Go Carts
Gold Silver & Platinum Dealers
Golf Cars & Carts
Golf Course Architects
Golf Course Construction
Golf Course Equipment Wholesale
Golf Courses Miniature
Golf Courses Private
Golf Courses Public
Golf Driving Ranges
Golf Equipment & Supplies Sales & Repair
Golf Equipment & Supplies Wholesale
Golf Instruction
Golf Tour Organizers & Promotions
Gourmet Shops & Food Services
Government Contract Consultants
Government Offices City & Townships
Government Offices County
Government Offices Indian
Government Offices State
Government Offices US
Government Post Offices
Grain Dealers Wholesale
Granite Wholesale
Graphic Designers
Graphic Services
Grease Traps Cleaning Service
Greek Food
Greenhouses
Greeting Cards Retail
Grinding Precision & Production
Grocers Retail Supermarket
Grocers Wholesale
Group Dental Insurance
Gun Instruction
Guns Accessories & Gunsmiths
Gutters & Downspouts
Gymnasiums
Gymnasiums Equipment & Supplies
Gymnastic Instruction
Gynecologic Oncology
Gynecology
Gypsum & Gypsum Products Manufacturers

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=85032

Categories_7042 (Records=2253, Time=125ms)
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=7042
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=77, Time=46ms)
SQL = 
SELECT		*
	FROM		Categories_7042
	WHERE		Catname LIKE 'G%'
	ORDER BY	CatName

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


Execution Time

187 milliseconds
0 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
0 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
187 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=G
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=85032

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=CFCLIENT_MAGICYELLOW=FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+15%3A09%3A02%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+15%3A09%3A02%27%7D%23; CFID=118168105; CFTOKEN=34252735
HTTP_HOST=85032.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_G.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=G
REMOTE_ADDR=38.107.191.109
REMOTE_HOST=38.107.191.109
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=85032.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI