SELECT uco.order_id, u.uid, u.name, u.mail, uco.delivery_first_name, uco.delivery_last_name, uco.delivery_phone, uco.delivery_street1, uco.delivery_street2, uco.delivery_city, ucz.zone_code, uco.delivery_postal_code, ucc.country_name,  FROM_UNIXTIME(uco.created, '%m %d %Y') as order_date,  ucop.title, SUBSTRING(ucop.data, 90, 14)  as shirtsize
FROM uc_orders uco
LEFT JOIN users u ON u.uid =  uco.uid
LEFT JOIN uc_order_products ucop ON ucop.order_id =  uco.order_id
LEFT JOIN uc_order_line_items ucoli ON ucoli.order_id =  uco.order_id
LEFT JOIN uc_zones ucz ON uco.delivery_zone  = ucz.zone_id
LEFT JOIN uc_countries ucc ON uco.delivery_country  = ucc.country_id
WHERE uco.uid IN (SELECT uid FROM uc_orders WHERE order_status = "completed"  GROUP BY uid HAVING COUNT(order_id) > 1  )
AND  ucoli.type !=  'coupon'
ORDER BY uco.uid, uco.created ASC