Semantic search
From OHO - search engine for sustainable open hardware projects
Jump to:navigation, search
Debug output SQLStore
ASK Query
[[Category:Business, industry|+depth=10]]
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
0
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 332 | 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) (640).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=640 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneLoading...
- "Wanjiku" Ventilator Do It Yourself (DIY) Using a Stepper Motor ... (Desc: 09.06.2020 · https://youtu.be/eLJPc52WYo8 Making a DIY Ventilator using a stepper motor. For construction of the ventilator, we need: A piece of woodAImage: CWL.472676.1.pngTypeproject: Web)
- $1 DIY Anvil (Desc: This video will show how to make anImage: YTB.KPoSJ8kxoCs.jpgTypeproject: Youtube)
- $10 DIY Moxon Vise 2 (Desc: This video gives tips on how to make a portable MoxonImage: YTB.Im7AVjgIe64.jpgTypeproject: Youtube)
- $100 Homemade 2X72 Belt Grinder Built (Desc: This is a 2X72 beltImage: YTB.-LQLfeP1LEA.jpgTypeproject: Youtube)
- $100 Homemade Air Conditioner - DIY (Desc: It's ridiculously hot in my workshop, so I built a homemade air conditioner using a cooler, box fan, water pump, and tubing.Image: YTB.NiPLJEFRBnM.jpgTypeproject: Youtube)
- $2 do it yourself Vegetable Wash Station (Desc: If you have 2 washtubs and a drill you can make this super simple vegetable wash tub in less than 5 minutes time Waste less ...Image: YTB.1MhourvQEYk.jpgTypeproject: Youtube)
- $20 DIY counter pressure bottle filler (Desc: This shows you how to make a cheap ball lock counter pressureImage: YTB.DToygHtV1do.jpgTypeproject: Youtube)
- $200 Elevator Construction - do it yourself Elevator Materials List Provided (Desc: This was fun to build and has is incredibly useful for transferring materials and people to the second floor of our shop 10 ft above ...Image: YTB.pIvWTH8L0Fk.jpgTypeproject: Youtube)
- $3 Vegetable Washing Station Easy 30 minute DIY (Desc: This video is aImage: YTB.SJHHILcJQtc.jpgTypeproject: Youtube)
- $3 do it yourself Electric Edger (Desc: Edgers are expensive BUT in this video I will show you a clever way to cut crisp clean edges on your sidewalk or driveway with ...Image: YTB.OZ8nB7Lsvos.jpgTypeproject: Youtube)
- $4 do it yourself Welding Table Clamps (Desc: I made several $50 dog hole clamps for my CertiFlat welding table for about $4 each using Harbor Freight F-clamps and a handful ...Image: YTB.NP2wWQG1vlI.jpgTypeproject: Youtube)
- $40 Moxon Vise - Easy to build in an afternoon (Desc: A MoxonImage: YTB.2QbDh76mzCg.jpgTypeproject: Youtube)
- $40 do it yourself Sandblaster Setup (Desc: Quick video showing the first phase of our super cheap sandblasting setup. Subscribe for more how-to and other car videosImage: YTB.AQX97HlvMwY.jpgTypeproject: Youtube)
- $5 Blanket Ladder - build and free plans (Desc: Build a 6 foot blanketImage: YTB.lKpMW1E3izQ.jpgTypeproject: Youtube)
- $5 do it yourself Hot Wire Foam Cutter: 9 Steps (with Pictures) - Instructables (Desc: By in
Hey Guys, It has been a long time I have not written an instructable.
In this instructable, I will show you how to make a StyroFoam Cutter using things that are lying in your home.
I is the current flowing throw the wire and R is...Image: CWL.459352.1.jpgTypeproject: Web) - ( 1) Shop Tips: Make the gear cutter yourself (Desc: In this video, I'd like to show you how you can make a gear making cutter yourself. The principle is ...Image: YTB.iCQV 9jBKb8.jpgTypeproject: Youtube)
- (1 of 2) How to make a homemade grinding machine with recyclable material, Part One (Desc: It is a homemade grinding machine with 100% recyclable material, for small parts.Image: YTB.6YeiGWQwHtU.jpgTypeproject: Youtube)
- (1/3) Disc Grinder + Belt Sander Machine Tag build by yourself (Desc: ? Video from the Lutz to the plate + belt grinder // https://youtu.be/3y9oiWL-8Ko? NEW.WORKSTATT new possibilities.In this ...Image: YTB.i1eSi06HXYk.jpgTypeproject: Youtube)
- (1/3) Disc Grinder + Belt Sander Machine Tag build by yourself 2 (Desc: Related videosImage: CWL.11440.1.jpgTypeproject: Web)
- (1/4) Build workbench drawers for the workshop itself (Desc: ? DETAILS TO THE VIDEO? / NEW.WORKSTATT new possibilities. /// In this video I show the construction of my new ...Image: YTB.3MlZbk-lwoM.jpgTypeproject: Youtube)
- (1/7/10) TFCTech: Wire Draw Bench work progress 5 (Desc: Sounds.Image: YTB.4HG9aLbJNwE.jpgTypeproject: Youtube)
- (2/3) Disc grinder + belt grinder rebuild yourself Build grinder yourself (Desc: ? NEW.WERKSTATT new possibilities.In this video series, I show the conversion of a plate / belt grinder I over ...Image: YTB.7SU3neTmZas.jpgTypeproject: Youtube)
- (2/4) Multifunctional workbench with integrated Bosch GTS 10XC - build yourself - step by step (Desc: VIDEO DESCRIPTION (Important Info's) Moin Moin and welcome to this new video, more specifically to ...Image: YTB.uWGYm0-alIY.jpgTypeproject: Youtube)
- (4) How to make an air raid siren (Desc: An air raidImage: YTB.zZSxQPYOzyc.jpgTypeproject: Youtube)
- (D.I.Y.) How to make an infrared motion detector (Desc: This tutorial is for all the people that have a basic knowledge in electronics and are wondering how could a motion detector works.Image: YTB.nPWS3SMLXvM.jpgTypeproject: Youtube)
- (DIY Video) Homemade Five Ton Hydraulic Press, Simple To Install ... (Desc: “How to make a homemade hydraulic press with a car jack, u channel steel (u beam) and threaded bar. It is not finished. The jack should be bolt down oImage: CWL.443815.3.pngTypeproject: Web)
- (DIY) (DIY) Manual pump double effect, Manual pump double effect (Desc: Construction of aImage: YTB.Fe yfkmwEdk.jpgTypeproject: Youtube)
- (DIY) 3rd Part (DIY) Manual pump double effect, manual pump double effect (Desc: Last part, Construction of an incubatorImage: YTB.yDGCYSu2nck.jpgTypeproject: Youtube)
- (DIY) EIGENBAU MAGNETRÜHRER (Desc: Built-in Quad Magnetic Stirrer Construction Manual at: https: //drive.google.com/file/d/0B1DP3vr3ZSrARlhCY3p2bXFz ....Image: YTB.tqxJRuj6JGE.jpgTypeproject: Youtube)
- (DIY) How to Make Orange Juicer Thaitrick (Desc: How to MakeImage: YTB.nWD0ZcndwPE.jpgTypeproject: Youtube)
- (DIY) Peltier Box Cooler Version 2 (Desc: Discord link https://discord.gg/GC8QGUv.Image: YTB.l90v2RPyjs0.jpgTypeproject: Youtube)
- (DIY) Tiny sandblasting gun for 4$ :) (Desc: Hi On youtube I saw a lot of similar videos withImage: YTB.YRopDK8XuW0.jpgTypeproject: Youtube)
- (DIY) Waste-oil-burner, what a hotty (Gravity-Drip) (Desc: The link to an update on this burner: https://www.youtube.com/watch?v=-Yz0tjDfYL0 SO I build this little burner over the course of ...Image: YTB.bAPOkkwXoxY.jpgTypeproject: Youtube)
- (F) How To Make A Cordless Tool Cabinet (ep34) (Desc: https://nickferry.com/2014/12/how-to-make-a-cordless-tool... Get your workshop more organized and your tools in ...Image: YTB.Nz68LIZ OkA.jpgTypeproject: Youtube)
- (HOW TO MAKE) A Magnetic Stirrer Hotplate (Desc: Here we have a magnetic stirrer hotplate with variable speed and temperature control This project is a bit more complex than the ...Image: YTB.4m3UxlEfT84.jpgTypeproject: Youtube)
- (HOW TO MAKE) A Simple Magnetic Stirrer from Everyday Items (Desc: As you can see I've made a very simple homemade magneticImage: YTB.IwyAbkMMza8.jpgTypeproject: Youtube)
- (HOW2) Build Jacob's Ladder by Microwave Transformer - High Voltage Arcs (Desc: For more detail contact me: lucas.perocco@outlook.com Lucas Perocco Moreira chillinglu thechillinglu chilling lu Peaceful ...Image: YTB.0SWJsPRf9hs.jpgTypeproject: Youtube)
- (How To) Make A Steel Wheel Wood Burner Easy do it yourself Project (Desc: How to make a steel wheel wood burner/ BBQ. You just need: 3-4 Steel wheels. Something to cut metal. And something to stick it ...Image: YTB.yBORETZdNxc.jpgTypeproject: Youtube)
- (How2) Build Melting Furnace Cast Aluminum (Desc: At some point you get to the point where you think: Actually, something would have to pour something itself. Said and done ...Image: YTB.-KA9Re-xCuM.jpgTypeproject: Youtube)
- (How2) Build workshop trolley / drawer cabinet yourself (Desc: So, today the blog post to the tool cart or drawer cabinet. I have built it for me as a base cabinet for the future workbench, but also as a standalone solution it works (for me on the trolley) very well ....Image: CWL.471915.1.jpgTypeproject: Web)
- (JLCPCB) BitBastelei 279 - DIY Networked Smoke Detectors - Part 2 (Desc: Sponsored by https://jlcpcb.com/ - 10 prototype PCBs from 2$ Already in the last episode I had explained that for a ...Image: YTB.VCHHPmy HRI.jpgTypeproject: Youtube)
- (Norelizz Original) Tutorial How to make your rectangular loom (Desc: Making your own loom is like I do here in Mexico, but taking the measures in other countries can come with a ...Image: YTB.Vtmpsu5u-Yc.jpgTypeproject: Youtube)
- (Not funny )MY HOMEMADE AUTOMATIC BAND SAW Sharpener FROM IQB (Desc: SHARPENING MY BANDSAW WITH MY HAND MADE BANDSAW SHARPENER.Image: YTB.8olyyRN1ZCY.jpgTypeproject: Youtube)
- (PDF) Electric Fan Heater Design for Eco-Energy Saving Semantic ... (Desc: Several induction heating methods are attractive for Eco-energy and energy saving. In this paper, electrical fan heater was designed and developed witImage: CWL.759234.1.pngTypeproject: Web)
- (PDF) Homemade Hydraulic Ram Pump for Livestock Water ... (Desc: pasture and grazing land seems to be the supply of drinking water for livestock. In some cases existing streams, creeks, or ponds provide drinking watImage: CWL.759259.1.pngTypeproject: Web)
- (Part 2) Machine 3 in 1 Homemade drill, cutter and grinder (Desc: Simple and practical homemade machine, for three functions cut rectify and drill.Image: YTB.aimy-j-wlM8.jpgTypeproject: Youtube)
- (Part 2) do it yourself Ice Cream Machine Milkshake Machine Slushy Machine 3 in 1 at Home (Desc: (Part 2 of 3) do it yourself Ice Cream Machine Milkshake Machine Slushy Machine 3 in 1 at Home Made with cardboard, Popsicle sticks, ...Image: YTB.-SFq585BIX4.jpgTypeproject: Youtube)
- (Quick Vid) Homemade Agastat for Mini T-bolt Siren (Desc: So I had the idea in means of a substitute agastat relay to use a centrifugal switch from an electric motor to delay the stop of the ...Image: YTB.y10OpIBcYIE.jpgTypeproject: Youtube)
- (Tutorial) How To DIY Peltier Water Cooler System For Aquascape (Desc: (Tutorial) How To DIY peltier Water Cooler System For Aquascape Today i want to share tutorial How ToImage: YTB.r79lVJd9bos.jpgTypeproject: Youtube)
- (Tutorial) How To Make Powerful Mini Water Pump (Simple) (Desc: How to Make powerful mini water pump (simple), make water pumps MINI at homeMaterials to include: 1 engine 5v, Battery 4.8v ...Image: YTB.-7bkJgjcnN0.jpgTypeproject: Youtube)
×Cheat sheet
This section contains some links to help explain how to use the #ask
syntax.
- Selecting pages describes how to selected pages and build conditions
- Search operators lists available search operators including those for range and wildcard queries
- Displaying information outlines the use of printout statements and formatting options
Format
- broadtable format
Input assistance
Input assistance is provided for the printout, sort, and condition field. The condition field requires to use one of following prefixes:p:
to fetch property suggestions (e.g.[[p:Has ...
)c:
to fetch category suggestionscon:
to fetch concept suggestions
Retrieved from "https://en.oho.wiki/wiki/Special:Ask"