SURVEYID == 1
//$sqlStr=" AND vw_products.ProductID  ";
	//$sqlStr=" AND vw_products.ProductID IN(1,7)";
	//$sqlStr=" AND vw_products.ProductID IN(1,2,4,7,9,10,11,12,13)";
	//qlStr=" AND vw_products.ProductID IN(167,547,574,576,762)";
	//$sqlStr=" AND vw_products.ProductID IN(888488,547,574,576)";
//$sqlStr=" AND vw_products.ProductID IN(95,121,51,132,165,53,2872,206,146,286,259,105,48,2873,32,1012)";
/*
		$sqlStr=" AND vw_products.ProductID IN(888488,228,205,160,175,197,279,187,1187,201,618,246,236,619,275,192,1954,954,194,1956,956,546,874,876,185,614,193,247,218,212,223,1223,225,1225,222,1222,224,1224,226,1226,547,528,617,606,1402,402,1240,240,217,231,881,251,865,616,20,601,542,261,249,886,612,208,227,182,1401,401,1239,239,613,201,189,1189,211,200,207,1952,575,952,188,1188,216,271,204,220,232)";
*/
//$sqlStr=" AND vw_products.ProductID IN(88488,228,205,160,187,1187,201,618,246,275,1954,954,194,1956,956,546,614,193,247,547,528,617,606,1402,402,1240,240,217,231,251,865,616,620,542,261,249,612,208,227,182,1401,401,1239,239,613,199,189,
//1189,211,200,207,1952,952,188,1188,216,271,232,186,1186,237,198,238,1238,234,520,539,1289,289,574,183,214,229,248,210,233,826,219,215,196,203,530,1241,241,195,245,235,167,1958,958,762)";
		//$sqlStr=" AND vw_products.ProductID IN(4,7,9,10,11,12,403,5201,5202,5203,112111,11321,581817,1213,303403,5200) ";
		/*** Brand Source ***/

 //$sqlStr=" AND vw_products.ProductID IN(13,16,12,4,2,3,14,1,9,11,7,10,18,17,197,187,1187,194,546,189,1189,575,188,1188,271,238,1238,888,195,269,51,457,164,206,45,48,31) ";
	   /*ProSource*/
	  //$sqlStr=" AND vw_products.ProductID IN(246,606,601,542,182,167,205,247,188,1188) ";
	   //$sqlStr=" AND vw_products.ProductID IN(31, 32, 36, 45, 48, 51, 53, 61, 64, 77, 78, 82, 89, 90, 92, 95, 105, 121, 134, 146, 162, 163, 164, 165, 181, 206, 259, 285, 286, 377, 457, 1011, 1012, 1013, 1014, 1015, 1016, 2872, 2873) ";
		//$sqlStr=" AND vw_products.ProductID IN(12, 13, 21, 22, 23, 25, 26, 27, 28, 29, 210, 251, 520, 528, 530, 542, 606, 873, 908, 960) ";
       // $sqlStr=" AND vw_products.ProductID IN(883,877,267,519,625,875,898) ";      
        //$sqlStr=" AND vw_products.ProductID IN(908,856,840,626,868,947,872,21,42,171,853,880,875,166,871,873,519,839,899,29,623,629,837,951,852,268,901,22,884,838,950,23,138,858,898,861,869,625,1000,960,850,857,621,895,854,26,
        //877,883,855,893,170,870,161,888,437,622,267,25,826,628,630,866,172,904,906,905,900,168,624,27,913,627,269,896,885,228,205,160,175,197,187,1187,201,618,246,275,192,1954,954,194,1956,
       // 956,546,874,876,193,212,225,1225,226,1226,547,528,617,606,1402,1240,240,217,231,881,251,865,620,601,542,886,612,208,227,182,1401,401,1239,239,613,189,1189,211,207,1952,575,952,188,1188,
       // 216,271,204,232,186,1186,237,198,238,1238,234,520,539,878,183,889,280,214,229,210,233,278,879,219,215,864,1173,173,1274,274,615,887,196,203,530,1241,241,195,576,235,167,221,1221,1958,958) ";     
	   /*set it all back*/

	  // $sqlStr=" AND vw_products.ProductID IN(952,1952,954,1954,957,1957,958,1958,956,1956) ";
	   
	  //$sqlStr=" AND vw_products.ProductID IN(888200,888202,888204,888205,888206,888207,888208,888209,888210) ";
	   //AND vw_products.ProductID IN(888191,888192,888193,888194,888195,888196,888197,888198,888199,888257,888258,888485,888486,888487,888488,888489,888490,888497,888603,888604,888605)
	   //$sqlStr=" AND vw_products.ProductID IN(21,223,1223,225,1225)";
	   //$sqlStr=" AND vw_products.ProductID IN(132,286,2872,2873)";
	//$sqlStr=" AND vw_products.ProductID IN(197,279,201,275,1956,956,193,200,204,280,278,276,277,203,1957,957,184)";
	//$sqlStr=" AND vw_products.ProductID IN(1954, 1956, 1952, 1957, 1958, 954, 956, 952, 957, 958)";
//31, 32, 36, 45, 48, 51, 53, 61, 64, 77, 78, 82, 89, 90, 92 95, 105, 121, 134, 146, 162, 163, 164, 165, 181, 206, 259, 285, 286, 377, 457, 1011, 1012, 1013, 1014, 1015, 1016, 2872, 2873

//$sqlStr=" AND vw_products.ProductID IN(13,16,12,4,2,5,3,14,1,9,11,7,10,18,30,6,17,20,457,31,187,1187,618,275,601,519,188,1188,1000,574,855,893,167) "; 
/*
$sqlStr=" AND vw_products.ProductID IN($sqlStr = " and vw_products.ProductID IN(1,2,4,6,7,9,10,11,12,13,14,16,17,18,30,574,3)) ";
$sqlStr=" AND vw_products.ProductID IN(173) ";

//$sqlStr=" AND vw_products.ProductID IN(61,67,92,95,64,36,119,121,66,51,148,78,1011,457,165,149,53,163,164,2872,134,206,162,89,146,286,1014,285,1013,82,259,105,90,45,181,48,2873,31,32,37,1016,1015,1012) ";
/*
		$sqlStr=" AND vw_products.ProductID IN( 
					select ProductID from us_meta.tblSASRawDataSets 
					where RawDSN IN('rf', 'fz', 'dw', 'rgfs', 'rgbi', 'rgwo', 'rgct', 'dr', 'aw', 'tv', 'mattress', 'speak', 'rec', 'hdphn', 'gril')
					order by ProductID ) ";
*/
		//$sqlStr = " and vw_products.ProductID IN(21, 22, 23, 25, 26, 27, 29, 132, 198, 227, 228, 229, 231, 232, 233, 234, 235, 237, 261, 403, 404, 516, 517, 518, 519, 629, 630, 1238)";
	    /*$sqlStr = " and vw_products.ProductID IN(select ProductID from us_meta.tblSASRawDataSets where RawDSN IN('airptset', 'bedfurn', 'bedfurnresp', 'bread', 'drpre', 'extst' 
                    , 'extstresp', 'fert', 'jssaw', 'medcab', 'osand', 'pest', 'ragrd', 'rgbi', 'rgct', 'rgwo', 'roto', 'routr', 'trbox' 
                    , 'varn', 'varnresp', 'wdisp', 'wkbnch', 'wren', 'rf', 'aw', 'dr', 'rgfs', 'fz', 'dw') )";*/
               //$sqlStr=" AND vw_products.ProductID IN (246,247,575) ";
    	//$sqlStr = " and vw_products.ProductID IN(1, 2, 3, 4, 7, 9, 10, 11, 12, 13, 14)";
    //$sqlStr = " and vw_products.ProductID IN(908,856,840,626,868,947,872,21,42,171,853,880,875,166,871,873,519,899,29,629,837,951,852,268,901,22,884,838,950,23,
////138,898,861,869,625,1000,960,850,857,621,895,854,26,877,883,28,893,170,870,161,888,437,622,267,25,630,866,172,904,906,
//905,900,168,624,27,913,269,896,885) ";
	//$sqlStr=" AND vw_products.ProductID IN(205,160,197,187,1187,201,618,246,619,275,194,1956,956,546,614,247,547,873,606,616,620,601,519,29,612,208,629,1401,401,199,189,1189,200,575,188,1188,216,271,884,204,186,1186,237,198,238,1238,539,960,850,28,280,437,214,25,630,219,215,615,970,906,905,900,277,203,195,27,627,269)";

	/*
	$sqlStr = " and vw_products.ProductID IN(192,193,6459, 6460, 6461, 6462, 6463, 6464, 6465, 6466, 6467, 952, 954, 956, 957, 958, 884, 960, 14, 519, 520, 539, 1238, 185)";
	*/
/*
$sqlStr=" AND vw_products.ProductID IN(2,3,4,5,6,7,9,10,11,12,13,14,16,17,18,19,20,30,31,36,48,51,53,61,64,78,82,89,90,92,95,105,121,132,134,138,146,149,162,163,164,165,167,173,181,206,210,259,285,457,547,574,873,905,1020,1173,2872,2873,888500) ";
*/
	//$sqlStr=" AND vw_products.ProductID IN(21,22,26,27,29,857,854,853,852,850,950) ";
	//$sqlStr=" AND vw_products.ProductID IN(1,2,4,7,9,10,11,12,13,271,31,14,3) ";

		//Monthly Prods Lowes Monthly products we are adding the Quarterly
		//$sqlStr=" AND vw_products.ProductID not IN(888485,888490,888498,888614,888627,8884900,8884901,8884902) ";

//$sqlStr=" AND vw_products.ProductID  IN(1,2,3, 4,7,9,10,11,12,13) ";
//$sqlStr=" AND vw_products.ProductID IN(850, 852, 853, 854, 950) "; 
//$sqlStr=" AND vw_products.ProductID IN(61) "; 
//$sqlStr=" AND vw_products.ProductID  IN(select ProductID from tq_admin.vw_companies_products where SurveyID=1 and CompanyID=879) "; 
	//$sqlStr=" AND vw_products.ProductID  IN(908)";  


SURVEYID == 2
//$sqlStr=" AND vw_products.ProductID  ";

		 
//$sqlStr = " and vw_products.ProductID IN(select ProductID from tq_admin.vw_companies_products where SurveyID=2 and ProductID in (";