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 * from variables.qMeta
				where (
				meta_type = ?
					and (
					
						type_paramvalue like ? 
					)
				) or (
					meta_type = ?
						and (
						type_paramvalue like ?
					)
				)
			

			SELECT
				article_id as id,
				title,
				dek,
				type_name as description,
				source_tbl as source,
				publish_date as pubdate,
				url_alias
			FROM
				jumbotron j
			ORDER BY dsporder ASC
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'blog_entry'
			

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '43B18A3B-ECF1-3860-D818A29181A19B1A'
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'blog_entry'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '19FC1663-A603-2A39-51F21757C49B633D'
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '1A16BE81-9367-288E-E8BDE82AA2664F6B'
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

				SELECT inline_id
					FROM inline_image
				WHERE article_id = ?
					AND image_type = 'article'
					AND image_order = '1'
					

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '1D881F9E-E304-B65E-90BC35F1E71FBC4F'
		

		SELECT * FROM (
			SELECT
				a.*,
				rownum rn
			FROM (
				SELECT DISTINCT
					mview_articles.id,
					mview_articles.title,
					mview_articles.description,
					mview_articles.dek,
					mview_articles.pubdate,
					mview_articles.source,
					mview_articles.url_alias,
					mview_articles.paid_only,
					mview_articles.status_id,
					mview_articles.type_id
					
					FROM mview_articles
					
					WHERE type_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
						AND status_id IN (?,?,?,?)
						AND pubdate BETWEEN
							?
							AND
							?
						
						AND lower(title) NOT LIKE 'on the web%'
						
							AND isPromoted = '1'
						
							AND id NOT IN (?,?,?,?)
						
						ORDER BY pubdate desc
					) a
				WHERE rownum <8)
			WHERE rn >= 1 

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

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

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

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

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

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

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

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

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

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

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

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

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

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			SELECT * FROM (
			SELECT
				a.*,
				rownum rn
			FROM (
				SELECT DISTINCT
					mview_articles.id,
					mview_articles.title,
					mview_articles.description,
					mview_articles.dek,
					mview_articles.pubdate,
					mview_articles.source,
					mview_articles.url_alias,
					mview_articles.paid_only,
					mview_articles.status_id,
					mview_articles.type_id
					
					FROM mview_articles
					
					WHERE type_id IN (?,?)
						AND status_id IN (?,?,?,?)
						AND pubdate BETWEEN
							?
							AND
							? 
						AND length(title) <= ?
						ORDER BY pubdate desc
					) a
				WHERE rownum <4)
			WHERE rn >= 1 

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

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = 'B10F8C38-E98C-92D2-7E764160DC77DDA1'
		

			select * from variables.qType
			where contenttype_id = ? 

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

			SELECT * FROM (
			SELECT
				a.*,
				rownum rn
			FROM (
				SELECT DISTINCT
					BLOG_ENTRY_ID AS ID,
					TITLE,
					(select NAME from rd_contenttype where contenttype_id = rd_rel_category.fk_contenttype_id and rownum = 1) as description,
					(select url_alias from rd_contenttype where contenttype_id = rd_rel_category.fk_contenttype_id and rownum = 1) as blogname,
					'' as dek,
					pub_date as pubdate,
					'blog_entry' as source,
					url_alias,
					link,
					0 as paid_only,
					status_id,
					fk_contenttype_id as type_id,
					USER_ID,
					AUTHOR_ID,
					AUTHOR
					
				FROM rd_rel_category
					JOIN blog_entry ON (rd_rel_category.item_id = blog_entry.blog_entry_id)
				WHERE status_id IN (?,?,?,?)
					AND fk_contenttype_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
					AND pub_date BETWEEN
						?
						AND
						? 
						AND isBlogPromoted = '1'
					
				ORDER BY PUB_DATE DESC
				) a
				WHERE rownum <6)
			WHERE rn >= 1 

			select * from variables.qType
			where contenttype_id = ? 

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

			select * from variables.qType
			where contenttype_id = ? 

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

			select * from variables.qType
			where contenttype_id = ? 

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

			select * from variables.qType
			where contenttype_id = ? 

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

			select * from variables.qType
			where contenttype_id = ? 

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

			SELECT * FROM (
			SELECT
				a.*,
				rownum rn
			FROM (
				SELECT DISTINCT
					mview_articles.id,
					mview_articles.title,
					mview_articles.description,
					mview_articles.dek,
					mview_articles.pubdate,
					mview_articles.source,
					mview_articles.url_alias,
					mview_articles.paid_only,
					mview_articles.status_id,
					mview_articles.type_id
					
					FROM mview_articles
					
					WHERE type_id IN (?,?,?,?,?,?,?)
						AND status_id IN (?,?,?,?)
						AND pubdate BETWEEN
							?
							AND
							? 
						AND length(title) <= ?
						ORDER BY pubdate desc
					) a
				WHERE rownum <6)
			WHERE rn >= 1 

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

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

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

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

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

			SELECT *
				FROM citizen_science
			
				WHERE 1 = 1
			
				ORDER BY publish_date desc 

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = 'ABA5E979-0BC2-ED9C-0360AA26A8FFE48F'
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'citizen_science'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '473E2837-0964-AE01-59FBF05407B0BBEC'
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'citizen_science'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = 'B3A28C37-C689-8319-CAAF1D4FF6744122'
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'citizen_science'
			

			select * from variables.qType
			where contenttype_id = ? 

			SELECT * FROM (
			SELECT
				a.*,
				rownum rn
			FROM (
				SELECT DISTINCT
					mview_articles.id,
					mview_articles.title,
					mview_articles.description,
					mview_articles.dek,
					mview_articles.pubdate,
					mview_articles.source,
					mview_articles.url_alias,
					mview_articles.paid_only,
					mview_articles.status_id,
					mview_articles.type_id
					
					FROM mview_articles
					
					WHERE type_id IN (?)
						AND status_id IN (?,?,?,?)
						AND pubdate BETWEEN
							?
							AND
							? 
						AND length(title) <= ?
						ORDER BY pubdate desc
					) a
				WHERE rownum <4)
			WHERE rn >= 1 

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = 'E732D48E-FD50-6451-B1BB0BDDE7E98D43'
		

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

			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 = 'E6EF0A5A-FAD0-36A5-8C4AA4B7B41A6E82'
		

				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 template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '9FD80CAF-F128-8F44-03AC5576FD17E84D'
		

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

			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 = '7FEA9927-DAA6-17F7-00B92ECE66B6A0C6'
		

				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 template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '15FEC0CE-C679-5C65-6941031DAF4D9E96'
		

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

			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 = '15EC7845-0BBC-A774-FFFC79EDE8A79CC5'
		

				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 template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			SELECT * FROM (
			SELECT
				a.*,
				rownum rn
			FROM (
				SELECT DISTINCT
					mview_articles.id,
					mview_articles.title,
					mview_articles.description,
					mview_articles.dek,
					mview_articles.pubdate,
					mview_articles.source,
					mview_articles.url_alias,
					mview_articles.paid_only,
					mview_articles.status_id,
					mview_articles.type_id
					
					FROM mview_articles
					
					WHERE type_id IN (?,?)
						AND status_id IN (?,?,?,?)
						AND pubdate BETWEEN
							?
							AND
							? 
						AND length(title) <= ?
						ORDER BY pubdate desc
					) a
				WHERE rownum <4)
			WHERE rn >= 1 

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

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

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			select
				v_image,
				v_title
			from
				video_newswire
			where
				v_id = ? 

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

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

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			select
				v_image,
				v_title
			from
				video_newswire
			where
				v_id = ? 

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

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

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			select
				v_image,
				v_title
			from
				video_newswire
			where
				v_id = ? 

			select * from variables.qType
			where contenttype_id = ? 

				SELECT category_id
					FROM rd_category
				WHERE dsp_home = '1'
			

			SELECT DISTINCT
				id,
				title,
				description,
				dek,
				pubdate,
				source,
				url_alias,
				paid_only,
				status_id,
				type_id
			FROM
				mview_articles
			WHERE
				id IN (
				SELECT item_id as id
					FROM editors_picks
				WHERE fk_category_id IN (?,?,?,?,?)
			)
			AND source != 'photo_gallery'
			ORDER BY pubdate DESC
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '6F0FECCA-02C2-2298-153E657AB7BFD14A'
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '1522B8EF-FC3A-3EAC-CF366084525D69E8'
		

			select template, urlparam
			from arguments.qType
			
				where lower(tablename) = 'article'
			

			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 *
				FROM variables.qAllTypes
			
				WHERE
				contenttype_id IN (?)
			
			ORDER BY tablename
		

			SELECT inline_id
				FROM inline_image
			WHERE article_id = ?
				AND image_type = ?
				AND image_order = ? 
			ORDER BY image_order
		

			SELECT INLINE_ID,IMAGE_TYPE,TITLE,FILE_NAME,THUMB,IMAGE_NUMBER,IMAGE_ORDER,EXTENSION,CAPTION,CREDIT,URL,ALT,ARTICLE_ID,EXPIRE_DATE,SYNDICATE,HEIGHT,WIDTH FROM inline_image
			WHERE INLINE_ID = '4C18C150-C6C5-45CD-24C40CB82D828ADB'
		

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/index.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=
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/index.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.179.219
REMOTE_HOST=38.107.179.219
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.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:
cfid=16769
cftoken=64310848
hitcount=1
lastvisit={ts '2012-01-27 14:46:44'}
timecreated={ts '2012-01-27 14:46:44'}
urltoken=CFID=16769&CFTOKEN=64310848

Cookie Variables:
CFID=16769
CFTOKEN=64310848
SSCIAMUSER=

URL Parameters:
ADTEST=0
ID=
WT.ec_id=
WT.i_dcsvid=
WT.mc_id=