Keyword:	ZipCode:

Category List starting with M: 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
Machine Shop Tools & Equipment Machine Tools (wholesale) Machinery Movers & Erectors Magazines Dealers Magazines Publishers Magicians Supplies & Lessons Maid & Butler Service Maid & Butler Service Mail Order & Catalog Shopping Mailing & Shipping Services Mailing Lists Mammograph Management Consultants Management Training Manicures & Pedicures Manufactured Mobile Homes Brokers Manufactured Mobile Homes New & Used Manufactured Mobile Homes Parks Manufactured Mobile Homes Repair & Svc Manufacturers Agents & Representatives Maps Publishers & Distributors Marble & Terrazzo Cleaning & Service Marble Contractors Marble Cultured (wholesale) Marble Natural (wholesale) Market Research & Analysis Marketing Consultants Marketing Programs & Services Marriage & Family Counselors Martial Arts Instruction Martial Arts Supplies & Equipment Mason Contractors Equip & Supls (whol) Massage Equipment & Supplies (wholesale) Massage Therapists Material Handling Equipment (wholesale) Maternity Apparel Mats & Matting (wholesale) Mattresses Mattresses Wholesale Mausoleums Meat Brokers Meat Retail Meat Wholesale Mechanical Contractors Mediation Services Medical Bill Processing Medical Business Administration Medical Equipment & Supplies (wholesale) Medical Equipment Repairing Medical Information Services Medical Malpractice Attorneys Medical Transcription Service Meditation Instruction Meeting & Conference Consultants Mental Health Services Mental Retardation & Dev Disabled Svcs Mergers & Acquisitions Messenger Service Metal Detecting Equipment Metal Fabricators Metal Finishers (manufacturers)		Metaphysical Supplies & Services Meters (wholesale) Mexican Food Mexican Goods Microfilm & Imaging Svc Equip & Supls Microscopes (wholesale) Middle Eastern Midwives Millwork (manufacturers) Minerals Mini Blinds & Window Treatments Mining Equipment & Supplies Retail Missions Mobile Home Communities Mobile Homes Dealers Modeling Agencies Modular Homes Dealers Molds (manufacturers) Money Transfer Service Monuments Mortgage Brokers Mortgage Feasibility Consultants Mortgage Loan Processors Mortgages & Contracts Mosques Motel & Hotel Equipment & Supls (whol) Motel & Hotel Management Motels Hotels & Other Accommodations Motels other Accommodations Reservations Motion Picture Equip & Supplies Renting Motion Picture Producers & Studios Motivational & Self Improvement Training Motor Homes Renting & Leasing Motor Homes Repairing & Service Motorcycles & Motor Scooters Accessories Motorcycles & Motor Scooters Dealers Motorcycles & Motor Scooters Rent lease Motorcycles & Motor Scooters Rpr & Svc Motorcycles & Motor Scooters Supplies Movers & Full Service Storage Movie Theatres Moving Companies Moving Self Service Moving Services Labor & Materials Moving Supplies & Equipment Moving Supplies & Equipment Renting Mowing Service Mufflers & Exhaust Systems Mulches Multimedia (manufacturers) Murals Museums Music & Live Entertainment Music Boxes Music Instruction Music Production Services Music Publishers Music Stores Musical Instruments Dealers Musical Instruments Repairing Mutual Funds

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

Categories_7541 (Records=1759, Time=188ms)
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=7541
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=122, Time=47ms)
SQL = 
SELECT		*
	FROM		Categories_7541
	WHERE		Catname LIKE 'M%'
	ORDER BY	CatName

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

266 milliseconds

URL Parameters:

LETTER=M
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=80903

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+14%3A57%3A37%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A57%3A37%27%7D%23; CFID=118165660; CFTOKEN=51956611
HTTP_HOST=80903.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_M.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=M
REMOTE_ADDR=38.107.191.107
REMOTE_HOST=38.107.191.107
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=80903.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI