query
RESULTSET
query
  CATCODE CATEGORYTYPEID CONFSTARTDATE EARLY EARLYBIRDENDDATE EARLYBIRDSTARTDATE FIRSTPRICE GLACCT HASVTASSRECORD PRODUCTCODE PRODUCTID PROMO QUANTITY REG REGULARENDDATE REGULARSTARTDATE RESPONSE SUBS TAXAMOUNT TAXOPT TITLE VTASSMODULE
1 [empty string] 4 1/4/2005 100.00 1/2/2005 1/1/2005 100.00 000 no SYDMAR18D2 6883 100.00 1 100.00 1/4/2005 1/3/2005 0 100.00 [empty string] [empty string] Fourth Annual Sydney 10 CPD Point Conference - Day 2 only (CPD Compulsories) MEETINGS
CACHED false
EXECUTIONTIME 0
SQL SELECT TENSHOPproducts.productID, TENSHOPproducts.productCode, TENSHOPproducts.firstprice, TENSHOPproducts.title, TENSHOPcategorytype.vTASSmodule, TENSHOPcategorytype.categorytypeID, '' as taxopt, '' as taxamount, 'no' as hasVtassRecord, TENSHOPproducts.firstprice as EARLY, TENSHOPproducts.firstprice as REG, TENSHOPproducts.firstprice as SUBS, '1/1/2005' as earlybirdStartDate, '1/2/2005' as earlybirdEndDate, '1/3/2005' as regularStartDate, '1/4/2005' as regularEndDate, '1/4/2005' as confstartDate, '0' as response, '' as catcode, '000' as glacct, '1' as quantity, TENSHOPproducts.firstprice as PROMO FROM TENSHOPproducts, TENSHOPcategorytype WHERE productID = '6883' AND TENSHOPproducts.categoryFK = TENSHOPcategorytype.categorytypeID

  Order Progress:
1. Basket
2. Checkout
3. Review
4. Completion

Title
Unit Price Quantity Subtotal Remove
Fourth Annual Sydney 10 CPD Point Conference - Day 2 only (CPD Compulsories)
REMOVE
Total (Inc. GST)   
All transactions are processed in AUD. All prices include delivery costs.