Skip Ribbon Commands
Skip to main content
SharePoint

Skip Navigation LinksListDewey

Search
  
sql
sqlcount
param
sqlimage
  
select C2.* from(select C1.bibid,C1.title, case when C1.rating is null then 0 else C1.rating end as rating from  bibsearch B,(select bi.bibid,AVG(rating) as rating,S.title from bibsearch S INNER JOIN BIBLIOGRAPHIC bi ON S.BIBID = bi.BIBID LEFT OUTER JOIN bibcomment co on bi.bibid = co.bibid where s.aastatus = 0 and bi.RECORDSTATUS = 'c' and (co.active = '1' or co.active IS NULL) group by bi.bibid,S.title)C1 where B.BIBID = C1.bibid)C2 ORDER BY C2.rating desc fetch first 10 rows only
select img from bibliographic where bibid=%bibid%
  
select C2.* from(select C1.bibid,C1.title, case when C1.rating is null then 0 else C1.rating end as rating from  bibsearch B,(select bi.bibid,AVG(rating) as rating,S.title from bibsearch S INNER JOIN BIBLIOGRAPHIC bi ON S.BIBID = bi.BIBID LEFT OUTER JOIN bibcomment co on bi.bibid = co.bibid where s.aastatus = 0 and bi.RECORDSTATUS = 'c' and SUBSTR(S.deweyclassification,1,1)='0' and (co.active = '1' or co.active IS NULL) group by bi.bibid,S.title)C1 where B.BIBID = C1.bibid)C2 ORDER BY C2.rating desc fetch first 10 rows only
select img from bibliographic where bibid=%bibid%
  
select C2.* from(select C1.bibid,C1.title, case when C1.rating is null then 0 else C1.rating end as rating from  bibsearch B,(select bi.bibid,AVG(rating) as rating,S.title from bibsearch S INNER JOIN BIBLIOGRAPHIC bi ON S.BIBID = bi.BIBID LEFT OUTER JOIN bibcomment co on bi.bibid = co.bibid where s.aastatus = 0 and bi.RECORDSTATUS = 'c' and SUBSTR(S.deweyclassification,1,1)='1' and (co.active = '1' or co.active IS NULL) group by bi.bibid,S.title)C1 where B.BIBID = C1.bibid)C2 ORDER BY C2.rating desc fetch first 10 rows only
select img from bibliographic where bibid=%bibid%
  
select C2.* from(select C1.bibid,C1.title, case when C1.rating is null then 0 else C1.rating end as rating from  bibsearch B,(select bi.bibid,AVG(rating) as rating,S.title from bibsearch S INNER JOIN BIBLIOGRAPHIC bi ON S.BIBID = bi.BIBID LEFT OUTER JOIN bibcomment co on bi.bibid = co.bibid where s.aastatus = 0 and bi.RECORDSTATUS = 'c' and SUBSTR(S.deweyclassification,1,1)='2' and (co.active = '1' or co.active IS NULL) group by bi.bibid,S.title)C1 where B.BIBID = C1.bibid)C2 ORDER BY C2.rating desc fetch first 10 rows only
select img from bibliographic where bibid=%bibid%
  
select C2.* from(select C1.bibid,C1.title, case when C1.rating is null then 0 else C1.rating end as rating from  bibsearch B,(select bi.bibid,AVG(rating) as rating,S.title from bibsearch S INNER JOIN BIBLIOGRAPHIC bi ON S.BIBID = bi.BIBID LEFT OUTER JOIN bibcomment co on bi.bibid = co.bibid where s.aastatus = 0 and bi.RECORDSTATUS = 'c' and SUBSTR(S.deweyclassification,1,1)='3' and (co.active = '1' or co.active IS NULL) group by bi.bibid,S.title)C1 where B.BIBID = C1.bibid)C2 ORDER BY C2.rating desc fetch first 10 rows only
select img from bibliographic where bibid=%bibid%
  
select C2.* from(select C1.bibid,C1.title, case when C1.rating is null then 0 else C1.rating end as rating from  bibsearch B,(select bi.bibid,AVG(rating) as rating,S.title from bibsearch S INNER JOIN BIBLIOGRAPHIC bi ON S.BIBID = bi.BIBID LEFT OUTER JOIN bibcomment co on bi.bibid = co.bibid where s.aastatus = 0 and bi.RECORDSTATUS = 'c' and SUBSTR(S.deweyclassification,1,1)='5' and (co.active = '1' or co.active IS NULL) group by bi.bibid,S.title)C1 where B.BIBID = C1.bibid)C2 ORDER BY C2.rating desc fetch first 10 rows only
select img from bibliographic where bibid=%bibid%