I really got it wrong with "Display on All Pages" as noted by the Edit to my previous blog. But isn't that part of the point in bloging what you found ... warts and all ...
Anyway, I have revised the select presented in the previous blog to restrict the modules listed to those who have the AllTabs bit set.
select
T.ModuleID,
Left(M.ModuleTitle, 30) as ModuleTitle,
Count(T.TabID) as OnPages
from
TabModules T
join Modules M on M.ModuleID = T.ModuleID
where
M.AllTabs = 1
group by
T.ModuleID,
Left(M.ModuleTitle, 30)
having
Count(T.TabID) > 1
order by
OnPages desc
Here is the revised results
The orginal select is still valid, but will discover other modules spread over several pages. More on that later.
Paul.
ModuleID ModuleTitle OnPages
----------- ------------------------------ -----------
445 Google Add Panel 65
489 Google Add Panel 27