SELECT a.Persistence_Object_Identifier, 'Storing' AS type, z.street, z.city, a.maintenanceCompany, a.realisedDate, a.approved as approved FROM `mcb_app_domain_model_failure_failure` a
LEFT JOIN `mcb_app_domain_model_container_container` z
ON z.Persistence_Object_Identifier = a.container AND a.deleted = 0 AND a.approved = 0 AND a.realisedDate > '0000-00-00 00:00:00'
WHERE z.company = 'cc7ef0f7-4034-37e6-154f-eaaecfc18648'

UNION

SELECT b.Persistence_Object_Identifier, 'Correctief onderhoud' AS type, z.street, z.city, b.maintenanceCompany, b.realisedDate, b.approved as approved FROM `mcb_app_domain_model_correction_correction` b
LEFT JOIN `mcb_app_domain_model_container_container` z
ON  z.Persistence_Object_Identifier = b.container AND b.deleted = 0 AND b.approved = 0 AND b.realisedDate > '0000-00-00 00:00:00'
WHERE z.company = 'cc7ef0f7-4034-37e6-154f-eaaecfc18648'

UNION

SELECT c.Persistence_Object_Identifier, 'Onderhoud' AS type, z.street, z.city, c.maintenanceCompany, c.realisedDate, '' as approved FROM `mcb_app_domain_model_maintenancelist_maintenancelist` c
LEFT JOIN `mcb_app_domain_model_container_container` z
ON z.Persistence_Object_Identifier = c.container AND c.deleted = 0 AND c.realisedDate > '0000-00-00 00:00:00' AND c.acceptCorrection < 2
WHERE z.company = 'cc7ef0f7-4034-37e6-154f-eaaecfc18648'