Recherche sémantique
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
`wiki_smw_object_ids` AS t0
INNER JOIN
`wiki_smw_di_wikipage` AS t1 ON t0.smw_id=t1.o_id
WHERE
(t1.p_id=8004)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | o_id, p_id, o_id_2, o_id_3 | p_id | 4 | const | 185 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | remix_wiki.t1.o_id | 1 | Using where |
Query-Depth:1
Fondation Rosa Luxembourg, Fondation Terre Solidaire, Foundups, Fribourg, GALLECO Complementary Currency, Gazibo, Goteo, Greek Telecomunication Organization, Green, Guerrilla Translation, Haut Béarn, Heinrich Boell Foundation, Heinrich-Böll-Foundation, Hub of Transition Network, Hungarian Contemporary Architecture Centre, IASC, ICCA Consortium, Iniciativa Comunales, Institute for a Sustainable Future, Institute for Solidarity Economics, Institute of Govern and Public Policies at Autonomous University of Barcelona, Instituto Universitário de Lisboa, Interdisciplinary Research Institute on Social Issues (IRIS), International Federation of the Phonographic Industry, Kultura Nova, La Coop des Communs, La Hidra Cooperativa, La municipalité de Rotterdam, La région Nord Pas de Calais, La ville d'Unieux (42), La ville de Bordeaux, La ville de Clichy Sous-Bois, La Ville de Lons-le-Saunier, La ville de Madrid, La ville de Metz, La ville de Montpellier, La ville de Munich, La ville de Saint Etienne, Labsus, LABSUS - Laboratorio per la sussidiarietà, Landes du Mené, Le département de Saône-et-Loire, Legambiente, Letting Space, Lille, Macao, Mairie de Naples, Maisons d’Isatis, Montataire, Montpellier