I am creating a module that allows the customer to select their country / zone which auto-populates the total of Shipping + Tax to give an estimated total on the product_info_display.php page.

I was able to successfully create this information through basic database queries but have gotten stuck on countries with NULL zones.

How is the shipping calculated in a zone with NO geo_zone_id?

Currently I am going through step by step:
zen_countries -> zen_zones -> shipping:
SELECT
c.configuration_value
FROM zen_zones_to_geo_zones z
LEFT JOIN
zen_configuration c ON configuration_key=CONCAT("MODULE_SHIPPING_ZONETABLE_COST_",z.geo_zone_id)
WHERE
z.zone_id="'.$zoneid.'"