home / fixtures
select pk, created, planet_int, on_earth, state, city_id, neighborhood, tags, complex_array, distinct_some_null from facetable where "complex_array" = :p0 and "neighborhood" = :p1 and "on_earth" = :p2 and rowid in ( select facetable.rowid from facetable, json_each(facetable.tags) j where j.value = :p3 ) and rowid in ( select facetable.rowid from facetable, json_each(facetable.tags) j where j.value = :p4 ) order by pk limit 101
p0
p1
p2
p3
p4
Format SQL
This data as json, CSV