| Line 162... |
Line 162... |
| 162 |
pa.value 'payment_method', t.coupon_code, t.session_source,
|
162 |
pa.value 'payment_method', t.coupon_code, t.session_source,
|
| 163 |
case when datediff(t.session_start_time, '20101231') > 0 then datediff(t.session_start_time, '20101231') else 1 end as session_start_date_id,
|
163 |
case when datediff(t.session_start_time, '20101231') > 0 then datediff(t.session_start_time, '20101231') else 1 end as session_start_date_id,
|
| 164 |
hour(t.session_start_time) as session_start_hour, aff.name aff_name
|
164 |
hour(t.session_start_time) as session_start_hour, aff.name aff_name
|
| 165 |
FROM `order` o
|
165 |
FROM `order` o
|
| 166 |
left join lineitem l on(o.id = l.order_id )
|
166 |
left join lineitem l on(o.id = l.order_id )
|
| 167 |
left join payment.payment p on (o.transaction_id = p.merchantTxnId)
|
167 |
left join (select * from payment.payment order by id desc) p on (o.transaction_id = p.merchantTxnId)
|
| 168 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
168 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
| 169 |
left join transaction t on (o.transaction_id = t.id)
|
169 |
left join transaction t on (o.transaction_id = t.id)
|
| 170 |
left join user.tracklog tl on (tl.data like concat(convert(p.id, char), '%'))
|
170 |
left join user.tracklog tl on (tl.data like concat(convert(p.id, char), '%'))
|
| 171 |
left join user.affiliate aff on (tl.affiliate_id = aff.id)
|
171 |
left join user.affiliate aff on (tl.affiliate_id = aff.id)
|
| 172 |
group by order_id</sql>
|
172 |
group by order_id</sql>
|