Title: Orphan Events SQL statement
Last modified: February 27, 2018

---

# Orphan Events SQL statement

 *  Resolved [7strel](https://wordpress.org/support/users/7strel/)
 * (@7strel)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/orphan-events-sql-statement/)
 * Hi,
    How to query the Database to get a list of orphan events?

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [caimin_nwl](https://wordpress.org/support/users/caimin_nwl/)
 * (@caimin_nwl)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/orphan-events-sql-statement/#post-10021025)
 * Hi,
 * In the latest version of Events Manager there’s now a tool for removing orphaned
   events under Events > Settings > General > Admin Tools.
 *  Thread Starter [7strel](https://wordpress.org/support/users/7strel/)
 * (@7strel)
 * [8 years, 3 months ago](https://wordpress.org/support/topic/orphan-events-sql-statement/#post-10022835)
 * Hi Caimin_nwl,
 * Thanks for the answer. I know the tool, but I do not want to delete the orphaned
   events. What I want is to get a list of orphaned events through the database/
   SQL statement. How can I do that?
 *  [caimin_nwl](https://wordpress.org/support/users/caimin_nwl/)
 * (@caimin_nwl)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/orphan-events-sql-statement/#post-10041622)
 * You can find the MySQL statement on line 151 of this file:
 * /events-manager/admin/em-options.php
 *  Thread Starter [7strel](https://wordpress.org/support/users/7strel/)
 * (@7strel)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/orphan-events-sql-statement/#post-10043992)
 * Hi Caimin_nwl,
 * Thanks.
 *  Thread Starter [7strel](https://wordpress.org/support/users/7strel/)
 * (@7strel)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/orphan-events-sql-statement/#post-10048597)
 * Hi caimin_nwl,
 * Thank you for your help!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Orphan Events SQL statement’ is closed to new replies.

 * ![](https://ps.w.org/events-manager/assets/icon-256x256.png?rev=3550347)
 * [Events Manager - Calendar, Bookings, Tickets, and more!](https://wordpress.org/plugins/events-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/events-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/events-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/events-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/events-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/events-manager/reviews/)

## Tags

 * [events](https://wordpress.org/support/topic-tag/events/)
 * [orphan](https://wordpress.org/support/topic-tag/orphan/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 5 replies
 * 2 participants
 * Last reply from: [7strel](https://wordpress.org/support/users/7strel/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/orphan-events-sql-statement/#post-10048597)
 * Status: resolved