Project statistics

Routines: 8 Postures in routines: 404 Techniques: 154 Quan Pu: 124 Quan Pu parts: 5454

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.P2::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
  `smw_di_blob` AS t12 ON t10.o_id=t12.s_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 (
   ((t12.o_hash='118') OR (t12.o_hash='119') OR (t12.o_hash='120') OR (t12.o_hash='121') OR (t12.o_hash='122') OR (t12.o_hash='||') OR (t12.o_hash='123') OR (t12.o_hash='35') OR (t12.o_hash='126') OR (t12.o_hash='99') OR (t12.o_hash='||99') OR (t12.o_hash='44') OR (t12.o_hash='124') OR (t12.o_hash='||124') OR (t12.o_hash='||127') OR (t12.o_hash='128') OR (t12.o_hash='135') OR (t12.o_hash='||135') OR (t12.o_hash='||129') OR (t12.o_hash='130') OR (t12.o_hash='60') OR (t12.o_hash='||60') OR (t12.o_hash='||131') OR (t12.o_hash='34') OR (t12.o_hash='||34') OR (t12.o_hash='132') OR (t12.o_hash='133') OR (t12.o_hash='||133') OR (t12.o_hash='||134') OR (t12.o_hash='86') OR (t12.o_hash='||100') OR (t12.o_hash='101') OR (t12.o_hash='106') OR (t12.o_hash='117') OR (t12.o_hash='6') OR (t12.o_hash='107') OR (t12.o_hash='46') OR (t12.o_hash='2') OR (t12.o_hash='110') OR (t12.o_hash='11') OR (t12.o_hash='141') OR (t12.o_hash='12') OR (t12.o_hash='13') OR (t12.o_hash='14') OR (t12.o_hash='15') OR (t12.o_hash='16') OR (t12.o_hash='17') OR (t12.o_hash='18') OR (t12.o_hash='103') OR (t12.o_hash='20') OR (t12.o_hash='21') OR (t12.o_hash='22') OR (t12.o_hash='23') OR (t12.o_hash='9') OR (t12.o_hash='24') OR (t12.o_hash='25') OR (t12.o_hash='26') OR (t12.o_hash='27') OR (t12.o_hash='28') OR (t12.o_hash='29') OR (t12.o_hash='30') OR (t12.o_hash='31') OR (t12.o_hash='32') OR (t12.o_hash='33') OR (t12.o_hash='36') OR (t12.o_hash='37') OR (t12.o_hash='38') OR (t12.o_hash='39') OR (t12.o_hash='40') OR (t12.o_hash='41') OR (t12.o_hash='42') OR (t12.o_hash='43') OR (t12.o_hash='||45') OR (t12.o_hash='45') OR (t12.o_hash='||47') OR (t12.o_hash='48') OR (t12.o_hash='49') OR (t12.o_hash='||89') OR (t12.o_hash='50') OR (t12.o_hash='57') OR (t12.o_hash='54') OR (t12.o_hash='||90') OR (t12.o_hash='91') OR (t12.o_hash='||92') OR (t12.o_hash='||93') OR (t12.o_hash='94') OR (t12.o_hash='||95') OR (t12.o_hash='96') OR (t12.o_hash='97') OR (t12.o_hash='||98') OR (t12.o_hash='102') OR (t12.o_hash='||104') OR (t12.o_hash='105') OR (t12.o_hash='||109') OR (t12.o_hash='3') OR (t12.o_hash='||4') OR (t12.o_hash='||108') OR (t12.o_hash='||10') OR (t12.o_hash='55') OR (t12.o_hash='||1') OR (t12.o_hash='5') OR (t12.o_hash='80') OR (t12.o_hash='81') OR (t12.o_hash='7') OR (t12.o_hash='111') OR (t12.o_hash='114') OR (t12.o_hash='115') OR (t12.o_hash='||116') OR (t12.o_hash='||125') OR (t12.o_hash='125') OR (t12.o_hash='||75') OR (t12.o_hash='76') OR (t12.o_hash='77') OR (t12.o_hash='78') OR (t12.o_hash='79') OR (t12.o_hash='82') OR (t12.o_hash='83') OR (t12.o_hash='||84') OR (t12.o_hash='87') OR (t12.o_hash='88') OR (t12.o_hash='142') OR (t12.o_hash='143') OR (t12.o_hash='144') OR (t12.o_hash='145') OR (t12.o_hash='146') OR (t12.o_hash='147') OR (t12.o_hash='148') OR (t12.o_hash='149') OR (t12.o_hash='||150') OR (t12.o_hash='151') OR (t12.o_hash='152') OR (t12.o_hash='153') OR (t12.o_hash='||154') OR (t12.o_hash='51') OR (t12.o_hash='136') OR (t12.o_hash='52') OR (t12.o_hash='53') OR (t12.o_hash='56') OR (t12.o_hash='||56') OR (t12.o_hash='58') OR (t12.o_hash='59') OR (t12.o_hash='||61') OR (t12.o_hash='62') OR (t12.o_hash='63') OR (t12.o_hash='64') OR (t12.o_hash='65') OR (t12.o_hash='66') OR (t12.o_hash='67') OR (t12.o_hash='||69') OR (t12.o_hash='||70') OR (t12.o_hash='||71') OR (t12.o_hash='72') OR (t12.o_hash='73') OR (t12.o_hash='||73') OR (t12.o_hash='||74') OR (t12.o_hash=']]')
  ) AND t12.p_id=754)
  ))
  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	range	s_id, o_hash, s_id_2, p_id	p_id	262		686		Using index condition; 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.s_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

No auxilliary tables used.

Query Metrics

Query-Size:163
Query-Depth:2

Errors and Warnings

Some use of "<nowiki>[[</nowiki>" in your query was not closed by a matching "]]".

Some use of "" in your query was not closed by a matching "".

     during technique

Some 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