"Where Used" report - Joomla! Forum - community, help and support

i have searched far , wide , can't believe it's not out there somewhere. old database days, called "where used" report. need know articles include links particular image file or pdf file. i'm trying clean large , unused jpg's , pdf's can't find report tell me articles refer particular file. if doesn't exist, i'll write , put out here i'm hoping someone's done it!

thanks

you can through mysql client application mysql administrator or phpmyadmin. here example how find out on published pages particular image used:

code: select all

select sect.title section, cat.title category, cont.title page
from `jos_content` cont
left join `jos_categories` cat on cont.catid = cat.id
left join `jos_sections` sect on cont.sectionid = sect.id
where introtext "%myimage.jpg%" , state = 1
order section, category, page