Other Heritage Sites | Blog | Bookstore | About Us | Contact Us 

Advanced Search
Heritage home Issues Where We Stand Experts Press and Media Support Heritage





  ISSUES  > Homeland Security/Terrorism
 
icon_print
Email This Link
October 16, 2007
Modernize FISA, But Don't Hobble American Intelligence Operations
WebMemo #1666

The House of Representatives would hamstring the wartime intelligence gathering of the United States if it passes the incorrectly named "Responsible Electronic Surveillance that is Overseen, Reviewed, and Effective Act of 2007," or RESTORE Act (H.R. 3773). Will Representatives who support the bill accept responsibility when the intelligence gap created by the bill results in a failure to detect another terrorist attack on America soil? This is no rhetorical question. The bill would impose a Byzantine and unprecedentedly burdensome intelligence regime on those charged with protecting Americans from international terrorists and substantially impede the ability of the executive branch to gather intelligence on terrorist threats. Lawmakers who support H.R. 3773 should be required to clearly stake their careers on its effectiveness.

The RESTORE Act is remarkable primarily for what its supporters do not address. They provide little or no information on the following points:

  • Why Congress would depart from the recommendations of the 9/11 Commission by making it more difficult and cumbersome to gather intelligence on Islamic terrorists;
  • Whether there was any actual harm (rather than psychic harm that supposedly results from potential surveillance) to any American citizens as a result of five years of intelligence gathering on foreign terrorists since 9/11 and, if so, what that supposed harm was;
  • Why Congress believes it has the constitutional authority, with or without a court's assistance, to micromanage decisions about which potential foreign enemies to gather information on, when that power is constitutionally vested in the commander in chief;
  • Why no previous President--Jimmy Carter, Ronald Reagan, George H.W. Bush, or Bill Clinton--has ever conceded that FISA or any other regulatory regime crafted by Congress is the sole means by which a President may collect intelligence for national security purposes; or
  • Why Americans should entrust to Congress and congressional staff members a database containing information on every American whose name is mentioned as part of a national security investigation.

The Administration is right to threaten a presidential veto of the RESTORE Act if it is not fundamentally changed. The Act is unwise as a matter of constitutional law and policy. The current Administration has gone much further than any previous administration in safeguarding American civil liberties. Yet hyperbolic privacy activists never acknowledge this and refuse to accept sensible minimization procedures to provide further anonymity of information that might incidentally be collected on persons within the United States. Congress should expand and make permanent the FISA reforms in the Protect America Act and not hobble America's wartime intelligence-gathering abilities.

What Harm Is Being Remedied?

Privacy absolutists have to date been unable to point to any actual harm that individual Americans have suffered because of information collected as part of the Terrorist Surveillance Program (TSP) and similar foreign intelligence programs since 9/11. They can point to no Americans who have been convicted unjustly, or even prosecuted unjustly, based on information obtained through the TSP in violation of their statutory or constitutional rights.

When the Foreign Intelligence Surveillance Act (FISA) was enacted in 1978, Congress was at least responding to some actual evidence of abuses of warrantless electronic surveillance of average Americans who were not threatening national security at a time when the United States was not in an actual (or "shooting") war. J. Edgar Hoover's FBI had, among other abuses, conducted electronic surveillance of American citizens whose only apparent wrongdoing was that they were considered to be among Nixon's enemies. It thus made sense to require court supervision of domestic electronic surveillance of Americans who were not supporting foreign enemies in an actual shooting war.

1978 was also near the height of the Cold War. The agents of America's enemies were predominately embassy staff members and other officials of Soviet and Soviet-affiliated states. FISA permitted electronic surveillance of these potential enemy agents within the United States without traditional warrants but with the involvement of a new Foreign Intelligence Surveillance Court. Two important distinctions are relevant to today's debate over modernizing FISA: (1) The original law did not impose any restrictions on the then-current means of intercepting foreign agents' communications abroad, and (2) the number of potential Cold War agents in America covered by FISA was quite small compared to the number of potential soldiers and saboteurs in a traditional shooting war.

In short, acts of war on American soil by foreign agents were not among the significant threats confronting the nation in 1978. FISA was crafted for the Cold War, not for today's world of secretive networks of foreign soldiers on U.S. soil planning acts of terrorism against Americans. FISA's restrictions on domestic surveillance were designed to prevent Watergate-like abuses, not to hinder the executive branch's ability to gather intelligence about wartime enemies planning to kill Americans.

After the attacks of September 11, Congress enacted an Authorization for the Use of Military Force (AUMF) that set a very different tone. Congress wisely authorized the President to use all necessary force to defeat the terrorist entities and their allies with whom we were now at war. This is a real shooting war, as is demonstrated by continued military combat in Afghanistan; by bombings in London, Madrid, Asia, and the Middle East; and by the many foiled plots around the globe. When at war, it is a paramount duty of the military to locate, track, and intercept the communications of enemies--never an easy task. President Bush assumed that grave responsibility, as has every commander in chief during wartime. Using the National Security Agency (itself a military agency) and following standard military protocols, he has engaged in the traditional tasks of military intelligence. Thus has been the duty of military commanders since time immemorial.

Although the President's authority to use the military units Congress funds to engage in traditional military intelligence duties flows from the Constitution, it is not inconsistent with any statute either. To the extent that the old FISA regime would have presented difficulties in foreign intelligence gathering, the AUMF removed most such statutory constraints. Notwithstanding his constitutional authority, the President sought and received additional statutory authority in August with passage of the Protect America Act to avoid constitutional questions and activist court rulings.

With these laws in place, the President has undertaken his intelligence duties responsibly. The worst that proponents of legislation like the RESTORE Act can point to are hypothetical abuses of information obtained through the Terrorist Surveillance Program or incidental intrusions on non-specific, amorphous privacies.

But most of today's privacy activists are absolutists. They believe that every governmental access of information that they would prefer to keep private is an injury that must be justified by a compelling governmental interest, subjected to court supervision (such as a warrant process), or both. Their rhetoric asserts-- incorrectly and misleadingly--that these privacy rights are enshrined in the Constitution, but the Supreme Court has repeatedly rejected the notion that the Fourth Amendment includes the generalized, amorphous "right to privacy" they favor.

Because the Constitution does not include any such right, constitutional rhetoric should not be used to cloak attempts to create such a right by statute. Decisions to create new statutory rights are merely policy preferences. Only when they are acknowledged as such can they be honestly and productively discussed.

The RESTORE Act and the Intelligence Gap

The contrast could not be starker between the nebulous, hypothetical harms that privacy absolutists assert could result from the incidental collection of information through electronic surveillance programs and the concrete harms that could result from the lack of robust foreign intelligence-gathering programs to detect and prevent acts of domestic terrorism. U.S. intelligence systems have improved in the past five years, but foreign enemies show an alarming ability to adapt to these advances. There is little reason to doubt that foreign terrorists would use a weapon of mass destruction on American soil if they could do so. The only question is whether the United States will be able to detect and foil such plots in the future.

The shortcomings that led to pre-9/11 intelligence failures have been well documented, and the RESTORE Act would only make such problems worse. The highly regarded, bipartisan commission that Congress charged with investigating the events and causes of the September 11 attacks--the 9/11 Commission--identified major gaps in U.S. intelligence-gathering on terrorist activities. The 9/11 Commission determined that the effectiveness of U.S. intelligence-gathering was hamstrung by a "[l]ack of common standards and practices across the foreign-domestic divide."[1] The Commission recommended that intelligence and information-gathering procedures "should provide incentives for sharing, to restore a better balance between security and shared knowledge" regardless of whether such information "is collected in Pakistan or Texas."[2]

The RESTORE Act would actually widen the "foreign-domestic divide" identified by the 9/11 Commission by reducing the sharing of information within the U.S. intelligence community. The RESTORE Act would multiply the difficulties involved in collecting information about foreigners engaged in terrorist activities who happen to communicate with persons within the United States or who are themselves "U.S. persons." This is despite the fact that the category of "U.S. persons" defined by FISA[3] would include an alien who has legal residency in the United States only because he fraudulently obtained a U.S. visa in order to carry out terrorist activities within the United States. At the time of the September 11 attacks, all of the Islamic terrorists who murdered Americans were arguably "U.S. persons."

