gardenbot

Custom SQL query returning 3 rows (hide)

select id, ideal_temp, min_full_sun, plant_spacing, season, seed_name, year_produced, need_to_reorder, days_to_harvest, is_flower, num_packets, indertiminate_determinate, notes from seeds where rowid in ( select seeds.rowid from seeds, json_each(seeds.season) j where j.value = :p0 ) and rowid in ( select seeds.rowid from seeds, json_each(seeds.season) j where j.value = :p1 ) and rowid in ( select seeds.rowid from seeds, json_each(seeds.season) j where j.value = :p2 ) order by seed_name limit 101

Query parameters

This data as json, CSV

id	ideal_temp	min_full_sun	plant_spacing	season	seed_name	year_produced	days_to_harvest
122	50-80		2	["summer", "fall", "winter", "spring"]	Ishikura Improved Green Onion	2021	40-50
112	45-80	6-12	4	["spring", "fall", "winter", "summer"]	Sugar Daddy Peas	2020
2	50-80		4-6in	["fall", "winter", "spring", "summer"]	bok choi white taisai	2020	50