SELECT sql_cache da.app_guid,
       master.dynamic_app_collection.did,
       master.dynamic_app_collection.app_id,
       master.dynamic_app_freq_overrides.freq
FROM   master.dynamic_app_collection
       left join master.dynamic_app da
              ON master.dynamic_app_collection.app_id = da.aid
       inner join master.definitions_dynamic_application_types app
               ON da.app_type = app.app_type
       left join master.dynamic_app_freq_overrides
              ON master.dynamic_app_collection.app_id =
                 master.dynamic_app_freq_overrides.app_id
                 AND
       master.dynamic_app_collection.did = master.dynamic_app_freq_overrides.did
       left join master.map_dynamic_app_device_cred
              ON master.dynamic_app_collection.app_id =
                 master.map_dynamic_app_device_cred.app_id
                 AND
       master.dynamic_app_collection.did =
       master.map_dynamic_app_device_cred.did
       left join master.system_credentials syscred
              ON syscred.cred_id = master.map_dynamic_app_device_cred.cred_id
WHERE  master.dynamic_app_collection.did = '1'
       AND ( EXISTS (SELECT 1
                     FROM   master.dynamic_app dapp
                     WHERE  da.name LIKE '%name%'
                            AND master.dynamic_app_collection.app_id = da.aid)
              OR EXISTS (SELECT 1
                         FROM   master.dynamic_app dapp
                         WHERE  app.name LIKE '%S%'
                                AND master.dynamic_app_collection.app_id =
                                    da.aid)
              OR EXISTS (SELECT 1
                         FROM   master.system_credentials syscred
                         WHERE  syscred.cred_name LIKE '%a%'
                                AND syscred.cred_id =
                                    master.map_dynamic_app_device_cred.cred_id)
              OR master.dynamic_app_freq_overrides.freq = -1 )
       AND app.app_super_type IN ( 0, 1, 2, 3 )
GROUP  BY app_guid,
          did
ORDER  BY ` da `.` app_guid ` ASC