Semantic search

Jump to navigation Jump to search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
import-annotation:

Additional annotated data are to be copied during the parsing of a subject
propsep:

The separator between the properties of a result entry
valuesep:

The separator between the values for a property of a result
template:

The name of a template with which to display the printouts
named args:

Name the arguments passed to the template
userparam:

A value passed into each template call, if a template is used
class:

An additional CSS class to set for the list
introtemplate:

The name of a template to display before the query results, if there are any
outrotemplate:

The name of a template to display after the query results, if there are any
sep:

The separator between results
prefix:

Control display of namespace in printouts
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[Category:Clubs||Ballgames]] [[State::MI]] [[Category:First in a MI City||First in MI||First in United States]]
SQL Query
SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  (`smw_fpt_inst` AS t2
INNER JOIN
  `smw_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `smw_fpt_inst` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
  (
   (t2.o_id=7808 OR t2.o_id=681)
   AND (
   (t4.o_hash='MI') AND t4.p_id=568)
   AND (
   (t6.o_id=69451 OR t6.o_id=28103 OR t6.o_id=101366)
  ))
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  100
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt6ranges_id, o_id, s_id_2, o_id_2o_id_25188100.00Using where; Using index; Using temporary; Using filesort
1SIMPLEt4refs_id, o_hash, s_id_2, p_ids_id8protoballdb.t6.s_id, const15.00Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4protoballdb.t6.s_id150.00Using where
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id4protoballdb.t6.s_id140.84Using where; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:4
Query-Depth:1
Errors and Warnings
None
Type / Page Club / Match Date City Borough State First in
Club Light Foot Club of Union City 1870 Union City MI Union City, MI
Club Lively Reds Club of Sturgis 1870 Sturgis MI Sturgis, MI
Club Lively Turtles Club of Coloma 1870 Coloma MI Coloma, MI
Club Lone Star Club of Leslie 1868 Leslie MI Leslie, MI
Club Maple Valley Club of Ovid 1866 Ovid MI Ovid, MI
Club Marquette BBC 1866 Marquette MI Marquette, MI
Club Mattawee Club of Leroy 1870 Leroy MI Leroy, MI
Club Mayflower Club of Maple Rapids 1867 Maple Rapids MI Maple Rapids, MI
Ballgame Monitor Club of Ann Arbor v Brother Jonathans Club of Detroit 32 - 25 1862-07-04 Ann Arbor MI Ann Arbor, MI
Club Monitor Club of Niles 1863 Niles MI Niles, MI
Ballgame Monitor Club of Niles v Monitor Club of Niles 27 - 22 1863-04-27 Niles MI Niles, MI
Club Monitor Club of St. Johns 1866 St. Johns MI St. Johns, MI
Club Monitor Club of Taylor 1867 Taylor MI Taylor, MI
Club National Club of Middleville 1867 Middleville MI Middleville, MI
Club National Club of Parma 1867 Parma MI Parma, MI
Club National Union Club of Pentwater 1867 Pentwater MI Pentwater, MI
Club Oakland Club of Holly 1867 Holly MI Holly, MI
Club Olivet BBC 1866 Olivet MI Olivet, MI
Club Ontonagon BBC 1868 Ontonagon MI Ontonagon, MI
Club Otisco Club of Cooks Corners 1866 Cooks Corner MI Cooks Corner, MI
Club Owosso BBC 1865 Owosso MI Owosso, MI
Club Pastime Club of Marshall 1861 Marshall MI Marshall, MI
Ballgame Pastime Club of Marshall v Red, White and Blue Club of Marshall 30 - 18 1861-09-06 Marshall MI Marshall, MI
Club Peninsular Club of Albion 1866 Albion MI Albion, MI
Club Pine Browns Club of Wayland 1867 Wayland MI Wayland, MI
Club Pioneer Club of Grand Rapids 1859 Grand Rapids MI Grand Rapids, MI
Club Plow Boys of Linden 1870 Linden MI Linden, MI
Club Pontiac BBC 1867 Pontiac MI Pontiac, MI
Club Prairie Club of Charlotte 1867 Charlotte MI Charlotte, MI
Club Prairie Club of Schoolcraft 1859 Schoolcraft MI Schoolcraft, MI
Ballgame Prairie Club of Schoolcraft v Champion Club of Kalamazoo 30 - 17 1860-10-02 Schoolcraft MI Schoolcraft, MI
Club Radical Club of Rives Township 1868 Rives MI Rives, MI
Club Rag Pickers Club of Litchfield 1867 Litchfield MI Litchfield, MI
Club Redford Club of Redford 1870 Redford MI Redford, MI
Club Regulars Club of Mt. Clemens 1867 Mt. Clemens MI Mt. Clemens, MI
Club Renescule Club of Allegan 1867 Allegan MI Allegan, MI
Club Salem Club of Washtenaw County 1865 Salem MI Salem, MI
Club Sault Club of Sault Ste. Marie 1887 Sault Ste. Marie MI Sault Ste. Marie, MI
Club Sheridan Club of Ithaca 1867 Ithaca MI Ithaca, MI
Club Sheridan Club of Mason 1865 Mason MI Mason, MI
Club Shoo Fly Club of Porter 1870 Porter MI Porter, MI
Club Shoo Fly Club of White Lake 1870 White Lake MI White Lake, MI
Club Shoo Fly Club of Williamston 1870 Williamston MI Williamston, MI
Club St. Joseph Club of Burr Oak 1870 Burr Oak MI Burr Oak, MI
Club Star Club of Algansee 1870 Algansee MI Algansee, MI
Club Star Club of Almont 1866 Almont MI Almont, MI
Club Star Club of Antwerp 1870 Antwerp MI Antwerp, MI
Club Star Club of East Saginaw 1870 East Saginaw MI East Saginaw, MI
Club Star Club of Lamont 1867 Lamont MI Lamont, MI
Club Star Club of Lansing College 1865 East Lansing MI East Lansing, MI