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) Machine Tools Dealers Machinery Movers & Erectors Machinery New (wholesale) Machinery Specially Designed & Built Magazines Dealers Magicians Supplies & Lessons Magnetic Resonance Imaging Maid & Butler Service Mail Boxes (wholesale) Mail Boxes Rental & Receiving Mail Order & Catalog Shopping Mailing & Shipping Services Mailing Lists Mailing Machines & Equipment (wholesale) Mammograms Management Consultants Manicuring Manufactured Housing Repair & Service Manufacturers Agents & Representatives Maps Publishers & Distributors Marble & Terrazzo Cleaning & Service Marble Contractors Marble Cultured (wholesale) Marble Natural (wholesale) Marinas Marine Contractors & Designers Marine Surveyors & Adjusters Market Research & Analysis Marketing Consultants Marketing Programs & Services Marriage & Family Counselors Martial Arts Instruction Martial Arts Supplies & Equipment Mason Contractors Equip & Supls (whol) Massage Schools Massage Therapists Material Handling Equipment (wholesale) Maternity Apparel Mats & Matting (wholesale) Mattresses Mattresses Wholesale Mausoleums Meat Brokers Meat Packers Meat Retail Meat Wholesale Mechanical Contractors Mediation Services Medical Alarms (wholesale) Medical Bill Processing Medical Business Administration Medical Equipment & Supplies (wholesale) Medical Equipment Repairing Medical Examinations Insurance Medical Malpractice Attorneys		Medical Records Service Medical Service Organizations Medical Transcription Service Medicare Supplement Mens Apparel Retail Mental Health Centers Counselors Messenger Service Metal Detecting Equipment Meters (wholesale) Mexican Food Mexican Foods (products) Microfilming & Imaging Middle Eastern Midwives Millwork (manufacturers) Mini Blinds & Window Treatments Mining Equipment & Supplies Retail Mirrors & Glass Missions Mobile Home Communities Mobile Homes Dealers Mobile Homes Equipment & Parts Mobile Homes Repairing & Service Mobile Homes Transporting Mobile Telephone Service Modeling Agencies Modeling Schools Mold Remediation Money Order Service Monograms Monuments Mortgage Brokers Mortgage Feasibility Consultants Mortgage Loan Processors Mortgages & Contracts Mosques Motels Hotels & Other Accommodations Motorcycles & Motor Scooters Dealers Movers & Full Service Storage Movie Theatres Moving Companies Moving Self Service Moving Services Labor & Materials Moving Supplies & Equipment Moving Supplies & Equipment Renting Mowing Service Mud Jacking Contractors Mufflers & Exhaust Systems Multimedia (manufacturers) Murals Museums Music & Live Entertainment Music Arrangers & Composers Music Background & Foreground Music Instruction Instrumental Music Vocals Instruction Musical Instruments Dealers Musical Instruments Repairing

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

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

Categories_6960 (Records=1670, Time=62ms)
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=6960
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=115, Time=31ms)
SQL = 
SELECT		*
	FROM		Categories_6960
	WHERE		Catname LIKE 'M%'
	ORDER BY	CatName

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

141 milliseconds

URL Parameters:

LETTER=M
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=72201

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%3A34%3A39%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A34%3A39%27%7D%23; CFID=118160836; CFTOKEN=1693751
HTTP_HOST=72201.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=72201.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI