SQL: extracting the purl and title from dspace given a handle
dspace_sr=> select text_value from metadatavalue, handle where metadata_field_id=25 AND item_id=handle.resource_id and handle=49928;
text_value
---------------------------
http://purl.umn.edu/49928
dspace_sr=> select text_value from metadatavalue, handle where metadata_field_id=64 AND item_id=handle.resource_id and handle=49928;
text_value
-------------------------------------------------------------------------------------------
Food-safety Standards and Farmers Health: Evidence from Kenyan’s Export Vegetable Growers
text_value
---------------------------
http://purl.umn.edu/49928
dspace_sr=> select text_value from metadatavalue, handle where metadata_field_id=64 AND item_id=handle.resource_id and handle=49928;
text_value
-------------------------------------------------------------------------------------------
Food-safety Standards and Farmers Health: Evidence from Kenyan’s Export Vegetable Growers