Rollover images for more info
View All Specials
Featured Vehicle
click photo for details
500 South Broadway, Salem New Hampshire 03079 500 South Broadway, Salem New Hampshire 03079

Queries

qrySpecials (Records=3, Time=31ms)
SQL = 
SELECT	TOP 3 V.vin, V.cstocknum, V.cmileage, V.cyear, V.deleted, M.make_descr, V.cmodel, VS.special_price,
			VS.special_price, O.model_descr, VS.special_id, VSS.special_status_descr, V.cmodel, VS.special_status_id
	FROM	vehix V INNER JOIN vehix_specials VS ON V.vin = VS.vin
			INNER JOIN vehix_special_status VSS ON VS.special_status_id = VSS.special_status_id
			INNER JOIN vehix_make M ON V.make_id = M.make_id
			INNER JOIN vehix_model O ON V.model_id = O.model_id
	WHERE	V.dealership_id = 2469
			AND VS.deleted = 0
			AND V.deleted = 0
			AND VS.special_status_id = 1
	ORDER BY VS.display_order

qryFeature (Records=3, Time=78ms)
SQL = 
SELECT    	 V.vin, V.cyear, M.make_descr, V.cmodel, V.cprice, V.cmileage, isNull(B.body_descr,V.body) as body_descr, V.ccolor, V.transmission, V.engine, V.cenginesiz, D.dealership_id, 
                      M.make_id, O.model_descr, V.model_id, V.active, T.vehix_type_descr, dbo.monthlyPrice(V.cprice, D.default_rate, D.default_terms) AS payment, 
                      V.vehix_sales_id, V.vehix_status_id, V.certified, V.option_list, V.msr_price, V.body, MT.vehix_model_type_descr, V.invoice_price, S.special_price, 
                      S.deleted AS special_deleted,V.trim_level,V.mfg_model_number,V.cstocknum, V.dealer_location_id, 
		v.engine_brand_id, eb.engine_brand,v.engine_fuel_id,ef.engine_fuel,v.dual_wheel_drive,bd.bed_length,c.cab,c.cab_id,dateDiff(second,getDate(),S.ltEndDate) as timeLeft,
		S.ltprice,S.ltActive,v.date_in,vehix_comments
FROM         	dbo.vehix_dealership D
		INNER JOIN dbo.vehix V ON D.dealership_id = V.dealership_id 
INNER JOIN dbo.vehix_make M ON V.make_id = M.make_id 
LEFT OUTER JOIN dbo.vehix_model O ON V.model_id = O.model_id 
LEFT OUTER JOIN dbo.vehix_model_type MT ON O.vehix_model_type_id = MT.vehix_model_type_id 
LEFT OUTER JOIN dbo.vehix_specials S ON V.vin = S.vin AND V.dealership_id = S.dealership_id AND S.deleted = 0 
LEFT OUTER JOIN dbo.vehix_body B ON V.body_id = B.body_id 
LEFT OUTER JOIN dbo.vehix_type T ON B.vehix_type_id = T.vehix_type_id
LEFT join vehix_engine_brand eb on eb.engine_brand_id = v.engine_brand_id
LEFT join vehix_engine_fuel ef on ef.engine_fuel_id = v.engine_fuel_id
LEFT join vehix_bed_length bd on bd.bed_length_id = v.bed_length_id
LEFT join vehix_cab c on c.cab_id = v.cab_id
WHERE   (V.active = 1)
		and v.dealership_id = 2469
		AND v.vehix_sales_id = 'F'

Execution Time

125 milliseconds

Parameters
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:\www\locatecentral.com\clients\AleksaAuto\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/xml,application/xhtml+xml,text/html;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=2179814; CFTOKEN=41588446
HTTP_HOST=www.aleksaonline.com
HTTP_PRAGMA=no-cache
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc03-01
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/index.cfm
PATH_TRANSLATED=D:\www\locatecentral.com\clients\AleksaAuto\index.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.114
REMOTE_HOST=38.107.191.114
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.aleksaonline.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI