# Delete companies that have no related contacts

**URL:** <https://forum.mautic.org/t/delete-companies-that-have-no-related-contacts/23827>\
**Category:** Ideas and Feature Requests\
**Created:** [April 21, 2022, 4:18pm UTC](https://forum.mautic.org/t/delete-companies-that-have-no-related-contacts/23827 "2022-04-21T16:18:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pierre\_a](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/pierre_a/32/7031_2.png) [@pierre\_a](https://forum.mautic.org/u/pierre_a)\
**Post date:** [April 21, 2022, 4:18pm UTC](https://forum.mautic.org/t/delete-companies-that-have-no-related-contacts/23827/1 "2022-04-21T16:18:41Z")

</div>

Hello,

I wanted to clean up my Mautic contact database.  
To do this, I want to delete the companies that have no related contacts.  
In Mautic it is possible to do this manually company by company.

This is a bit time consuming. So I wrote an SQL query.  
The results are : 15139 rows affected. (Query took 0.5347 seconds.)

```auto
DELETE FROM companies
WHERE id IN (
SELECT companies.id
FROM companies
EXCEPT 
SELECT companies_leads.company_id FROM companies_leads
)

```

If that helps.

If a developer goes through this and wants to make it a feature (e.g. via a CRON) that would be great. 🙂

Pierre

---

<div class="post-metadata">

**Author:** ![eruizmillan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/eruizmillan/32/284_2.png) [@eruizmillan](https://forum.mautic.org/u/eruizmillan)\
**Post date:** [February 23, 2023, 10:17am UTC](https://forum.mautic.org/t/delete-companies-that-have-no-related-contacts/23827/2 "2023-02-23T10:17:33Z")

</div>

@pierre_a It has worked perfectly. Thank you so much .

---

<div class="post-metadata">

**Author:** ![eruizmillan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/eruizmillan/32/284_2.png) [@eruizmillan](https://forum.mautic.org/u/eruizmillan)\
**Post date:** [February 23, 2023, 10:18am UTC](https://forum.mautic.org/t/delete-companies-that-have-no-related-contacts/23827/3 "2023-02-23T10:18:50Z")

</div>

One question @pierre_a : Would you know how to eliminate duplicate companies? Thank you

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [February 23, 2023, 2:33pm UTC](https://forum.mautic.org/t/delete-companies-that-have-no-related-contacts/23827/4 "2023-02-23T14:33:38Z")

</div>

@ekke Maybe you want to add this to your cleanup script?

---

<div class="post-metadata">

**Author:** ![ekke](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ekke/32/296_2.png) [@ekke](https://forum.mautic.org/u/ekke)\
**Post date:** [February 23, 2023, 6:58pm UTC](https://forum.mautic.org/t/delete-companies-that-have-no-related-contacts/23827/5 "2023-02-23T18:58:17Z")

</div>

Thx, noted!