Project statistics: Difference between revisions
From Kungfu-Wiki
No edit summary |
No edit summary |
||
| Line 39: | Line 39: | ||
|format=count | |format=count | ||
}} | }} | ||
{{#vardefine:ids|{{#ask: [[P1::RoutinePosture]][[Has subobject::+]]|?P24.P2=|mainlabel=-|links=none|format=plainlist|sep={{!}}{{!}}|limit=9999}}}} | |||
{{#var:ids}} | |||
= Frequency of fighting positions = | = Frequency of fighting positions = | ||
<div class="container" > | <div class="container" > | ||
| Line 45: | Line 46: | ||
<div class="col" style="margin-right: -15px; margin-left: -15px;"> | <div class="col" style="margin-right: -15px; margin-left: -15px;"> | ||
'''before''' technique {{#ask: [[P1::RoutinePosture]][[Has subobject::+]][[P24.P2::+]]|?P24.P2=|mainlabel=-|links=none|format=plainlist|sep={{!}}{{!}}|limit=9999}} | '''before''' technique {{#ask: [[P1::RoutinePosture]][[Has subobject::+]][[P24.P2::+]]|?P24.P2=|mainlabel=-|links=none|format=plainlist|sep={{!}}{{!}}|limit=9999}} | ||
{{#ask:[[P1::contextInterpretation]][[Has subobject::+]][[P41::+]][[P44::+]][[P24 | {{#ask:[[P1::contextInterpretation]][[Has subobject::+]][[P41::+]][[P44::+]][[P24::{{#var:ids}}]] | ||
|?P41 | |?P41 | ||
|mainlabel=- | |mainlabel=- | ||
Revision as of 22:39, 29 November 2024
Routines: 8 Postures in routines: 404 Techniques: 154 Quan Pu: 124 Quan Pu parts: 5454 118||119||120||121||122||||||||||122||123||35||126||99||||||||99||44||124||||||||124||||||||127||128||135||||||||135||||129||130||60||||||||60||||131||34||||||||34||||||132||133||||||||133||||||||134||86||||||||||86||||100||101||106||117||6||107||46||2||110||11||11||141||12||13||14||15||16||17||18||103||20||21||22||23||||||9||24||25||26||27||28||29||30||31||32||33||33||||||36||37||38||39||40||41||42||43||||45||45||45||||47||48||49||||||||89||50||57||54||||90||||||91||||92||||93||94||||95||96||97||||98||||||||||||||||||||||||||102||102||||||||||||104||||||||||||||105||||||||||||||||109||3||||4||||||||||||108||||10||||||55||||1||||||5||80||81||7||||||||||||||||||||||||||111||111||114||115||||116||||||||||||||||||||||||||||125||||||||125||||||125||125||||||125||125||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||75||76||77||||||||||78||79||||||82||83||||84||||||||||||||87||||||||||||||||||||||88||||||142||143||144||145||146||146||147||||||148||149||||||||||||||||||||||||150||||||||||151||152||153||||154||||||||||||||51||136||52||||||53||||||56||||56||58||||||59||||61||62||63||||||64||65||66||67||||69||||70||||71||72||73||||73||||73||||74||
Frequency of fighting positions
before technique 118||119||120||121||122||||||||||122||123||35||126||99||||||||99||44||124||||||||124||||||||127||128||135||||||||135||||129||130||60||||||||60||||131||34||||||||34||||||132||133||||||||133||||||||134||86||||||||||86||||100||101||106||117||6||107||46||2||110||11||11||141||12||13||14||15||16||17||18||103||20||21||22||23||||||9||24||25||26||27||28||29||30||31||32||33||33||||||36||37||38||39||40||41||42||43||||45||45||45||||47||48||49||||||||89||50||57||54||||90||||||91||||92||||93||94||||95||96||97||||98||||||||||||||||||||||||||102||102||||||||||||104||||||||||||||105||||||||||||||||109||3||||4||||||||||||108||||10||||||55||||1||||||5||80||81||7||||||||||||||||||||||||||111||111||114||115||||116||||||||||||||||||||||||||||125||||||||125||||||125||125||||||125||125||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||75||76||77||||||||||78||79||||||82||83||||84||||||||||||||87||||||||||||||||||||||88||||||142||143||144||145||146||146||147||||||148||149||||||||||||||||||||||||150||||||||||151||152||153||||154||||||||||||||51||136||52||||||53||||||56||||56||58||||||59||||61||62||63||||||64||65||66||67||||69||||70||||71||72||73||||73||||73||||74||
Debug output SQLStore
ASK Query
[[P1::contextInterpretation]] [[Has subobject::+]] [[P41::+]] [[P44::+]] [[P24::118||119||120||121||122||||||123||35||126||99||||99||44||124||||124||||127||128||135||||135||||129||130||60||||60||||131||34||||34||132||133||||133||||134||86||||100||101||106||117||6||107||46||2||110||11||141||12||13||14||15||16||17||18||103||20||21||22||23||9||24||25||26||27||28||29||30||31||32||33||36||37||38||39||40||41||42||43||||45||45||||47||48||49||||89||50||57||54||||90||91||||92||||93||94||||95||96||97||||98||102||||104||105||||109||3||||4||||108||||10||55||||1||5||80||81||7||111||114||115||||116||||125||125||||75||76||77||78||79||82||83||||84||87||88||142||143||144||145||146||147||148||149||||150||151||152||153||||154||51||136||52||53||56||||56||58||59||||61||62||63||64||65||66||67||||69||||70||||71||72||73||||73||||74||]]
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_blob` AS t2
INNER JOIN
`smw_fpt_sobj` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_blob` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
`smw_di_blob` AS t8 ON t2.s_id=t8.s_id
INNER JOIN
(`smw_di_wikipage` AS t10
INNER JOIN
`t12` AS t12 ON t10.o_id=t12.id) ON t2.s_id=t10.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='contextInterpretation') AND t2.p_id=747
AND (t6.p_id=859)
AND (t8.p_id=862)
AND (t10.p_id=11419)
)
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
0
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_blob` AS t2
INNER JOIN
`smw_fpt_sobj` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_blob` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
`smw_di_blob` AS t8 ON t2.s_id=t8.s_id
INNER JOIN
(`smw_di_wikipage` AS t10
INNER JOIN
`t12` AS t12 ON t10.o_id=t12.id) ON t2.s_id=t10.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='contextInterpretation') AND t2.p_id=747
AND (t6.p_id=859)
AND (t8.p_id=862)
AND (t10.p_id=11419)
)
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
0
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t12 | ALL | PRIMARY | 156 | Using temporary; Using filesort | ||||
| 1 | SIMPLE | t10 | ref|filter | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id|p_id | 5|4 | wiki.t12.id | 3 (0%) | Using where; Using rowid filter | |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t10.s_id | 1 | Using where | |
| 1 | SIMPLE | t8 | ref | s_id, s_id_2, p_id | s_id | 8 | wiki.t10.s_id, const | 1 | Using index; Distinct | |
| 1 | SIMPLE | t6 | ref | s_id, s_id_2, p_id | s_id | 8 | wiki.t10.s_id, const | 1 | Using index; Distinct | |
| 1 | SIMPLE | t2 | ref | s_id, o_hash, s_id_2, p_id | s_id | 8 | wiki.t10.s_id, const | 1 | Using where; Distinct | |
| 1 | SIMPLE | t4 | ref | s_id, s_id_2 | s_id | 4 | wiki.t10.s_id | 4 | Using index; Distinct |
Auxilliary Tables
- Temporary table t12
INSERT IGNORE INTO `t12` (id) VALUES (125919)
INSERT IGNORE INTO `t12` (id) VALUES (33234)
INSERT IGNORE INTO `t12` (id) VALUES (25127)
INSERT IGNORE INTO `t12` (id) VALUES (125941)
INSERT IGNORE INTO `t12` (id) VALUES (40928)
INSERT IGNORE INTO `t12` (id) VALUES (226899)
INSERT IGNORE INTO `t12` (id) VALUES (5482)
INSERT IGNORE INTO `t12` (id) VALUES (25436)
INSERT IGNORE INTO `t12` (id) VALUES (14686)
INSERT IGNORE INTO `t12` (id) VALUES (7598)
INSERT IGNORE INTO `t12` (id) VALUES (226900)
INSERT IGNORE INTO `t12` (id) VALUES (41255)
INSERT IGNORE INTO `t12` (id) VALUES (1373)
INSERT IGNORE INTO `t12` (id) VALUES (226901)
INSERT IGNORE INTO `t12` (id) VALUES (226902)
INSERT IGNORE INTO `t12` (id) VALUES (125991)
INSERT IGNORE INTO `t12` (id) VALUES (9401)
INSERT IGNORE INTO `t12` (id) VALUES (226903)
INSERT IGNORE INTO `t12` (id) VALUES (226904)
INSERT IGNORE INTO `t12` (id) VALUES (126006)
INSERT IGNORE INTO `t12` (id) VALUES (62701)
INSERT IGNORE INTO `t12` (id) VALUES (226905)
INSERT IGNORE INTO `t12` (id) VALUES (226906)
INSERT IGNORE INTO `t12` (id) VALUES (4457)
INSERT IGNORE INTO `t12` (id) VALUES (226907)
INSERT IGNORE INTO `t12` (id) VALUES (27290)
INSERT IGNORE INTO `t12` (id) VALUES (33539)
INSERT IGNORE INTO `t12` (id) VALUES (226908)
INSERT IGNORE INTO `t12` (id) VALUES (226909)
INSERT IGNORE INTO `t12` (id) VALUES (9896)
INSERT IGNORE INTO `t12` (id) VALUES (226910)
INSERT IGNORE INTO `t12` (id) VALUES (6505)
INSERT IGNORE INTO `t12` (id) VALUES (37780)
INSERT IGNORE INTO `t12` (id) VALUES (125910)
INSERT IGNORE INTO `t12` (id) VALUES (20870)
INSERT IGNORE INTO `t12` (id) VALUES (2238)
INSERT IGNORE INTO `t12` (id) VALUES (1739)
INSERT IGNORE INTO `t12` (id) VALUES (821)
INSERT IGNORE INTO `t12` (id) VALUES (9042)
INSERT IGNORE INTO `t12` (id) VALUES (125179)
INSERT IGNORE INTO `t12` (id) VALUES (18568)
INSERT IGNORE INTO `t12` (id) VALUES (1396)
INSERT IGNORE INTO `t12` (id) VALUES (15948)
INSERT IGNORE INTO `t12` (id) VALUES (5139)
INSERT IGNORE INTO `t12` (id) VALUES (8391)
INSERT IGNORE INTO `t12` (id) VALUES (3796)
INSERT IGNORE INTO `t12` (id) VALUES (19979)
INSERT IGNORE INTO `t12` (id) VALUES (31998)
INSERT IGNORE INTO `t12` (id) VALUES (41640)
INSERT IGNORE INTO `t12` (id) VALUES (16953)
INSERT IGNORE INTO `t12` (id) VALUES (28628)
INSERT IGNORE INTO `t12` (id) VALUES (29157)
INSERT IGNORE INTO `t12` (id) VALUES (7284)
INSERT IGNORE INTO `t12` (id) VALUES (2737)
INSERT IGNORE INTO `t12` (id) VALUES (16664)
INSERT IGNORE INTO `t12` (id) VALUES (6850)
INSERT IGNORE INTO `t12` (id) VALUES (14426)
INSERT IGNORE INTO `t12` (id) VALUES (28851)
INSERT IGNORE INTO `t12` (id) VALUES (26376)
INSERT IGNORE INTO `t12` (id) VALUES (28316)
INSERT IGNORE INTO `t12` (id) VALUES (125316)
INSERT IGNORE INTO `t12` (id) VALUES (38823)
INSERT IGNORE INTO `t12` (id) VALUES (38197)
INSERT IGNORE INTO `t12` (id) VALUES (18201)
INSERT IGNORE INTO `t12` (id) VALUES (34558)
INSERT IGNORE INTO `t12` (id) VALUES (33846)
INSERT IGNORE INTO `t12` (id) VALUES (27199)
INSERT IGNORE INTO `t12` (id) VALUES (21872)
INSERT IGNORE INTO `t12` (id) VALUES (125377)
INSERT IGNORE INTO `t12` (id) VALUES (36704)
INSERT IGNORE INTO `t12` (id) VALUES (14078)
INSERT IGNORE INTO `t12` (id) VALUES (22943)
INSERT IGNORE INTO `t12` (id) VALUES (226911)
INSERT IGNORE INTO `t12` (id) VALUES (35939)
INSERT IGNORE INTO `t12` (id) VALUES (226912)
INSERT IGNORE INTO `t12` (id) VALUES (27636)
INSERT IGNORE INTO `t12` (id) VALUES (23035)
INSERT IGNORE INTO `t12` (id) VALUES (226913)
INSERT IGNORE INTO `t12` (id) VALUES (39913)
INSERT IGNORE INTO `t12` (id) VALUES (772)
INSERT IGNORE INTO `t12` (id) VALUES (13394)
INSERT IGNORE INTO `t12` (id) VALUES (226914)
INSERT IGNORE INTO `t12` (id) VALUES (24481)
INSERT IGNORE INTO `t12` (id) VALUES (226915)
INSERT IGNORE INTO `t12` (id) VALUES (226916)
INSERT IGNORE INTO `t12` (id) VALUES (16296)
INSERT IGNORE INTO `t12` (id) VALUES (226917)
INSERT IGNORE INTO `t12` (id) VALUES (12135)
INSERT IGNORE INTO `t12` (id) VALUES (15014)
INSERT IGNORE INTO `t12` (id) VALUES (226918)
INSERT IGNORE INTO `t12` (id) VALUES (20542)
INSERT IGNORE INTO `t12` (id) VALUES (226919)
INSERT IGNORE INTO `t12` (id) VALUES (30446)
INSERT IGNORE INTO `t12` (id) VALUES (226920)
INSERT IGNORE INTO `t12` (id) VALUES (22285)
INSERT IGNORE INTO `t12` (id) VALUES (226921)
INSERT IGNORE INTO `t12` (id) VALUES (226922)
INSERT IGNORE INTO `t12` (id) VALUES (226923)
INSERT IGNORE INTO `t12` (id) VALUES (42577)
INSERT IGNORE INTO `t12` (id) VALUES (226924)
INSERT IGNORE INTO `t12` (id) VALUES (816)
INSERT IGNORE INTO `t12` (id) VALUES (4120)
INSERT IGNORE INTO `t12` (id) VALUES (8251)
INSERT IGNORE INTO `t12` (id) VALUES (2151)
INSERT IGNORE INTO `t12` (id) VALUES (30751)
INSERT IGNORE INTO `t12` (id) VALUES (23793)
INSERT IGNORE INTO `t12` (id) VALUES (42287)
INSERT IGNORE INTO `t12` (id) VALUES (226925)
INSERT IGNORE INTO `t12` (id) VALUES (226926)
INSERT IGNORE INTO `t12` (id) VALUES (35552)
INSERT IGNORE INTO `t12` (id) VALUES (226927)
INSERT IGNORE INTO `t12` (id) VALUES (2126)
INSERT IGNORE INTO `t12` (id) VALUES (23369)
INSERT IGNORE INTO `t12` (id) VALUES (10986)
INSERT IGNORE INTO `t12` (id) VALUES (11082)
INSERT IGNORE INTO `t12` (id) VALUES (125658)
INSERT IGNORE INTO `t12` (id) VALUES (43306)
INSERT IGNORE INTO `t12` (id) VALUES (226928)
INSERT IGNORE INTO `t12` (id) VALUES (32240)
INSERT IGNORE INTO `t12` (id) VALUES (24409)
INSERT IGNORE INTO `t12` (id) VALUES (5115)
INSERT IGNORE INTO `t12` (id) VALUES (34907)
INSERT IGNORE INTO `t12` (id) VALUES (40295)
INSERT IGNORE INTO `t12` (id) VALUES (8711)
INSERT IGNORE INTO `t12` (id) VALUES (34178)
INSERT IGNORE INTO `t12` (id) VALUES (25763)
INSERT IGNORE INTO `t12` (id) VALUES (12465)
INSERT IGNORE INTO `t12` (id) VALUES (7930)
INSERT IGNORE INTO `t12` (id) VALUES (226929)
INSERT IGNORE INTO `t12` (id) VALUES (13771)
INSERT IGNORE INTO `t12` (id) VALUES (37028)
INSERT IGNORE INTO `t12` (id) VALUES (17895)
INSERT IGNORE INTO `t12` (id) VALUES (226930)
INSERT IGNORE INTO `t12` (id) VALUES (24788)
INSERT IGNORE INTO `t12` (id) VALUES (10369)
INSERT IGNORE INTO `t12` (id) VALUES (21566)
INSERT IGNORE INTO `t12` (id) VALUES (15322)
INSERT IGNORE INTO `t12` (id) VALUES (40602)
INSERT IGNORE INTO `t12` (id) VALUES (226931)
INSERT IGNORE INTO `t12` (id) VALUES (19659)
INSERT IGNORE INTO `t12` (id) VALUES (38505)
INSERT IGNORE INTO `t12` (id) VALUES (226932)
INSERT IGNORE INTO `t12` (id) VALUES (72308)
INSERT IGNORE INTO `t12` (id) VALUES (37101)
INSERT IGNORE INTO `t12` (id) VALUES (125543)
INSERT IGNORE INTO `t12` (id) VALUES (5859)
INSERT IGNORE INTO `t12` (id) VALUES (68455)
INSERT IGNORE INTO `t12` (id) VALUES (31077)
INSERT IGNORE INTO `t12` (id) VALUES (226933)
INSERT IGNORE INTO `t12` (id) VALUES (226934)
INSERT IGNORE INTO `t12` (id) VALUES (226935)
INSERT IGNORE INTO `t12` (id) VALUES (37705)
INSERT IGNORE INTO `t12` (id) VALUES (9713)
INSERT IGNORE INTO `t12` (id) VALUES (226936)
INSERT IGNORE INTO `t12` (id) VALUES (226937)
INSERT IGNORE INTO `t12` (id) VALUES (226938)
Query Metrics
Query-Size:162Query-Depth:1
Errors and Warnings
Some use of "<nowiki>[[</nowiki>" in your query was not closed by a matching "]]".during techniqueSome use of "[[" in your query was not closed by a matching "]]".
Frequency of fighting positions in entry techniques
before technique
during technique
after technique
Frequency of fighting positions in transition techniques
before technique
during technique
after technique
Frequency of fighting positions in end techniques
before technique
during technique
after technique