B:BD[
2.10306] → [
2.10306:10581]
data: (await pool.query('select product.id, type, display_brand, producer, display_name, strain, strain_family_effect.name as strain_family from product left outer join strain_family_effect on (product.strain_family = strain_family_effect.id) where show = true')).rows
data: (await pool.query(` select first(product.id), first(type), first(display_brand), first(producer), first(display_name), first(strain), first(strain_family_effect.name) as strain_family, array_agg((portions, quantity)) from product left outer join variant on (product.id = variant.product) left outer join strain_family_effect on (product.strain_family = strain_family_effect.id) where show = true group by product.id;
`)).rows