SELECT
        o.*,GROUP_CONCAT(DISTINCT mt.mobilityTypeName) as mobility,GROUP_CONCAT(DISTINCT st.serviceTypeName) as service,GROUP_CONCAT(DISTINCT  tt.steamTypeName) as stream,GROUP_CONCAT(DISTINCT pt.providerTypeName) as provider
FROM
        Organizations o
# mobilty
INNER JOIN
        Organizations_has_mobilityType oht on oht.Organizations_organizationID = o.organizationID
INNER JOIN
        mobilityType mt on mt.mobilityTypeID = oht.mobilityType_mobilityTypeID

# service
INNER JOIN
        Organizations_has_serviceType sht on sht.Organizations_organizationID = o.organizationID
INNER JOIN
        serviceType st on st.serviceTypeID = sht.serviceType_serviceTypeID

# steam
INNER JOIN
        Organizations_has_steamType tht on tht.Organizations_organizationID = o.organizationID
INNER JOIN
        steamType tt on tt.streamTypeID = tht.steamType_streamTypeID


# providers
INNER JOIN
        providerType_has_Organizations pht on pht.Organizations_organizationID = o.organizationID
INNER JOIN
        providerType pt on pt.providerTypeID = pht.providerType_providerTypeID


WHERE o.`wheelChairAccessible` = 1 AND
st.serviceTypeID in (1,2,3) AND
mt.mobilityTypeID in (2,4) AND
tt.streamTypeID in (2,3,4,5) AND
pt.providerTypeID in (1,2,3,4,6,7)

GROUP BY o.organizationID;