Semantic search
From OHO - search engine for sustainable open hardware projects
Jump to:navigation, search
Debug output SQLStore
ASK Query
[[Category:Agriculture, forest|+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
980
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
980
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 90 | 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) (972).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=972 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneLoading...
- Homemade drinking fountain for rabbits (EASY TO DO) (Desc: To make a homemade drinker like the one in the video I uploaded, we only need: 1.- empty sardine can 2.- coca cola bottle ...Image: YTB.1fU49ZN7uL8.jpgTypeproject: Youtube)
- Homemade drip water irrigation system making use of a bell syphon to regulate watering cycles (Image: YTB.dTuIWpfhABQ.jpgTypeproject: Youtube)
- Homemade electric fence electrifier (Desc: Hello everyone today I wheat a video of a homemade fence electrifier that I made because there is a patio in my house ...Image: YTB.B nKKGMzcBU.jpgTypeproject: Youtube)
- Homemade electric fence energiser (Desc: Please don't leave any bad comments this was just a test to see if it would work.Image: YTB.TwYZWLvOkIQ.jpgTypeproject: Youtube)
- Homemade electric fence for mice (Desc: This video is about a homemade electric fence for mice. Tried regular traps, poison, electronic sound gadgets, and the Victor ...Image: YTB.MrWRH0BsJiM.jpgTypeproject: Youtube)
- Homemade electric fence insulator at the Tipton's Farm (Desc: Tipton's farm.Image: YTB.O1v0P8RpriI.jpgTypeproject: Youtube)
- Homemade fish food feeder for aquarium or pond (Desc: This easy to make and inexpensive homemade (diy) automatic fish food feeder was designed to automatically feed my pond fish ...Image: YTB.A5dsESVhh1I.jpgTypeproject: Youtube)
- Homemade fish pond Updates . New nursery aquarium for fish babys (Desc: Hi friends in this vedio you see 1month update ofImage: YTB.P6qGs7oBqyg.jpgTypeproject: Youtube)
- Homemade fish pond aerator (Desc: How to make a fish pond aerator. I didnt show the pump but its your basic sump pump from home depot. I have less than 20 bucks ...Image: YTB.NJGpqHFrCgw.jpgTypeproject: Youtube)
- Homemade forest tractor with winch / Traktor do lesa s navijákem - domácí výroba (Image: YTB.EX4DzURSlgg.jpgTypeproject: Youtube)
- Homemade garden tractor Ground Ripper, cultivator, chisel on John Deere 317 (Desc: I used anhydrous knives. My alley was very hard and full of potholes so I made this to break it up so I could regrade it.Image: YTB.yRn-6IGTxBc.jpgTypeproject: Youtube)
- Homemade garden tractor v plow (Desc: All I have to do to my v/angle/straight plow is go over my welds (I have little welding experience), add some braces and paint it.Image: YTB.wmIfrrCkktc.jpgTypeproject: Youtube)
- Homemade gardentractor harrow (Desc: Tobias Sahl og Asger Lundby.Image: YTB.HxX4hIBBJ7c.jpgTypeproject: Youtube)
- Homemade goat hay feeder (Desc: My brand new homemade one of a kind hay feeder for goats.Image: YTB.8kAWD6Lc25s.jpgTypeproject: Youtube)
- Homemade gravity fed irrigation system for mini garden (Desc: In this video i quickly show how we made a gravity fed irrigation system for our small but very suitable garden. please hit that ...Image: YTB.Frjr1j53G5Y.jpgTypeproject: Youtube)
- Homemade greenhouse and almost free - Ecocosas (Image: CWL.226057.1.jpgTypeproject: Web)
- Homemade greenhouse with reused materials - iHuerting (Desc: For some time I was thinking about whether to have a greenhouse or not. The high cost of greenhouses is something that, in many cases, causes the illusion of having one to be lost. For that reason and because many ...Image: CWL.253117.1.jpgTypeproject: Web)
- Homemade grower homemade cultivator (Desc: Due to copyright problems I had to upload this video again with another song.Image: YTB.45TBp6jbGvg.jpgTypeproject: Youtube)
- Homemade harrow (Image: YTB.Ty-GU1ZnxQw.jpgTypeproject: Youtube)
- Homemade harrow mount for lawn tractor (Image: YTB.diQxiUWmirA.jpgTypeproject: Youtube)
- Homemade harrow rake thatcher (Image: YTB.m c0G5JQtrw.jpgTypeproject: Youtube)
- Homemade harvester (Image: YTB.zr9tTDIMVZE.jpgTypeproject: Youtube)
- Homemade harvester based on T 40 (Desc: Homemade harvester based on T 40.Image: YTB.1EzIHIZpJBg.jpgTypeproject: Youtube)
- Homemade high grass mower (Desc: Tecumseh lawnmower + Kinderradl = Hochgrasmäher ))Image: YTB.UYRtfockFv0.jpgTypeproject: Youtube)
- Homemade high grass mower? (Desc: ?
B.Tholen02724 / 8260 www.kulturspritze.de.
Improvement of the till so far built.
Self-constructed and built Crusher bucket for our mini excavator Kubota U-17.
Self-built lawn sweeper ...Image: CWL.163637.1.jpgTypeproject: Web) - Homemade hoist for lawn tractor construction management (Desc: If someone wants to build it, I wish a lot of fun.Image: YTB.GjgkWBGn8G0.jpgTypeproject: Youtube)
- Homemade honey extractor (Desc: 4 frame honey extractor ..made from bicycle rims and a 31 gallon galvanized can .. a couple bearings ..etc my bee site ...Image: YTB.P3EMnhan 68.jpgTypeproject: Youtube)
- Homemade honey extractor 2 (Desc: Homemade honey extractor using 220 V 400W electric motor reused from electric blender. Base for honey extractor is plastic ...Image: YTB.f5exIUbHZMY.jpgTypeproject: Youtube)
- Homemade honey extractor 3 (Desc: A honey extractor that I built. Based on the plans from: http://www.beesource.com/build-it-yourself/20-frame-honey-extractor/Image: YTB.mnzFIvF9dJ8.jpgTypeproject: Youtube)
- Homemade honey extractor 4 (Desc: Homemade honey extractor.Image: YTB.NHxue4TChPQ.jpgTypeproject: Youtube)
- Homemade honey extractor. A beekeepers review - heavy duty four frame beekeeping honey spinner (Desc: A beekeepers review of a homemade heavy duty four frame electric honey extractor. Visit http://www.mahakobees.com/store.html ...Image: YTB.aPwXee1UZiI.jpgTypeproject: Youtube)
- Homemade hook for tractor trailer (Desc: In this video you can see how we made homemade tractor trailer hook,the original hook was not practical so we decide to make ...Image: YTB.8l0LqjVTbFA.jpgTypeproject: Youtube)
- Homemade hydroponic system blueprints ~ Get Aquaponics PLans (Desc: homemade hydroponic system blueprints. Free hydroponic system plans . building homemade hydroponics systems doesn't have to be hard find out how to .Image: CWL.256850.3.jpgTypeproject: Web)
- Homemade inventions. Chicken feeder (Desc: Chicken feeder.Image: YTB.NLJsOeJ-c0U.jpgTypeproject: Youtube)
- Homemade irrigation system - do it yourself Start (Desc: The irrigation system is used to assure a proper amount of water to the garden. The drip irrigation system is the most efficient of all because it delivers the water to the roots of the plants. You can make your own drip irrigation system...Image: CWL.390877.2.jpgTypeproject: Web)
- Homemade irrigation system using a water bottle on Vimeo (Image: CWL.315102.1.jpgTypeproject: Web)
- Homemade livestock trailer for sale (Desc: Homemade livestock trailer for sale. It was built out of an old military axle. The backing plates and entire brake assembly are all ...Image: YTB.YeuQ2PghiaM.jpgTypeproject: Youtube)
- Homemade low budget electric tractor for Agriculture Part -1 (Desc: "Spread your wings with Unacademy's Career Quest - Break the Norm. Guest Speakers featuring Gautam Bhimani,Kunal Vijaykar, ...Image: YTB.2rfQ5yEHi4k.jpgTypeproject: Youtube)
- Homemade mantis cultivator (Desc: I made a homemade cultivator out of a old weedeater and a cultivator attachment which went to my 4 stroke weedeater but it ...Image: YTB.yPnwbMImxKU.jpgTypeproject: Youtube)
- Homemade manual seeder (Desc: +58 04163605554 for more information add to the wasap.Image: YTB.3MkjDCeVp5s.jpgTypeproject: Youtube)
- Homemade manual seeder 2 (Desc: New seeders for corn, sorghum and others from Venezuela num 04163605554 are looking for international distributors.Image: YTB.BFGUEmIO6Gk.jpgTypeproject: Youtube)
- Homemade marker for hives. (Desc: Made of ironImage: YTB.RpMiuF6lACA.jpgTypeproject: Youtube)
- Homemade milking machines for cows - Clip Ready (Image: CWL.207685.1.jpgTypeproject: Web)
- Homemade milking machines for cows? (Desc: Animation of GEA IQ Milking Unit in Action.
In this video we Cover Milk Parlour for cows of dairy farm by gurjeet Singh. in this video how to work Milk Parlour Machine, benefits and cost of milk Parlour.
Useing the Udderly Ez Milker on a...Image: CWL.163656.1.jpgTypeproject: Web) - Homemade mini TRACTOR - COMPILATION (Desc: Building a homemade Mini tractor. Little tractor homemade. Homemade tractors.Image: YTB.WaRTCHobW1s.jpgTypeproject: Youtube)
- Homemade mini tractor (Image: YTB.F7-8DWJrZUA.jpgTypeproject: Youtube)
- Homemade mini tractor 1 (Image: YTB.yPNXzlmeCP4.jpgTypeproject: Youtube)
- Homemade mini tractor 2 (Desc: Homemade mini tractorImage: YTB.oOKOJg8MQQ0.jpgTypeproject: Youtube)
- Homemade mini tractor ???? Manoj desale 8554915519 (Image: YTB.kg0JgMkq1Os.jpgTypeproject: Youtube)
- Homemade mini tractor lawn mower. (Image: YTB.Qd0irgSYfdc.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"