Recherche sémantique
De Wicri Lorraine
Debug output SQLStore
ASK Query
[[A pour pays partenaire de projet européen::Royaume-Uni]]
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1129' AND t1.o_id='2764')
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
50
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1129' AND t1.o_id='2764')
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | 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 | 96 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | WicLorraineFr.t1.s_id | 1 | 50.01 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneTitre | |
---|---|
LEUKOTREAT | Development and laboratory testing of improved action and Matrix hydro turbines designed by advanced analysis and optimization tools |
LIAISON | LocatIon bAsed servIceS for the enhancement of wOrking enviroNment |
LOWCAFF | Low Carbon Future Fuels |
M4CO2 | |
MASTER | |
MEALS | Mobility between Europe and Argentina applying Logics to Systems |
MEDOANET | Mediterranean Open Access Network |
MOBI-KIDS | Risk of brain cancer from exposure to radiofrequency fields in childhood and adolescence |
MULTISWARD | |
NANOINTERFACE | Knowledge-based multi-scale modelling of metal-oxide-polymer interface behaviour for micro- and nanoelectronics |
NECST | Networked control systems tolerant to faults |
NEUROCHEM | Biologically inspired computation for chemical sensing |
NOVELTREE | Novel tree breeding strategies |
PEPT-FLOW | Innovative polymer flow visualisation for optimised machine design, improved mixing and material properties, process efficiency and energy reductions |
PERMED | Personalized Medicine 2020 and beyond – Preparing Europe for leading the global way |
PETRUS II | Towards an European training market and professional qualification in Geological Disposal |
PETRUS III | |
POWER-OM | |
PROARTIS | Probabilistically Analysable Real-Time Systems |
PROMINE | Nano-particle products from new mineral resources in Europe |
QUALIREDFRUITS | New agricultural practices for quality production of red fruits enriched in healthy compounds |
QUIESST | Quietening the environment for a sustainable surface transport |
RECOSY | Redox phenomena controlling systems |
RED CAT | Natural products and related redox catalysts: basic research and applications in medicine and agriculture |
RESSEEPE | |
RESTAR | |
ROBCRANE | |
SAFESCIMET | European Modular Education and Training Programme in Safety Sciences for Medicines |
SAFETY-INDAL | |
SAM.SSA | Sugar Alcohol based Materials for Seasonal Storage Applications |
SANY | Sensors Anywhere |
SECUREAU | Security and decontamination of drinking water distribution systems following a deliberate contamination |
SECURECHANGE | Security engineering for lifelong evolvable systems |
SHOPINSTANTSHOE | Development of a cost-effective footwear based on shape memory materials to provide an instant fitting personalization service at the retail shop for enhancing user's comfort |
SMARTCELL | Rational design of plant systems for sustainable generation of value-added industrial products |
SPIDER | Statistical Physics in Diverse Realisations |
STOICISM | |
SWAN | Save Water and Attend Nature |
SWIFT-WFD | |
T-REX | |
TAMER | |
THERADPOX | Optimised and novel oncolytic adenoviruses and pox viruses in the treatment of cancer: Virotherapy combined with molecular chemotherapy |
THERMOMAG | Nanostructured energy-harvesting thermoelectrics based on Mg2Si |
TIMMO-2-USE | |
UNIPACK | Universal Failsafe IGBT Package for robust power transmission |
UNIVERSELF | UNIVERSELF |