OPTIONS: 0 SELECT * FROM products where parent=0 and active=1 and for_sale=1 and parent_sku='96-TTP5B' and curdate() between ifnull(if(char_length(start_date)=0,'0000-00-00',start_date),'0000-00-00') and ifnull(if(char_length(end_date)=0,'9999-12-31',end_date),'9999-12-31') order by display_order,name Tuff-Temp Plus Provisional Veneer Crown & Bridge Resin, 5mL Automix Syringe, 8 Automix Tips, 3mL Glaze, Shade Bleach

Tuff-Temp Plus Provisional Veneer Crown & Bridge Resin, 5mL Automix Syringe, 8 Automix Tips, 3mL Glaze, Shade Bleach

SKU#: 96-TTP5B
Tuff-Temp Plus Provisional Veneer Crown & Bridge Resin, 5mL Automix Syringe, 8 Automix Tips, 3mL Glaze, Shade Bleach
$0.00Each
  

AID:
PID:
ORDER ID:
ORDER ACCT ID:
SESS: cart_id|202601210426248317497