Skip to content

Instantly share code, notes, and snippets.

@phette23

phette23/publication.sql

Created October 21, 2019 22:10
Show Gist options
  • Save phette23/51037b2a4cd940205c127370f8f54620 to your computer and use it in GitHub Desktop.
Save phette23/51037b2a4cd940205c127370f8f54620 to your computer and use it in GitHub Desktop.
Download ZIP
get people's publications from CCA portal
Raw
publication.sql
SELECT u.first_name, u.last_name, u.email, pub.title, pub.published_in, pub.url, pub.date, pub.description
FROM people_ppublication pub
JOIN people_portalprofile prof ON (pub.object_id = prof.id)
JOIN people_userprofile u ON (prof.user_id = u.id)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment