stephen

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.idGROUP BY z.idORDER BY z.name ASC