| Line 155... |
Line 155... |
| 155 |
<method>none</method>
|
155 |
<method>none</method>
|
| 156 |
<schema_name/>
|
156 |
<schema_name/>
|
| 157 |
</partitioning>
|
157 |
</partitioning>
|
| 158 |
<connection>userDC_Prod</connection>
|
158 |
<connection>userDC_Prod</connection>
|
| 159 |
<sql>select cart_id, cart.user_id, item_id, quantity, address.pin,
|
159 |
<sql>select cart_id, cart.user_id, item_id, quantity, address.pin,
|
| 160 |
datediff(checked_out_on, '20110101') as checked_out_date_id,
|
160 |
datediff(checked_out_on, '20110101') as checked_out_date_id,
|
| 161 |
datediff(cart.created_on, '20110101') as created_date_id,
|
161 |
datediff(cart.created_on, '20110101') as created_date_id,
|
| 162 |
datediff(cart.updated_on, '20110101') as updated_date_id,
|
162 |
datediff(cart.updated_on, '20110101') as updated_date_id, actual_price, line.discounted_price,
|
| 163 |
actual_price, line.discounted_price, coupon_code,
|
- |
|
| 164 |
hour(checked_out_on) as checked_out_hour, hour(cart.created_on) as created_hour,
|
163 |
coupon_code, hour(checked_out_on) as checked_out_hour, hour(cart.created_on) as created_hour,
|
| 165 |
hour(cart.updated_on) as updated_hour
|
164 |
hour(cart.updated_on) as updated_hour
|
| 166 |
from line, cart, address, user
|
165 |
from line
|
| 167 |
where cart.id = line.cart_id
|
166 |
join cart on cart.id = line.cart_id
|
| 168 |
and (address_id = address.id or address_id is null)
|
167 |
left join address on address_id = address.id
|
| 169 |
and user.active_cart_id = cart.id
|
168 |
join user on user.active_cart_id = cart.id
|
| 170 |
and user.id = cart.user_id
|
- |
|
| 171 |
and user.is_anonymous = 0;</sql>
|
169 |
where user.is_anonymous = 0;</sql>
|
| 172 |
<limit>0</limit>
|
170 |
<limit>0</limit>
|
| 173 |
<lookup/>
|
171 |
<lookup/>
|
| 174 |
<execute_each_row>N</execute_each_row>
|
172 |
<execute_each_row>N</execute_each_row>
|
| 175 |
<variables_active>N</variables_active>
|
173 |
<variables_active>N</variables_active>
|
| 176 |
<lazy_conversion_active>N</lazy_conversion_active>
|
174 |
<lazy_conversion_active>N</lazy_conversion_active>
|