SELECT lpc.product_ID, lpc.classifiers_ID, pmp.hide_from_site
link_products_classifiers as lpc,
products_main as pm
WHERE pm.id = lpc.product_ID
AND lpc.default_flag = 1
AND pm.status = 1
AND pm.template != 5
AND pm.parent_id = 0Unknown column 'pmp.hide_from_site' in 'field list'2018-12-11 16:12:18
|1 - 11||12 - 23||24 - 35||36+
Generously sized this 50" X 60" Gildan stadium blanket is made of 9.3 ounce, 50/50 cotton/polyester sweatshirt fleece. It is hemmed all around is has mitered V corners. Safety Green is compliant with ANSI/ISEA 107.
This Product Is Sold By
SCCC/LCCC Sorority of Hope Sisterhood Storefront
The names and numbers you provide below will replace what's shown in your design. If you do not provide names or numbers, your product will be decorated as shown.
Please Note: "PLAYER NAME" and "00" are sample placeholders. On your actual finished product, we will center and space each player name and number from your roster above. Depending on the product, names / numbers may be screenprinted or printed heat applied transfer.