SELECT RAW ARRAY_DISTINCT( ARRAY_FLATTEN((SELECT DISTINCT RAW tags AS tags
FROM `company`
WHERE `type` = 'product' AND categories IS NOT MISSING
ORDER BY(tags) ASC LIMIT 2),1));
OR
SELECT RAW ARRAY_DISTINCT( ARRAY_FLATTEN(av,1))
LET av = (SELECT DISTINCT RAW tags AS tags
FROM `company`
WHERE `type` = 'product' AND categories IS NOT MISSING
ORDER BY(tags) ASC LIMIT 2);
OR
SELECT DISTINCT RAW tag
FROM (SELECT DISTINCT tags
FROM `company`
WHERE `type` = 'product' AND categories IS NOT MISSING
ORDER BY(tags) ASC LIMIT 2) AS d
UNNEST d.tags AS tag;
SELECT RAW ARRAY_DISTINCT( ARRAY_FLATTEN(av,1))
LET av = (SELECT DISTINCT RAW tags AS tags
FROM `company`
WHERE `type` = 'product' AND categories IS NOT MISSING
ORDER BY(tags) ASC LIMIT 2);
SELECT RAW ARRAY_SORT(ARRAY_DISTINCT( ARRAY_FLATTEN(av,1)))
LET av = (SELECT DISTINCT RAW tags AS tags
FROM `company`
WHERE `type` = 'product' AND categories IS NOT MISSING
ORDER BY(tags) ASC LIMIT 2);
OR
SELECT DISTINCT RAW tag
FROM (SELECT DISTINCT tags
FROM `company`
WHERE `type` = 'product' AND categories IS NOT MISSING
ORDER BY(tags) ASC LIMIT 2) AS d
UNNEST d.tags AS tag
ORDER BY tag;