Semantische Suche

Diese Seite oder Aktion erfordert JavaScript, damit sie funktioniert. Bitte aktiviere JavaScript in deinem Browser oder verwende einen Browser, der dies unterstützt, damit diese Funktionalität wie gewünscht angeboten werden kann. Weitere Informationen sind auf der entsprechenden Hilfeseite vorhanden.

Optionen | Suche Alle Einträge löschen |

Abfrageanweisungen (Bedingungen)

Ausgabeanweisungen (Anzeige)

Optionen

Parameter [+]

limit:

Legt fest, wie viele Ergebnisse bei der Ausgabe der Abfrageergebnisse maximal angezeigt werden sollen

offset:

Legt fest, ab dem wievielten Ergebnis mit der Ausgabe der Abfrageergebnisse begonnen werden soll

link:

Legt fest, ob die Datenwerte der Ergebnisse bei der Ausgabe der Abfrageergebnisse als Link angezeigt werden sollen

headers:

Legt fest, ob Überschriften bzw. Attributbezeichnungen bei der Ausgabe der Abfrageergebnisse verwendet werden sollen

mainlabel:

Legt fest, welche Überschrift oder Bezeichnung für die Hauptergebnisspalte bei der Ausgabe der Abfrageergebnisse angezeigt werden soll

intro:

Legt fest, welcher Text vor der Ausgabe der Abfrageergebnisse angezeigt werden soll

outro:

Legt fest, welcher Text nach der Ausgabe der Abfrageergebnisse angezeigt werden soll

searchlabel:

Legt fest, welcher Text als Link zur Ausgabe weiterer Abfrageergebnisse angezeigt werden soll

default:

Legt fest, welcher Text angezeigt werden soll, sofern keine Abfrageergebnisse vorhanden sind

class:

Legt fest, welche zusätzliche CSS-Klasse genutzt werden soll

transpose:

Legt fest, ob der Spalten- und Zeilenkopf bei der Anzeige der Abfrageergebnisse transponiert werden soll

sep:

Legt fest, welches Trennzeichen bei der Ausgabe der Abfrageergebnisse genutzt werden soll

Sortierbedingungen

Löschen

Sortierbedingung hinzufügen

ErgebnisCodeFehleranalyseExtra

Zum Einbetten dieser Abfrage in eine Wikiseite kann der unten angegebene Code verwendet werden:

{{#ask: [[Kategorie:Tafel Sprache]] [[Sprache::~*eng*]]
 |?Übersetzungüberprüfung
 |?Beschreibungstext
 |format=table
 |limit=50
 |offset=30
 |sort=
 |order=asc
 |mainlabel=
}}

Ergebnisse 31 – 80 vorherige 50 20 50 100 250 500 nächste 50

JSON CSV RSS RDF

Abfrage-Logbuch

{
    "query_string": "[[Kategorie:Tafel Sprache]] [[Sprache::~*eng*]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0845",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Kategorie:Tafel Sprache]] [[Sprache::~*eng*]]

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 t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=702
   AND (
   (t4.o_hash LIKE '%eng%') AND t4.p_id=157725)
  )
  AND 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
30

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	const	4436	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	t4	ref	s_id, p_id, s_id_2	s_id	8	Interlinking_Pictura_wiki.t2.s_id, const	1	11.11	Using where
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	Interlinking_Pictura_wiki.t2.s_id	1	50.00	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

	Übersetzungüberprüfung	Beschreibungstext
