Keyword:	ZipCode:

Behavioral & Developmental Medicine in 72401 ZIP Code (Jonesboro, AR)

Categories Related to Behavioral & Developmental Medicine Abortion Alternatives Organizations Acupressure Acupuncture Alternative Health Alternative Medicine Ambulance Service Ambulance Service Air Aromatherapy Biofeedback Therapists Birth Centers Breastfeeding Supplies & Information Clinical & Therapeutic Massage Clinics Colonic Irrigation Diabetes Information Centers Dietitians Druggists Sundries Retail Druggists Sundries Wholesale Exercise Equipment Sales & Service Health & Diet Food Products Wholesale Health Care Consultants Health Care Planning & Management Health Fitness & Nutrition Consultants Herbs Homeopaths Infectious Disease Nurses Home Services Nutritionists Occupational Medicine Relaxation & Tantra Massage   All Categories in 72401 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   ZIP Codes near 72401 63829 72005 72112 72314 72324 72347 72354 72365 72377 72391 72402 72403 72404 72410 72411 72412 72414 72415 72416 72417 72419 72421 72425 72427 72428 72429 72431 72432 72433 72436 72437 72439 72440 72442 72445 72447 72449 72450 72451 72457 72458 72465 72467 72471 72472 72473 72474 72475 72476 72479

OTOLARYNGOLOGY CENTER  870-523-6721 Newport Hospital Newport, AR 72112 (~31.1mi. from 72401)

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

GetCat (Records=1, Time=0ms)
SQL = 
SELECT	MYCatID, CatName, htmlTitle, keywordSingle2 AS KW
	FROM	listingcategories
	WHERE	CatName='Behavioral & Developmental Medicine' AND Display='Y'

 (Records=1, Time=46ms)
SQL = 
spZipsLocalListings

 (Records=31, Time=0ms)
SQL = 
spGetRelatedCats

getRelatedCats (Records=30, Time=0ms)
SQL = 
SELECT		*
	FROM		getRelatedCats1
	WHERE		MYCatID <> 353133
	ORDER BY	catName

GetNearbyZips1 (Records=50, Time=0ms)
SQL = 
SELECT		TOP 50 a.TargetZip, a.Distance, b.City, b.StateCode
	FROM		ZipDistances a INNER JOIN ZipCoords b ON a.TargetZip=b.iZip
	WHERE		a.BaseZip=72401 AND a.TargetZip<>72401
	ORDER BY	a.Distance

GetNearbyZips (Records=50, Time=0ms)
SQL = 
SELECT		*
	FROM		GetNearbyZips1
	ORDER BY	TargetZip

getArticleLong (Records=0, Time=78ms)
SQL = 
SELECT textSection1 AS articleText, title, articleID, myCatID, styleID
		FROM Article
		WHERE display = 1
			AND myCatID = 353133
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=11)
		ORDER BY createDt desc

getArticleLong (Records=0, Time=31ms)
SQL = 
SELECT textSection1 AS articleText, title, articleID, myCatID, styleID
		FROM Article
		WHERE display = 1
			AND myCatID = 353133
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=12)
		ORDER BY createDt desc

187 milliseconds

URL Parameters:

CATNAME=Behavioral_and_Developmental_Medicine
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
PAGE=1
ZIP=72401

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\listings.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=118162036; CFTOKEN=27827754; CFCLIENT_MAGICYELLOW=CATNAME%3DAttorneys%5FService%5FBureaus%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D2%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A40%3A44%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A40%3A15%27%7D%23
HTTP_HOST=72401.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/Behavioral_and_Developmental_Medicine.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=/listings.cfm
PATH_TRANSLATED=D:\Websites\ZipsLocal\listings.cfm
QUERY_STRING=CatName=Behavioral_and_Developmental_Medicine
REMOTE_ADDR=38.107.191.106
REMOTE_HOST=38.107.191.106
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/listings.cfm
SERVER_NAME=72401.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI