Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Equipment]]
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
"smw_object_ids" AS t0
INNER JOIN
("smw_fpt_inst" AS t1
INNER JOIN
"t2" AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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
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
"smw_object_ids" AS t0
INNER JOIN
("smw_fpt_inst" AS t1
INNER JOIN
"t2" AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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
SQL Explain
Limit (cost=1820.09..1820.22 rows=55 width=86)
└── Sort (cost=1819.96..1836.26 rows=6521 width=86)
Sort Key: t0.smw_sort
└── HashAggregate (cost=1503.23..1568.44 rows=6521 width=86)
Group Key: t0.smw_sort, t0.smw_id, t0.smw_title, t0.smw_namespace, t0.smw_iw, t0.smw_subobject, t0.smw_sortkey
└── Merge Join (cost=932.88..1199.78 rows=17340 width=86)
Merge Cond: (t1.o_id = t2.id)
└── Sort (cost=753.10..756.50 rows=1360 width=90)
Sort Key: t1.o_id
└── Hash Join (cost=42.99..682.31 rows=1360 width=90)
Hash Cond: (t0.smw_id = t1.s_id)
└── Seq Scan on smw_object_ids t0 (cost=0.00..560.51 rows=6521 width=86)
Filter: ((smw_iw <> ':smw'::text) AND (smw_iw <> ':smw-delete'::text) AND (smw_iw <> ':smw-redi'::text))
└── Hash (cost=23.55..23.55 rows=1555 width=8)
└── Seq Scan on smw_fpt_inst t1 (cost=0.00..23.55 rows=1555 width=8)
└── Sort (cost=179.78..186.16 rows=2550 width=4)
Sort Key: t2.id
└── Seq Scan on t2 (cost=0.00..35.50 rows=2550 width=4)
└── Sort (cost=1819.96..1836.26 rows=6521 width=86)
Sort Key: t0.smw_sort
└── HashAggregate (cost=1503.23..1568.44 rows=6521 width=86)
Group Key: t0.smw_sort, t0.smw_id, t0.smw_title, t0.smw_namespace, t0.smw_iw, t0.smw_subobject, t0.smw_sortkey
└── Merge Join (cost=932.88..1199.78 rows=17340 width=86)
Merge Cond: (t1.o_id = t2.id)
└── Sort (cost=753.10..756.50 rows=1360 width=90)
Sort Key: t1.o_id
└── Hash Join (cost=42.99..682.31 rows=1360 width=90)
Hash Cond: (t0.smw_id = t1.s_id)
└── Seq Scan on smw_object_ids t0 (cost=0.00..560.51 rows=6521 width=86)
Filter: ((smw_iw <> ':smw'::text) AND (smw_iw <> ':smw-delete'::text) AND (smw_iw <> ':smw-redi'::text))
└── Hash (cost=23.55..23.55 rows=1555 width=8)
└── Seq Scan on smw_fpt_inst t1 (cost=0.00..23.55 rows=1555 width=8)
└── Sort (cost=179.78..186.16 rows=2550 width=4)
Sort Key: t2.id
└── Seq Scan on t2 (cost=0.00..35.50 rows=2550 width=4)
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (9784).
SELECT s_id FROM "smw_fpt_subc" WHERE o_id=9784 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneItem wiki page | Name | Subcat | Location | Owner | Maintainers | Training required? | ACnode locked? | Status | Last updated"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>. | Last updated by"Last editor is" is a predefined property that contains the page name of the user who created the last revision and is provided by <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>. |
---|---|---|---|---|---|---|---|---|---|---|
Jones-Shipman arbor press | Jones-Shipman arbor press | Defunct | Metalshop | Friend of Michael Trew | No | Defunct | 17 January 2022 11:58:47 | |||
LHS Gantry Induction | 19 November 2017 18:54:52 | |||||||||
Linisher metal | Metal Linisher (RJH) | Metalworking | Cage | Artag | Metalshop team | No | No | Good working order | 21 January 2022 13:18:35 | |
Lulzbot Mini | Lulzbot 1 (Hull) | CNC | 3D printer area, Ground floor | Hackspace | Yes | Yes | Https://london.hackspace.org.uk/members/tools.php Check the Tools Status Page | 21 February 2022 13:37:43 | ||
Lulzbot Mini Flexystuder | 11 August 2019 13:44:15 | |||||||||
Marshall Dynabolt 250 Amp AC/DC Tig Welding Set | TIG Welding Set (Marshall Dynabolt) | Metalworking | Metalworking shop | Hackpace | Tim, Des, Dean, Liam | Yes | No | Good working order | 1 September 2022 09:39:25 | |
Meddings Pillar Drill | Pillar Drill (Meddings) | Metalworking | Metalworking shop | Metalshop team | No | No | Good working order | 20 January 2022 18:42:40 | ||
MightMIG 190 | MIG Welding Set (Sealey MightyMIG 190) | Metalworking | Metalworking shop | Tim, Des, Dean, Liam | Yes | No | Good working order | 1 September 2022 09:38:52 | ||
Pedestal disc sander | Startrite pedestal disc sander | Defunct | Ground Floor, Woodshop | No | Defunct | 19 January 2022 12:16:06 | ||||
Pick-and-Place | Charmhigh CHM-T36VA Pick-and-Place Machine | Fabrication | Murder Kitchen | Yes | Yes | Working | 12 May 2022 10:00:01 | |||
Polishing Machine | Polishing Machine (Modified Union Lathe) | Metalworking | Cage | Metalshop team | No | No | Good working order | 4 May 2022 07:17:34 | ||
Propane + Air Torch (Flamefast T4) | Propane + Air Torch (Flamefast T4) | Metalworking | Metalworking shop | Torch owned by space, regulators on long term loan from Toby Molyneux (HS32098) | Toby Molyneux | Yes | No | Good working order | 6 April 2022 07:10:17 | |
Propane Torch (Sievert) | Propane Torch (Sievert) | Metalworking | Cage | Metalshop team | No | No | Good working order | 6 April 2022 07:21:41 | ||
Router Table | Router Table | Woodworking | Woodshop | No | No | Good working order | 6 May 2022 11:04:42 | |||
User:Sci | Sci's page | Unknown | Unknown | Unknown | Unknown | Unknown | Unknown | 28 May 2013 18:54:16 | ||
Silvertail A0 Laser Cutter | Silvertail A0 Laser Cutter | CNC | Ground Floor, Metal Workshop | LHS | Padski, YetiFiasco, Russ | Yes | Yes | Https://london.hackspace.org.uk/members/tools.php View tool status | 10 October 2022 18:00:37 | |
SMD Stencil Print Frame | SMD Stencil Print Frame | Murder Kitchen | Yes | Unknown | 12 May 2022 09:58:44 | |||||
Startrite Bandsaw | Bandsaw (Startrite) | Defunct | Wood shop | Woodshop team | Yes | Yes | Defunct | 7 March 2022 14:03:16 | ||
Stationary Dust Extractor | Stationary Dust Extractor | Woodworking | Wood shop | Woodshop team | No | No | Good working order | 8 August 2022 17:08:08 | ||
Stick Welder (GCE) | Stick Welder (GCE) | Defunct | Cage | Metalshop team | Yes | No | Defunct | 14 December 2022 08:45:24 | ||
TEST | TEST | No | Unknown | 8 July 2022 07:17:43 | ||||||
Test2 | Test | Test | Test | Test | Test | No | Yes | Unknown | 10 March 2022 08:07:29 | |
Triton Thickness Planer | Thickness Planer (Triton) | Woodworking | Wood shop | Woodshop team | No | No | Good working order | 8 August 2022 11:43:58 | ||
Viceroy-Pillar-Drill | Viceroy Pillar Drill | Defunct | Metalworking shop | No | No | Out of order | 20 January 2022 18:44:15 | |||
Viceroy Sharpedge | Viceroy Sharpedge tool grinder | Defunct | Middle Workshop | Dean Forbes (Long Term Loan) | Yes | Defunct | 17 January 2022 15:05:35 | |||
Wood Lathe | Wood Lathe (Myford) | Defunct | Wood shop | Hackspace | Jonathan Hodgson | Yes | Yes | Defunct | 7 March 2022 14:04:46 | |
Wood Lathe (Nova DVR XP) | Wood Lathe (Nova DVR XP) | Woodworking | Wood shop | Jonathan Hodgson | Yes | Yes | Good working order | 7 March 2022 13:56:26 | ||
Woodworking Hand Tools | Woodworking Hand Tools Cupboard | Woodworking | Wood shop | PLAYWOOD | PLAYWOOD | Yes | No | Good working order | 11 February 2022 08:42:29 |