/*** BRANDSOURCE ***/
//$sqlStr = " and vw_products.ProductID IN(5200) ";
//and ProductID NOT IN(33940031, 33940031, 33942711, 33943131, 33943139, 33943149, 33943153, 33943160, 33943161,4720031,4723139,4723149,
//4723153,4723160,4723161,4723131,4723125,4722711,4728184)
//$sqlStr = " and vw_products.ProductID IN(5200, 5204) ";
//873
	/* LG&Q */
	/**/
	//exclude 1
	//2,4,7,9,10,11,12,13,31,271,3,14,873
	/*
	$sqlStr = " and ProductID IN(
								select DerivedProductID as ProductID from us_meta.vw_product_hierarchy_using_singles 
								where SingleProductID IN(1, 2, 4, 7, 9, 10, 11, 12, 13) group by DerivedProductID
							) ";
	/**/

/*Brand Source Run*/
	//$sqlStr = " and vw_products.ProductID IN(5200, 5204,33940031, 33940519, 33942711, 33943131, 33943139, 33943149, 33943153, 33943160, 33943161) ";
/*
rf breakouts
5200, 5201, 5202, 5203, 5204, 5208, 5209, 5230, 5231, 5371, 35200, 35201, 35202, 35203, 35209, 35213, 35299, 35208, 70001, 705201, 705202, 705203, 705204, 33945200, 110435200

*/
/*Samsung*/
/*
		$sqlBreakout = "select ProductID from vw_products where ProductType=2".$sqlStr." 
						 and ProductID IN(5200, 620000004, 620000007, 620000009, 620000010, 620000011
							, 620000012, 620000013, 620000112, 620000113, 620000307, 620000309
							, 620000310, 620000311, 620000312, 620000314, 620000315, 620000316
							, 620003122, 620004707, 620005200, 620005201, 620005204, 620005208
							, 620005209, 620013133, 620001213, 620003227, 620013476, 620013477
							, 620042906, 620042907, 620042908, 620042909, 620620818
							, 620005208) 
					 group by ProductID                     
                ORDER BY vw_products.ProductID";
/*

						and ProductID 
						IN(
							select DerivedProductID as ProductID from us_meta.vw_product_hierarchy_using_singles 
							where SingleProductID IN(1,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) group by DerivedProductID


$sqlStr = " and ProductID IN(select DerivedProductID as ProductID from us_meta.vw_product_hierarchy_using_singles 
				where SingleProductID IN(1,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) 
				group by DerivedProductID) ";
*/
//1,2,4,7,9,10,11,12,13
/*
$sqlStr = " and ProductID IN(
							select DerivedProductID as ProductID from us_meta.vw_product_hierarchy_using_singles 
							where SingleProductID  IN(850,852,853,854,950,42,437,621,622,623,624,625,626,627,629,630,21,22,23,27,29,138) group by DerivedProductID
						) ";

*/
/*GE for release*/
	//$sqlStr = " and vw_products.ProductID IN(784)";

//$sqlStr = " and vw_products.ProductID IN(1140,1141,112) ";
/*
and ProductID in (448271,
448272,
448273,
448274,
448275,
448276,
448277,
448278,
448279,
448280,
448281,
448282,
1271271)
*/
//$sqlStr = " and ProductID IN(select ProductID from tq_admin.vw_companies_products where CompanyID  in (180)) ";
/*
$sqlStr = "		and (ProductID IN(select ProductID from tq_admin.vw_companies_products where CompanyID IN(180)) 
								OR ProductID IN(5204,5200,311,316,3072,3074,3123,3124)) ";
*/
//$sqlStr = " and ProductID IN(21462a) ";
/*
$sqlStr = " and ProductID IN(
							select DerivedProductID as ProductID from us_meta.vw_product_hierarchy_using_singles 
							where SingleProductID  IN(1,2,4,7,9,10,11,12,13,3) group by DerivedProductID
						) ";
*/
// and ProductID NOT IN(5200,5204)
//$sqlStr = " and ProductID IN(select DerivedProductID as ProductID from us_meta.vw_product_hierarchy_using_singles where SingleProductID=542 GROUP BY DerivedProductID) ";
/*
							and ProductID IN(
							    select DerivedProductID as ProductID from us_meta.vw_product_hierarchy_using_singles 
							    where SingleProductID  IN(1,2,4,7,9,10,11,12,13) group by DerivedProductID
							)
*/
SURVEYID == 2
/*
ProductID in (4610,4625,4646,4854,10238,14946,32631,42915,79993,326999,4420000,4420800,4421000,4421800,4429100,4429999,291)*/

   // $sqlStr = " and vw_products.ProductID IN(select DerivedProductID as ProductID from can_meta.vw_product_hierarchy_using_singles 
	//   where SingleProductID IN(21,22,138,23,27,29,850,437,852,853,854,855,947,950,861,951,857,166,960,203,621,622,623,624,625,627,628,629,630) group by DerivedProductID) ";
//$sqlStr = " and ProductID IN(1494,1495,1498,1500,1502,1496,961,962,963,42913) ";

SURVEYID == 3
	/*Propane*/
	/* 
	$sqlStr = "		and ProductID IN(select DerivedProductID as ProductID from 	
												serv_meta.vw_product_hierarchy_using_singles 
												group by DerivedProductID) ";
	/**/