![]() 21:35:44 T: M:879718400 DEBUG: RunQuery took 2 ms for 0 items query: SELECT sets.idSet,sets.strSet,COUNT(1) AS c,count(a圜ount) FROM sets JOIN setlinkmovie ON sets.idSet=setlinkmovie.idSet JOIN movie ON setlinkmovie.idMovie=movie.idMovie JOIN files ON files.idFile=movie.idFile where movie.idMovie in (select movieview.idMovie from movieview WHERE (idMovie in (select idMovie from studiolinkmovie join studio on studio.idStudio=studiolinkmovie.idStudio where studio.strStudio LIKE 'Brandywine Productions Ltd.' ))) GROUP BY sets.idSet HAVING c1. ![]() 21:35:43 T: M:880783360 DEBUG: RunQuery took 4 ms for 0 items query: SELECT sets.idSet,sets.strSet,COUNT(1) AS c,count(a圜ount) FROM sets JOIN setlinkmovie ON sets.idSet=setlinkmovie.idSet JOIN movie ON setlinkmovie.idMovie=movie.idMovie JOIN files ON files.idFile=movie.idFile where movie.idMovie in (select movieview.idMovie from movieview WHERE (idMovie in (select idMovie from genrelinkmovie join genre on genre.idGenre=genrelinkmovie.idGenre where genre.strGenre LIKE 'Documentary'))) GROUP BY sets.idSet HAVING c1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |