Category=Documents Name=Show Document Pages By Institution Description=This script shows all document pages, selected by document, then institution Heading=Select a document SQL=SELECT * FROM DOCUMENT LinkColumn=DOCUMENTID Heading2=Select an Institution SQL2=SELECT T1.DOCUMENTID, COALESCE(T4.INSTITUTIONID, -1) INSTITUTIONIDORNULL, T4.NAME, count(*) PAGECOUNT FROM PAGE T1 LEFT OUTER JOIN SHELFINSTANCEPAGES T2 ON (T1.DOCUMENTID=T2.DOCUMENTID and T1.PAGEID=T2.PAGEID) LEFT OUTER JOIN SHELFINSTANCE T3 ON T3.SHELFID=T2.SHELFID LEFT OUTER JOIN INSTITUTION T4 ON T4.INSTITUTIONID=T3.INSTITUTIONID WHERE T1.DOCUMENTID={0} GROUP BY T1.DOCUMENTID, INSTITUTIONIDORNULL, T4.NAME LinkColumn2=INSTITUTIONIDORNULL Heading3=Select a Page to View Surrogates LinkColumn3=PAGEID SQL3=SELECT * FROM PAGE T1 LEFT OUTER JOIN SHELFINSTANCEPAGES T2 ON (T1.DOCUMENTID=T2.DOCUMENTID and T1.PAGEID=T2.PAGEID) LEFT OUTER JOIN SHELFINSTANCE T3 ON T3.SHELFID=T2.SHELFID LEFT OUTER JOIN INSTITUTION T4 ON T4.INSTITUTIONID=T3.INSTITUTIONID WHERE T1.DOCUMENTID={1} AND (T4.INSTITUTIONID={0} or ({0}=-1 and T4.INSTITUTIONID is NULL)) ORDER BY T1.SORTORDER SQL4=SELECT concat('') FROM SURROGATEIMAGE WHERE DOCUMENTID={1} and PAGEID={0} SQL5=SELECT concat('Transcription') FROM SURROGATETRANSCRIPTION WHERE DOCUMENTID={1} and PAGEID={0}