Need for Modernization

The House of Representatives passed the Protect America Act of 2007 (PAA) on August 4, 2007, and the President signed it into law the next day. Despite the disclaimers by Members of Congress who want to create a more restrictive regime for gathering intelligence on terrorists, the PAA passed because it had bipartisan support and because Director of National Intelligence (DNI) Mike McConnell spoke personally with approximately 260 Members. He explained why the PAA was necessary to remedy the damage caused by an unprecedented and seemingly erroneous decision by the Foreign Intelligence Surveillance Court in May of this year.[4] The decision opened an intelligence gap by effectively requiring the federal government, for the first time ever, to obtain a FISA warrant for any surveillance of persons located overseas if their electronic communications (e.g., emails, cell-phone calls, and text messages) might possibly be routed through the United States.

Because most of the world's largest telecommunications and Internet service providers are located in the United States, this would have required a FISA warrant for surveillance of potentially every person located overseas. No one could know in advance whether any communication by a person located outside the United States might end up being routed through the United States. DNI McConnell disclosed that thousands of individuals overseas are being monitored for terrorist activities. Obtaining approval for each intercept would be nearly impossible.

Each FISA application requires approximately 200 person-hours of government attorneys' and other intelligence officials' time for each telephone number intercepted. Only about 100 persons are being monitored in the United States, but this alone requires the equivalent of full-time service of ten government attorneys or other intelligence officials just to prepare the FISA applications.[5] Thousands of persons outside of the United States are being monitored for terrorism-related activities. For every thousand, 100 government officials would have to spend a year working fulltime to prepare all of the FISA applications. This is not the formula for a nimble and effective international intelligence regime.

Putting the RESTORE Act's manpower demands aside, it is highly unlikely that the FISA court would approve every application. It is human nature for judges who have been tasked with second-guessing intelligence intercepts to resist the notion that they are mere rubber stamps. Yet these are traditional foreign intelligence intercepts, undertaken during war, that no court has the constitutional authority to review. Furthermore, judges may not have the expertise. Military intelligence officers themselves often do not know the value of individual intercepts until months or years later, and ordinary federal judges are far less suited to make that kind of determination. The intelligence gaps that would be imposed on America's intelligence gathering if the PAA were repealed or replaced are enormous and would make the task of detecting and preventing terrorism even harder than it is today. America's enemies must rejoice over their prospects when they read proposals such as the RESTORE Act.

Members of Congress who now publicly express regret about their vote to enact the Protect America Act should trust their original instincts rather than be swayed by unfounded hypothetical harms or the potential for partisan gain. A bipartisan majority recognized in August that if Congress failed to act, it would expose tens of thousands of Americans to a heightened risk of injury and death at the hands of terrorists. Unfortunately, the sky-is-falling rhetoric of privacy absolutists seems to have swayed some Members since. The FISA "fix" they propose is pure window dressing. It is calculated to provide political cover if the resulting intelligence gap does result in another terrorist attack on U.S. soil. But it fails to do the sensible thing: close the intelligence gap.

Conclusion

The Protect America Act wisely exempts intelligence gathering targeted at persons not on U.S. soil. This makes perfect sense because constitutional protections were never intended to extend to intelligence gathering for national security purposes to persons located outside of the United States. It relies on the same minimization procedures that have always applied to reduce the intrusion on the privacy interests of Americans who (whether wittingly or unwittingly) communicate with suspected terrorists or other enemy soldiers.

Congress should make the Protect America Act permanent and enhance its provisions to provide retroactive and permanent liability protection to American businesses that cooperate with reasonable intelligence requests. The House of Representatives should not impose unconstitutional restrictions on the ability of the executive branch to carry out one of its primary, constitutionally mandated functions: protecting Americans from acts of war by foreign enemies.

