<p>I already found a solution. I just created a simple query:</p>

<pre><code>SELECT content.elementId entryId, title, uri
FROM `craft_content` content
JOIN craft_elements elements ON elements.id = content.elementId
JOIN `craft_entries` entries ON entries.`id` = content.`elementId`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = 
elements.id
</code></pre>

CC BY-SA 3.0
2017-06-07T09:12:17.727Z
2017-06-07T09:12:17.727Z
Mr. Sam
<p>I want to create a Excel file with all used slugs in my Craft website.
I've searched for a plugin but without succes. I also tried to find a useful table in the Craft database, also without succes.</p>

<p>Is there a simple way to achieve this?</p>

<plugins><slug><entry-slug><plugin-sitemap>
Receive all used slugs
# Receive all used slugs

(Asked by: username_0 on 2017-06-07)

I want to create a Excel file with all used slugs in my Craft website.
I've searched for a plugin but without succes. I also tried to find a useful table in the Craft database, also without succes.

Is there a simple way to achieve this?

**Tags:** plugins, slug, entry-slug, plugin-sitemap

---

## 1 answers

### Answer by username_0 on 2017-06-07. Score: 2

I already found a solution. I just created a simple query:
SELECT content.elementId entryId, title, uri
FROM `craft_content` content
JOIN craft_elements elements ON elements.id = content.elementId
JOIN `craft_entries` entries ON entries.`id` = content.`elementId`
JOIN `craft_elements_i18n` `elements_i18n` ON elements_i18n.elementId = 
elements.id


---

