select m, p from various_joined_tables_and_views where u = N group by m, p, u
</code.

<p>The result looks like this:</p>

<code>
m1, p1
m1, p2
m1, p3
m2, p1
m2, p2
m3, p1
.
.
.
alot more