HTTP_HOST: www.triadhosting.biz SELF: /store/details.html HTTP_REFERER : CUST SESS ACCT ID: CUST ID: CUST EMAIL: SHOP CART URL PATH: /orders LAST SHOPPING URL:
OPTIONS: 0 SELECT * FROM products where parent=0 and active=1 and for_sale=1 and parent_sku='18-856-016SC' 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
Defend Round End Taper Super Coarse Diamonds 856-016SC 10/pk