SELECT 
cuy_wc_orders.`date_updated_gmt`,
cuy_wc_orders.`id`,
GROUP_CONCAT(DISTINCT cuy_raffleplaywoo_main.`ticket`) AS tickets,
cuy_wc_order_addresses.`first_name`,
cuy_wc_order_addresses.last_name,
cuy_wc_order_addresses.`phone`,
cuy_wc_order_addresses.`email`,
GROUP_CONCAT(DISTINCT cuy_woocommerce_order_items.`order_item_name`) AS items,
cuy_wc_orders.`total_amount`,
cuy_wc_orders.`transaction_id`
FROM `cuy_wc_orders` 
JOIN `cuy_woocommerce_order_items` ON cuy_woocommerce_order_items.`order_id` = cuy_wc_orders.`id` 
JOIN `cuy_raffleplaywoo_main` ON cuy_raffleplaywoo_main.`order_id` = cuy_wc_orders.`id` 
JOIN `cuy_wc_order_addresses` ON cuy_wc_order_addresses.`order_id` = cuy_wc_orders.`id` 
WHERE cuy_wc_order_addresses.`address_type` = "billing"
GROUP BY cuy_wc_orders.`id`;