first the simple answer -- look for phpmyadmin under databases in the cpanel. there are usually other tools there for simple reports also.

the bad news is WP, has one of the worst databases ever designed.  it violates just about every rule you can think of, normalization being high on that list.  it's really amazing what leo's been able to do with it

I've created a separate sql database of images, sites and keywords at http://symbiostock-search.com  and have been writing different reports.  if anyone has a report they'd like to see, I can easily add others.

for this db I use vbscript and sql since its on a MS website.  all thatcan also be done with php on a Linux site, and there's lots of code examples available.

a basics report has 2 steps:

--select the records you want to report, and sort them

--read each record and write a line of the report

counts, summaries, etc then come at the end

---
right now i'm experimenting with ways to handle similar images, and looking for better matches wuth multiple keywords.  neither is really a problem at this stage since the total # of images is small, but it will be a concern in the future