The DHS Program

					UPDATE ElementInstance
						SET CacheFormat=?,
							 CacheValidUntil=?,
							 ContentValidUntil=?,
							 DataPageID=?,
							 DependentObjectID=?,
							 DynamicStatus=?,
							 HasChildren=?,
							 HasData=?,
							 HasDynamicContent=?,
							 IndexStatus=?,
							 IsDeviceDependent=?,
							 ParamPageID=?,
							 PrintStatus=?,
							 ShareStatus=?,
							 ConflictList=?
					 WHERE ServerID=?
						AND SubsiteID=?
						AND PageID=?
						AND ControlID=?
						AND CacheLevel=?
						AND IsWIP=? 

			SELECT *
			  FROM ElementInstance
			 WHERE SubsiteID=?
				AND PageID=?
				AND IsWIP=? 
				AND ServerID=? 
		 ORDER BY ControlID DESC,CacheLevel
		

		SELECT *
		  FROM SitePages
		 WHERE ID=?
			AND AudienceID=0
	

	SELECT *
	  FROM SitePages
	 WHERE ID=? 

		SELECT StaleCacheMaxKeepTime,DynamicContentCacheKeepTime
		  FROM SitePages
		 WHERE (ID IN (?,?,?)) 
	 ORDER BY ID
	

		SELECT DISTINCT SitePages.SubSiteID
		  FROM SitePages, Subsites
		 WHERE SitePages.SubSiteID = Subsites.ID
		
			AND Subsites.ID = ? 

			SELECT PageType
			  FROM SitePages
			 WHERE ID = ? 

					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,3,11,14,15))
	

		SELECT OriginalString AS Word 
				, KeywordType As KeywordTypeID
				
		  FROM ObjectKeywords
		 WHERE ObjectID = ? 
			AND KeywordType = ? 
	 ORDER BY Position, OriginalString
	

			SELECT GeneralCategories.Category, RenderOptions.PageID
			  FROM RenderOptions, GeneralCategories
			 WHERE GeneralCategories.ID = RenderOptions.CategoryID
				AND GeneralCategories.CategoryTypeID = ?
				AND (RenderOptions.PageID IN (?,?,?,?)) 
		 ORDER BY RenderOptions.PageID Desc
		

	SELECT PageType, SubSiteID, CategoryID, InheritedTemplateList, DocType, Uploaded
	  FROM SitePages
	 WHERE ID = ? 

	SELECT Data_FieldValue.PageID, Data_FieldValue.FieldValue, FormInputControl.FieldName, FormInputControl.type, FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid, FormInputControl.params AS fieldParams
						  
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE (Data_FieldValue.PageID IN (?,?,?,?))  
		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 (?,?)) 
				)
				
				
					OR (
								 (FormControlMap.ClassConstant = 1)
							AND ( (FormControlMap.ClassID IN (?,?,?)) )
						)
				
				
					OR (
								 (FormControlMap.ClassConstant = 2)
							AND (FormControlMap.ClassID = ?)
						)
				
				

				
			 )
	
 ORDER BY PageID DESC, FormControl.ID, FormInputControl.ID

	SELECT *
	  FROM Data_ClassNames
	 WHERE (PageID IN (?,?,?,?)) 
		AND VersionState = ?
		AND OutputTypeID = 0
 ORDER BY PageID DESC, ControlID DESC

		SELECT *
		  FROM Data_StyleSheetGroups
		 WHERE (PageID IN (?,?,?,?)) 
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos ASC
	

		SELECT *
		  FROM Data_StyleSheets
		 WHERE (PageID IN (?,?,?,?)) 
			AND ControlID = ?
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos
	

		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	

	SELECT DISTINCT ControlID
	  FROM ItemSecurity
	 WHERE PageID = ?
		AND ApplyTo = 0 

		SELECT SubsiteID,Filename,PageType
		  FROM SitePages
		 WHERE ID = ? 

			SELECT *
			  FROM ItemSecurity
			 WHERE PageID = ?
				AND ApplyTo = 0 

		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
	

			SELECT *
			  FROM Param_Page
			 WHERE (PageID=4240 OR (PageID IN (1652,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		

					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	

		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID
	

		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=4240 OR (PageID IN (1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

                                        SELECT DISTINCT  
                                            S.Survey_ID, 
                                            C.Ctry_ID 
                                        FROM Survey S   
                                               INNER JOIN Ctry C ON S.Ctry_ID = C.Ctry_ID
                                               INNER JOIN Rgn R ON R.Rgn_ID = C.Rgn_ID  
                                               INNER JOIN Survey_subType T1 ON T1.Survey_subType_ID = S.Survey_Type_ID
                                               INNER JOIN Survey_Type T ON  T.Survey_Type_ID = T1.Survey_Type_MainID   
                                               INNER JOIN Survey_Stts St ON St.Stts_ID = S.Stts_ID  
                                               INNER JOIN pub_Catalog e ON e.Survey_ID = s.Survey_ID   
                                         WHERE 
                                               St.Stts_ID <> 1
                                               AND St.Stts_ID <> 4
                                               AND St.Stts_ID <> 99
                                               AND St.Stts_ID <> 0 AND
                                               ((e.Pub_Type_ID IN (?,?,?,?,?)) and e.Stts_id=?)     
                                               AND s.survey_id IN
                                                      (select m.survey_id 
                                                       from survey_mod_feat_lnk m 
                                                       WHERE mod_feat_id IN (15,41))
                                    

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=19 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=45 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=2 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=21 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=63 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=15 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=19 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=69 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=81 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=18 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=45 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=4 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=2 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=243 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=6 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=160 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=63 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=175 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=220 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=48 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=81 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=142 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=60 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=13 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=29 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=85 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=76 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=18 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=100 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=139 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=63 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=7 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=118 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=160 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=205 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=2 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=72 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=41 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=22 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=18 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=4 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=117 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=51 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=1 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=81 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=13 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=17 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=46 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=22 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=61 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=28 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=48 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=142 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=21 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=60 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=55 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=5 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=76 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=66 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=18 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=29 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=243 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=129 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=15 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=51 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=64 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=160 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=51 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=63 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=61 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=205 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=13 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=48 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=76 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=81 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=168 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=41 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=18 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=7 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=22 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=4 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=117 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=157 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=225 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=72 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=61 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=1 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=22 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=47 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=68 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=129 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                        SELECT DISTINCT count(c.Pub_ID) As final_report_count1
                                        
                                        FROM Pub_Catalog c
                                        INNER JOIN Pub_Type t ON t.Pub_Type_ID = c.Pub_Type_ID
                                        INNER JOIN Pub_Type_Prnt t2 ON t.Pub_Type_Prnt_ID = t2.Pub_Type_Prnt_ID
                                        LEFT OUTER JOIN Survey s ON s.Survey_ID = c.Survey_ID    
                                        WHERE c.Pub_Code <> 'NA'
                                        AND c.Stts_ID = 3        AND pub_id IN (2308,114,129,126,141,133,135,342,326,275,335,297,279,370,346,334,348,344,523,411,366,457,666,720,466,543,583,463,485,808,596,582,575,594,566,559,563,624,608,769,678,634,723,625,681,597,669,586,759,660,796,743,733,860,1007,955,873,884,1065,1103,1316,1394,1034,1020,974,936,978,997,1525,1208,941,1032,1094,1006,1013,1217,942,1040,1054,1191,1223,1145,1806,1126,1322,1557,1134,1188,1270,1505,1122,1141,1131,1289,1284,1382,1076,1050,1332,1945,1375,1117,1247,1198,1111,1180,1546,1301,1207,1288,1362,1437,1366,1389,1476,1325,1545,1061,1245,1179,1273,1585,1720,1311,996,1424,1466,1736,1418,1360,1580,1650,1837,1592,1751,1825,1639,1555,1808,1533,1690,1699,1755,1775,1589,1729,1600,1704,1680,1689,1964,1784,1634,1954,1554,1876,1961,1890,1830,1721,1949,1814,2100,1846,1843,1797,1768,2036,1927,1938,1790,1944,1997,2009,2050,1919,2170,2176,2046,2228,2062,2167,2083,2238,2209,2183,2116,2263,2229,2293,2298,2220,2234)
                                    

                                        SELECT DISTINCT  
                                            S.Survey_ID, 
                                            C.Ctry_ID 
                                        FROM Survey S   
                                               INNER JOIN Ctry C ON S.Ctry_ID = C.Ctry_ID
                                               INNER JOIN Rgn R ON R.Rgn_ID = C.Rgn_ID  
                                               INNER JOIN Survey_subType T1 ON T1.Survey_subType_ID = S.Survey_Type_ID
                                               INNER JOIN Survey_Type T ON  T.Survey_Type_ID = T1.Survey_Type_MainID   
                                               INNER JOIN Survey_Stts St ON St.Stts_ID = S.Stts_ID  
                                               INNER JOIN pub_Catalog e ON e.Survey_ID = s.Survey_ID   
                                         WHERE 
                                               St.Stts_ID <> 1
                                               AND St.Stts_ID <> 4
                                               AND St.Stts_ID <> 99
                                               AND St.Stts_ID <> 0 AND
                                               ((e.Pub_Type_ID IN (?,?,?,?,?)) and e.Stts_id=?)     
                                               AND s.survey_id IN
                                                      (select m.survey_id 
                                                       from survey_mod_feat_lnk m 
                                                       WHERE mod_feat_id IN (6))
                                    

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=6 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=6 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=54 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=55 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=63 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=6 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=8 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=69 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=34 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=47 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=8 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=7 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=4 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=2 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=243 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=55 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=6 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=63 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=175 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=48 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=142 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=22 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=47 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=85 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=230 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=1 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=8 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=18 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=34 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=100 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=7 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=118 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=205 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=2 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=41 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=8 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=4 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=117 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=13 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=46 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=61 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=28 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=48 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=142 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=6 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=21 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=225 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=55 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=66 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=18 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=47 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=31 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=243 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=129 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=34 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=8 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=15 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=53 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=64 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=51 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=63 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=59 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=61 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=13 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=48 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=6 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=76 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=8 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=81 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=168 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=191 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=18 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=34 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=4 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=117 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=225 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=31 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=72 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=22 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=47 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=68 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=129 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                        SELECT DISTINCT count(c.Pub_ID) As final_report_count1
                                        
                                        FROM Pub_Catalog c
                                        INNER JOIN Pub_Type t ON t.Pub_Type_ID = c.Pub_Type_ID
                                        INNER JOIN Pub_Type_Prnt t2 ON t.Pub_Type_Prnt_ID = t2.Pub_Type_Prnt_ID
                                        LEFT OUTER JOIN Survey s ON s.Survey_ID = c.Survey_ID    
                                        WHERE c.Pub_Code <> 'NA'
                                        AND c.Stts_ID = 3        AND pub_id IN (304,113,106,64,360,117,342,282,630,335,297,334,348,153,403,437,462,666,720,633,543,485,808,799,575,594,559,624,608,678,723,625,681,791,586,759,894,796,853,890,772,860,982,1008,955,970,873,1316,1394,1020,974,1525,1208,804,1094,1006,1217,1040,1054,1806,1126,1557,1270,1505,1122,1131,1289,1284,1049,1382,1346,1945,1546,1207,1288,1362,1437,1535,1370,1476,1545,1061,1179,1273,1449,1425,1491,1720,1421,996,1466,1611,1736,1418,1837,1592,1657,1825,1639,1808,1699,1743,1755,1775,1729,1704,1514,1964,1784,1954,1554,2057,1961,1890,1830,1923,2100,1843,2036,1938,1950,1944,2050,2176,2046,2228,2062,2167,2238,2209,2183,2263,2308,2103,2156)
                                    

                                        SELECT DISTINCT  
                                            S.Survey_ID, 
                                            C.Ctry_ID 
                                        FROM Survey S   
                                               INNER JOIN Ctry C ON S.Ctry_ID = C.Ctry_ID
                                               INNER JOIN Rgn R ON R.Rgn_ID = C.Rgn_ID  
                                               INNER JOIN Survey_subType T1 ON T1.Survey_subType_ID = S.Survey_Type_ID
                                               INNER JOIN Survey_Type T ON  T.Survey_Type_ID = T1.Survey_Type_MainID   
                                               INNER JOIN Survey_Stts St ON St.Stts_ID = S.Stts_ID  
                                               INNER JOIN pub_Catalog e ON e.Survey_ID = s.Survey_ID   
                                         WHERE 
                                               St.Stts_ID <> 1
                                               AND St.Stts_ID <> 4
                                               AND St.Stts_ID <> 99
                                               AND St.Stts_ID <> 0 AND
                                               ((e.Pub_Type_ID IN (?,?,?,?,?)) and e.Stts_id=?)     
                                               AND s.survey_id IN
                                                      (select m.survey_id 
                                                       from survey_mod_feat_lnk m 
                                                       WHERE mod_feat_id IN (4))
                                    

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=38 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=46 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=5 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=12 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=29 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=46 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=7 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=68 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=12 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=59 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=7 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=4 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=220 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=29 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=7 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=41 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=46 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=29 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=129 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=51 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=59 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=10 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=168 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=22 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=208 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=68 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=129 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                        SELECT DISTINCT count(c.Pub_ID) As final_report_count1
                                        
                                        FROM Pub_Catalog c
                                        INNER JOIN Pub_Type t ON t.Pub_Type_ID = c.Pub_Type_ID
                                        INNER JOIN Pub_Type_Prnt t2 ON t.Pub_Type_Prnt_ID = t2.Pub_Type_Prnt_ID
                                        LEFT OUTER JOIN Survey s ON s.Survey_ID = c.Survey_ID    
                                        WHERE c.Pub_Code <> 'NA'
                                        AND c.Stts_ID = 3        AND pub_id IN (321,93,108,113,122,116,125,127,140,136,347,66,278,326,327,277,370,345,295,405,366,557,462,454,466,633,543,583,496,463,458,596,582,566,769,681,586,759,660,872,733,926,1008,970,1316,978,1525,1208,1054,1557,1141,1375,1546,1301,1207,1437,1366,1389,1325,1545,1425,1466,1611,1580,1837,1657,1775,1604,1704,1689,1954,1830,2036,1790,2050,1919,2176,2046,2167,2238,2183,2308,2103,2156)
                                    

                                    SELECT DISTINCT  
                                        S.Survey_ID, 
                                        C.Ctry_ID 
                                        FROM Survey S   
                                           INNER JOIN Ctry C ON S.Ctry_ID = C.Ctry_ID
                                           INNER JOIN Rgn R ON R.Rgn_ID = C.Rgn_ID  
                                           INNER JOIN Survey_subType T1 ON T1.Survey_subType_ID = S.Survey_Type_ID
                                           INNER JOIN Survey_Type T ON  T.Survey_Type_ID = T1.Survey_Type_MainID   
                                           INNER JOIN Survey_Stts St ON St.Stts_ID = S.Stts_ID  
                                           INNER JOIN pub_Catalog e ON e.Survey_ID = s.Survey_ID   
                                        WHERE 
                                           St.Stts_ID <> 1
                                           AND St.Stts_ID <> 4
                                           AND St.Stts_ID <> 99
                                           AND St.Stts_ID <> 0 AND
                                           ((e.Pub_Type_ID IN (?,?,?,?,?)) and e.Stts_id=?)     
                                           AND s.survey_id IN
                                                  (select m.survey_id 
                                                   from survey_mod_feat_lnk m 
                                                   WHERE mod_feat_id IN (57,8))
                                    

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=6 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=68 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=12 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=61 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=28 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=47 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=23 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=52 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=20 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=16 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=30 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=33 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=68 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=50 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=7 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=4 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=36 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=243 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=55 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=139 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=139 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=65 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=67 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=24 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=35 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=63 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=220 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=48 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=56 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=47 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=57 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=44 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=60 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=13 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=39 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=22 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=31 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=25 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=29 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=47 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=76 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=14 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=? 

                                            select p.survey_id,pub_id from pub_catalog p,Survey s,Ctry c
                                            where p.survey_id=s.survey_id and 
                                            s.ctry_id=c.ctry_id and
                                            c.Ctry_id=28 and p.Survey_id=?
                                            and (pub_type_id IN (?,?,?,?,?)) and p.stts_id=?