GUQ Featured Images Query

guq-featured-images-query.sql

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://www.qatar.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