| Line 223... |
Line 223... |
| 223 |
date(o.created_timestamp) as order_date, o.transaction_id, l.item_id,
|
223 |
date(o.created_timestamp) as order_date, o.transaction_id, l.item_id,
|
| 224 |
l.quantity, l.unit_price, l.transfer_price, p.gatewayId, pa.value 'payment_method'
|
224 |
l.quantity, l.unit_price, l.transfer_price, p.gatewayId, pa.value 'payment_method'
|
| 225 |
FROM `order` o
|
225 |
FROM `order` o
|
| 226 |
left join lineitem l on(o.id = l.order_id )
|
226 |
left join lineitem l on(o.id = l.order_id )
|
| 227 |
left join payment.payment p on (o.transaction_id = p.merchantTxnId)
|
227 |
left join payment.payment p on (o.transaction_id = p.merchantTxnId)
|
| 228 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')</sql>
|
228 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
| - |
|
229 |
group by order_id</sql>
|
| 229 |
<limit>0</limit>
|
230 |
<limit>0</limit>
|
| 230 |
<lookup/>
|
231 |
<lookup/>
|
| 231 |
<execute_each_row>N</execute_each_row>
|
232 |
<execute_each_row>N</execute_each_row>
|
| 232 |
<variables_active>N</variables_active>
|
233 |
<variables_active>N</variables_active>
|
| 233 |
<lazy_conversion_active>N</lazy_conversion_active>
|
234 |
<lazy_conversion_active>N</lazy_conversion_active>
|