Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Clubs]]
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=7808)
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
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=7808)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 23042 | 100.00 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | protoballbetadb.t1.s_id | 1 | 50.00 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NonePage | Date | City | State | Club | First in | Notes |
---|---|---|---|---|---|---|
Club | Error: Invalid time. | Hudson | IL | Active Club of Hudson | Hudson, IL | |
Club | Error: Invalid time. | Hudson City | NJ | Active Club of Hudson City | ||
Club | Error: Invalid time. | Huntington | MA | Active Club of Huntington | ||
Club | Error: Invalid time. | Jersey City | NJ | Active Club of Jersey City | ||
Club | Error: Invalid time. | Kankakee | IL | Active Club of Kankakee | ||
Club | Error: Invalid time. | Kansas City | MO | Active Club of Kansas City | ||
Club | Error: Invalid time. | La Grange | KY | Active Club of La Grange | La Grange, KY | |
Club | Error: Invalid time. | Jersey City | NJ | Active Club of Lafayette | ||
Club | Error: Invalid time. | Lafayette | IN | Active Club of Lafayette, IN | ||
Club | Error: Invalid time. | Lansingburgh | NY | Active Club of Lansingburgh | ||
Club | Error: Invalid time. | Lawrenceville | PA | Active Club of Lawrenceville | ||
Club | Error: Invalid time. | Lexington | MA | Active Club of Lexington, MA | ||
Club | Error: Invalid time. | Lincoln | IL | Active Club of Lincoln | ||
Club | Error: Invalid time. | Litchfield | CT | Active Club of Litchfield | ||
Club | Error: Invalid time. | Little Falls | NJ | Active Club of Little Falls | ||
Club | Error: Invalid time. | Little Rock | AR | Active Club of Little Rock | ||
Club | Error: Invalid time. | Los Angeles | CA | Active Club of Los Angeles | ||
Club | Error: Invalid time. | Louisville | KY | Active Club of Louisville | ||
Club | Error: Invalid time. | Lowellville | OH | Active Club of Lowellville | Lowellville, OH | |
Club | Error: Invalid time. | Manchester | VT | Active Club of Manchester | Manchester, VT | |
Club | Error: Invalid time. | Martinsburg | NY | Active Club of Martinsburg | Martinsburg, NY | |
Club | Error: Invalid time. | Meadville | PA | Active Club of Meadville | ||
Club | Error: Invalid time. | Mechanicsburg | PA | Active Club of Mechanicsburg | ||
Club | Error: Invalid time. | Melrose | NY | Active Club of Melrose | ||
Club | Error: Invalid time. | Memphis | TN | Active Club of Memphis | ||
Club | Error: Invalid time. | Millbury | MA | Active Club of Millbury | ||
Club | Error: Invalid time. | Milwaukee | WI | Active Club of Milwaukee | ||
Club | Error: Invalid time. | Morrisania | NY | Active Club of Morrisania | ||
Club | Error: Invalid time. | Mystic | CT | Active Club of Mystic Bridge | ||
Club | Error: Invalid time. | New Albany | IN | Active Club of New Albany | ||
Club | Error: Invalid time. | New Haven | CT | Active Club of New Haven | ||
Club | Error: Invalid time. | New London | CT | Active Club of New London | ||
Club | Error: Invalid time. | New Orleans | LA | Active Club of New Orleans | ||
Club | Error: Invalid time. | Newark | NJ | Active Club of Newark | ||
Club | Error: Invalid time. | Newton | NJ | Active Club of Newton | ||
Club | Error: Invalid time. | Norfolk | CT | Active Club of Norfolk | Norfolk, CT | |
Club | Error: Invalid time. | Woburn | MA | Active Club of North Woburn | ||
Club | Error: Invalid time. | Ottumwa | IA | Active Club of Ottumwa | Ottumwa, IA | |
Club | Error: Invalid time. | Palmyra | NY | Active Club of Palmyra | ||
Club | Error: Invalid time. | Parma | NY | Active Club of Parma | Parma, NY | |
Club | Error: Invalid time. | Pascagoula | MS | Active Club of Pascagoula | Pascagoula, MS | |
Club | Error: Invalid time. | Paterson | NJ | Active Club of Paterson | ||
Club | Error: Invalid time. | Peoria | IL | Active Club of Peoria | ||
Club | Error: Invalid time. | Peru | NY | Active Club of Peru | ||
Club | Error: Invalid time. | Petaluma | CA | Active Club of Petaluma | Petaluma, CA | |
Club | Error: Invalid time. | Philadelphia | PA | Active Club of Philadelphia | ||
Club | Error: Invalid time. | Pittston | PA | Active Club of Pittston | ||
Club | Error: Invalid time. | Plattsburgh | NY | Active Club of Plattsburgh | ||
Club | Error: Invalid time. | Polo | IL | Active Club of Polo | ||
Club | Error: Invalid time. | Portland | ME | Active Club of Portland |