Difference between revisions of "TestPage"
Warning: Parameter 1 to MapsHooks::onParserClearState() expected to be a reference, value given in /var/www/vhosts/shdenham.co.uk/httpdocs/mw/includes/Hooks.php on line 201
Warning: Parameter 1 to ExtArrays::onParserClearState() expected to be a reference, value given in /var/www/vhosts/shdenham.co.uk/httpdocs/mw/includes/Hooks.php on line 201
Warning: Parameter 1 to Cite::clearState() expected to be a reference, value given in /var/www/vhosts/shdenham.co.uk/httpdocs/mw/includes/Hooks.php on line 201
From Aktanak
| Line 6: | Line 6: | ||
| − | [[ArtefactEndDate::{{#ask:[[ArtefactPhase2::C-1]] |?ArtefactEndDate |format= | + | [[ArtefactEndDate::{{#ask:[[ArtefactPhase2::C-1]] |?ArtefactEndDate |format=debug |template=PhaseStart}}]] |
Revision as of 10:44, 26 May 2011
6800
Contents
Debug Output by SQLStore
Ask query
[[ArtefactPhase2::C-1
The date "<div style="border: 5px dotted #A1FB00; background: #FFF0BD; padding: 20px;"><h3>Debug Output by SQLStore</h3><h4>Ask query</h4><div class="smwpre">[[ArtefactPhase2::C-1" was not understood.
SQL Query
SELECT DISTINCT
t2.smw_id AS id,t2.smw_title AS t,t2.smw_namespace AS ns,t2.smw_iw AS iw,t2.smw_subobject AS so,t2.smw_sortkey AS sortkey
FROM
`mw_smw_object_ids` AS t2
INNER JOIN
`mw_smw_di_blob` AS t0 ON t2.smw_id=t0.s_id
WHERE
((t0.o_hash='C-1') AND t0.p_id='126')
ORDER BY
t2.smw_sortkey ASC
LIMIT
55
OFFSET
0
t2.smw_id AS id,t2.smw_title AS t,t2.smw_namespace AS ns,t2.smw_iw AS iw,t2.smw_subobject AS so,t2.smw_sortkey AS sortkey
FROM
`mw_smw_object_ids` AS t2
INNER JOIN
`mw_smw_di_blob` AS t0 ON t2.smw_id=t0.s_id
WHERE
((t0.o_hash='C-1') AND t0.p_id='126')
ORDER BY
t2.smw_sortkey ASC
LIMIT
55
OFFSET
0
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t0 | ref | s_id,p_id | p_id | 262 | const,const | 1 | Using index condition; Using temporary; Using filesort |
| 1 | SIMPLE | t2 | eq_ref | PRIMARY,smw_id | PRIMARY | 4 | wikidb.t0.s_id | 1 |
Auxilliary Tables Used
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
