Debugging Information
ColdFusion Server Standard 11,0,19,314546
Template /index.cfm
Time Stamp 08-Sep-25 03:54 PM
Locale English (US)
User Agent Amazon CloudFront
Remote IP 98.165.181.21
Host Name 98.165.181.21


Execution Time

Total Time Avg Time Count Template
985 ms 985 ms 1 C:/websites/wsadmnbz/index.cfm
637 ms 71 ms 9 C:/websites/wsadmnbz/templates/AttorneyFirmNewsList.cfm
224 ms 112 ms 2 C:/websites/wsadmnbz/templates/AttorneyDetail.cfm
49 ms 49 ms 1 C:/websites/wsadmnbz/Application.cfm
18 ms 9 ms 2 C:/websites/wsadmnbz/templates/MainNav.cfm
10 ms 10 ms 1 C:/websites/wsadmnbz/templates/LocalNav.cfm
0 ms 0 ms 9 C:/websites/wsadmnbz/018EE5/FirmNewsItems_Upcoming2_new.xsl
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1035 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getWebSite (Datasource=wise, Time=0ms, Records=1, Cached Query) in C:\websites\wsadmnbz\Application.cfm @ 15:54:10.010
    SELECT  tbl_WebSite.WEBSITE_ID,
            tbl_WebSite.WebSite_MainURL,
            tbl_WebSite.WebSite_Name,
            tbl_WebSite.WebSite_Title,
            tbl_WebSite.WebSite_HeaderHTML,
            tbl_WebSite.WebSite_AssetFolder,
            tbl_WebSite.WebSite_Delimiter,
            tbl_WebSite.WebSite_Doctype,
            tbl_WebSite.WebSite_Secure,
            tbl_WebSite.Website_DefaultToXML,
            tbl_WebSite.Page_ID_lkp,
            tbl_WebSiteServices.OpenTracker_Active,
            tbl_WebSiteServices.OpenTracker_URL,
            tbl_WebSiteServices.GoogleAnalytics_Active,
            tbl_WebSiteServices.GoogleAnalytics_SiteID,
            tbl_WebSiteServices.Clicky_Active, 
            tbl_WebSiteServices.Clicky_SiteID, 
            tbl_WebSiteServices.Clicky_SiteKey,
            tbl_WebSiteServices.Amazon_DistributionID,
            tbl_Company.Company_Name, 
			tbl_User.User_Email
      FROM  tbl_WebSite WITH (NOLOCK)
INNER JOIN  tbl_WebSiteServices WITH (NOLOCK) ON Website_ID = WebSite_ID_lkp
 LEFT JOIN  tbl_Company WITH (NOLOCK) ON Company_ID = Company_ID_lkp
 LEFT JOIN  tbl_User WITH (NOLOCK) ON User_ID = User_ID_mstr
	
     WHERE  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_MainURL = ?
        OR  WebSite_ID IN (SELECT WebSite_ID_lkp 
                            FROM tbl_URL WITH (NOLOCK)
                           WHERE URL_Name = ?)
	
	AND Website_Active = 1
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = spsk.com
Parameter #2(cf_sql_varchar) = www.spsk.com
Parameter #3(cf_sql_varchar) = www.spsk.com
Parameter #4(cf_sql_varchar) = www.spsk.com
Parameter #5(cf_sql_varchar) = www.spsk.com
Parameter #6(cf_sql_varchar) = www.spsk.com
Parameter #7(cf_sql_varchar) = spsk.com

getFeatures (Datasource=wise, Time=0ms, Records=25, Cached Query) in C:\websites\wsadmnbz\Application.cfm @ 15:54:10.010
SELECT Feature_Name
  FROM tbl_Feature tF WITH (NOLOCK)
 INNER JOIN tbl_WebSite_Feature tWF WITH (NOLOCK) ON tF.Feature_ID = tWF.Feature_ID_lkp
 WHERE tWF.WebSite_ID_lkp = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 396

qryGetSEFURL (Datasource=Wise, Time=9ms, Records=1) in C:\websites\wsadmnbz\index.cfm @ 15:54:10.010
    SELECT SEFURL_QueryString
      FROM tbl_SEFURL WITH (NOLOCK)
	 WHERE WebSite_ID_lkp = ?
       AND SEFURL_Name = ?
       AND SEFURL_Active = 1
    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_varchar) = our-attorneys/Katherine_Gilfillan

