# PredefinedStatement

Name: ImageSet_GetImageDetails
Class: sql
Par2:
select ibba.w,ibba.h,ibba.hotspotx,ibba.hotspoty,ibba.imagedata,ibba.imageblob_id from ImageBlob_BaseAttributes as ibba left join Image_ImageBlob_Relation as iibr on ibba.imageblob_id = iibr.imageblob_id where iibr.image_id = ?1 and iibr.imageset_id = (select imageset_id from imageset_baseattributes, string_baseattributes where name_string_id = string_id and value = ?2);


Name: ImageSet_GetImageDetailsByName
Class: sql
Par2:
select ibba.w,ibba.h,ibba.hotspotx,ibba.hotspoty,ibba.imagedata,ibba.imageblob_id from ImageBlob_BaseAttributes as ibba, Image_BaseAttributes iba, String_BaseAttributes sba left join Image_ImageBlob_Relation as iibr on ibba.imageblob_id = iibr.imageblob_id where iibr.image_id = iba.Image_ID and iba.Name_String_ID=sba.String_ID and sba.Value = ?1 and iibr.imageset_id = (select Imageset_ID from ImageSet_BaseAttributes, String_BaseAttributes where Name_String_ID = String_ID and value = ?2);


