SELECT ... UNION [ALL] SELECT ... [UNION SELECT ...]
Union combines many results into one.
Without the ALL keyword, rows are unique.