Ticketera: query para obtener código de autorización Transbank
Notas: Versión 2 (trae el mes actual y el anterior, y solo los pedidos con estado wc-completed) Código para obtener resumen de eventos y tipos de tickets SELECTCOALESCE(parent_event.post_title, ticket_variation.post_title) AS event_name,ticket_type_meta.meta_value AS ticket_type,SUM(p.product_qty) AS total_quantity,SUM(CAST(line_subtotal.meta_value AS DECIMAL(10,2))) AS total_sales FROM xxt_wc_order_product_lookup AS pJOIN xxt_wc_orders AS o ON p.order_id = o.id LEFT JOIN xxt_posts AS ticket_variation … Leer más