SELECT id from tree_usage_index WHERE name='cider' OR name='juicer' # if there are results SELECT id from tree_flowering_index WHERE id IN (results) and name='spring' # if there are still results SELECT id from tree_ripe_index WHERE id IN (results) and name='autumn'