Best/fastest way to find all pages in a selections page field?

[thomas]

Hello,

I have a bunch of pages ("Products") containing a Page field ("Brand"). Those products are narrowed down by category and then paginated. I want to show all the brands included in the current selection of products. Is there a better way than loading the whole selection (normally I would only load the pagination) and foreach over it? The categories contain as much as 300 products so I fear loading the whole selection and foreaching just to get the brands will slow things down.

Anyone got a hint for me?

Thanks,

thomas

[LostKobrakai]

On mobile, therefore only the link: https://processwire.com/talk/topic/9730-get-pages-used-by-a-pagefield/#entry97705

[thomas]

Thanks Kobrakai,

so this method Ryan suggests will give me a list of all "marke" pages that are selected somewhere in a page field, right? This would certainly help (I'd iterate over 200 "Marken" instead of 3400 Products). I'll try some more raw MySQL queries to narrow it down ...