Skip to content

Instantly share code, notes, and snippets.

@kdwolski

kdwolski/queries.sql

Last active September 20, 2016 21:36
Show Gist options
  • Save kdwolski/5f599cd22a51c3ceedcca7e80466d668 to your computer and use it in GitHub Desktop.
Save kdwolski/5f599cd22a51c3ceedcca7e80466d668 to your computer and use it in GitHub Desktop.
Download ZIP
Handy Drupal SQL Queries
Raw
queries.sql
# Set status override on nodes in XML Sitemap when they have a noindex meta tag set
# For sites using XML Sitemap and Meta Tag modules
UPDATE xmlsitemap JOIN metatag ON ( metatag.entity_id = xmlsitemap.id)
SET xmlsitemap.status_override = 1
WHERE xmlsitemap.id = metatag.entity_id AND metatag.data LIKE '%noindex%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment