I can add another property to whom it must be a brief description, and who complete.Can we also get strPlotOutline from movieinfo in myvideo as it's much shorter
How about - strAlbumArtist in tracks?strArtist in 'tracks' is
| Artist |
| AlbumArtist |How about - strAlbumArtist in tracks?strArtist in 'tracks' is
| Artist |
Great ! Is it possible to make a short summary for movies and tvseries too ? for e.g i use a script to collect the plot but limit it to the first two sentences, this means i don't have to have scrolling text in homescreenI can add another property to whom it must be a brief description, and who complete.Can we also get strPlotOutline from movieinfo in myvideo as it's much shorter
#latestMediaHandler.myvideo.latest" + z + ".plotoutline
Try run select:| AlbumArtist |
SELECT tracks.strAlbumArtist, tracks.strAlbum, tracks.strFileType, MAX(tracks.dateAdded) as dateAdded,
CAST(ROUND(AVG(tracks.iTimesPlayed)) AS INTEGER) as iTimesPlayed, MAX(tracks.dateLastPlayed) as dateLastPlayed,
GROUP_CONCAT(tracks.strGenre,'|') as strGenre, GROUP_CONCAT(tracks.strPath,'|') as strPath,
artistinfo.strAMGBio as strLyrics
FROM tracks
LEFT JOIN artistinfo ON TRIM(tracks.strAlbumArtist,'| ') = TRIM(artistinfo.strArtist)
GROUP BY strAlbumArtist, strAlbum, strFileType
ORDER BY dateLastPlayed DESC LIMIT 10;
No We need to look for a field there.and tvseries too
Summary From online_episodes ( limit this to two sentences ) ?No We need to look for a field there.and tvseries too