ku# %') OR UPPER(SKU) LIKE UPPER('%sku#%') OR UPPER(' ' + KEYWORDS + ' ') LIKE UPPER('% sku# %') OR UPPER(' ' + SEARCH_KEYWORDS + ' ') LIKE UPPER('% sku# %') OR UPPER(' ' + MANUFACTURER_NAME + ' ') LIKE UPPER('% sku# %')) ) GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Max(B.Product_Score) Desc, SKU0ўпї 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, MAX(B.Product_Order) As Product_Order FROM ii_products A, ii_productcategories B, ii_categoryclasses C, ii_manufacturers D WHERE A.id = B.product_id AND B.categoryclass_id = C.category_class_id AND A.manufacturer_id = D.id AND A.Active_YN = 1 AND ( (UPPER(Product_Name) LIKE UPPER('%%') OR UPPER(SKU) LIKE UPPER('%%') OR UPPER(Description) LIKE UPPER('%%')) AND B.CategoryClass_Id = 66 ) GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Max(B-Product_Score) Desc, SKU0¤пї 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, MAX(B.Product_Order) As Product_Order FROM ii_products A, ii_productcategories B, ii_categoryclasses C, ii_manufacturers D WHERE A.id = B.product_id AND B.categoryclass_id = C.category_class_id AND A.manufacturer_id = D.id AND A.Active_YN = 1 AND ( (UPPER(Product_Name) LIKE UPPER('%%') MR UPPER(SKU) LIKE UPPER('%%') OR UPPER(Description) LIKE UPPER('%%')) AND B.CategoryClass_Id = 66 ) GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Max(B.Product_Score) Desc, SKU0Ґпї 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, MAX(B.Product_Order) As Product_Order FROM ii_products A, ii_productcategories B, ii_categoryclasses C- ii_manufacturers D WHERE A.id = B.product_id AND B.categoryclass_id = C.category_class_id AND A.manufacturer_id = D.id AND A.Active_YN = 1 AND ( (UPPER(Product_Name) LIKE UPPER('%%') OR UPPER(SKU) LIKE UPPER('%%') OR UPPER(Description) LIKE UPPER('%%')) AND B.CategoryClass_Id = 68 ) GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Max(B.Product_Score) Desc, SKU0¦пА 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, MAX(B.Product_Order) As Product_Order FROM ii_products A, ii_productcategories B, ii_categoryclasses C, ii_manufacturers D WHERE A.id = B.product_id AND B.categoryclass_id = C.category_class_id AND A.manufacturer_id = D.id AND A.Active_YN = 1 AND ( (UPPER(Product_Name) LIKE UPPER('%%') OR UPPER(SKU) LIKE UPPER('%%') OR UPPER(Description) LIKE UPPER('%%')) AND B.CategoryClass_Id = 405 ) GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Max(B.Product_Score) Desc, SKU0§пї 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, MAX(B.Product_Order) As Product_Order FROM ii_products A, ii_productcategories B, ii_categoryclasses C, ii_manufacturers D WHERE A.id = B.product_id AND B.categoryclass_id = C.category_class_id AND A.manufacturer_id = D.id AND!A.Active_YN = 1 AND ( (UPPER(Product_Name) LIKE UPPER('%%') OR UPPER(SKU) LIKE UPPER('%%') OR UPPER(Description) LIKE UPPER('%%')) AND B.CategoryClass_Id = 66 ) GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Max(B.Product_Score) Desc, SKU0©пї 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, MAX(B.Product_Order) As Product_Order FRMM ii_products A, ii_productcategories B, ii_categoryclasses C, ii_manufacturers D WHERE A.id = B.product_id AND B.categoryclass_id = C.category_class_id AND A.manufacturer_id = D.id AND A.Active_YN = 1 AND ( (UPPER(Product_Name) LIKE UPPER('%%') OR UPPER(SKU) LIKE UPPER('%%') OR UPPER(Description) LIKE UPPER('%%')) AND B.CategoryClass_Id = 66 ) GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Max(B.Product_Score) Desc, SKUFILE_ID:FILENAME||5818:F236-X.gifGF2366" x 8"WhiteFlat65# CoverManufacturer Card0"›яяA Qжф0QVglpyyyЉSnowman ArgyleThis uniquely colorful card is premium quality cardstock and includes a white envelope. Inkjet/laser compatible and available blank or personalized.snowman argylehttp://www.impressinprint.com/FILE-itemDetails_PID-4507.aspxFILE_ID:FILENAME||5817:F239-X.gifGF2396" x 8"WhiteFlat65# CoverManufacturer Card0"ќяяA Oдъ6W\mrvђRee OrnamentThis uniquely colorful card is premium quality cardstock and includes a white envelope. Inkjet/laser compatible and available blank or personalized.ornament ornaments redhttp://www.impressinprint.com/FILE-itemDetails_PID-4509.aspxFILE_ID:FILENAME||5819:F240-X.gifGF2406" x 8"WhiteFlat80# CoverManufacturer Cardlank, Personalized & Greeted8.75"WhiteFlat80# CoverManufacturer Card8.5" x 11"IvoryFlat60# BookFill In Dynamic 8.5"WhiteFlat80# CoV–ЧYГ `ЃБМл!|*6ьАз«ё†i0МйЪ€яяяяяяяяИяяяяяяяяяяяя›WD, яяяяяяяяяяяяяяяяr—^зO—^зO—:юЁЇµµГГдфІЖSpider Web PaperOur desktop/EZ-print papers are a cinch for you to print on your inkjet/laser printer. Don’t forget the coordinating #10 size envelope shown. (NOT AVAILABLE PERSONALIZED)M974848974848YOU PRINT ONLYspider spiders web webs halloweenSpider Web PaperSpider Web Paper -- Our desktop/EZ-print papers are a cinch for you to print on your inkjet/laser printer. Don’t forget the coordinating #10 size envelope shown. (NOT AVAILABLE PERSONALIZED)Impressions In Print0МкЪ€яяяяяяяяИяяяяяяяяяяяя›WD- яяяяяяяяяяяяяяяяr—итзO—итзO—:¬і№јККрЖЪBlooming Roses PaperOur desktop/EZ-print papers are a cinch for you to print on your inkjet/laser printer. Don’t forget the coordinating #10 size envelope shown. (NOT AVAILABLE PERSONALIZED)M974812974812553YOU PRINT ONLYrose roses bloom blooming blooms pink Blooming Roses PaperBlooming Roses Paper -- Our desktop/EZ-print papers are a cinch for you to print on your inkjet/laser printer. Don’t forget the coordinating #10 size envelope shown. (NOT AVAILABLE PERSONALIZED)Impressions In Prinuoduct_Id, Product_Name, Product_Image_Id, Product_Message, SKU, Card_Order) SELECT A.Id, A.