asharirfan · February 8, 2020 14:25
diff --git a/guq-featured-images-query.sql b/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
	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