SELECT * from orders O inner join tUser U on O.user_ID=U.user_ID where order_ID=#val(url.order_ID)#

Customer Info:	Show Info:
Name: #getorder.LastName#, #getorder.FirstName# #getorder.MiddleInitial# Address 1: #getorder.Address1# Address 2: #getorder.Address2# City: #getorder.City# Zip: #getorder.Zip# Phone Home: #getorder.PhoneHome# Phone Office: #getorder.PhoneOffice# Phone Cell: #getorder.PhoneCell# Email Address: #getorder.email# Card Number: #getorder.card_number# Exp Date: #getorder.expdate# Name On Card: #getorder.name# Billing Address: #getorder.billing_address# Billing City: #getorder.billing_city# Billing State: #getorder.billing_state# Billing Zip: #getorder.billing_zip#	SELECT s.title, p.performancedate, t.seat, t.price from tix t, tshow s, tperformance p where order_ID=#val(url.order_ID)# and t.performance_ID=p.performance_ID and s.show_ID=p.showID order by t.seat SHOW: #title# DATE: #dateFormat(gettix.performancedate,'short')# #timeFormat(gettix.performancedate,'medium')# SEATS: #REALSEAT# Front Left Left Center Right Front Center Front Right Balcony Left Balcony Center Balcony Right : #lscurrencyformat(price)# BACKOUT THIS TICKET Shipping: HOLD AT DOORMAILED: #lscurrencyformat(getorder.shipping)# Donation Amount: #lscurrencyformat(getorder.amt_donation)# Order Total: $#numberformat(getorder.GRANDTOTAL,'99999.99')# ORDER STATUS: PENDINGSOLDPRINTEDMAILED Authorize.Net Code: Not Available#getorder.authnetcode# PRINT THIS PAGE
Backing out this order will make these seats available again, but refund must be done through the merchant account control panel.