Semantic search

MyWikiBiz, Author Your Legacy — Wednesday December 08, 2021
Jump to navigationJump 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
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[NAICS Code1::≥44111 - 1]] [[NAICS Code1::≤45439 + 1]]
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_di_wikipage` AS t2
INNER JOIN
  `smw_object_ids` AS t4 ON t2.o_id=t4.smw_id
INNER JOIN
  (`smw_di_wikipage` AS t5
INNER JOIN
  `smw_object_ids` AS t7 ON t5.o_id=t7.smw_id) ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.p_id=327479
   AND (t4.smw_sortkey>='44111 - 1')
   AND (t5.p_id=327479
   AND (t7.smw_sortkey<='45439 + 1')
  ))
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  25
OFFSET
  20
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt2refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3p_id4const596Using where; Using temporary; Using filesort
1SIMPLEt5refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3p_id8const, admin_wiki.t2.s_id1Using where
1SIMPLEt7eq_refPRIMARY, smw_id, smw_sortkeyPRIMARY4admin_wiki.t5.o_id1Using where
1SIMPLEt4eq_refPRIMARY, smw_id, smw_sortkeyPRIMARY4admin_wiki.t2.o_id1Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4admin_wiki.t2.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:4
Query-Depth:1
Errors and Warnings
None
Company NameCityStateZipNAICSPhone
Practical Sports & OutdoorsDallasTexas75227451110
PracticalSports.comTexas75227454111
Riders DiscountMichigan49424441310866.931.6644
SOG-Knives.netHaughton454111800.458.1606
Shrimp ButlerHaughton454111800.458.1606
Starlite Weddings & OccasionsWaynesvilleNorth Carolina28785453998828.356.6883
SuperNotebookHaughton454111800.458.1606
The Scrapper BeesCoatesvillePennsylvania1932045112762.233.7249
Water Cooler (all)San Francisco, California45431
Water Cooler (assistance)San Francisco, California45431
West Florida ComponentsFlorida34688454111866.342.2003
World Wide FloorsNew Jersey08837444190Tel : 732-906-1400
Worth Protection SecurityNew Hampshire030524529603.674-4159