getTemplate (Datasource=wise, Time=0ms, Records=1, Cached Query) in C:\websites\wsadmnbz\index.cfm @ 15:54:10.010
	SELECT Template_Path, Template_Name 
	  FROM tbl_Template WITH (NOLOCK) 
	 WHERE Template_ID = ? 
	   AND Feature_ID_lkp IN (SELECT Feature_ID_lkp FROM tbl_WebSite_Feature WITH (NOLOCK) WHERE WebSite_ID_lkp = ?) 
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3
Parameter #2(cf_sql_integer) = 396

qryGetAttorneyDetails (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
SELECT * FROM tbl_Attorney WITH (NOLOCK) 
WHERE WebSite_ID_lkp = ?
AND Attorney_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 19602

qryGetAllPracticeAreas (Datasource=Wise, Time=8ms, Records=4) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT LPA.*, (SELECT LawPracticeArea_ID FROM tbl_LawPracticeArea WHERE LawPracticeArea_Id_orig = LPA.LawPracticeArea_ID AND Version_ID_lkp = ? AND Website_ID_lkp = ?) AS IsVersion
    FROM tbl_LawPracticeArea LPA WITH (NOLOCK) 
   INNER JOIN tbl_Attorney_LawPracticeArea WITH (NOLOCK) ON LawPracticeArea_ID = LawPracticeArea_ID_lkp
   WHERE WebSite_ID_lkp = ?
     AND Attorney_ID_lkp = ?
     AND LawPracticeArea_ID_orig is NULL
     
     AND LawPracticeArea_Active = 1
     
  ORDER BY tbl_Attorney_LawPracticeArea.SYS_TimeStamp_Entered ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 396
Parameter #4(cf_sql_integer) = 19602

qryGetPracticeAreas (Datasource=, Time=0ms, Records=4) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT *
    FROM qryGetAllPracticeAreas
   WHERE LawPracticeArea_ID_prnt IS NULL
  
qryGetPracticeOrphans (Datasource=, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM qryGetAllPracticeAreas 
  WHERE LawPracticeArea_ID_prnt IS NOT NULL
	
	AND LawPracticeArea_ID_prnt NOT IN (8607,8600,8584,8595)
	
qryGetPracticeLeaderships (Datasource=Wise, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
    SELECT tbl_LawPracticeArea.*,
    	   (SELECT COUNT(*) FROM tbl_LawPracticeArea_Attorney WHERE LawPracticeArea_ID_lkp = LawPracticeArea_ID) as LeaderCount
      FROM tbl_LawPracticeArea WITH (NOLOCK) 
     INNER JOIN tbl_LawPracticeArea_Attorney WITH (NOLOCK) ON LawPracticeArea_ID = LawPracticeArea_ID_lkp
     WHERE WebSite_ID_lkp = ?
       AND Attorney_ID_lkp = ? 
       AND LawPracticeArea_Active = 1
       
    ORDER BY tbl_LawPracticeArea_Attorney.SYS_TimeStamp_Entered ASC
    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 19602

qryGetLocations (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT tbl_Location.* 
    FROM tbl_Location WITH (NOLOCK) INNER JOIN tbl_Attorney_Location WITH (NOLOCK)
      ON Location_ID = Location_ID_lkp
   WHERE WebSite_ID_lkp = ?
     AND Attorney_ID_lkp = ?
   ORDER BY tbl_Attorney_Location.SYS_TimeStamp_Entered ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 19602

qryGetNews (Datasource=Wise, Time=79ms, Records=45) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT *
    FROM tbl_AttorneyNews WITH (NOLOCK) 
   INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK) 
      ON AttorneyNews_ID = AttorneyNews_ID_lkp
    LEFT JOIN tbl_AttorneyNewsCategory
      ON AttorneyNewsCategory_ID=AttorneyNewsCategory_ID_lkp
   WHERE tbl_AttorneyNews.WebSite_ID_lkp = ?
     AND Attorney_ID_lkp = ? 
     AND AttorneyNews_Active = 1
     
   ORDER BY tbl_AttorneyNews.AttorneyNews_Date DESC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyAttorneyRank WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetCourtAdmissions (Datasource=Wise, Time=2ms, Records=4) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyCourtAdmission WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetBarAdmissions (Datasource=Wise, Time=2ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT BarAdmission_Name, BarAdmission_Admitted, BarAdmission_Number
  FROM tbl_AttorneyBarAdmission WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetLawSchools (Datasource=Wise, Time=2ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyLawSchool WITH (NOLOCK) WHERE Attorney_ID_lkp =  ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetColleges (Datasource=Wise, Time=3ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyCollege WITH (NOLOCK) WHERE Attorney_ID_lkp =  ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetBadges (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyBadge WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetLanguages (Datasource=Wise, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyLanguage WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetFreeForms (Datasource=Wise, Time=3ms, Records=5) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyFreeForm WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetPracticeChildren (Datasource=, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
                         SELECT * FROM qryGetAllPracticeAreas 
                          WHERE LawPracticeArea_ID_prnt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8607

qryGetPracticeChildren (Datasource=, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
                         SELECT * FROM qryGetAllPracticeAreas 
                          WHERE LawPracticeArea_ID_prnt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8600

qryGetPracticeChildren (Datasource=, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
                         SELECT * FROM qryGetAllPracticeAreas 
                          WHERE LawPracticeArea_ID_prnt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8584

qryGetPracticeChildren (Datasource=, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
                         SELECT * FROM qryGetAllPracticeAreas 
                          WHERE LawPracticeArea_ID_prnt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8595

GetMainPages (Datasource=wise, Time=1ms, Records=7) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:10.010
SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
	  (SELECT COUNT(*) FROM tbl_WebSite WHERE Page_Id_lkp  = P.Page_ID) AS IsHomePage, 
      (SELECT Page_ID  FROM tbl_Page    WHERE Page_Id_orig = P.Page_ID 
      		  							  AND Version_ID_lkp = ? 
                                          AND Website_ID_lkp = ?) AS IsVersion
From tbl_Page P WITH (NOLOCK)
WHERE Page_ID_prnt = ?
  AND Website_ID_lkp = ?
  AND Page_NavSet = ?
  AND Page_OnNavigation = 1
  AND Page_ID <> (SELECT Page = CASE WHEN Page_ID_lkp > 0 THEN Page_ID_lkp ELSE 0 END FROM tbl_WebSite WHERE Website_ID = ?)
  AND Page_ID_orig is NULL
ORDER BY SYS_TimeStamp_Position
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 0
Parameter #4(cf_sql_integer) = 396
Parameter #5(cf_sql_integer) = 0
Parameter #6(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=2ms, Records=5) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:10.010
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16627
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:10.010
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16628
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:10.010
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16629
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=1ms, Records=2) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:10.010
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16630
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=1ms, Records=6) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:10.010
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16631
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=1ms, Records=4) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:10.010
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16632
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=2ms, Records=1) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:10.010
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16633
Parameter #4(cf_sql_integer) = 396

qryGetAttorneyDetails (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
SELECT * FROM tbl_Attorney WITH (NOLOCK) 
WHERE WebSite_ID_lkp = ?
AND Attorney_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 19602

qryGetAllPracticeAreas (Datasource=Wise, Time=8ms, Records=4) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT LPA.*, (SELECT LawPracticeArea_ID FROM tbl_LawPracticeArea WHERE LawPracticeArea_Id_orig = LPA.LawPracticeArea_ID AND Version_ID_lkp = ? AND Website_ID_lkp = ?) AS IsVersion
    FROM tbl_LawPracticeArea LPA WITH (NOLOCK) 
   INNER JOIN tbl_Attorney_LawPracticeArea WITH (NOLOCK) ON LawPracticeArea_ID = LawPracticeArea_ID_lkp
   WHERE WebSite_ID_lkp = ?
     AND Attorney_ID_lkp = ?
     AND LawPracticeArea_ID_orig is NULL
     
     AND LawPracticeArea_Active = 1
     
  ORDER BY tbl_Attorney_LawPracticeArea.SYS_TimeStamp_Entered ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 396
Parameter #4(cf_sql_integer) = 19602

qryGetPracticeAreas (Datasource=, Time=4ms, Records=4) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT *
    FROM qryGetAllPracticeAreas
   WHERE LawPracticeArea_ID_prnt IS NULL
  
qryGetPracticeOrphans (Datasource=, Time=3ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM qryGetAllPracticeAreas 
  WHERE LawPracticeArea_ID_prnt IS NOT NULL
	
	AND LawPracticeArea_ID_prnt NOT IN (8607,8600,8584,8595)
	
qryGetPracticeLeaderships (Datasource=Wise, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
    SELECT tbl_LawPracticeArea.*,
    	   (SELECT COUNT(*) FROM tbl_LawPracticeArea_Attorney WHERE LawPracticeArea_ID_lkp = LawPracticeArea_ID) as LeaderCount
      FROM tbl_LawPracticeArea WITH (NOLOCK) 
     INNER JOIN tbl_LawPracticeArea_Attorney WITH (NOLOCK) ON LawPracticeArea_ID = LawPracticeArea_ID_lkp
     WHERE WebSite_ID_lkp = ?
       AND Attorney_ID_lkp = ? 
       AND LawPracticeArea_Active = 1
       
    ORDER BY tbl_LawPracticeArea_Attorney.SYS_TimeStamp_Entered ASC
    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 19602

qryGetLocations (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT tbl_Location.* 
    FROM tbl_Location WITH (NOLOCK) INNER JOIN tbl_Attorney_Location WITH (NOLOCK)
      ON Location_ID = Location_ID_lkp
   WHERE WebSite_ID_lkp = ?
     AND Attorney_ID_lkp = ?
   ORDER BY tbl_Attorney_Location.SYS_TimeStamp_Entered ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 19602

qryGetNews (Datasource=Wise, Time=4ms, Records=45) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT *
    FROM tbl_AttorneyNews WITH (NOLOCK) 
   INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK) 
      ON AttorneyNews_ID = AttorneyNews_ID_lkp
    LEFT JOIN tbl_AttorneyNewsCategory
      ON AttorneyNewsCategory_ID=AttorneyNewsCategory_ID_lkp
   WHERE tbl_AttorneyNews.WebSite_ID_lkp = ?
     AND Attorney_ID_lkp = ? 
     AND AttorneyNews_Active = 1
     
   ORDER BY tbl_AttorneyNews.AttorneyNews_Date DESC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyAttorneyRank WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetCourtAdmissions (Datasource=Wise, Time=2ms, Records=4) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyCourtAdmission WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetBarAdmissions (Datasource=Wise, Time=2ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT BarAdmission_Name, BarAdmission_Admitted, BarAdmission_Number
  FROM tbl_AttorneyBarAdmission WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetLawSchools (Datasource=Wise, Time=2ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyLawSchool WITH (NOLOCK) WHERE Attorney_ID_lkp =  ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetColleges (Datasource=Wise, Time=2ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyCollege WITH (NOLOCK) WHERE Attorney_ID_lkp =  ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetBadges (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyBadge WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetLanguages (Datasource=Wise, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyLanguage WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetFreeForms (Datasource=Wise, Time=4ms, Records=5) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
  SELECT * FROM tbl_AttorneyFreeForm WITH (NOLOCK) WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
  
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetPracticeChildren (Datasource=, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
                         SELECT * FROM qryGetAllPracticeAreas 
                          WHERE LawPracticeArea_ID_prnt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8607

qryGetPracticeChildren (Datasource=, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
                         SELECT * FROM qryGetAllPracticeAreas 
                          WHERE LawPracticeArea_ID_prnt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8600

qryGetPracticeChildren (Datasource=, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
                         SELECT * FROM qryGetAllPracticeAreas 
                          WHERE LawPracticeArea_ID_prnt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8584

qryGetPracticeChildren (Datasource=, Time=0ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyDetail.cfm @ 15:54:10.010
                         SELECT * FROM qryGetAllPracticeAreas 
                          WHERE LawPracticeArea_ID_prnt = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8595

qryGetArticles (Datasource=Wise, Time=3ms, Records=18) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:10.010
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2142
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:10.010
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 144110

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:10.010
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19576

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19614

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 144045

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19576

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19614

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 141128

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=2ms, Records=7) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 140915

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22313

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22311

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19613

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 30921

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27168

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19648

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=6) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 140894

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19576

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19603

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19614

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19638

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19634

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 140831

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=2) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 137709

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19653

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=7) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 137562

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22311

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22314

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22310

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22313

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22312

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 20830

qryGetAttorneys (Datasource=Wise, Time=3ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133426

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19584

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19613

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133098

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 131601

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=2) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 119279

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19634

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=2) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 100795

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19653

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 100856

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 101021

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 101049

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 101053

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=2ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 101155

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetArticles (Datasource=Wise, Time=2ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2131
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

qryGetArticles (Datasource=Wise, Time=2ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2132
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

qryGetArticles (Datasource=Wise, Time=2ms, Records=8) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2140
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

qryGetAttorneys (Datasource=Wise, Time=2ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133482

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 114228

qryGetAttorneyRank (Datasource=Wise, Time=3ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 108288

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 100056

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 100062

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=3ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 100065

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 100067

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 100095

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetArticles (Datasource=Wise, Time=2ms, Records=16) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2141
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

qryGetAttorneys (Datasource=Wise, Time=2ms, Records=35) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 144603

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19573

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19575

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19576

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19577

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19581

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19584

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19585

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19588

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19593

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19595

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19598

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19599

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19606

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 29555

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19612

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19613

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19614

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19619

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19618

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19620

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19621

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19622

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22310

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19630

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 20830

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 32199

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19634

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19636

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19648

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19649

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19650

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19653

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22314

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19645

qryGetAttorneys (Datasource=Wise, Time=3ms, Records=21) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 144085

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19575

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19577

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19581

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19588

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27123

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22312

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22311

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19598

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19612

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19613

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19619

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19621

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19622

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22310

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27168

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 32199

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19638

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 32275

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19645

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19650

qryGetAttorneys (Datasource=Wise, Time=4ms, Records=8) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 144068

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 32199

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 32275

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 32079

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 20830

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19604

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19595

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 30919

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 143396

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=20) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 139520

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19650

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19575

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19581

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22312

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22311

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 29555

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19612

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19613

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19618

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19621

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19622

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22310

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19645

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19577

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27123

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19598

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19619

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27168

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19638

qryGetAttorneys (Datasource=Wise, Time=2ms, Records=6) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 135277

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19653

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19576

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19634

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19614

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19638

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 134690

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=20) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 133058

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19575

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19581

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19585

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22312

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22311

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 29555

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19612

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19613

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19618

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19620

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19621

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19622

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22310

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19645

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19650

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19577

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19588

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19598

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19619

qryGetAttorneys (Datasource=Wise, Time=2ms, Records=5) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 132670

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27157

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19604

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 29555

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 20830

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=4) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 127887

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19599

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19584

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19645

qryGetAttorneys (Datasource=Wise, Time=3ms, Records=21) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124041

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19575

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19581

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19583

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19585

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22311

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19612

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19613

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19618

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19620

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19621

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19622

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22310

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19627

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19630

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19645

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19650

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19588

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19598

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19619

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19577

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 119647

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 119348

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19584

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22311

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=2) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 119030

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19634

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 108329

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19603

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19634

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 104434

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19575

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19648

qryGetArticles (Datasource=Wise, Time=1ms, Records=3) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2143
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 140832

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 140819

qryGetAttorneyRank (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetAttorneys (Datasource=Wise, Time=1ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                    SELECT *
                      FROM tbl_Attorney WITH (NOLOCK) INNER JOIN tbl_Attorney_AttorneyNews WITH (NOLOCK)
                        ON Attorney_ID = Attorney_ID_lkp
                     WHERE AttorneyNews_ID_lkp = ? 
   					   AND Attorney_Active = 1
                       
		     		ORDER BY tbl_Attorney_AttorneyNews.SYS_TimeStamp_Entered ASC
                    
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 129572

qryGetAttorneyRank (Datasource=Wise, Time=0ms, Records=1) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
                        SELECT * FROM tbl_AttorneyAttorneyRank WHERE Attorney_ID_lkp = ? ORDER BY SYS_TimeStamp_Updated ASC
                        
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19602

qryGetArticles (Datasource=Wise, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2144
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

qryGetArticles (Datasource=Wise, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2145
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

qryGetArticles (Datasource=Wise, Time=1ms, Records=0) in C:\websites\wsadmnbz\templates\AttorneyFirmNewsList.cfm @ 15:54:11.011
SELECT AttorneyNews_ID, AttorneyNews_Name, AttorneyNews_FileName, AttorneyNews_URL, AttorneyNews_Content, AttorneyNews_Date, AttorneyNews_Active, AttorneyNews_LinkText,
	   AttorneyNewsCategory_ID_lkp, AttorneyNews_Subtitle, AttorneyNews_Publisher, AttorneyNews_Thumbnail, AttorneyNews_Abstract, AttorneyNews_Featured, AttorneyNews_DisplayDate,
	   AttorneyNews_Event, AttorneyNews_Venue,	AttorneyNews_Location, AttorneyNews_Tags, AttorneyNewsCategory_ID, AttorneyNewsCategory_Name, AttorneyNewsCategory_Description

  FROM tbl_AttorneyNews tAN WITH (NOLOCK)
  LEFT JOIN tbl_AttorneyNewsCategory WITH (NOLOCK) ON AttorneyNewsCategory_ID = AttorneyNewsCategory_ID_lkp 
 WHERE tAN.WebSite_ID_lkp = ? 
    AND AttorneyNewsCategory_ID_lkp = ? 
    AND AttorneyNews_ID IN (SELECT AttorneyNews_ID_lkp FROM tbl_Attorney_AttorneyNews WITH (NOLOCK) WHERE Attorney_ID_lkp = ?)
	
  	 AND AttorneyNews_Active = ? 
    ORDER BY AttorneyNews_Date DESC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 396
Parameter #2(cf_sql_integer) = 2146
Parameter #3(cf_sql_integer) = 19602
Parameter #4(cf_sql_integer) = 1

GetMainPages (Datasource=wise, Time=0ms, Records=7, Cached Query) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:11.011
SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
	  (SELECT COUNT(*) FROM tbl_WebSite WHERE Page_Id_lkp  = P.Page_ID) AS IsHomePage, 
      (SELECT Page_ID  FROM tbl_Page    WHERE Page_Id_orig = P.Page_ID 
      		  							  AND Version_ID_lkp = ? 
                                          AND Website_ID_lkp = ?) AS IsVersion
From tbl_Page P WITH (NOLOCK)
WHERE Page_ID_prnt = ?
  AND Website_ID_lkp = ?
  AND Page_NavSet = ?
  AND Page_OnNavigation = 1
  AND Page_ID <> (SELECT Page = CASE WHEN Page_ID_lkp > 0 THEN Page_ID_lkp ELSE 0 END FROM tbl_WebSite WHERE Website_ID = ?)
  AND Page_ID_orig is NULL
ORDER BY SYS_TimeStamp_Position
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 0
Parameter #4(cf_sql_integer) = 396
Parameter #5(cf_sql_integer) = 0
Parameter #6(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=0ms, Records=5, Cached Query) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:11.011
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16627
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=0ms, Records=0, Cached Query) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:11.011
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16628
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=0ms, Records=0, Cached Query) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:11.011
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16629
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=0ms, Records=2, Cached Query) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:11.011
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16630
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=0ms, Records=6, Cached Query) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:11.011
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16631
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=0ms, Records=4, Cached Query) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:11.011
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16632
Parameter #4(cf_sql_integer) = 396

GetSubPages (Datasource=wise, Time=0ms, Records=1, Cached Query) in C:\websites\wsadmnbz\templates\MainNav.cfm @ 15:54:11.011
		SELECT Page_ID, Page_Name, Page_NoContent, Page_NavExtend, 
      		   (SELECT Page_ID  FROM tbl_Page   WHERE Page_Id_orig = P.Page_ID 
      		  							  		AND Version_ID_lkp = ? 
                                          		AND Website_ID_lkp = ?) AS IsVersion
		  FROM tbl_Page P WITH (NOLOCK)
		 WHERE Page_ID_prnt =  ?
		   AND Page_OnNavigation = 1
  		   AND Website_ID_lkp = ?
		 ORDER BY SYS_TimeStamp_Position
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) =
Parameter #2(cf_sql_integer) = 396
Parameter #3(cf_sql_integer) = 16633
Parameter #4(cf_sql_integer) = 396


Scope Variables

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=C:\websites\wsadmnbz\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.spsk.com
HTTP_REFERER=
HTTP_URL=/index.cfm?r=our-attorneys/Katherine_Gilfillan
HTTP_USER_AGENT=Amazon CloudFront
LOCAL_ADDR=172.31.28.92
PATH_INFO=
PATH_TRANSLATED=C:\websites\wsadmnbz\index.cfm
QUERY_STRING=r=our-attorneys/Katherine_Gilfillan
REMOTE_ADDR=98.165.181.21
REMOTE_HOST=98.165.181.21
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.spsk.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Client Variables:
cfid=425369940
cftoken=47097967
hitcount=1
lastvisit={ts '2025-09-08 15:54:10'}
timecreated={ts '2025-09-08 15:54:10'}
urltoken=CFID=425369940&CFTOKEN=47097967
Cookie Variables:
CFID=425369940
CFTOKEN=47097967
HTTP_REFERER=http://www.spsk.com?r=our-attorneys/Katherine_Gilfillan
URL Parameters:
r=our-attorneys/Katherine_Gilfillan
Debug Rendering Time: 84 ms