oduct_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('%%') 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 = 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.Prmduct_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(Proeuct_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_productcategmries 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 = 85 ) GROUP BY A.Id, A.Product_Name, A.Zoom_Image_Id, A.Product_Message, A.SKU ORDER BY Max(B.Product_Score) Desc, SKU d available blank or personalized.bride bridal shower bridal teahttp://www-impressinprint.com/FILE-itemDetails_PID-6731.aspxFILE_ID:FILENAME||8970:FI-534.jpgFI-5345.75" x 8.75"WhiteFlat80# CoverManufacturer Card E-itemDetails_PID-6424.aspxFILE_ID:FILENAME||8297:H109.jpgPH109LP8.5" x 11"Flat60# BookFill In Dynamic0 " A
] );DMaaFancy Snowflakes PhotocardBeautiful Foil Embossed Snowflake design. Horizontal or Vertical photo to max size 4" x 6" attaches to front of card. Available BLANK, with pre-printed greeuing HAPPY HOLIDAYS & HAPPY NEW YEAR or PERSONALIZED with your greeting.Includes white enveloped lined in silver foil.
photo card christmas silver snow snowflake snowflakeshttp://www.impressinprint.com/FILE-itemDetails_PID-5918.aspxFILE_ID:FILENAME||7642:971PC.jpg971PC6" x 8"White/silver-linedFold-over80# CoverFOIL EMBOSSED DESIGNPhoto Cards - Blank, Personalized & Greeted0 " A
\ | !%.BBmFancy Red Holly PhotocardBeautiful Foil Embossed Holly!design. Horizontal or Vertical photo to max size 4" x 6" attaches to front of card. Available BLANK, with pre-printed greeting MERRY CHRISTMAS & HAPPY NEW YEAR or PERSONALIZED with your greeting.Includes white enveloped lined in gold foil.
photo card christmas gold holly redhttp://www.impressinprint.com/FILE-itemDetails_PID-5919.aspxFILE_ID:FILENAME||8393:972pc.jpg972PC6" x 8"White/gold-linedFlat80# CoverFOIL EMBOSSED DESIGNPhoto Cards - Blank, Personali 5u 7 w ` a` 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, 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 = 123 ) 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 Producu_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('