use phpMyAdmin SQL to execute this:
-- Show all 1->9, A->Z
SELECT LEFT(`baseFilename`, 1) AS All_1toZ, count( LEFT(`baseFilename`, 1)) AS Count
FROM tblBurPix
GROUP BY All_1toZ ORDER BY All_1toZ;
SELECT count( `baseFilename`) AS TotalPictures
FROM tblBurPix;
-- Show total count for all not in 'A,B,C,F,G,L,M,P,S,W' i.e. root dir (we want it below 7000)
SELECT count(*) as CountRootExcludingFolders
FROM tblBurPix
WHERE FIND_IN_SET(LEFT(`baseFilename`, 1), 'A,B,C,F,G,L,M,P,S,W') = 0;
-- Show All but 'B,C,P,W'
SELECT LEFT(`baseFilename`, 1) AS AllButBCPW, count( LEFT(`baseFilename`, 1)) AS Count
FROM tblBurPix
WHERE FIND_IN_SET(LEFT(`baseFilename`, 1), 'A,B,C,F,G,L,M,P,S,W') = 0
GROUP BY AllButBCPW ORDER BY AllButBCPW;
-- Show just 'B,C,P,W'
SELECT LEFT(`baseFilename`, 1) AS JustBCPW, count( LEFT(`baseFilename`, 1)) AS Count
FROM tblBurPix
WHERE FIND_IN_SET(LEFT(`baseFilename`, 1), 'A,B,C,F,G,L,M,P,S,W') > 0
GROUP BY JustBCPW ORDER BY JustBCPW;
-- Show selected two-letter prefixes
SELECT LEFT(`baseFilename`, 2) AS Just2LetterPrefixes, count( LEFT(`baseFilename`, 2)) AS Count
FROM tblBurPix
WHERE FIND_IN_SET(LEFT(`baseFilename`, 2), 'CO,X1,X2') > 0
GROUP BY Just2LetterPrefixes ORDER BY Just2LetterPrefixes;
-- Show ALL two-letter prefixes
SELECT LEFT(`baseFilename`, 2) AS All2LetterPrefixes, count( LEFT(`baseFilename`, 2)) AS Count
FROM tblBurPix
WHERE FIND_IN_SET(LEFT(`baseFilename`, 2), '1,2,3,4,5,6,7,8,9,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z') > 0
GROUP BY All2LetterPrefixes ORDER BY All2LetterPrefixes;
SELECT count( `baseFilename`) AS TotalPictures
FROM tblBurPix;
;