Created
February 11, 2020 07:52
-
-
Save asharirfan/f8753b53a0c2e830ed70e0c115373a8a to your computer and use it in GitHub Desktop.
GUQ CIRS Featured Images Query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT file_managed.*, field_data_field_images.entity_id, field_data_field_images.field_images_alt, field_data_field_images.field_images_title, REPLACE(file_managed.uri, 'public://', 'https://cirs.georgetown.edu/sites/default/files/') AS url | |
FROM file_managed | |
JOIN field_data_field_images | |
ON file_managed.fid=field_data_field_images.field_images_fid |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment