| Line 299... |
Line 299... |
| 299 |
where status not in (0,1,8,11,28,29,30,47,49,53,55,69,71,73,75,78)
|
299 |
where status not in (0,1,8,11,28,29,30,47,49,53,55,69,71,73,75,78)
|
| 300 |
group by customer_id) as m
|
300 |
group by customer_id) as m
|
| 301 |
on (o.customer_id = m.customer_id and o.id > m.min_orderId and o.status not in (0,1,8,11,28,29,30,47,49,53,55,69,71,73,75,78))
|
301 |
on (o.customer_id = m.customer_id and o.id > m.min_orderId and o.status not in (0,1,8,11,28,29,30,47,49,53,55,69,71,73,75,78))
|
| 302 |
group by m.customer_id) as temp
|
302 |
group by m.customer_id) as temp
|
| 303 |
join `order` o1 on temp.min_orderId = o1.id
|
303 |
join `order` o1 on temp.min_orderId = o1.id
|
| 304 |
left join `order` o2 on o2.id = temp.second_min_orderId
|
304 |
left join `order` o2 on (o2.id = temp.second_min_orderId and o2.transaction_id != o1.transaction_id)
|
| 305 |
left join transaction t1 on o1.transaction_id = t1.id
|
305 |
left join transaction t1 on o1.transaction_id = t1.id
|
| 306 |
left join transaction t2 on o2.transaction_id = t2.id
|
306 |
left join transaction t2 on o2.transaction_id = t2.id
|
| 307 |
left join lineitem l1 on o1.id = l1.order_id
|
307 |
left join lineitem l1 on o1.id = l1.order_id
|
| 308 |
left join lineitem l2 on l2.order_id = o2.id
|
308 |
left join lineitem l2 on l2.order_id = o2.id
|
| 309 |
left join user.user u on o1.customer_id = u.id</sql>
|
309 |
left join user.user u on o1.customer_id = u.id</sql>
|