How Query deals multiple values

The SofaWiki database allows multiple values on a single page. You can define for example the following fields on a page
[[fooo::a]]
[[fooo::b]]
[[bar1::c]]

The order between the fields is not important. However, if there is more than one value per field, the order of the values matters within that field.

How many rows you get depends on the query. The query will give as many rows as the maximal rows of the fields implicated in the query.

If you write SELECT fooo, bar WHERE fooo *, you get 2 rows

fooo	bar
a
b

If you write SELECT fooo WHERE fooo *, you get 2 rows

fooo
a
b

If you write SELECT bar WHERE bar *, you get 1 row

bar
1
3

If you write SELECT fooo WHERE bar *, you get 2 rows

fooo

If you write SELECT bar WHERE fooo *, you get 1 row, because Sofawiki deals with relations where there cannot be duplicate rows.

bar