2011-09-12, 18:22
I have a 20 drive NAS with SD and HD files all over each drive. Now I want to have just HD files, so when I grad an HD file I more than likely already have in SD. How can I find the duplicate SD file so I can delete it?
select idMovie, concat(movie.c00, ' (' , movie.c07, ')') as title_year, movie.c22
from movie
inner join (
select c00, c07 from movie
group by concat(movie.c00, ' (' , movie.c07, ')')
having count(idMovie) > 1) dup on concat(movie.c00, ' (' , movie.c07, ')') = concat(dup.c00, ' (' , dup.c07, ')'
)
order by title_year
;
(2014-05-23, 01:43)Dave.Agent Wrote: I'm late to the party here, but this maybe useful for others googling the same problem...
I use a MySQL db and the following query shows all duplicate Movie title/year combos
Code:select idMovie, concat(movie.c00, ' (' , movie.c07, ')') as title_year, movie.c22
from movie
inner join (
select c00, c07 from movie
group by concat(movie.c00, ' (' , movie.c07, ')')
having count(idMovie) > 1) dup on concat(movie.c00, ' (' , movie.c07, ')') = concat(dup.c00, ' (' , dup.c07, ')'
)
order by title_year
;
(2014-08-18, 05:27)Milhouse Wrote: Or run the script in my signature, "./texturecache.py duplicates" to get a list of duplicate movies based on matching imdbnumber.
(2014-08-18, 13:24)madmax2 Wrote: I already enable
XBMC client in Settings -> Services -> Remote control:
Allow programs on this system to control XBMC
Allow programs on other systems to control XBMC
(2014-08-18, 01:44)madmax2 Wrote:(2014-05-23, 01:43)Dave.Agent Wrote: I'm late to the party here, but this maybe useful for others googling the same problem...
I use a MySQL db and the following query shows all duplicate Movie title/year combos
Code:select idMovie, concat(movie.c00, ' (' , movie.c07, ')') as title_year, movie.c22
from movie
inner join (
select c00, c07 from movie
group by concat(movie.c00, ' (' , movie.c07, ')')
having count(idMovie) > 1) dup on concat(movie.c00, ' (' , movie.c07, ')') = concat(dup.c00, ' (' , dup.c07, ')'
)
order by title_year
;
What is the SQL lite equivalent?
SELECT c00,
COUNT(c09)
FROM movie
GROUP BY c09
HAVING ( COUNT(c09) > 1 )
(2014-11-30, 05:38)McButton Wrote:(2014-08-18, 05:08)Soujirou Seta Wrote: The best way so far is use Ember Media Manager, and filter "Duplicated Movies"
...yep...
Scan, sort, delete. Done in about 3 minutes.