gardenbot

Custom SQL query returning 4 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 ) order by is_flower limit 101

Query parameters

p0

p1