me, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 AND B.SaleCat_Id = 959 AND B.SaleSubCat_Id = 965 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id- Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 AND B.SaleCat_Id = 947 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Ie, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Proeuct_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproductq B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 AND B.SaleCat_Id = 947 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN =!1 AND A.Discount_Id > 0 AND B.SaleCat_Id = 1045 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 AND B.SaleCat_Id = 1045 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 AND B.SaleCat_Id = 789 GROUP BY A.Id, A.Product_Name, A.Zoom_Imaee_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 AND B.SaleCat_Id = 789 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Produat_Name 0$ INSERT INTO #TempTable ( Product_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU, 1 As Product_Order FROM ii_Products A LEFT OUTER JOIN ii_salecategoryproducts B ON A.Id = B.product_id WHERE A.Active_YN = 1 AND A.Discount_Id > 0 AND B.SaleCat_Id = 789 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0$ INSERT INTO #TempTable !( Pro