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 AND B.SaleSubCat_Id = 992 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.Zmom_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 Product_Order FROM ii_Pqoducts 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 Ðº&)¥W$øÈº&&ð¹&,™½É©t0 & »&0™ð¹&,™0 &D»&0™ð¹&,™ó»J0 &h»&0™ð¹&,™xÓ0 &Œ»&0™ð¹&,™>0 &°»&0™ð¹&,™/¾m?0 &Ô»&0™ð¹&,™0 &ø»&0™ð¹%,™¼&0 &¼&0™ð¹&,™0 &@¼&0™ð¹&,™0 &d¼&0™ð¹&,™ëè©0 &ˆ¼&0™ð¹&,™0 &¬¼&0™ð¹&,™HZ™0 &Ð¼&0™ð¹&,™„Z?0 &ô¼&0™ð¹&,™r§@0 &½&0™ð¹&,™T6ô?0 &<½&0™ð¹&,™éFÓÚ0 &`½&0™ð¹&,™0 &„½&0™ð¹&,™0 &¨½&0™ð¹&,™xÓ0 &Ì½&0™ð¹&,™>0 &ð½&0™ð¹&,™êi(=0 &¾&0™ð¹&,™ øgÅ$¸fÅ$0 &8¾&0™ð¹&,™0 &\¾&0™ð¹&,™tA0 &€¾&0™ð¹&,™0 &¤¾&0™ð¹&,™HZ™0 &È¾&0™ð¹&,™Ö÷i?0 &ì¾&0™ð¹&,™6©@0 &¿&0™ð¹&,™â&ø?0 &4¿&0™ð¹&,™=m–´0 &X¿&0™ð¹&,™0 &|¿&0™ð¹&,™>ê–0 & ¿&0™ð¹&,™xÓ 8 &ð¿&`fÅ$jÅ$°kÅ$PmÅ$ðnÅ$pÅ$0rÅ$ÐsÅ$ f{ÁM“Ù3 HŽÔ`‘¯PHœF@™5D,yW0³'º 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 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 GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Product_Name 0µ'º INSERT INTO #TempTable ( Pqoduct_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 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_Mrder) 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 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 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 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 ANE 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_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_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¾'º INSERU 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 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, Produat_Message, SKU, Card_Order) SELECT A.Id, A.Product_Name, A.Zoom_Image_Id, A.Produ