case when address is not null then concat_ws(', ', address,	address2, city, region,	country, postal_code) end,

		case when address is not null then concat_ws(', ', address, address2, city, region, country, postal_code) end,

		images,
		times,

		(select json_agg(url) from store_image where store_image.store_id = store.store_id),
		(select json_build_object(x, array_agg) from (
			select
				case
					when wow then 6
					else lower(open) / 1440
				end as x,
				array_agg(open order by case
					when wow then 2147483647
					else lower(open)
				end asc)
			from (
				select
					lower(open) = 0 and exists(
						select 1
						from store_time
						where
							store_time.store_id = store.store_id and
							upper(open) = 10080
					) as wow,
					open
				from store_time
				where store_time.store_id = store.store_id
			) as t
			group by x
			order by x asc
		) as y)

	from
		store
		left outer join (
			select
				store_id,
				json_agg(url) as images
			from
				store_image
			--order by rank
			group by
				store_id
		) as store_images using (store_id)
		left outer join (
			select
				store_id,
				json_agg(open) as times--combine the ranges? key value? (day : array of times)
			from
				store_time
			group by
				store_id
		) as store_times using (store_id)

	from store