fixtures

Custom SQL query returning 1 row (hide)

select pk, created, planet_int, on_earth, state, city_id, neighborhood, tags, complex_array, distinct_some_null from facetable where date("created") = :p0 and "tags" = :p1 and rowid in ( select facetable.rowid from facetable, json_each(facetable.tags) j where j.value = :p2 ) and rowid in ( select facetable.rowid from facetable, json_each(facetable.tags) j where j.value = :p3 ) order by pk limit 101

Query parameters

p0

p1

p2

p3