gistfile1.txt

SELECT tmp.* FROM (
  select _id as `certificate_id`,RegNumber, `Id` as `GUID`, ( select count(*) 
  from `certificatesupplement` cs 
  INNER JOIN `accreditedprogramm` ap on ap.certificatesupplement_id = cs._id 
  WHERE cs.certificate_id = ac._id ) as `Total` 
  from accreditationcertificate as ac) as tmp 
where tmp.`Total` = 0
ORDER BY `tmp`.`certificate_id` ASC