User:Arosio Stefano/test

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT ?item ?itemLabel (GROUP_CONCAT(distinct ?identifier) as ?identifiers) ?country ?gamesCount ?cpuInfo (group_concat(distinct concat(?sameAsManufLabel, ' ',?sameAsLabel);separator=",<br>") as ?sameAsAndManu2) (GROUP_CONCAT(distinct CONCAT("[[File:", STRAFTER(STR(?aManuLogo), "FilePath/"), "|center|100px|border|link=|alt=]]")) as ?manuLogoFile) WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],it,en". } #filtri veri e propri ?gen wdt:P361 wd:Q129781. ?item wdt:P279* ?gen. ?item wdt:P176* ?manufacturer. { ?item wdt:P31 wd:Q56682555 } UNION { ?item wdt:P31 wd:Q10929058 } UNION { ?item wdt:P31 wd:Q115187350 } # riduciamo le righe: ?item wdt:P176* wd:Q66049715. OPTIONAL { # Get external identifiers ?item ?prop ?id. ?propItem wikibase:directClaim ?prop. ?propItem wikibase:propertyType wikibase:ExternalId. {?propItem wdt:P31 wd:Q28147643} UNION {?propItem wdt:P31 wd:Q107786704} . ?propItem wdt:P1630 ?formatterurl . ?propItem rdfs:label ?propItemLabel . FILTER (lang(?propItemLabel) = "en"). BIND(IRI(REPLACE(?id, '^(.+)$', ?formatterurl)) AS ?url). BIND(CONCAT("[", str(?url), " ", ?propItemLabel, "]") as ?identifier) } # calcolo cpuInfo OPTIONAL { ?item wdt:P361 wd:Q58853262. BIND(wd:Q58853262 AS ?pc50Xfamily). } OPTIONAL { ?item wdt:P2283 wd:Q173475. BIND(wd:Q173475 AS ?isDiodeTransistorLogic). } OPTIONAL { ?item wdt:P2283 wd:Q265899. BIND(wd:Q265899 AS ?isTTL7400). } OPTIONAL { ?item wdt:P2283 wd:Q173451. BIND(wd:Q173451 AS ?isTTL). } OPTIONAL { ?item wdt:P2283 wd:Q173431. BIND(wd:Q173431 AS ?isCMOS). } OPTIONAL { ?item wdt:P880 ?cpu} BIND(IF(BOUND(?pc50Xfamily),'Into PC-50x cartridges',?cpu) AS ?cpu2). BIND(IF(BOUND(?isTTL7400), ?isTTL7400, ?cpu2) AS ?cpu3). BIND(IF(BOUND(?isTTL), ?isTTL, ?cpu3) AS ?cpu4). BIND(IF(BOUND(?isCMOS), ?isCMOS, ?cpu4) AS ?cpu5). BIND(IF(BOUND(?isDiodeTransistorLogic), ?isDiodeTransistorLogic, ?cpu5) AS ?cpuInfo). # calcolo paese e logo dal manufacturer OPTIONAL{?manufacturer wdt:P17 ?country .} OPTIONAL{?manufacturer wdt:P154 ?aManuLogo .} # calcolo numero di giochi OPTIONAL { ?item p:P2670 ?partOfClass . ?partOfClass pq:P1114 ?gamesCount } # test OPTIONAL{?item wdt:P460 ?sameAs. ?sameAs wdt:P176 ?sameAsManuf} # uguale a OPTIONAL{?item wdt:P460 ?sameAs. ?sameAs wdt:P176 ?sameAsManuf. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?sameAs rdfs:label ?sameAsLabel . ?sameAsManuf rdfs:label ?sameAsManufLabel . } } } GROUP BY ?item ?itemLabel ?country ?gamesCount ?cpuInfo

Poppy

item	Console label	Console itemLabel	Produttore	Logo	Anno	Paese	Descrizione	Immagine	CPU	Input aggiuntivi	Num giochi	Uguale a	Rif. esterni
Q66085294	Tele-spiel 9009	Tele-spiel 9009	Poppy		1977	Germany	Poppy Pong console		AY-3-8500		4
Q66085308	TV-Game Fernseh Spiel TVG-4	TV-Game Fernseh Spiel TVG-4	Poppy		1978	Germany	German Poppy Pong console		AY-3-8500		4
Q66085297	Colour Video Game 9012	Colour Video Game 9012	Poppy		1982	Germany	German Poppy console		AY-3-8500	light gun	6
Q66085300	TVG-10	TVG-10	Poppy			Germany	German Poppy Pong console.PC-50x series		Into PC-50x cartridges			Novex Computerized Electronic Programmable Video Game 1010
Q66085305	9017 Colour TV Game	9017 Colour TV Game	Poppy			Germany	German Poppy Pong console. games: pong + race		AY-3-8760 AY-3-8512		10	Soundic SD-019, Tele-Partner Giochi Televisivi (Mod. G)	old-computers.com ID
Q66085307	TVG-3	TVG-3	Poppy			Germany	German Poppy Pong console. ≈ Conic TG-721				3
Q66085310	Poppy 9015	Poppy 9015	Poppy			Germany	German Poppy Pong console. PC-50x family		Into PC-50x cartridges				old-computers.com ID

---

∑ 7 items.

End of automatically generated list.