Todd Gaziano is the Director of, and Brian W. Walsh is Senior Legal Research Fellow in, the Center for Legal and Judicial Studies at The Heritage Foundation.



[1]The 9/11 Comm'n Report: Final Report of the Nat'l Comm'n on Terrorist Attacks Upon the United States 409 (2004).

[2]Id. at 417.

[3]See 50 U.S.C. § 1801(i).

[4]Although this secret court decision was never released, it seems erroneous based on news reports citing officials who have reviewed it. The conclusions these officials have drawn from their review are the only available public source for evaluating the decision’s merits, and the decision thus may have had the effect of chilling more intelligence gathering conduct than its holding necessarily required.

[5]This estimate assumes that a workweek is at least 40 hours and that each government attorney or other intelligence official spends all of his or her time working on nothing other than FISA applications.

 
 
Contact An Expert
MEDIA INFORMATION LINE:
Phone: 202.675.1761
Fax: 202.544.6979

Sign up for Morning Bell Email

 


Debugging Information
ColdFusion Server Enterprise 7,0,2,142559
Template /Research/HomelandDefense/wm1666.cfm
Time Stamp 04-Jul-08 06:27 PM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 10.10.41.254
Host Name 10.10.41.254


Execution Time

Total Time Avg Time Count Template
1515 ms 189 ms 8 D:\websites\commonspot\cache\cached-render.cfm
969 ms 969 ms 1 D:\websites\heritage.org\Research\HomelandDefense\wm1666.cfm
953 ms 953 ms 1 D:\websites\commonspot\master-render.cfm
953 ms 953 ms 1 D:\websites\commonspot\master.cfm
890 ms 890 ms 1 D:\websites\commonspot\render-page-meat.cfm
890 ms 890 ms 1 D:\websites\commonspot\render-page.cfm
844 ms 844 ms 1 D:\websites\heritage.org\templates\template-basepage.cfm
626 ms 70 ms 9 D:\websites\commonspot\utilities\ct-render-element.cfm
594 ms 99 ms 6 D:\websites\commonspot\utilities\ct-render-named-element.cfm
375 ms 188 ms 2 D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm
328 ms 328 ms 1 D:\websites\heritage.org\templates\RHBoxesRD06.cfm
205 ms 15 ms 14 D:\websites\commonspot\utilities\cp-cffile.cfm
156 ms 156 ms 1 D:\websites\commonspot\controls\customcf\cpe-customcf.cfm
125 ms 31 ms 4 D:\websites\commonspot\controls\layout\cpe-layout.cfm
125 ms 125 ms 1 D:\websites\heritage.org\templates\RHBoxesRD06-new.cfm
63 ms 21 ms 3 D:\websites\commonspot\utilities\cp-cffile-charset.cfm
62 ms 62 ms 1 D:\websites\heritage.org\customcf\MetaData_ResearchPaperOutputDupFix-RD06.cfm
47 ms 47 ms 1 D:\websites\commonspot\controls\layout\render-cell.cfm
31 ms 31 ms 1 D:\websites\commonspot\controls\dhtmlmenu\cpe-menu.cfm
31 ms 16 ms 2 D:\websites\commonspot\controls\upfront-generic.cfm
30 ms 15 ms 2 D:\websites\commonspot\controls\textblock\cpe-textblock.cfm
16 ms 2 ms 7 D:\websites\commonspot\controls\control-setup.cfm
16 ms 2 ms 7 D:\websites\commonspot\security\security-control.cfm
16 ms 16 ms 1 D:\websites\commonspot\security\security-detail-queries.cfm
16 ms 4 ms 4 D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm
16 ms 16 ms 1 D:\websites\commonspot\utilities\ct-limit-inheritance.cfm
16 ms 16 ms 1 D:\websites\heritage.org\cache\s36-n1031-p206196-c0-t0-mr-blame.cache
15 ms 8 ms 2 D:\websites\commonspot\controls\textblock\tb-standard-render.cfm
15 ms 15 ms 1 D:\websites\commonspot\metadata\build-struct.cfm
15 ms 15 ms 1 D:\websites\commonspot\render-head.cfm
15 ms 8 ms 2 D:\websites\commonspot\tb-data-upfront-queries.cfm
15 ms 15 ms 1 D:\websites\heritage.org\templates\template-basepage.head
0 ms 0 ms 1 D:\websites\commonspot\approve\ct-render-approval-icon-subitems.cfm
0 ms 0 ms 2 D:\websites\commonspot\approve\ct-render-approval-icon.cfm
0 ms 0 ms 4 D:\websites\commonspot\controls\ct-include-once.cfm
0 ms 0 ms 2 D:\websites\commonspot\controls\default-mode.cfm
0 ms 0 ms 1 D:\websites\commonspot\controls\dhtmlmenu\menu-get-data.cfm
0 ms 0 ms 4 D:\websites\commonspot\controls\layout\layout-rowcol-actions.cfm
0 ms 0 ms 1 D:\websites\commonspot\controls\layout\layout-setcellvars.cfm
0 ms 0 ms 1 D:\websites\commonspot\controls\layout\layout-settablevars.cfm
0 ms 0 ms 35 D:\websites\commonspot\controls\set-caller-vars.cfm
0 ms 0 ms 2 D:\websites\commonspot\controls\textblock\tb-default-params.cfm
0 ms 0 ms 1 D:\websites\commonspot\generate-usage-stats.cfm
0 ms 0 ms 1 D:\websites\commonspot\menu\core-js.cfm
0 ms 0 ms 1 D:\websites\commonspot\menu_ie_style.cfm
0 ms 0 ms 1 D:\websites\commonspot\metadata\init-cache.cfm
0 ms 0 ms 1 D:\websites\commonspot\pagemode\newpagemodeui.cfm
0 ms 0 ms 1 D:\websites\commonspot\pagemode\pagemodeui.cfm
0 ms 0 ms 1 D:\websites\commonspot\render-body-tag.cfm
0 ms 0 ms 1 D:\websites\commonspot\render-metatags.cfm
0 ms 0 ms 1 D:\websites\commonspot\security\security-page.cfm
0 ms 0 ms 1 D:\websites\commonspot\security\session-user-approvals.cfm
0 ms 0 ms 1 D:\websites\commonspot\set-page-vars.cfm
0 ms 0 ms 1 D:\websites\commonspot\site-application.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\core-application-meat.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\handle-head-request.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\handle-request-timeout.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\session-first-global.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\session-first-site.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\site-application-meat.cfm
0 ms 0 ms 1 D:\websites\commonspot\static\do-replacements.cfm
0 ms 0 ms 1 D:\websites\commonspot\static\get-feature-enabled.cfm
0 ms 0 ms 1 D:\websites\commonspot\static\replacement-wrapper.cfm
0 ms 0 ms 1 D:\websites\commonspot\tb-param-upfront-queries.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\build-pagedata.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\build-user-struct.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\cp-cfwddx.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\cp-setencoding.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\ct-render-edit-icon-subitem.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\ct-render-edit-icon.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\ct-render-text.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\define-upfront-vars.cfm
0 ms 0 ms 3 D:\websites\commonspot\utilities\edit-mode-get-valid.cfm
0 ms 0 ms 8 D:\websites\commonspot\utilities\handle-cache-flags.cfm
0 ms 0 ms 6 D:\websites\commonspot\utilities\handle-in-list.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\load-template-stub.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\newwindow-js-meat.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\newwindow-js.cfm
0 ms 0 ms 8 D:\websites\commonspot\utilities\validate-date-string.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\validation\render-info.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\verify-stub-data.cfm
0 ms 0 ms 1 D:\websites\heritage.org\Research\HomelandDefense\Application.cfm
0 ms 0 ms 1 D:\websites\heritage.org\Research\template-ResearchPaper.cfm
0 ms 0 ms 1 D:\websites\heritage.org\cache\s36-n1031-p206196-c131131-t1-mr-blame.cache
0 ms 0 ms 1 D:\websites\heritage.org\cache\temp625250-s36-n1031-p206196-c130947-t26-mr-blame.cache
0 ms 0 ms 1 D:\websites\heritage.org\custom-application.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\Header_AutodiscoveryLinks.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-additional-resources.cfm
0 ms 0 ms 2 D:\websites\heritage.org\customcf\RD06\box-standard-media-contacts.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-policywire-signup.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-products-displayad.cfm
0 ms 0 ms 2 D:\websites\heritage.org\customcf\RD06\box-standard-rtcol-videos.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-xml.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\left-nav-display-ads.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\searchform-header-greyblue.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\LHNavRD06.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\basepagefooter980.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\basepageheader980.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\pagetitles-RD06.cfm
0 ms 0 ms 1 D:\websites\heritage.org\ui\redesign\nav\ResearchNav.cfm
93 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1062 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

