Changes between Version 1 and Version 2 of Ticket #117


Ignore:
Timestamp:
10/18/2012 03:02:50 PM (13 years ago)
Author:
huangzhong
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #117 – Description

    v1 v2  
    33{{{ 
    44 
    5 SELECT t0.IMG1, t0.IMG2, t0.IMG3, t1.id, t1.BIG_PIC_PATH, t1.BRAND_NAME, t1.LAST_COUNT_ORDER, t1.CREATE_DATE, t1.FORUM_PATH, t1.HOT_NEW, t1.MID_PATH, t1.name, t1.ORDER_KEY, t1.price, t1.PRICE_CONFIG, t1.PUB_URL, t1.REVIEW_STATUS, t1.SHORT_NAME, t1.PIC_PATH, t1.SMALLTYPE_ID, t1.TYPE_ID, t1.VARIANCE_ID FROM ENT_PRODUCT t0 LEFT OUTER JOIN V_PDL_PRODUCT t1 ON t0.PRODUCT_ID = t1.id WHERE t0.id = $1 
     5SELECT t0.IMG1, t0.IMG2, t0.IMG3, t1.id, t1.BIG_PIC_PATH, 
     6  
     7t1.BRAND_NAME, t1.LAST_COUNT_ORDER, t1.CREATE_DATE, t1.FORUM_PATH,  
     8 
     9t1.HOT_NEW, t1.MID_PATH, t1.name, t1.ORDER_KEY, t1.price,  
     10 
     11t1.PRICE_CONFIG, t1.PUB_URL, t1.REVIEW_STATUS, t1.SHORT_NAME,  
     12 
     13t1.PIC_PATH, t1.SMALLTYPE_ID, t1.TYPE_ID, t1.VARIANCE_ID FROM  
     14 
     15ENT_PRODUCT t0 LEFT OUTER JOIN V_PDL_PRODUCT t1 ON t0.PRODUCT_ID =  
     16 
     17t1.id WHERE t0.id = $1 
    618 
    719}}}