Ad00341 04 032a/eng		Roses XII. Vol. V. No. 30. TWO SPECIES OF ROSES. Fig. 1. The common Damask-Rose. (Rosa Damascena communis.) Fig. 2. The striped Ribbandrose. (Rosa versicolor.)
Ad00341 04 033a/eng		Antiquities XVI. Vol. V. NO. 31. GREEK AND ROMAN DEITIES. Fig. 1. Chronos and Rhea. Fig. 2. Rhea. Fig. 3. 4. and 5. Jupiter. Fig. 6. and 7. Juno.
Ad00341 04 034a/eng		Antiquities XVII. Vol. V. No. 32. GREEK AND ROMAN DEITIES. Fig. 1. Neptune. Fig. 2. Ceres. Fig. 3. 4. And 5. Apollo.
Ad00341 04 035a/eng		Antiquities XVIII. Vol. V. No. 33. DEITIES OF THE GREEKS AND ROMANS. Fig. 1. 2. and 3. Diana. Fig. 4. Vulcan. Fig. 5. Minerva.
Ad00341 04 036a/eng		Antiquities XIX. Vol. V. No. 34. DEITIES OF THE GREEKS AND ROMANS. Fig. 1. Mars. Fig. 2. and 3. Venus. Fig. 4. Cupid. Fig. 5. Mercury.
Ad00341 04 037a/eng		Antiquities XX. Vol. V. No. 35. GREEK AND ROMAN DEITIES. Fig. 1. and 2. Pluto. Fig. 3. Vesta. Fig. 4. and 5. Bacchus.
Ad00341 04 038a/eng		Antiquities XXI. Vol. V. No. 36. GREEK AND ROMAN DEITIES. Fig. 1. Hercules. Fig. 2. Esculapius. Fig. 3. Hygieja. Fig. 4. Vertumnus. Fig. 5. Flora.
Ad00341 04 039a/eng		Antiquities XXII. Vol. V. No. 37. GREEK AND ROMAN DEITIES. The nine Muses. Fig. 1. Clio. Fig. 2. Euterpe. Fig. 3. Thalia. Fig. 4. Melpomène. Fig. 5. Terpsichore. Fig. 6. Erato. Fig. 7. Polyhymnia. Fig. 8. Urania. Fig. 9. Calliope.
Ad00341 04 040a/eng		Plants XCV. Vol. V. No. 38. GERMAN POISONOUS PLANTS. Fig. 1. The Violet-Anemone. (Anemone pulsatilla.) Fig. 2. The venomous Lettice. (Lactuca virosa.)
Ad00341 04 041a/eng		Insects XXXIII. Vol. V. No. 39. REMARKABLE INSECTS. Fig. 1. The Tant. (Trombidium phalangioides.) Fig. 2. The Scarlet Water-mite. (Hydrachne histrionica.) Fig. 3. The louse of the birds. (Acarus chelopus.) Fig. 4. The dove’s Tick. (Rhynchoprion columbae.) Fig. 5. The Carter. (Phalangium rufum.) Fig. 6. The Scorpion-Tick (Chelifer pratsita.) Fig. 7. The bat’s Tick. (Phthiridium biarticulatum.) Fig. 8. The sturgeion’s Louse. (Dichelesthium Sturionis.) Fig. 9. The Water-flea. (Argulus Delphinus.)
Ad00341 04 042a/eng		Insects XXXIV. Vol. V. No. 40. BEAUTIFUL BUTTERFLIES. Fig. 1. The blue Iris-Papillon. (Papilio Nymphalis gemmata, Iris.) Fig. 2. The Helicon-Papillon. (Papilio eques Heliconius, Apollo.)
Ad00341 04 043a/eng		Birds LXVIII. Vol.V.No. 41. AFRICAN BIRDS. Fig. 1. The Griffin-Eagle. Fig. 2. The crested Buzzard. Fig. 3. The White-Hawk. Fig. 4. The Singing-Eagle. Fig. 5. The Ospray. Fig. 6. The Caffree-Eagle.
Ad00341 04 044a/eng		Fruit I. Vol. V. No. 42. REMARKABLE FRUITS. The Giant’s Apple.
Ad00341 04 045a/eng		MISCELL. Subj. LIV. Vol. V. No. 43. THE SLAVE-TRADE.
Ad00341 04 046a/eng		Miscell. Sub. LV. Vol. V. No. 44. REMARKABLE BRIDGES. Fig. 1. The Bridge of Rocks in Virginia. Fig. 2. Hanging and drawing bridges in South-America.
Ad00341 04 047a/eng		Roses XIII. Vol. V. No. 45. ROSES. The great Damason Rose. (Rosa Damascena grandiflora.)
Ad00341 04 048a/eng		Fruit II. Vol. V. No. 46. REMARKABLE FRUITS. The Venitian two-coloured grape. (Vitis vinifera bicolor.)
Ad00341 04 049a/eng		Birds LXIX. Vol. V. No. 47. VULTURES OF AFRICA AND ASIA. Fig. 1. The red-eared Vulture. Fig. 2. Dung-hunter. Fig. 3. The Shegoun Fig. 4. The Tumbler. Fig. 5. The Ourigourap.
Ad00341 04 050a/eng		Dresses VI. Vol. V. No. 48. PERUVIAN DRESSES. Fig. 1. Inhabitants of Lima. Fig. 2. A Lady of Lima. Fig. 3. Indians of Peru. Fig. 4. Country people. Fig. 5. Inhabitants of Quito.
Ad00341 04 051a/eng		Miscell. Subj. LVI. Vol. V. No. 49. REMARKABLE BRIDGES. Fig. 1. The Devi’s bridge upon St. Gotthard. Fig. 2. The Bridge over the Rohone at St. Maurice.
Ad00341 04 052a/eng		Roses XIV. Vol. V. No. 50. TWO DIFFERENT KINDS OF ROSES. Fig. 1. The little Provence-Rose. (Rosa provincialis minima.) Fig. 2. The Dijon Damason-Rose. (Rosa Damascena Dijonensis.)
Ad00341 04 053a/eng		Birds. LXX. Vol. V. No. 51. DIFFERENT KINDS OF FOREIGN OWLS. Fig. 1. The Chocouhou. Fig. 2. The Huhul. Fig. 3. The Collar-Owl. Fig. 4. The crested owl. Fig. 5. The black mask. Fig. 6. The white Church-owl.
Ad00341 04 054a/eng		Insects XXXV. Vol. V. No. 52. BUTTERFLIES OF FOREIGN COUNTRIES. Fig. 1. The green Marble Papilion. Fig. 2. The Harlequin. Fig. 3. The Indian Gold-Butterfly. Fig. 4. The Scarlet spot.
Ad00341 04 055a/eng		Insects XXXVI. Vol. V. No. 53. THE COMMON CRAWFISH.
Ad00341 04 056a/eng		Miscell. Subj. LVIII. Vol. V. No. 54. CATARACTS. Fig. 1 The falls of Niagara. Fig. 2. The cataract of the Rhine near Lauffen.
Ad00341 04 057a/eng		Miscell. Sub. LIX. Vol. V. No. 55. PUBLICK GAMES IN THE ALPS NEAR UNTERSEEN IN THE CANTON OF BERN. Fig. 1. Wrestling. Fig. 2. The Alp-horns. Fig. 3. Stone-flinging. Fig. 4. The Distribution of prices.
Ad00341 04 058a/eng		Plants XCVI. Vol. V. No. 56. MAGNIFIC FLOWER. The beautiful Nelumbo. (Nelumbium speciosum.)
Ad00341 04 059a/eng		Worms VIII. Vol. V. No. 57. THE MOLLUSKS OR SMOOTH-WORMS. Fig. 1. and 2. The Common cuttle-fisch. (Sepia officinalis.) Fig. 3. The Tuberous cuttle-fish. (Sepia tuberculata.) Fig. 4. The spotted cuttle-fisch. (Sepia maculata.) Fig. 5. The small cuttle-fish. (Sepia sepiola.)
Ad00341 04 060a/eng		Insects. XXXVII. Vol. V. No. 58. GERMAN BUTTERFLIES. Fig. 1. The Poplar Butterfly. (Papilio Nymph. Populi.) Fig. 2. The white marbled Butterfly. (Papilio Dan. Cardamines.) Fig. 3. The brimstone Butterfly. (Papilio D. Rhamni.) Fig. 4. The Silver Comma. (Papilio N. C. album.) Fig. 5. The lesser Tortoise Shell. (Papilio N. urticae.)
Ad00341 04 061a/eng		Miscell. Subj. LX. Vol. V. No. 59. FIELDS AND MOUNTAINS OF ICE. Fig. 1. The Rock or Mountain ice. Fig. 2. The Field ice.
Ad00341 04 062a/eng		Roses XV. Vol. V. No. 60. DIFFERENT KINDS OF ROSES. The white Rose of Damas. (Rosa Damascena flor. alba.)
Ad00341 04 063a/eng		Garments VII. Vol. V. No. 61. ORDERS OF KNIGHTS. Fig. 1. and 2. Templars. Fig. 3. and 4. Knights of the Order of S. John.
Ad00341 04 064a/eng		Garments VIII. Vol. V. No. 62. DIVERS ORDERS OF KNIGHTS. Fig. 1. Knights of the Teutonic Order. Fig. 2. Knights of the golden Fleece. Fig. 3. Knights of S. Stephan Fig. 4. Knights of S. Hubert.
Ad00341 04 065a/eng		Birds LXXI. Vol. V. No. 63. AFRICAN BIRDS. Fig. 1. The Bacha. Fig. 2. The Singing Falcon. Fig. 3. The Corbivau. Fig. 4. The Forktailed Goat-Sucker. Fig. 5. The Crested Falcon. Fig. 6. The Chivquera.
Ad00341 04 066a/eng		Insects XXXVIII. Vol. V. No. 64. BEAUTIFUL GERMAN BUTTERFLIES. Fig. 1. The bindweed Sphinx. (Sphinx convolvuli.) Fig. 2. The privet Sphinx. (Sphinx Ligustri.)
Ad00341 04 067a/eng		Plants XCVII. Vol. V. No. 65. THE GENUINE LOTOS PLANT. The Egyptian Sea-rose or genuine Lotos-plant. (Nymphaea Lotus.)
Ad00341 04 068a/eng		Garments IX. Vol. V. No. 66. DIVERS ORDERS OF KNIGHTS. Fig. 1. Knights of the order of the black eagle. Fig. 2. Kinights of the order of S. Andrew. Fig. 3. Kinights of the Seraphins order. Fig. 4. Knights of the white Elephant.
Ad00341 04 069a/eng		Insects XXXIX. Vol. V. No. 67. RARE GERMAN MOTHS. Fig. 1. The clifton Non pareil. (Phalaena noctua fraxini.) Fig. 2. The orange underwing Moth (Phalaena noctua paranympha.) Fig. 3. The high red underwing Moth. (Phalaena noctua Hera.) Fig. 4. The crimson underwing Moth. (Phalaena noctua Sponsa.)
Ad00341 04 070a/eng		Plants XCVIII. Vol. V. No. 68. GERMAN FOREST TREES. Fig. 1. The European Lime-tree. (Tilia Europaea.) Fig. 2. The common Oak. (Quercus pedunculata.)
Ad00341 04 071a/eng		Worms IX. Vol. V. No. 69. MOLLUSKS OR SMOOTH WORMS. Fig. 1. The Fleeve. (Sepia Loligo.) Fig. 2. The Harpoon Calmory. (Sepia sagittata.) Fig. 3. and 4. The Preke Pour contrel. (Sepia octopodia.) Fig. 5. The grained Ink-fish. (Sepia granulata.)
Ad00341 04 072a/eng		Miscellaneous Subjects LXI. Vol. V. No. 70. NOTHERN APPEARANCES. Fig. 1. The norhern Light. Fig. 2. The Sun at midnight.
Ad00341 04 073a/eng		Quadrupedes LXXIV. Vol. V. No. 71. REMARKABLES SUCKING ANIMALS. Fig. 1. The Canada Rat. (Mus bursarius.) Fig. 2. The Common mouse, white var. (Mus musculus. Var. alba.)
Ad00341 04 074a/eng		Insects. XL. Vol. V. No. 72. REMARKABLE INSECTS. The gigantic Grasshopper. (Gryllus cristatus.)
Ad00341 04 075a/eng		Insects XLI. Vol. V. No. 73. BEAUTIFUL GERMAN HAWK-MOTHS. Fig. 1. The Poplar Sphinx. (Sphinx populi.) Fig. 2. The lime-tree Sphinx. (Sphinx tiliae.) Fig. 3. The trunked Sphinx. (Sphinx Elpenor.)
Ad00341 04 076a/eng		Plants XCIX. Vol. V. No. 74. GERMAN FRUIT-SORTS. Fig. 1. The common plum (Prunus domestica.) Fig. 2. The common cherry. (Prunus avium.)
Ad00341 04 077a/eng		Roses XVI. Vol. V. No. 75. VARIETIES OF ROSES. Fig. 1. The French-Rose. (Rosa gallica. L.) Fig. 2. The large flesh-coloured Rose. (Rosa truncata carnea major.)
Ad00341 04 078a/eng		Birds LXXII. Vol. V. No. 76. GERMAN SINGING BIRDS. Fig. 1. The Nightingale with ist nest. Fig. 2. The petti-chaps. (Motacilla Hippolais.)
Ad00341 04 079a/eng		Plants C. Vol. V. No. 77. GERMAN FOREST-TREES. Fig. 1. The common beech. (Fagus sylvatica.) Fig. 2. The common Elm. (Ulmus campestris.)
Ad00341 04 080a/eng		Plants CI. Vol. V. No. 78. GERMAN FRUIT-SORTS. Fig. 1. The garden-currant tree. (Ribes rubrum.) Fig. 2. The goose-berry-bush. (Ribes grossularia.)
Ad00341 04 081a/eng		Insects XLII. Vol. V. No. 79. MAGNIFICENT FOREIGN BUTTERFLIES. Fig. 1. The Iujube-tree Moth. (Phalaena Bombyx Paphia.) Fig. 2. The Claret-Sphinx. (Sphinx Labruscae.)