Semantic search
From OHO - search engine for sustainable open hardware projects
Debug output SQLStore
ASK Query
[[Category:Recycling]]
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
140
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
140
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 26 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | oho_wiki_en.t2.id | 13 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | oho_wiki_en.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (1090).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=1090 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None
The craftsman: Homemade cable stripper.
Homemade cable stripper.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
This is a short video of my homemade can crusher
It seems to get the job done.
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Trimming paper baling machine homemade cardboard baler
TCM BALER: http://www.tcmbaler.com/ TCMBALER is a professional hydraulic baler machine manufacturer and supplier in China ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
WOOD CAN CRUSHER with plans perfect project for the novice woodworker easy first project
Diy wooden
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Waste and Construction Debris Removal and Steel Container Rental in Rocky Mount, NC
Waste and Construction Debris Removal and Steel Container Rental in Rocky Mount, NC Give Jimmy Tanner a call at ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown
Wooden construction waste shredder machine
this is double shaft shredder machine,the type double shaft shredder machine can shredder all of waste in the life or in the ...
Contains PDF Blueprints: No
Contains CAD Files: No
License: unknown