{"datasette": "<datasette.app.Datasette object at 0x3ea1ff4e3450>", "columns": ["_table", "rowid"], "rows": ["<sqlite3.Row object at 0x3ea1fc902050>", "<sqlite3.Row object at 0x3ea1fc900fa0>", "<sqlite3.Row object at 0x3ea1fc903220>"], "sql": "select\r\n  '123_starts_with_digits' as _table,\r\n  rowid\r\nfrom\r\n  \"123_starts_with_digits\"\r\nwhere\r\n  \"content\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'Table With Space In Name' as _table,\r\n  rowid\r\nfrom\r\n  \"Table With Space In Name\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"content\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'attraction_characteristic' as _table,\r\n  rowid\r\nfrom\r\n  \"attraction_characteristic\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"name\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'binary_data' as _table,\r\n  rowid\r\nfrom\r\n  \"binary_data\"\r\nwhere\r\n  \"data\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'complex_foreign_keys' as _table,\r\n  rowid\r\nfrom\r\n  \"complex_foreign_keys\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"f1\" like '%' || :search || '%'\r\n  or \"f2\" like '%' || :search || '%'\r\n  or \"f3\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'compound_primary_key' as _table,\r\n  rowid\r\nfrom\r\n  \"compound_primary_key\"\r\nwhere\r\n  \"pk1\" like '%' || :search || '%'\r\n  or \"pk2\" like '%' || :search || '%'\r\n  or \"content\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'compound_three_primary_keys' as _table,\r\n  rowid\r\nfrom\r\n  \"compound_three_primary_keys\"\r\nwhere\r\n  \"pk1\" like '%' || :search || '%'\r\n  or \"pk2\" like '%' || :search || '%'\r\n  or \"pk3\" like '%' || :search || '%'\r\n  or \"content\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'custom_foreign_key_label' as _table,\r\n  rowid\r\nfrom\r\n  \"custom_foreign_key_label\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"foreign_key_with_custom_label\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'facet_cities' as _table,\r\n  rowid\r\nfrom\r\n  \"facet_cities\"\r\nwhere\r\n  \"id\" like '%' || :search || '%'\r\n  or \"name\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'facetable' as _table,\r\n  rowid\r\nfrom\r\n  \"facetable\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"created\" like '%' || :search || '%'\r\n  or \"planet_int\" like '%' || :search || '%'\r\n  or \"on_earth\" like '%' || :search || '%'\r\n  or \"state\" like '%' || :search || '%'\r\n  or \"city_id\" like '%' || :search || '%'\r\n  or \"neighborhood\" like '%' || :search || '%'\r\n  or \"tags\" like '%' || :search || '%'\r\n  or \"complex_array\" like '%' || :search || '%'\r\n  or \"distinct_some_null\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'foreign_key_references' as _table,\r\n  rowid\r\nfrom\r\n  \"foreign_key_references\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"foreign_key_with_label\" like '%' || :search || '%'\r\n  or \"foreign_key_with_blank_label\" like '%' || :search || '%'\r\n  or \"foreign_key_with_no_label\" like '%' || :search || '%'\r\n  or \"foreign_key_compound_pk1\" like '%' || :search || '%'\r\n  or \"foreign_key_compound_pk2\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'infinity' as _table,\r\n  rowid\r\nfrom\r\n  \"infinity\"\r\nwhere\r\n  \"value\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'no_primary_key' as _table,\r\n  rowid\r\nfrom\r\n  \"no_primary_key\"\r\nwhere\r\n  \"content\" like '%' || :search || '%'\r\n  or \"a\" like '%' || :search || '%'\r\n  or \"b\" like '%' || :search || '%'\r\n  or \"c\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'primary_key_multiple_columns' as _table,\r\n  rowid\r\nfrom\r\n  \"primary_key_multiple_columns\"\r\nwhere\r\n  \"id\" like '%' || :search || '%'\r\n  or \"content\" like '%' || :search || '%'\r\n  or \"content2\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'primary_key_multiple_columns_explicit_label' as _table,\r\n  rowid\r\nfrom\r\n  \"primary_key_multiple_columns_explicit_label\"\r\nwhere\r\n  \"id\" like '%' || :search || '%'\r\n  or \"content\" like '%' || :search || '%'\r\n  or \"content2\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'roadside_attraction_characteristics' as _table,\r\n  rowid\r\nfrom\r\n  \"roadside_attraction_characteristics\"\r\nwhere\r\n  \"attraction_id\" like '%' || :search || '%'\r\n  or \"characteristic_id\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'roadside_attractions' as _table,\r\n  rowid\r\nfrom\r\n  \"roadside_attractions\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"name\" like '%' || :search || '%'\r\n  or \"address\" like '%' || :search || '%'\r\n  or \"latitude\" like '%' || :search || '%'\r\n  or \"longitude\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'searchable' as _table,\r\n  rowid\r\nfrom\r\n  \"searchable\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"text1\" like '%' || :search || '%'\r\n  or \"text2\" like '%' || :search || '%'\r\n  or \"name with . and spaces\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'searchable_fts' as _table,\r\n  rowid\r\nfrom\r\n  \"searchable_fts\"\r\nwhere\r\n  \"text1\" like '%' || :search || '%'\r\n  or \"text2\" like '%' || :search || '%'\r\n  or \"name with . and spaces\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'searchable_fts_docsize' as _table,\r\n  rowid\r\nfrom\r\n  \"searchable_fts_docsize\"\r\nwhere\r\n  \"docid\" like '%' || :search || '%'\r\n  or \"size\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'searchable_fts_segdir' as _table,\r\n  rowid\r\nfrom\r\n  \"searchable_fts_segdir\"\r\nwhere\r\n  \"level\" like '%' || :search || '%'\r\n  or \"idx\" like '%' || :search || '%'\r\n  or \"start_block\" like '%' || :search || '%'\r\n  or \"leaves_end_block\" like '%' || :search || '%'\r\n  or \"end_block\" like '%' || :search || '%'\r\n  or \"root\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'searchable_fts_segments' as _table,\r\n  rowid\r\nfrom\r\n  \"searchable_fts_segments\"\r\nwhere\r\n  \"blockid\" like '%' || :search || '%'\r\n  or \"block\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'searchable_fts_stat' as _table,\r\n  rowid\r\nfrom\r\n  \"searchable_fts_stat\"\r\nwhere\r\n  \"id\" like '%' || :search || '%'\r\n  or \"value\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'searchable_tags' as _table,\r\n  rowid\r\nfrom\r\n  \"searchable_tags\"\r\nwhere\r\n  \"searchable_id\" like '%' || :search || '%'\r\n  or \"tag\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'select' as _table,\r\n  rowid\r\nfrom\r\n  \"select\"\r\nwhere\r\n  \"group\" like '%' || :search || '%'\r\n  or \"having\" like '%' || :search || '%'\r\n  or \"and\" like '%' || :search || '%'\r\n  or \"json\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'simple_primary_key' as _table,\r\n  rowid\r\nfrom\r\n  \"simple_primary_key\"\r\nwhere\r\n  \"id\" like '%' || :search || '%'\r\n  or \"content\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'sortable' as _table,\r\n  rowid\r\nfrom\r\n  \"sortable\"\r\nwhere\r\n  \"pk1\" like '%' || :search || '%'\r\n  or \"pk2\" like '%' || :search || '%'\r\n  or \"content\" like '%' || :search || '%'\r\n  or \"sortable\" like '%' || :search || '%'\r\n  or \"sortable_with_nulls\" like '%' || :search || '%'\r\n  or \"sortable_with_nulls_2\" like '%' || :search || '%'\r\n  or \"text\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'table/with/slashes.csv' as _table,\r\n  rowid\r\nfrom\r\n  \"table/with/slashes.csv\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"content\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'tags' as _table,\r\n  rowid\r\nfrom\r\n  \"tags\"\r\nwhere\r\n  \"tag\" like '%' || :search || '%'\r\nunion all\r\nselect\r\n  'units' as _table,\r\n  rowid\r\nfrom\r\n  \"units\"\r\nwhere\r\n  \"pk\" like '%' || :search || '%'\r\n  or \"distance\" like '%' || :search || '%'\r\n  or \"frequency\" like '%' || :search || '%'", "query_name": null, "database": "fixtures", "table": null, "request": "<asgi.Request method=\"GET\" url=\"https://latest.datasette.io/fixtures.testall?sql=select%0D%0A++'123_starts_with_digits'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22123_starts_with_digits%22%0D%0Awhere%0D%0A++%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'Table+With+Space+In+Name'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22Table+With+Space+In+Name%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'attraction_characteristic'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22attraction_characteristic%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22name%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'binary_data'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22binary_data%22%0D%0Awhere%0D%0A++%22data%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'complex_foreign_keys'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22complex_foreign_keys%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22f1%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22f2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22f3%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'compound_primary_key'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22compound_primary_key%22%0D%0Awhere%0D%0A++%22pk1%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22pk2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'compound_three_primary_keys'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22compound_three_primary_keys%22%0D%0Awhere%0D%0A++%22pk1%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22pk2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22pk3%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'custom_foreign_key_label'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22custom_foreign_key_label%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22foreign_key_with_custom_label%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'facet_cities'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22facet_cities%22%0D%0Awhere%0D%0A++%22id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22name%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'facetable'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22facetable%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22created%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22planet_int%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22on_earth%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22state%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22city_id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22neighborhood%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22tags%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22complex_array%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22distinct_some_null%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'foreign_key_references'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22foreign_key_references%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22foreign_key_with_label%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22foreign_key_with_blank_label%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22foreign_key_with_no_label%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22foreign_key_compound_pk1%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22foreign_key_compound_pk2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'infinity'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22infinity%22%0D%0Awhere%0D%0A++%22value%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'no_primary_key'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22no_primary_key%22%0D%0Awhere%0D%0A++%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22a%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22b%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22c%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'primary_key_multiple_columns'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22primary_key_multiple_columns%22%0D%0Awhere%0D%0A++%22id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'primary_key_multiple_columns_explicit_label'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22primary_key_multiple_columns_explicit_label%22%0D%0Awhere%0D%0A++%22id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'roadside_attraction_characteristics'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22roadside_attraction_characteristics%22%0D%0Awhere%0D%0A++%22attraction_id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22characteristic_id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'roadside_attractions'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22roadside_attractions%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22name%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22address%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22latitude%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22longitude%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'searchable'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22searchable%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22text1%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22text2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22name+with+.+and+spaces%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'searchable_fts'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22searchable_fts%22%0D%0Awhere%0D%0A++%22text1%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22text2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22name+with+.+and+spaces%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'searchable_fts_docsize'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22searchable_fts_docsize%22%0D%0Awhere%0D%0A++%22docid%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22size%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'searchable_fts_segdir'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22searchable_fts_segdir%22%0D%0Awhere%0D%0A++%22level%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22idx%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22start_block%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22leaves_end_block%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22end_block%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22root%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'searchable_fts_segments'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22searchable_fts_segments%22%0D%0Awhere%0D%0A++%22blockid%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22block%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'searchable_fts_stat'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22searchable_fts_stat%22%0D%0Awhere%0D%0A++%22id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22value%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'searchable_tags'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22searchable_tags%22%0D%0Awhere%0D%0A++%22searchable_id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22tag%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'select'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22select%22%0D%0Awhere%0D%0A++%22group%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22having%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22and%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22json%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'simple_primary_key'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22simple_primary_key%22%0D%0Awhere%0D%0A++%22id%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'sortable'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22sortable%22%0D%0Awhere%0D%0A++%22pk1%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22pk2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22sortable%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22sortable_with_nulls%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22sortable_with_nulls_2%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22text%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'table%2Fwith%2Fslashes.csv'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22table%2Fwith%2Fslashes.csv%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22content%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'tags'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22tags%22%0D%0Awhere%0D%0A++%22tag%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0Aunion+all%0D%0Aselect%0D%0A++'units'+as+_table%2C%0D%0A++rowid%0D%0Afrom%0D%0A++%22units%22%0D%0Awhere%0D%0A++%22pk%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22distance%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'%0D%0A++or+%22frequency%22+like+'%25'+%7C%7C+%3Asearch+%7C%7C+'%25'&search=museum\">", "view_name": "table", "1+1": 2}