Semantic search
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, t4.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=19630)
AND (t4.p_id=19652)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
55
OFFSET
20
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 103 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | jcastle_smw2021_prod.t1.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, p_id, p_id_2, s_id_2 | s_id_2 | 8 | jcastle_smw2021_prod.t1.s_id, const | 1 | Using index |
Query-Depth:0
Sep 9, 2022
ART Update 2022 Part 4
Sep 8, 2022
ART Update 2022 Part 3
Sep 5, 2022
ART Update 2022 Part 2
Sep 4, 2022
ART Update 2022 Part 1
Jun 26, 2022
Kyoto Castles Update
Jun 11, 2022
Minowa Castle and Ina Yashiki
Jun 4, 2022
Okinawa Castle contributions from RaymondW
May 30, 2022
13 new castle contributions from ChrisG
Apr 2, 2022
31 new contributions from ART
Mar 30, 2022
Nagano Castle Update from ART Part III
Mar 19, 2022
Nagano Castle Update from ART Part II
Feb 28, 2022
Nagano Castle Update Part I from ART
Feb 19, 2022
Autumn 2021 Castle Travels
Feb 15, 2022
Spambots and a little rant
Feb 6, 2022
Pre Edo Period Castles of Edo
Jan 17, 2022
Summer 2021 Castle Travels Update
Jan 5, 2022
Spring 2021 Castle Travels
Dec 28, 2021
20 New Samurai Homes by ART
Oct 1, 2021
26 New Nagano Prefecture Castle from ART
Sep 25, 2021
32 Kansai Castle Profiles by ART
Sep 23, 2021
20 Chubu Region Castle Profiles from ART
Sep 17, 2021
18 New Castle Profiles from ART
Aug 23, 2021
Server Migration
Apr 18, 2021
Edo Castle Stone Quarries Feature published
Jan 31, 2021
Northern Tohoku Castle Tour
Jan 26, 2021
Southern Tohoku Castle Trip Update
Jan 24, 2021
15 New Castles from ART
Jan 17, 2021
Kanazawa Castle Komatsu Castle and Ritsuunkyo (Takeda Castle)
Jan 16, 2021
34 New Nagano Prefecture Castle Profiles from ART
Dec 11, 2020
44 new castle profiles from ART
Dec 7, 2020
17 new castle profiles and 14 samurai residences from ART
Aug 31, 2020
Hishakuyama Castle, Hikobe Yashiki, Teusuyama Fort
Aug 23, 2020
4 Castle Hike in Gunma (Takasaki)
Aug 21, 2020
3 new castles and 2 yakata in Saitama
Aug 17, 2020
Ogyu Castle, Matsudaira Castle, Koromo Castle, Sakura Castle in Toyota City (Aichi Pref.)
Aug 10, 2020
3 Castles and 5 Forts Of Okehazama
Aug 5, 2020
Odawara Castle Profile Renewed
Jul 25, 2020
Asuke Castle, Nagoya Castle, Okazaki Castle Profiles Renewed
Jul 19, 2020
Ogaki Castle, Gifu Castle and Kano Castle Updated
Jul 7, 2020
6 new Tokyo area castles
Jul 1, 2020
Fortified Manors on Jcastle.info and 24 new profiles from ART
Jun 28, 2020
56 New Nagano Prefecture Castle Profiles by ART
Jun 24, 2020
Renewed Hikone Castle and Takatori Castle
May 31, 2020
Sasou Castle and Sawayama Castle
May 23, 2020
Added 3 castles in Tochigi: Nishikata Castle, Manago Castle, Nijo Castle
May 18, 2020
Gochaku Castle, Miyao Castle, Iwakuni Castle
May 16, 2020
Himeji Castle Profile Renewed
May 3, 2020
Iwadono Castle, Katsuyama Castle, Yamura Castle
May 2, 2020
30 new profiles for Nagano Castle by ART
Apr 29, 2020
Hamamatsu Castle, Futamata Castle, and Tobayama Castle Pages Renewed