Update December 10, 2017: Version 3.0 is now available here.

Database Query is now available to download from the Downloads -> Plugins menu.

This was originally intended to be two different plug-ins, but they were so similar, I just combined them into one.  Part one is for fun.  It allows you to query your database to check out tons of interesting statistics.  Part two is for cleanup.  It will assist you in finding bad data in your database.  This can then be edited or you can save the results to a flag set for later work.  Between the two, this plug-in will let you examine every field in the database that I could get access to.

There are a lot more details on my website including a few screen shots, so I won't go into great detail here.

If you have any questions, feel free to post them here and I'll answer them as soon as I can.  I'm also open to requests.  I've already scoured the forums looking for ideas and have incorporated as many as I could, but I'm sure there's still a lot of great ideas out there.  In fact, after working on this for 3 1/2 months, just a few days ago someone posted something that I hadn't ever thought of in all that time (searching for a person will show you which dividers they're listed under which is awesome for TV sets).

Finally, I'd like to thank 5 people who have spent the past 1 1/2 months testing this with me, giving me new ideas and without their help, there a lot that would be missing from what you see today.  So thanks to:

m.cellophane
ya_shin
lyonsden5
hal9g
Addicted2DVD

Nice... took 3 minutes from the time I hit begin to the time I could play. Very impressed, I was expecting a wait of about 3 times longer.

More impressions will follow!

I love this plugin... my favorite!

I like that you can change the font, very nice feature.

I also like the ability to edit the profile while the plugin is open, I will get a lot of use out of this.

Thanks Mark.

Two 

Quoting NewEnglander:

Quote:
I like that you can change the font, very nice feature.

Thanks.  The fonts gave me so much pain.  Just when I thought I had them figured out, I'd find another place where they were wrong (and there's probably a few places still).  That and the name coloring. 

Anyway, during the testing they were so annoying that I was thinking at least one person better appreciate them or I'd bang my head into the wall, so now I feel much better!

Quote:
I also like the ability to edit the profile while the plugin is open, I will get a lot of use out of this.

You can thank the people who helped me test.  That was all their idea.  They pushed and pushed and pushed until I gave in.    

Really, had it not been for their requests, I wouldn't have thought of it.

Quoting Mark Harrison:

Quote:
Quoting skipnet50:

Quote:
Summary page is frightening, at least you didn't include<gulp>a total runtime. Having a total Disc Count is just way too scary.

Skip

Ohhh.  There's the first thing I didn't consider.  Total running time!  That will be in the next version.  

I don't think I want to know, Mark. It tells me I have 6300+ total discs...I almost passed out.

Skip

That should be just owned, since my total with wishlist is 6500+ and addind discs to that total...<gasp>Thump....sorry...I fainted.

Skip

Oh, that reminds me...

The page that breaks down the stats to show how many child profiles, would it be posssible to even dig further down to grandchildren and great grandchildren. 

I love it. Thanks a tonne for your hard work.

KM