SELECT od.discount_amount as descuento_cupon, wco.ID as id_cupon, wco.post_title as cupon, wo.post_date as fecha, (SELECT meta_value from wp_postmeta where meta_key = 'rut' and post_id=wco.ID ) as rut, (SELECT meta_value from wp_postmeta where meta_key = '_billing_first_name' and post_id=wo.ID ) as nombre, (SELECT meta_value from wp_postmeta where meta_key = '_billing_last_name' and post_id=wo.ID ) as apellido, (SELECT meta_value from wp_postmeta where meta_key = '_order_total' and post_id=wo.ID ) as total_orden, (SELECT meta_value from wp_postmeta where meta_key = '_order_shipping' and post_id=wo.ID ) as precio_envio, ( select group_concat( order_item_name separator '
' ) from wp_woocommerce_order_items where order_id = wo.ID and order_item_type='line_item' ) as productos FROM wp_wc_order_coupon_lookup od INNER JOIN wp_posts wo ON od.order_id = wo.ID INNER JOIN wp_posts wco ON od.coupon_id = wco.ID WHERE wo.post_status IN ('wc-completed', 'wc-processing', 'wc-on-hold') AND wo.post_date >= '2019-05-05 10:00:00' AND wo.post_date <= '2021-02-27 21:00:00' ORDER BY wo.post_date ASC
FECHA_USO_BENEFICIO NOMBRE_PRESTADOR_COMERCIO SUCURSAL_USO_DESCUENTO COMUNA_SUCURSAL REGION_SUCURSAL PRESENCIAL_ONLINE RUT_SOCIO PRODUCTO_SERVICIO_UTILIZADO P_DESCUENTO_APLICADO PRECIO_LISTA_COMERCIO PRECIO_FINAL_SOCIO_CRUZ_VERDE M_DESCUENTO_APLICADO
16-02-2021 ThePowerfoods - - - ONLINE 15454224 Semilla de zapallo granel - 1kg
Almendra natural granel - 1kg
Sésamo tostado - 500g
Perfect snack - 500g
30% 41.700 29.190 12.510
18-02-2021 ThePowerfoods - - - ONLINE 14672115 Castaña cajú con sal granel - 1kg
Carne de soya granel - 1kg
Damasco turco granel - 1kg
Mani salado con miel granel - 1kg
30% 38.750 27.125 11.625
21-02-2021 ThePowerfoods - - - ONLINE 18848492 Maní tostado natural granel - 1kg
Harina de avena granel - 1kg
Harina de trigo integral granel - 1kg
30% 25.975 18.183 7.792
23-02-2021 ThePowerfoods - - - ONLINE 17601727 Mani salado con miel granel - 1kg
Mix nuts granel - 1kg
Semilla de chia granel - 1kg
Almendra natural granel - 1kg
Harina de fuerza - 1kg
30% 45.284 31.699 13.585
24-02-2021 ThePowerfoods - - - ONLINE 6626654 Maní japones - 1kg
Avena instantánea granel - 1kg
Damasco turco granel - 1kg
Castaña cajú sin sal granel - 1kg
Maní tostado natural granel - 1kg
Nuez mariposa clara granel - 1kg
Dátil con carozo granel - 1kg
30% 76.120 53.284 22.836