SELECT 
	z.id,
	z.name,
	Concat('$', Min(r.rate),' - $', Max(r.rate)) as rates,
	
	
	CASE
		WHEN Count(zip.id) > 0 THEN Concat(Count(zip.id), ' Zipcodes')
		WHEN Count(c.id) > 0 THEN Concat(Count(c.id ), ' Countries')
		ELSE 'None'
	END as cnt,
	
	CASE
		WHEN Count(zip.id) > 0 THEN Concat('/admin/shipping/zipcodes.php?zone=', z.id)
		WHEN Count(c.id) > 0 THEN Concat('/admin/shipping/countrys.php?zone=', z.id)
		ELSE ''
	END as cnt_href
	
	
FROM shipping_zones z
	INNER JOIN shipping_zonerates r ON r.id__zone = z.id
	LEFT JOIN shipping_zipcodes zip ON zip.id__zone = z.id
	LEFT JOIN shipping_countrys c ON c.id__zone = z.id
GROUP BY z.id
ORDER BY z.name ASC