Semantic search
Jump to navigation
Jump to search
Query-Depth:0
SQLStore debug output
ASK Query
[[Category:Characters]]
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='699')
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
500
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
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='699')
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
500
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | const | 922 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | westadmin_heroes.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneHero name | Actor name | Character Type | Theme | |
---|---|---|---|---|
Kurt Wagner | Nightcrawler | Comic Book Nightcrawler (Voiced by Liam O'Brien) | FC | Marvel |
Kwannon | Revanche | Aya Osanai | FC | Marvel |
Kyani Kohanna | Kyn | Michael B. Jordan | OC | Original |
Kyle Porter | Fixer | Hale Appleman | OC | Original |
Kyle Rayner | Green Lantern | Harry Styles | FC | DC |
Lance Hunter | "Hunter" | Nick Blood | FC | Marvel |
Landry Lugar | SpotOp | Colin Morgan | OC | Original |
Lara Croft | Tomb Raider | Camilla Luddington (Voice) | FC | IDW |
Larry Trainor | Negative Man | Matt Bomer | FC | DC |
Laura Kinney | Talon | FC | Marvel | |
Laxmi Mallick | None | OC | Original | |
Layla Abdalla El-Faouly | Scarlet Scarab | May Calamawy | FC | Marvel |
Leena Danvers | Ballista | OC | Original | |
Lei Ling | Aero | Ju Jingyi | FC | Marvel |
Leland Owlsley | The Owl | Gary Oldman | VFC | Marvel |
Leon O'Malley | The Wolf Spider | OC | Original | |
Leonard Sibelius | Lenny the Shark | James Woods | OC | Original |
Leonardo | None | Seth Green (voice) | FC | IDW |
Leonid Kovar | Red Star | Attila Toth | FC | DC |
Leopold Fitz | None | Iain De Caestecker | AFC | Marvel |
Leslie Willis | Livewire | VFC | DC | |
Lester Colt | Doll Man | Yul Brynner | FC | DC |
Levian | None | Aaron Taylor-Johnson | OC | Original |
Lex Luthor | N/A | Billy Zane | TPC | DC |
Lia Briggs | Looker | Aine O'Gorman (the model, not the footballer) | FC | DC |
Liam Traynor | Faoladh | Kevin McKidd | OC | Original |
Lilli Remillard | None | Janja Garnbret | OC | Original |
Lily Drake | Lilith Dracul | Herself. | FC | Marvel |
Lincoln March | Owlman | Peter Weller | VFC | DC |
Lisa molinari | Coat of Arms | Kaitlyn Dever | FC | Marvel |
Lobo | The Main Man | Not sure yet. | FC | DC |
Logan Howlett | Wolverine | Comic Book Logan | MFC | Marvel |
Lois Lane | None | Erica Durance | AFC | DC |
Loki | Loki | Tom Hiddleston | VFC | Marvel |
Longshot | Longshot | Lucas Till | FC | Marvel |
Lonnie Machin | Anarky | Cameron Monaghan | VFC | DC |
Lorena Marquez | Aquagirl | Jenna Ortega | FC | DC |
Lorna Dane | Polaris | Emma Dumont | FC | Marvel |
Luca Bandoni | None | Taylor Kinney | OC | Original |
Lucas Trent | Midnighter | Jeffrey Dean Morgan | FC | DC |
Lucifer | None | FC | DC | |
Lucius Fox | None | Morgan Freeman | AFC | DC |
Lucy Blaze | Zealot | Jeri Ryan (circa 1995) | FC | DC |
Luke Cage | Power Man | FC | Marvel | |
Lunella Lafayette | Moon Girl | Amandla Stenberg | FC | Marvel |
Lydia Dietrich | Spectra | Odeya Rush | OC | Original |
Lyle Marston | La Raton | Orlando Bloom | OC | Original |
M'gann M'orzz | Miss Martian | Anyone and everyone | FC | DC |
Madelyne Pryor | None. | Rachel Evan Wood | VFC | Marvel |
Madigan Belle | Mad B, Madi B, The Chemist? I'm still working on it. Jeez. | Madison Kate | OC | Original |