Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT (select count(distinct DETAIL_ID) from OBJECTS o left join DETAILS d on (o.DETAIL_ID = d.ID) where (OBJECT_ID glob '*$*') and ((o.CLASS like "item.audioItem%" or o.CLASS like "item.videoItem %") and (d.TITLE like "%bi-2%" or d.CREATOR like "%bi-2%" or d.ARTIST like "%bi-2%" or d.ALBUMArtist like "%bi-2%" or d.ALBUM like "%bi-2%" or upnp:author like "%bi-2%" or d.GENRE like "%bi-2%" ) )) + (select count(*) from OBJECTS o left join DETAILS d on (o.DETAIL_ID = d.ID) where (OBJECT_ID = '*') and ((o.CLASS like "item.audioItem%" or o.CLASS like "item.videoItem %") and (d.TITLE like "%bi-2%" or d.CREATOR like "%bi-2%" or d.ARTIST like "%bi-2%" or d.ALBUMArtist like "%bi-2%" or d.ALBUM like "%bi-2%" or upnp:author like "%bi-2%" or d.GENRE like "%bi-2%" ) ))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement