Skip to content

Instantly share code, notes, and snippets.

@maxout

maxout/seo_urls_sw5.sql

Created June 29, 2023 06:37
Show Gist options
  • Save maxout/960eabf3d1712362ab23e12324b60071 to your computer and use it in GitHub Desktop.
Save maxout/960eabf3d1712362ab23e12324b60071 to your computer and use it in GitHub Desktop.
Download ZIP
selects rewrite urls from SW5 Database
Raw
seo_urls_sw5.sql
SELECT DISTINCT scru.org_path,scru.path, sad.ordernumber, SUBSTRING_INDEX(scru.org_path,'=',-1) AS aid from s_core_rewrite_urls scru
LEFT JOIN s_articles_details sad ON sad.articleID = SUBSTRING_INDEX(scru.org_path,'=',-1)
WHERE scru.org_path LIKE "sViewport=detail&sArticle=%"
GROUP BY scru.org_path
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment