SELECT * FROM (
				SELECT a.*, ROWNUM rn FROM (
					SELECT *
						FROM rd_contenttype
					ORDER BY 'NAME'
				) a
				where ROWNUM <?
			) where rn >= ? 

			select * from variables.qType
			where tablename like ? 

			SELECT id, type_id, source
				FROM view_articles
			WHERE type_id NOT IN (16) 
			
				AND url_alias = ? 

			SELECT article_id,title,status_id,keyword,abstract,dek,sidebar,publish_date,issue_date,creation_date,update_date,home_page_graphic,from_whom,from_where,quick_fact,archive_asset_id,print_sub_topic,paid_only,url_alias,author_bio,footnote,key_concepts,SYNDICATE,PUBDATE_OVERRIDE FROM article
			WHERE article_id = '5F8E6DF8-B685-CBFC-72F8F7624BD1A8C4'
		

				select content
					from article_page
				where article_id = ?
					order by page_number
			

				select
					a.author_id,
					a.name
				from rel_author r
					left outer join author a on (r.author_id = a.author_id)
				where r.article_id = ?
					order by dsp_order, name
			

				select
					se.se_title,
					se.se_url,
					st.st_name,
					se.se_filename
				from sidebar_element se
					join sidebar_type st on (se.se_filetype = st.st_id)
				where se.article_id = ?
					order by sort_order
			

				select
					title,
					url
				from more_to_explore
				where article_id = ?
					order by sort_order
			

				select
					i.issue_column_id,
					i.name,
					i.url_alias
				from rel_issue_column r
					join issue_column i on (r.issue_column_id = i.issue_column_id)
				where article_id = ? 

			SELECT
				c.category_id,
				c.Name,
				c.url_alias,
				r.isPrimary
			FROM rd_rel_category r
				JOIN rd_category c ON (c.category_id = r.fk_category_id)
			WHERE r.item_id = ?
			ORDER BY Name
		

			SELECT DISTINCT
				t.topic_id,
				t.Name,
				t.url_alias,
				r.score
			FROM rel_content_topic r
				JOIN content_topic t ON (r.fk_content_topic_id = t.topic_id)
			WHERE r.item_id = ?
				AND t.isActive = ?
				AND r.score >= ?
			ORDER BY r.score DESC
		

				SELECT Category_Id, Name, url_alias FROM stReturn.category ORDER BY isPrimary DESC
			

				SELECT Topic_id, Name, url_alias FROM stReturn.topic ORDER BY Score DESC
			

			SELECT
				r.id,
				r.Title,
				r.url_alias
			FROM indepth_report_content rc
				JOIN indepth_report r ON (rc.fk_indepth_report_id = r.id)
			WHERE rc.item_id = ? 

			select * from variables.qType
			where contenttype_id = ? 

				select * from variables.qMeta
				where (
				meta_type = ?
					and (
					
						type_paramvalue like ? 
					)
				) or (
					meta_type = ?
						and (
						type_paramvalue like ?
					)
				)
			

			SELECT COUNT(comment_id) as count
				FROM sciam_comment
			WHERE item_id = ?
				AND isDeleted = ? 

			select * from variables.qType
			where name like ? 

			SELECT DISTINCT
				id,
				title,
				description,
				dek,
				pubdate,
				source,
				url_alias,
				paid_only,
				status_id,
				type_id,
				syndicate
			FROM
				view_articles
			WHERE
				id IN (?)
		

			select * from variables.qType
			where contenttype_id = ? 

			select template, urlparam
			from arguments.qType
			
				where contenttype_id = 9 

			select * from variables.qType
			where contenttype_id = ? 

			select
				contenttype_id as id,
				name,
				tablename
			from rd_contenttype a
				join rd_rel_category b on (a.contenttype_id = b.fk_contenttype_id)
			where item_id = ? 

					select count(article_id) as ct
					from inline_image
					where article_id = ?
					and image_type = 'article'
				

			SELECT
				name as Word,
				 '/topic.cfm?id=' || url_alias as link,
				 Length(name) as Len,
				 '' as class,
				 '' as target,
				 '' as onClick
			FROM content_topic
				WHERE isActive = '1'
		

			SELECT Word,Link,
				Class,
				Target,
				onClick
			FROM Arguments.WordQuery
			ORDER BY Len DESC
		

			select * from variables.qType
			where contenttype_id = ? 

			select distinct
				item_id,
				url_alias,
				title,
				count(item_id) as ct
			from rel_content_topic
				join article on (item_id = article_id)
			where fk_content_topic_id in (
				select fk_content_topic_id from rel_content_topic
				where item_id = ?
			)
			and item_id != ?
			group by item_id, title, url_alias
			order by count(item_id) desc
		

		SELECT item_id, url_alias, title, 'Zzzzzz' as dspOrder
			FROM qRelated
		ORDER BY dspOrder ASC
	

			SELECT b.*, e.rn4 ParentPosition
			FROM (
				SELECT a.*, ROWNUM rn
				FROM
					(SELECT rownum rownum2,
								c.comment_id,
								c.parent_id,
								c.flagged,
								c.subject,
								c.body,
								c.date_created,
								to_char(c.date_created,'HH:MI PM') || ' on ' || to_char(c.date_created,'MM/DD/YY') as formatted_date,
								c.user_id,
								(
									SELECT username FROM sciam_user
									WHERE user_id IN (
										SELECT user_id
										FROM sciam_comment
										WHERE comment_id = c.parent_id
									)
								) as ParentUsername,
								u.username,
								u.email,
								u.firstname || ' ' || u.lastname as name,
								(
									SELECT count(comment_id)
									FROM sciam_comment
									WHERE item_id = c.item_id
									AND isDeleted = '0'
								) as count
							FROM sciam_comment c
								JOIN sciam_user u ON (c.user_id = u.user_id)
							WHERE c.item_id = ?
								AND c.isDeleted = '0'
							
								ORDER BY date_created ASC ) a
				WHERE rownum <100000) b,
				(SELECT d.*, ROWNUM rn4
					FROM
					(SELECT rownum rn3, c.comment_id
						FROM sciam_comment c
							JOIN sciam_user u ON (c.user_id = u.user_id)
						WHERE c.item_id = ?
							AND c.isDeleted = '0'
						
						
							ORDER BY c.date_created ASC ) d) e
			WHERE rn >= 1
				AND e.comment_id (+) = b.parent_id
			ORDER BY rn
		

			SELECT comments_closed
				FROM sciam_comment
			WHERE item_id = ? 

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=/netscape_data/sa/article.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=media=desktop; CFGLOBALS=urltoken%3DCFID%23%3D16769%26CFTOKEN%23%3D64310848%23lastvisit%3D%7Bts%20%272012%2D01%2D27%2014%3A46%3A47%27%7D%23timecreated%3D%7Bts%20%272012%2D01%2D27%2014%3A46%3A44%27%7D%23hitcount%3D2%23cftoken%3D64310848%23cfid%3D16769%23; CFID=16769; CFTOKEN=64310848
HTTP_HOST=dev.sciam.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/netscape_data/sa/article.cfm
QUERY_STRING=id=video-ces-tns-gaming-vest
REMOTE_ADDR=38.107.179.216
REMOTE_HOST=38.107.179.216
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/article.cfm
SERVER_NAME=dev.sciam.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/2.2.3 (Red Hat)
WEB_SERVER_API=

Client Variables:
abuseids=
cfid=16769
cftoken=64310848
hitcount=2
lastvisit={ts '2012-01-27 14:46:47'}
timecreated={ts '2012-01-27 14:46:44'}
urltoken=CFID=16769&CFTOKEN=64310848

Cookie Variables:
CFGLOBALS=urltoken=CFID#=16769&CFTOKEN#=64310848#lastvisit={ts '2012-01-27 14:46:47'}#timecreated={ts '2012-01-27 14:46:44'}#hitcount=2#cftoken=64310848#cfid=16769#
CFID=16769
CFTOKEN=64310848
SSCIAMUSER=
media=desktop

URL Parameters:
id=video-ces-tns-gaming-vest