The DHS Program

    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    

		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 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=9965 OR (PageID IN (5208,1886,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 *
	  FROM Data_Ghost_Common
	 WHERE (PageID=9965 OR (PageID IN (5208,1886,2,1) AND (VersionState = 2)))
	ORDER BY ControlID, PageID DESC

		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=9965 OR (PageID IN (5208,1886,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 ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

    select m.survey_id  from survey_mod_feat_lnk m WHERE mod_feat_id IN (21)
    and m.survey_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

    select m.survey_id  from survey_mod_feat_lnk m WHERE mod_feat_id IN (24)
    and m.survey_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

	SELECT *	from qsurvey ORDER BY Survey_end

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)
                     

                     select p.survey_id,p.pub_type_id,p.pub_id,t.Pub_Type_Name, Pub_Code 
  							from pub_catalog p,Survey s,Ctry c, Pub_Type t
                            where p.survey_id=s.survey_id and 
                            s.ctry_id=c.ctry_id and
                            t.Pub_Type_ID = P.pub_Type_ID and 
                            c.Ctry_id=?
                            and p.Survey_id=? 
                            and (p.pub_type_id  IN (?,?,?,?,? ) 
                            and p.stts_id=?)