Queries

qryGetNavigation (Records=46, Time=31ms)
SQL = 
spProjectRollOutNavigation 1633

qryGetDealerInfo (Records=1, Time=0ms)
SQL = 
spPRO_DealerInfo 1633

qryGetMarquee (Records=16, Time=0ms)
SQL = 
SPProDealer_Marquee 1633

qryGetAdRotator (Records=4, Time=0ms)
SQL = 
SPProDealer_adRotatorHome 1633

qryGetAdRotatorBack (Records=4, Time=0ms)
SQL = 
SPProDealer_adRotatorBack 1633

qrySpotlights (Records=6, Time=0ms)
SQL = 
spGetSpotlights 1633, 'u', 6

qryMetaData (Records=1, Time=47ms)
SQL = 
SPDealer_MetaData 1633, 1

qryGetFeaturedVehicles (Records=0, Time=16ms)
SQL = 
spProDealer_featuredVehicle "1633"

qrySpecials (Records=3, Time=0ms)
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
			   and v.dealership_id = vs.dealership_id
			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 = 1633
			AND VS.deleted = 0
			AND V.deleted = 0
			AND VS.special_status_id = 1
	ORDER BY VS.display_order