To restore images for an issue
select image.piccol_number||' or'
from siphoto.issue, siphoto.story, siphoto.story_image, siphoto.image
where
issue.id_issue = 583 AND
issue.id_issue = story.id_issue AND
story.id_story = story_image.id_story AND
story_image.id_image = image.id_image
copy and paste result into verity box
copy search results into correct imaging folder
|