SELECT
     CONCAT(order_addresses.`street`, order_addresses.`city`, order_addresses.`country_id`) AS address,
     COUNT(*) AS 'order_count'
     FROM `sales_order_address` AS `order_addresses`
         LEFT JOIN `sales_order` AS `sales` ON sales.`entity_id` = order_addresses.`parent_id`
             WHERE order_addresses.`address_type` = "shipping"
                 AND sales.`base_total_refunded` IS NULL
                 AND sales.`status` = "complete"
                 AND sales.`state` = "complete"
                 AND DATE(sales.`created_at`) >= DATE(NOW() - INTERVAL [THIS_IS_A_SYSTEM_VALUE] MONTH)
     GROUP BY address
     HAVING order_count > [THIS_IS_A_SYSTEM_VALUE]