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=8007)
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 | 139 | 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
GRIGG Katie, GROß Claudia, GUERRIERI Federico, GUIDO Roberta, HAMMERSTEIN David, HARVIE Jamie, HAVIE Jamie, HELFRICH Silke, HOVVER Elona, HUCKLE Steve, HUNT Elizabeth, JANSEN Amanda, JERRAM Sophie, JUAREZ David, KARTOUS Bohumil, KATELBACH Tibor, KATRINI Eleni, KHONSARI Torange, KICHLER Nikolas, KIMMEL Jens, KOULOUKAKIS Dimitris, KOVANEN Sunna, KRAUSZ Nicolas, KRIKORIAN Gaelle, LECAILLE Julien, LEVA Federico, LOESCHMANN Heike, LONZANO BRIGHT Carmen, LOPEZ Iñaki, LORRAIN Ann-Catherin, MARTINEZ Rubén, MAYOT Philippe, MEIXIDE Andreu, MEYER Camille, MIRANDA Ana, MOEBUS Katharina, MONTERO Eduardo, MUUKKONEN Marita, NALPAS Dominique, NIAROS Vasilis, O'SIOCHRU Emer, PAIRET Martin, PANAYOTIS Antoniadis, PAPADIMITRIOU Christos, PATERSON Andrew Gryf, PATTI Daniela, PEDERSEN Martin, PETCOU Constantin, PETRESCU Doina, PIM Joám Evans