Skip to content

Instantly share code, notes, and snippets.

@doublejosh

doublejosh/webinar.sql

Last active December 17, 2015 21:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save doublejosh/18dae257d20bb82586eb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save doublejosh/18dae257d20bb82586eb to your computer and use it in GitHub Desktop.
Download ZIP
Get webinar URLs
Raw
webinar.sql
SELECT n.nid as 'node-id', n.tnid as 'translation-nid', n.title, n.language, d.field_on_demand_value as 'ondemand', u.alias AS url
FROM node as n
LEFT JOIN url_alias as u
ON u.source = CONCAT('node/', n.nid)
LEFT JOIN field_data_field_on_demand as d
ON d.entity_id = n.nid
WHERE n.type = 'webinar'
ORDER BY nid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment