Ricerca semantica
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Categoria:Patents]] [[Patented by::Parker]]
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
`FP_smw_object_ids` AS t0
INNER JOIN
(`FP_smw_fpt_inst` AS t2
INNER JOIN
`FP_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`FP_smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=85420 AND t4.o_id=85535)
)
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
150
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
`FP_smw_object_ids` AS t0
INNER JOIN
(`FP_smw_fpt_inst` AS t2
INNER JOIN
`FP_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`FP_smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=85420 AND t4.o_id=85535)
)
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
150
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 209 | Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki_fp.t4.s_id | 1 | Using where | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | wiki_fp.t4.s_id | 2 | Using where; Using index; Distinct | |
1 | SIMPLE | t3 | eq_ref | PRIMARY | PRIMARY | 4 | wiki_fp.t2.o_id | 1 | Distinct |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (6183).
SELECT s_id FROM `FP_smw_fpt_subc` WHERE o_id=6183 LIMIT 1
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None- Year 1952, n° US-2774332, applied in 1956, by Ivan D. Tefft. Fountain pens.
- Year 1953, n° US-2782763, applied in 1957, by Harlan H. Zodtner. Fountain pens.
- Year 1954, n° US-2802450, applied in 1957, by Frederick R. Wittnebert. Fountain pens.
- Year 1956, n° US-2871823, applied in 1959, by Marlin S. Baker. Fountain pen.
- Year 1952, n° US-2888908, applied in 1959, by Robert W. Randolph. Fountain pen.
- Year 1951, n° US-2889810, applied in 1959, by Robert W. Randolph. Fountain pen.
- Year 1952, n° US-2905148, applied in 1959, by Marlin S. Baker. Fountain pen.
- Year 1953, n° US-2916013, applied in 1959, by Nolan Kent Rhoades, Marlin S. Baker. Receptacle for receiving and enclosing the writing end of a fountain pen.
- Year 1959, n° US-2935044, applied in 1960, by Frederick R. Wittnebert et al. Fountain pen.
- Year 1957, n° US-2979030, applied in 1961, by William J. Harrington. Writing instruments.
- Year 1961, n° US-3038506, applied in 1962, by Robert L. Kuranz. Filler device for fountain pens.
- Year 1959, n° US-3087464, applied in 1963, by Frederick R. Wittnebert, Clemens A. Sonntag. Modular fountain pen.
- Year 1960, n° US-3134362, applied in 1964, by Homer T. Green. Fountain pen.
- Year 1960, n° US-3154055, applied in 1964, by Ray A. Lawton. Fountain pen.
- Year 1888, n° US-416944, applied in 1889, by George S. Parker. Fountain pen.
- Year 1889, n° US-423804, applied in 1890, by George S. Parker. Fountain-pen.
- Year 1890, n° US-455023, applied in 1891, by George S. Parker. Fountain-pen.
- Year 1892, n° US-510439, applied in 1893, by George S. Parker. Fountain-pen.
- Year 1893, n° US-512319, applied in 1894, by George S. Parker. Fountain-pen.
- Year 1897, n° US-606231, applied in 1898, by George S. Parker. Fountain-pen.
- Year 1898, n° US-622256, applied in 1899, by George S. Parker. Fountain-pen.
- Year 1899, n° US-629519, applied in 1899, by Stephen J. Meyerpeter. Fountain-pen.
- Year 1899, n° US-635700, applied in 1899, by George S. Parker. Fountain-pen.
- Year 1899, n° US-642151, applied in 1900, by George S. Parker. Fountain-pen.
- Year 1900, n° US-653818, applied in 1900, by George S. Parker. Fountain-pen.
- Year 1903, n° US-758930, applied in 1904, by George S. Parker. Fountain-pen.
- Year 1904, n° US-778997, applied in 1905, by George S. Parker. Feeder for fountain-pens.
- Year 1904, n° US-787152, applied in 1905, by John T. Davison. Self-filling fountain-pen.
- Year 1905, n° US-791466, applied in 1905, by Edward M. Heylman. Self-filling fountain-pen.
- Year 1906, n° US-854584, applied in 1907, by Arnold Martinelli. Clip or sustaining device for fountain-pens.
- Year 1910, n° US-990288, applied in 1911, by George S. Parker. Fountain-pen.
- Year 1925, n° US-D070575, applied in 1926, by George S. Parker. Design for a pencil.
- Year 1927, n° US-D076794, applied in 1928, by Walter E. Guyot. Design for a support for penholder.
- Year 1929, n° US-D081254, applied in 1930, by Kenneth S. Parker. Design for a fountain pen.
- Year 1931, n° US-D087792, applied in 1932, by Russel C. Parker. Design for a fountain pen.
- Year 1932, n° US-D088821, applied in 1932, by Joseph B. Platt, Ivan D. Tefft. Design for a fountain pen and pencil clip.
- Year 1932, n° US-D089449, applied in 1933, by Russel C. Parker. Design for a fountain pen.
- Year 1932, n° US-D089815, applied in 1933, by Ivan D. Tefft. Design for a fountain pen.
- Year 1936, n° US-D102799, applied in 1937, by Kenneth S. Parker. Design for a fountain pen or other writing implement.
- Year 1936, n° US-D102800, applied in 1937, by Kenneth S. Parker. Design for a fountain pen or other writing implement.
- Year 1936, n° US-D102801, applied in 1937, by Kenneth S. Parker. Design for a fountain pen or other writing implement.
- Year 1937, n° US-D106326, applied in 1937, by Paul M. Ressinger. Design for a fountain pen or similar article.
- Year 1937, n° US-D107708, applied in 1937, by Paul M. Ressinger, Ivan D. Tefft. Design for a fountain pen and pencil clip.
- Year 1939, n° US-D116097, applied in 1939, by Kenneth S. Parker, Marlin S. Baker. Design for a fountain pen.
- Year 1939, n° US-D116098, applied in 1939, by Kenneth S. Parker, Marlin S. Baker. Design for a fountain pen barrel.
- Year 1946, n° US-D146806, applied in 1947, by Laszlo Moholy-Nagy. Fountain pen.
- Year 1952, n° US-D169456, applied in 1953, by Nolan Kent Rhoades. Pocket clip.
- Year 1956, n° US-D179053, applied in 1956, by Marlin S. Baker. Fountain pen.
- Year 1955, n° US-D179425, applied in 1956, by Kenneth S. Parker. Closure cap for a writing instrument.
- Year 1958, n° US-D185581, applied in 1959, by Clemens A. Sonntag, Lauren O. Main. Fountain pen nib.