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?
Craft CMS Stack Exchange is a question and answer site for administrators, end users, developers and designers for Craft CMS. It only takes a minute to sign up.Sign up to join this community
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