Request.PageData.PageParams (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\render-page-meat.cfm @ 18:27:31.031
				SELECT *
				  FROM Param_Page
				 WHERE (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
				   AND VersionState=2
	 		 ORDER BY PageID DESC
			
FormData (Datasource=commonspot-heritage.org, Time=0ms, Records=18) in D:\websites\commonspot\metadata\build-struct.cfm @ 18:27:31.031
	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE Data_FieldValue.PageID = ?
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
		AND (
				((FormControlMap.ClassConstant = 4)
			
				AND (FormControlMap.ClassID IN (1,3,36)) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7,1031)) ))
	
			OR ((FormControlMap.ClassConstant = 2) AND (FormControlMap.ClassID = ?))
	
			 )
 ORDER BY FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 206196
Parameter #2(CF_SQL_INTEGER) = 15

rsAuthor (Datasource=Authors, Time=0ms, Records=2) in D:\websites\heritage.org\templates\template-basepage.head @ 18:27:31.031
			select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
			tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
			WHERE SitePagesID = 206196
			ORDER BY SortOrder
		
CheckInheritance (Datasource=commonspot-heritage.org, Time=16ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance.cfm @ 18:27:31.031
   SELECT PageID,VersionState,AuthorID
     FROM Data_Menu_Items
    WHERE ControlID=?
		AND (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

request.pageDHTMLMenus (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\dhtmlmenu\menu-get-data.cfm @ 18:27:31.031
		SELECT *
		FROM Param_WDDX
		WHERE (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
			AND ElementTypeID = ?
			AND ControlID > 0
		ORDER BY ControlID, PageID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 47

request.pageDHTMLItems (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\upfront-generic.cfm @ 18:27:31.031
	SELECT *
	  FROM Data_Menu_Items
	 WHERE (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC 
FindMaxVersions (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\upfront-generic.cfm @ 18:27:31.031
		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_Menu_Items
		 WHERE (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	
rsSubsiteName (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\ui\redesign\nav\ResearchNav.cfm @ 18:27:31.031
				SELECT SitePages.Title
				  FROM SubSites,SitePages
				 WHERE SubSites.ID = 36
					AND SubSites.SecurityPageID = SitePages.ID
			
Request.CtrlInstUpFront (Datasource=commonspot-heritage.org, Time=0ms, Records=373) in D:\websites\commonspot\controls\control-setup.cfm @ 18:27:31.031
			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE (PageID IN (1,2,7,1031,206196)) 
		 ORDER BY PageID DESC
		
ReadRestrictions (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-render-element.cfm @ 18:27:31.031
			SELECT DISTINCT ControlID
			  FROM ItemSecurity
			 WHERE ((PageID = ? AND ApplyTo=0)
						OR ( (PageID IN (1,2,7,1031,206196)) 
							AND ApplyTo = 1))
			   AND ControlID <> 0
			   AND pRead=0
				AND pAuthor=0
				AND pEdit=0
				AND pDesign=0
				AND pApprove=0
				AND pAdmin=0
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 206196

Request.PageData.Restrictions (Datasource=commonspot-heritage.org, Time=0ms, Records=30) in D:\websites\commonspot\security\security-detail-queries.cfm @ 18:27:31.031
			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (1031,7,2,1) 
SecureElements (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\security\security-detail-queries.cfm @ 18:27:31.031
		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (1031,7,2,1)))
			)
			AND ControlID<>0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 206196
Parameter #3(CF_SQL_INTEGER) = 1

Request.PageData.ExplicitSecurity (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\security\security-detail-queries.cfm @ 18:27:31.031
			SELECT ControlID,
					 Max(pRead) AS maxRead,
					 Max(pAuthor) AS maxAuthor,
					 Max(pEdit) AS maxEdit,
					 Max(pDesign) AS maxDesign,
					 Max(pStyle) AS maxStyle,
					 Max(pAdmin) AS maxAdmin,
					 Max(pApprove) AS maxApprove
			  FROM ItemSecurity
			 WHERE ( (UserGroupID = ?) )
		      AND
				(
					((ApplyTo=?)
						AND (PageID=?))
					OR
					((ApplyTo=?)
						AND (PageID IN (1031,7,2,1)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 206196
Parameter #4(CF_SQL_INTEGER) = 1

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 18:27:31.031
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:27:31.031
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

GetCells (Datasource=commonspot-heritage.org, Time=16ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:27:31.031
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=206196 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:27:31.031
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 206196
Parameter #6(CF_SQL_INTEGER) = 83726
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

rsAuthor (Datasource=Authors, Time=0ms, Records=2) in D:\websites\heritage.org\customcf\MetaData_ResearchPaperOutputDupFix-RD06.cfm @ 18:27:31.031
		select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
		tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
		WHERE SitePagesID = 206196
		ORDER BY SortOrder
	
Request.TBUpfrontParam (Datasource=commonspot-heritage.org, Time=0ms, Records=21) in D:\websites\commonspot\tb-param-upfront-queries.cfm @ 18:27:31.031
		
		SELECT *
		  FROM Param_TextBlock
		 WHERE (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 ORDER BY ControlID, PageID Desc, VersionID Desc 
Request.TBUpfront (Datasource=commonspot-heritage.org, Time=15ms, Records=13) in D:\websites\commonspot\tb-data-upfront-queries.cfm @ 18:27:31.031
			
			SELECT *
			  FROM Data_TextBlock
			 WHERE (pageID IN (1,2,7,1031,206196)) 
			 	AND versionState = 2
		 ORDER BY ControlID, PageID Desc, VersionID Desc 
UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:27:31.031
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 206196
Parameter #6(CF_SQL_INTEGER) = 48266
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 18:27:31.031
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:27:31.031
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetCells (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:27:31.031
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=7 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetCellData (Datasource=commonspot-heritage.org, Time=0ms, Records=2) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:27:31.031
			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:27:31.031
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 206196
Parameter #6(CF_SQL_INTEGER) = 2172
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:27:31.031
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 206196
Parameter #6(CF_SQL_INTEGER) = 2
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 18:27:31.031
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:27:31.031
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

GetCells (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:27:31.031
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=206196 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:27:31.031
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 206196
Parameter #6(CF_SQL_INTEGER) = 88325
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

rsPapers (Datasource=commonspot-heritage.org, Time=312ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
				SELECT TOP 3 SitePages.*, DocCategories.Category, data_fieldvalue.Fieldvalue
				FROM DocCategories As DocCategories, SitePages As SitePages,
					data_fieldvalue as data_fieldvalue, forminputcontrol as forminputcontrol
				WHERE (DocCategories.ID = SitePages.CategoryID) 
					AND (SitePages.ApprovalStatus=0 AND SitePages.AudienceID=0 
					AND sitePages.subSiteID <> 0 AND SitePages.PageSetID = 0) 
					AND (SitePages.PageType IN (0,5) AND Uploaded=0) 
					AND SitePages.PageType NOT IN (4,9) 
					AND ( ( SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where Data_FieldValue.fieldID = 6858 and Data_FieldValue.formID = 6855 
							and Data_FieldValue.VersionState >= 2 
						) and ( SitePages.SubSiteID in (36) and ((SitePages.CategoryID not in (8)) OR (SitePages.CategoryID = 0)) ) 
						or SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where 
						(Data_FieldValue.fieldID = 45868 or data_fieldvalue.fieldid = 51999)
						and Data_FieldValue.formID = 6855 
						and Data_FieldValue.VersionState >= 2 AND ((Data_FieldValue.fieldValue LIKE '%HomelandDefense%') 
						OR (Data_FieldValue.fieldValue LIKE '%Homeland Security%'))) 
						) ) 
					AND ((SitePages.IsPublic > 0) ) AND (SitePages.PublicReleaseDate <= '2008-07-04 06:27:31') AND (SitePages.ID <> 96544) AND 
					(SitePages.ExpDate >= '2008-07-04 06:27:31' OR SitePages.ExpDate IS NULL) 
					AND sitepages.id = data_fieldvalue.pageid
					AND data_fieldvalue.fieldid = forminputcontrol.id
					and forminputcontrol.fieldname = 'FIC_Date'
					and sitepages.filename not like '%es.cfm'
				ORDER BY fieldvalue desc 

			
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 251225
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 251225
								ORDER BY SortOrder
							
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 251044
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 251044
								ORDER BY SortOrder
							
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 246961
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=16ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 246961
								ORDER BY SortOrder
							
Request.customCFUpfront (Datasource=commonspot-heritage.org, Time=0ms, Records=9) in D:\websites\commonspot\controls\upfront-generic.cfm @ 18:27:31.031
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=206196 OR (PageID IN (1031,7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 
rsPapers (Datasource=commonspot-heritage.org, Time=31ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
				SELECT TOP 3 SitePages.*, DocCategories.Category, data_fieldvalue.Fieldvalue
				FROM DocCategories As DocCategories, SitePages As SitePages,
					data_fieldvalue as data_fieldvalue, forminputcontrol as forminputcontrol
				WHERE (DocCategories.ID = SitePages.CategoryID) 
					AND (SitePages.ApprovalStatus=0 AND SitePages.AudienceID=0 
					AND sitePages.subSiteID <> 0 AND SitePages.PageSetID = 0) 
					AND (SitePages.PageType IN (0,5) AND Uploaded=0) 
					AND SitePages.PageType NOT IN (4,9) 
					AND ( ( SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where Data_FieldValue.fieldID = 6858 and Data_FieldValue.formID = 6855 
							and Data_FieldValue.VersionState >= 2 
						) and ( SitePages.SubSiteID in (36) and ((SitePages.CategoryID not in (8)) OR (SitePages.CategoryID = 0)) ) 
						or SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where 
						(Data_FieldValue.fieldID = 45868 or data_fieldvalue.fieldid = 51999)
						and Data_FieldValue.formID = 6855 
						and Data_FieldValue.VersionState >= 2 AND ((Data_FieldValue.fieldValue LIKE '%HomelandDefense%') 
						OR (Data_FieldValue.fieldValue LIKE '%Homeland Security%'))) 
						) ) 
					AND ((SitePages.IsPublic > 0) ) AND (SitePages.PublicReleaseDate <= '2008-07-04 06:27:31') AND (SitePages.ID <> 96544) AND 
					(SitePages.ExpDate >= '2008-07-04 06:27:31' OR SitePages.ExpDate IS NULL) 
					AND sitepages.id = data_fieldvalue.pageid
					AND data_fieldvalue.fieldid = forminputcontrol.id
					and forminputcontrol.fieldname = 'FIC_Date'
					and sitepages.filename not like '%es.cfm'
				ORDER BY fieldvalue desc 

			
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 251225
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 251225
								ORDER BY SortOrder
							
rsPaperDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 251044
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							
rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\RD06\box-standard-Latest-Research.cfm @ 18:27:31.031
								select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
								tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
								WHERE SitePagesID = 251044
								ORDER BY SortOrder
							
rsPaperDetails (Datasource=commonspot-heritage.org, Time=16ms, Records=3) in D:\websites\heritage.org\customcf\RD06\box