Too many connections SQL-> SELECT
mrt_products.LocationID,
mrt_products.Name,
mrt_products.OthersName,
mrt_locations.Name AS LocationName,
mrt_countries.CountryID,
mrt_countries.Name AS CountryName,
mrt_regions.RegionID,
mrt_regions.Name AS RegionName
FROM
mrt_products INNER JOIN mrt_suppliers ON mrt_products.SupplierID = mrt_suppliers.SupplierID
INNER JOIN mrt_locations ON mrt_products.LocationID = mrt_locations.LocationID
INNER JOIN mrt_countries ON mrt_locations.CountryID = mrt_countries.CountryID
INNER JOIN mrt_regions ON mrt_countries.RegionID = mrt_regions.RegionID
INNER JOIN mrt_activities ON mrt_products.ActivityID = mrt_activities.ActivityID
WHERE
mrt_regions.Name = 'Caribbean'
AND
mrt_products.Active = 1 GROUP BY mrt_countries.CountryID
ORDER BY
mrt_countries.Name ;
Flotilla Holidays, Yacht Charter, Sailing Holiday
