home / fixtures

fixtures

Custom SQL query returning 15 rows

                    select neighborhood, facet_cities.name, state
                    from facetable
                        join facet_cities on facetable.city_id = facet_cities.id
                    where neighborhood like '%' || :text || '%'
                    order by neighborhood;
                

Query parameters

neighborhoodnamestate
Arcadia Planitia Memnonia MC
Bernal Heights San Francisco CA
Corktown Detroit MI
Dogpatch San Francisco CA
Downtown Los Angeles CA
Downtown Detroit MI
Greektown Detroit MI
Hayes Valley San Francisco CA
Hollywood Los Angeles CA
Koreatown Los Angeles CA
Los Feliz Los Angeles CA
Mexicantown Detroit MI
Mission San Francisco CA
SOMA San Francisco CA
Tenderloin San Francisco CA
Powered by Datasette · Query took 0.597ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py