Semantic search
Debug output SQLStore
ASK Query
[[:+]] [[Page length::>>200]]
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_object_ids` AS t2
INNER JOIN
`wiki_smw_ftp_sesp_pagelgth` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0
AND (
(t3.o_sortkey>'200')
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
RAND()
LIMIT
505
OFFSET
12
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_object_ids` AS t2
INNER JOIN
`wiki_smw_ftp_sesp_pagelgth` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0
AND (
(t3.o_sortkey>'200')
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
RAND()
LIMIT
505
OFFSET
12
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | range | s_id, o_sortkey | o_sortkey | 9 | 1127 | Using index condition; Using temporary; Using filesort | ||
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | anotherwiki2.t3.s_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | anotherwiki2.t3.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None- The Otherkin Haven
- The New Kin
- GTA Otherkin
- Tribe of Fur
- Switchy
- Stockholm Howl
- There's weird, and then there's Otherkin
- Littles
- Southern Oregon Vampires
- Hybrid vampire
- Shadow Wolf
- Theriomythic
- /forfictionkin
- Co-fronting
- Berserker shift
- An Interview With An Otherkin
- Nethmeren
- Faeid (LJ)
- Calikinia
- Las Vegas Spirituality Meetup Group (HOKS)
- Otherlimb
- Vampires
- Angels
- Andrastai
- My Weekend At A Furry Convention
- The Kin Cafe
- Doctors Herding Cats: The Misadventures of Modern Medicine and Psychology with NonHuman Identities
- MechHaven
- Motley's House of Kin
- Blood junkie
- Angrian Pack
- Otherkin Greet n Meet!
- Voori
- List of Otherkin Media Appearances
- The Veil’s Edge: Exploring the Boundaries of Magic
- Indiana Otherkin
- Gwai
- El'Kariel
- Otherkin, We are here to stay
- FAE Retreat
- Therianthropy (G+)
- 'Otherkins' Special
- El
- Nes'tai
- Vampyre Donor Group
- Otherkin Code
- Ceshtanen
- Nature & the Unseen Realms with the Elves & otherkin. A spiritual journey
- Real Vampires
- Otherkin
- Coming Out of the Wardrobe
- Dorai
- AFSWATTF
- PluralKin
- Plant Otherkin
- The Key to the Otherkin
- Always Believe
- Sanguinarius Group Chat
- Otherkin: A Short Introduction
- Vampdar
- The Therians of Colorado
- Dragonkin (Short Story)
- Are
- aWere Otherkin Forum
- Therians & Otherkin
- Blend-a-kin
- Vampires and Donors
- Ageless
- Otherkin Resource Center
- Wulf Howl Forum
- Alardan
- Therians and OtherKin
- Walk-ins
- Sadrethe
- Black Swan Haven
- Haven of Kindred Spirits
- Boomshift Community Forum
- Enrai
- Citrakayah
- Ciaren
- Vampire Community Message Board
- Jarandhel
- Honey, I think I’m a cat
- Experimental Disposable Mythic Channel
- The Gathering
- Therian Dojo
- Adult Dragonkin
- Cenlish
- Forty-Foot Winged Reptiles Need Your Love, Too
- Til'Quintas
- Wolf Therians, UK
- Spirits of the Wild
- Virginia Vampire/Donor Connection
- Cencan
- TheLostWay
- Everyday Otherkin
- Northern Virginia Otherkin Meetup
- Animal Folk
- Space Elves (OKN)
- Tulari
- Ethereal Forest (IRC)
- A Vampire's Life? It's Really Draining
- Evrantilen
- OtherkinReiki
- Elen
- Krenar Dragon
- Llewyn
- Vampires, Therians & Otherkin (G+)
- A Quest for Dragons
- Thirst
- VampireRealm (IRC)
- Demons, fallen Angels, otherkin
- Cybertroniankind
- Sanguine Pack - New England Chapter
- Winged Chat
- Vampires in Central Florida? (Part III)
- The Beacon
- Enta
- VorjenHunting
- Dragonkin-Group
- Vampire Discussion
- Alaska Vampire/Donor Connection
- The Ivory Tower
- Blood drinker
- Manti Te'o Hoaxer's Female Cousin May Have Posed As Fake Dead Girlfriend
- SoCal Therian And Otherkin Community
- Therian Wiki
- Krenar
- Therian and proud
- Fairies and Elves Trapped in Human Form
- Draestari
- Coming Out of the Coffin
- The Dragons
- Vampire House Of Ireland
- TheDarkEricDraven
- Otherkin and theriken pack
- VampsOK
- Tricities Otherkin Meetup
- The Crimson Coven of Real Vampires
- Spiritual (IRC) (Furnet)
- Children of the Varda
- Vampire bait
- Emotional vampire
- Gae'ari
- Polykin
- Washington DC - House Eclipse
- Eden Fire
- International Vampiric And Otherkin Alliance (IVOA) (FB)
- Art-of-the-Therians
- London Vampire Meetup Group
- Christian Therianthropy
- Eliai'iriai
- Michigan Vampires
- Otherkin Hispano (Web)
- Fox
- DarkAsia
- Alfandria
- Eren'rai
- Vampires (IRC)
- Elder
- Christian Otherkin
- Sel'ar
- FurryFelines
- The Sydney Vampires Meetup Group
- Teylan
- Polytherian
- The Corruption
- Louisiana Creole Vampire Haven
- En
- Therian Thoughts
- Draconity (OKN)
- Sanguine Pack - Washington DC-TriState Chapter
- Roleplayer
- The Chicago Vampire Meetup Group
- Tristate Otherkin
- Therian Wilderness
- WoW, a new religion?
- Vampyre Support & Information Society
- Dark Sanctuary
- Entry Level: Otherkin
- Otherkin News Mirror
- Swanblood
- Antelope Valley Otherkin
- Hae Hanae-Sa
- The Non-Human Soul
- KinGatheringForum
- 0therkin-ny
- POWERS UMT
- Eldari
- My Life as a Therian
- Otherkin Village
- Otherhaven (G+)
- Gate
- Ohio Vampire, Otherkin, & Goth Alliance
- Therian Wildland
- Therianthropy/Териантропы
- Tucson Otherkin
- Wannabe
- SF Bay Otherkin Meetup
- Shapeshifters
- Soulbond (Otherkin)
- Glamourbombing
- Brinn
- Glamour Bomb
- Otherkin News
- Therian/Otherkin of Central Florida
- Therians United Club
- Therians-Otherkins
- Dragons
- Interview with Dr. Coral Hull
- Student profile: being an 'otherkin' at Knox
- Kin of Kemet
- Appalachians Howl Meetup
- Ibland får jag lust att yla som en varg
- Kin Crafts
- Otherkin Wiki (Miraheze)
- Wolfie Blackheart
- Otherkin and the Pagan community
- Draconity.org
- Smoke and Mirrors
- Therian (FB)
- Castle Otherkin
- AwakeAndDrink
- Alfandria (LJ)
- Kin Food
- Therian-Kingdom
- Colorado Otherkin and Therian Meetup
- Ohio Vampyres and Other Kin
- Sanguinarian
- Oniya
- Lostkin Project
- Maine Vampyres and Otherkin
- /AngelkinChat
- Otherkin and magical folk
- Otherkin Greet n Meet
- The Lupa Liturgy
- Arch Regional Furries
- Co-aware
- Classical vampire
- The Elfinkind Digest
- South-Eastern Animal-kin, Otherkin, Therians
- Helath
- Main Page
- Vampire Community News
- Children of the Moon
- The Obsidian Spire
- Alvan’diel
- Dragon Otherkin (G+)
- Otherkin (IRC) (Furnet)
- Mid-Continuum
- Portland Vampire Meetup
- Real Vampires of Houston Meetup
- Daemonkin (Otherkin)
- WestKin
- Texas Furry
- Acheyla
- Otherkin (IRC) (Wolfnet)
- A Cozy Home
- Emerging Vampires
- Des'eren
- Otherkin.net: Harmony & Discord
- Displaced Souls
- Otherkin Wiki
- Real Vampires and Donors
- Summer Gateways
- OtherCreatures (IRC)
- (Wolf) Therianthrope/Lycans/Were-creatures
- 3lvz
- Otherkin of Illinois
- WSI OtherkinAssociation
- Energy vampire
- Desh'ketai
- Kentucky Vampires and Donors
- Gwairoch
- Cyber-Verse
- Fictionkin
- Akron Sanguinarian Network
- Midwest Weres
- Portland Vampire Group
- Vampires Today: The Truth about Modern Vampirism
- Tumblrkin
- The Magic Division of Otherkin
- For the Others
- TrueForms Spirituality: VampyreSpace
- Orion Scribner
- Inner World
- Ja nevnay
- The Therians of Washington
- Split
- Open Paws
- UrbanPanther
- Otherkins Therians Vampyre u.ä.
- Clinical vampirism
- Southern California Otherkin
- Occupy.Otherkin
- Logical Otherkin Network
- Emotional-Dragons
- KinSpot
- Elven Realities
- Other Writings
- Posthum/an/ous: Identity, Imagination, and the Internet
- Animal-Inside-Us
- Dreamhaven
- Fae
- Kiwi Vamps
- Do we Always Practice What we Preach? Real Vampires’ Fears of Coming out of the Coffin to Social Workers and Helping Professionals
- Doulgen'ra
- Phytanthrope
- Wolf Therians
- Awere
- Portland Elf Kin Gathering
- LostHaven
- Dragon Runes
- UK Otherkin
- S.F. Bay Area Otherkin Society
- Fluff Piece
- Mundanes
- Akron Psi Vampire Network
- The Yokai Shrine
- Otherkin not so Other
- Portland OtherKin
- Chairen
- Blood doll
- Rocky Mountain Fur Con 2009
- Kitsune (G+)
- Kin Fashion
- Otherkin Photography: Being Human
- Otherkin (FB) 2
- Australian Therian/Otherkin
- Angrian Family
- Dark Otherkin
- Autovampirism
- Vampyre Beacon
- Haran
- The Dictionary of Vampspeak
- The Therian Guide
- Therianthropists and OtherKin Community Journal
- Sourcefire
- Faeidism
- Tyrian
- Theriotype
- Ohio Kin
- Otherkin (FB) 3
- Forest Horizon
- Great British Therians (and Otherkin)
- Present Day Vampires
- Latent vampire
- Clarash
- Cancan
- TheriansONdA
- Shift
- Ο Μαγικός Κόσμος των Otherkins
- Cirque du Nuit
- Place of the Fairies!
- Austin Draconics/Otherkin
- Merka-tha lien
- Vampire & Donor Connections Hub
- Gender-shifting
- Evil Eye
- Finding 'Verse
- Nethmeri
- The Life Aquatic
- Age-sliding
- KithKen
- Werelist
- C'lishlish
- Sanguine Pack - UK Chapter
- Nonhuman Quotes
- Fed up and annoyed therians 18+
- Vampire & Swan Meetup of Greater St. Louis
- Therian Connect
- Otherkin.com
- Otherkin (IRC) (synIRC)
- Therianthropy (G+) (Shiro)
- Therians
- UK Real Vampires and donors
- Blood bond
- Dreamhart.org
- The Internet Goes Mythic
- Collect-a-kin
- Canadian Collaborative Vampire & Otherkin Alliance
- Transcats
- TheriansofTheWorld
- Fictherian
- List of Active Otherkin Message Boards
- Howl
- Oklahoma Furs, Otherkin, and Therians
- Kai
- Otherkin (Mailing List)
- Colorado Kin
- Alt.Horror.Werewolves
- Boston Otherkin Gathers
- Kinmunity
- Otherkin speak past the grave
- Therian/Otherkin-Human Alliance
- Vampires in Virginia
- The Reincarnation Theory of Otherkin
- From the Stars
- The Therian,Otherkin Connection
- Therian Union
- Hybrid-Kin
- Wulf Howl
- Sympathetic vampirism
- Alorya
- To Some Conversion, To Others Perversion: How Are You a Pagan?
- Greymuzzle
- Kin Speak
- Host
- Glamourbombs
- Ceshar
- Otherkin Awakening via Reiki
- PrideKin
- How To Date A (Real-Life) Vampire
- Otherkin Compendium
- The Wild Lands
- Otherkin – dziwactwo czy fantastyczny sposób na życie?
- Great Lakes Area Otherkin
- I Think I'm An Animal
- TorontoKin
- TherianIndiana
- Ceshcan
- The VICE Guide to Voting - Otherkin
- Shifting Hearts
- Tampa Vampire Meetup
- Black Roses
- Unmaking
- Dan (troll)
- Vaurkala
- Therian.net (IRC)
- MAP Multiple Animal Personalities
- Fashion vampire
- House Kheperu Gather
- British Republic Alliance of Vampires & Otherkin
- House
- Kitsuhana (IRC)
- Vampkin
- OtherkinPride
- Teens Admit to Trolling Tumblr: JK, There’s No Such Thing as Transethnic Autistic Pangender Asexual Demiromantic Otherkin
- Otherkin (LJ)
- Unknown Forest
- Poser
- Starseeds
- Northwest Kin
- Otherkin (G+)
- Embracing Mystery
- Endrastai
- Haven of Vampyres
- DA-Therians
- Psyvamps
- AsianKin
- My Otherkin Headmate is a Two-Spirited Starseed
- Violets Are Blue may turn Baltimore's readers blue, too
- Tanaii
- Real Vampires (TN)
- Black swan
- Feed
- Mystic Hall
- Therian Discovery Chat
- TuathadeDanaan
- HowlNET
- Ceshen
- Vampire math doesn't add up
- Why be human when you can be otherkin?
- Rock Island Vampire Meetup
- Dream shift
- ShadowLore Summer Gathering
- TeenWolfies
- Des'tai
- Portland, OR, Elfkin Gathering
- Myhidr
- Setians
- Psychicvampireorg (IRC)
- Arkansas Real Vampires
- Blood fetishist
- From Otherkin to Transethnicity: Your Field Guide to the Weird World of Tumblr Identity Politics
- Bian za ri!
- Monthly Meet and Greet Lunch
- Seattle Dragons
- Incomprehensibles
- Otherkingazette
- Next of Kin
- Heaven and Hell
- The New Goth and Vampyre Alliance (GVA)
- SphynxCat's Real Vampires Support Page
- Therians and Otherkin
- Betwixt and Between
- Naia Ōkami
- Trigger
- Dreamhart (IRC)
- South Africa vampire and donors
- Drink Deeply and Dream
- Canan
- Janda'hai
- Ceshai
- The Kindred
- Ashtae
- /faekin
- Moon howlers wolf therian pack
- Vampyrian templeuvup
- Detroit Area Vampire Community