User:FabC

From Wikidata
Jump to navigation Jump to search
FabC
This user is a member of
WikiProject Informatics.
This user is a member of
WikiProject Space.
This user is penguin powered.
This user has a page on Wikipedia.
Babel user information
en-4 This user has near native speaker knowledge of English.
it-N Questo utente può contribuire con un livello madrelingua in italiano.
Users by language

Wikiprojects[edit]

Wikiproject:informatics[edit]

WikiProject Informatics/Operating System[edit]

https://www.wikidata.org/wiki/Wikidata:WikiProject_Informatics/Operating_System

Queries[edit]

Find all "independent" GNU/Linux distributions, i.e. not based on another OS 

# Find all GNU/Linux distributions that are independent, i.e. not based on another OS.
SELECT ?sistema_operativo ?sistema_operativoLabel WHERE {
  
  ?sistema_operativo wdt:P31/wdt:P279* wd:Q131669.        # Instances of subclass of "Linux distribution"
    OPTIONAL { ?sistema_operativo wdt:P144 ?w } # Filter out all those that have the "based on" (P144) property
    FILTER (!bound(?w))
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (?sistema_operativoLabel)
Try it! 


#Find all dead (i.e. not supported anymore) GNU/Linux distributions
SELECT ?item ?itemLabel
WHERE
{
  ?item wdt:P31/wdt:P279* wd:Q131669.
  ?item p:P2669 ?statement.
  ?statement rdf:type wdno:P2669. # This seems to be redundant...
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!

The discontinued date (P2669) could be a date (if known) or a novalue.


Operating systems developed by Microsoft 

SELECT DISTINCT ?os
  (SAMPLE(COALESCE(?en_label, ?any_label)) as ?label)
  (SAMPLE(?based_on_label) as ?based_on)
  (SAMPLE(?logo) as ?logo)
  (SAMPLE(?image) as ?image)
  (GROUP_CONCAT(DISTINCT ?packaging_system_label ; separator=", ") as ?packaging_system)
  (GROUP_CONCAT(DISTINCT ?developer_label ; separator=", ") as ?developer)
  (GROUP_CONCAT(DISTINCT ?license_label ; separator=", ") as ?license)
  (SAMPLE(?inception) as ?inception)
  (GROUP_CONCAT(DISTINCT ?origin_label ; separator=", ") as ?origin)
  #(SAMPLE(?website) as ?website)
WHERE {
  ?os wdt:P31 wd:Q9135.
  OPTIONAL{?os rdfs:label ?en_label. FILTER(LANG(?en_label) = "en")} OPTIONAL {?os rdfs:label ?any_label}
  OPTIONAL{?os wdt:P144 ?based_on. ?based_on rdfs:label ?based_on_label. FILTER(LANG(?based_on_label) = "en")}
  OPTIONAL{?os wdt:P154 ?logo}
  OPTIONAL{?os wdt:P18 ?image}
  OPTIONAL{?os wdt:P3033 ?packaging_system. ?packaging_system rdfs:label ?packaging_system_label. FILTER(LANG(?packaging_system_label) = "en")}
  OPTIONAL{?os wdt:P275 ?license. ?license rdfs:label ?license_label. FILTER(LANG(?license_label) = "en")}
  OPTIONAL{?os wdt:P178 ?developer. 
           ?developer rdfs:label ?developer_label. 
           FILTER(LANG(?developer_label) = "en").       
          }
  OPTIONAL{?os wdt:P571 ?inception}
  OPTIONAL{?os wdt:P495 ?origin. ?origin rdfs:label ?origin_label. FILTER(LANG(?origin_label) = "en")}
  OPTIONAL{?os wdt:P856 ?website}
  FILTER(SUBSTR(str(?developer_label), 1, 9) = "Microsoft").
}
GROUP BY ?os ORDER BY ?label
Try it!

List of the licenses that are subclasses or instances of free software license (Q3943414) 

# Free software and license
SELECT ?freesw ?freeswLabel ?freelicense ?freelicenseLabel WHERE {
  ?freelicense (wdt:P31/wdt:P279*) wd:Q3943414.      # Instances of free software licenses
  ?freesw wdt:P275 ?freelicense.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?freelicenseLabel
Try it!

Derived Linux Distribution 

#Distribuzioni Linux derivate
SELECT ?item ?itemLabel ?basedon ?basedonLabel
WHERE 
{
  ?item wdt:P31 wd:Q20983788.
  ?item wdt:P144 ?basedon.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,it". }
}
ORDER BY (?basedonLabel)
Try it!

Counts of derived Linux distribution 

#Statistica Linux derivate
#defaultView:BubbleChart
SELECT DISTINCT ?basedonLabel (COUNT (?item) as $count) 
WHERE 
{
  ?item wdt:P31 wd:Q20983788.
  ?item wdt:P144 ?basedon.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,it". }
}
GROUP BY ?basedon ?basedonLabel
ORDER BY DESC (?count)
Try it!

Astronautica[edit]

Elenco degli astronauti italiani in ordine di tempo di permanenza nello spazio[edit]

#Astronauti italiani in ordine di tempo di permanenza nello spazio
SELECT ?item ?itemLabel ?timeinspace ?unitLabel ?wikiarticle 
WHERE {
  ?item wdt:P106 wd:Q11631.                  # Astronuati
  ?item wdt:P31 wd:Q5.                       # umani (i.e. non di fantasia)
  ?item wdt:P27 wd:Q38.                      # Nazionalità italiana
  
  OPTIONAL { ?item wdt:P2873 ?timeinspace }  # Tempo nello spazio
  OPTIONAL { ?item p:P2873/psv:P2873 [       # Unità di tempo
            wikibase:quantityUnit ?unit 
            ]
  }
  FILTER (?timeinspace > 0).
  OPTIONAL {                                 # Articolo su Wikipedia
      ?wikiarticle schema:about ?item .
      ?wikiarticle schema:inLanguage "en" .
      FILTER (SUBSTR(str(?wikiarticle), 1, 25) = "https://en.wikipedia.org/")
    }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC (?timeinspace)
Try it!

Elenco delle industrie aerospaziali italiane[edit]

#Industrie aerospaziali italiane
SELECT ?industria_aerospaziale ?industria_aerospazialeLabel ?placeLabel
WHERE 
{
  {
    ?industria_aerospaziale wdt:P31 wd:Q936518. # Istanze di industrie aerospaziali
  } UNION
  {
    ?industria_aerospaziale wdt:P31 wd:Q4830453. # Istanza di impresa
    ?industria_aerospaziale wdt:P452 wd:Q936518. # settore di attività industria aereospaziale 
  }
  ?industria_aerospaziale wdt:P17 wd:Q38.        # Italiane

  OPTIONAL { ?industria_aerospaziale wdt:P159 ?place }  # Sede legale
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # l'etichetta verrà preferibilmente nella tua lingua, e altrimenti in inglese
}
order by ?industria_aerospazialeLabel
Try it!

Durata dell'attracco delle capsule SpaceX alla ISS[edit]

SELECT ?istanza_di 
      ?istanza_diLabel 
      ?data_di_lancio_del_veicolo_spaziale 
      ?data_di_atterraggio_del_veicolo_spaziale 
      ?elapseddays
WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?istanza_di wdt:P361 wd:Q245653.
  ?istanza_di wdt:P137 wd:Q193701.
  OPTIONAL { ?istanza_di wdt:P619 ?data_di_lancio_del_veicolo_spaziale. }
  OPTIONAL { ?istanza_di wdt:P620 ?data_di_atterraggio_del_veicolo_spaziale. }
  BIND(?data_di_atterraggio_del_veicolo_spaziale - ?data_di_lancio_del_veicolo_spaziale AS ?elapseddays).
}
ORDER BY ASC(?data_di_lancio_del_veicolo_spaziale)
LIMIT 100
Try it!

Durate delle missioni CRS usando le date negli eventi chiave (Example only! do not use!)[edit]

#Cronologia dei voli Commercial Resupply Services

SELECT ?itemLabel ?launchdate ?landingdate
WHERE
{
  ?item wdt:P31 wd:Q5916 .        #istanza di Volo Spaziale
  ?item wdt:P361 wd:Q245653 .     #parte di Commercial Resupply Services (CRS)
  
  OPTIONAL {
  ?item p:P793 [                  #riferimento alla dichiarazione evento chiave
           ps:P793 wd:Q797476;    #seleziona l'evento del lancio del razzo
           pq:P585 ?launchdate    #estrae il qualificatore con la data dell'evento di lancio
          ].
  }
  
  OPTIONAL {      
  ?item  p:P793 [                  #riferimento alla dichiarazione evento chiave
           ps:P793 wd:Q844947;     #seleziona l'evento dell'atterraggio
           pq:P585 ?landingdate    #estrae il qualificatore con la data dell'evento dell'atterraggio
          ].
  }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY ?launchdate
Try it!

ISS assembly timeline[edit]

#ISS assembly
#defaultView:Timeline
SELECT ?item ?itemLabel ?startdate ?picture
WHERE 
{
  ?item wdt:P31 wd:Q18812508 .   # Instance of a space module 
  ?item wdt:P361 wd:Q25271 .     # Part of ISS
  OPTIONAL { ?item wdt:P18 ?picture .}            # Get a picture
  OPTIONAL { ?item p:P361 [pq:P580 ?startdate] .} # Get the date the module became (or will become) part of the ISS
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?startdate
Try it!

History of the launches of the Soyuz program[edit]

#History of the launches of the Soyuz program
SELECT DISTINCT ?item ?itemLabel ?launchdate ?launchsiteLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q5916.          # Instance of any subclass of spaceflight
  ?item wdt:P361 wd:Q207329.                 # Part of the soyuz program
  OPTIONAL {
    ?item p:P793 [ ps:P793 wd:Q797476;       # Key events > rocket launch
                   pq:P585 ?launchdate       # "date" qualifier
                 ].
   }

  OPTIONAL {
    ?item p:P793 [ ps:P793 wd:Q797476;       # Key events > rocket launch
                   pq:P276 ?launchsite       # "date" qualifier
                 ].
   }  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
order by ?launchdate
Try it!

Flying time to the ISS[edit]

#Tempo di arrivo sulla ISS

SELECT ?item ?itemLabel ?launchdate ?dockdate ?flyingtime
WHERE
{
  ?item wdt:P31 wd:Q752783 .        #istanza di Volo Spaziale
  
  # Select the vehicles docked to the ISS
  ?item  p:P793 [                  #riferimento alla dichiarazione "evento chiave"
           ps:P793 wd:Q557450 ;    #seleziona l'evento del docking
           pq:P276 wd:Q25271       #luogo = ISS
          ].

  # Launch date  
  OPTIONAL {
  ?item p:P793 [                  #riferimento alla dichiarazione "evento chiave"
           ps:P793 wd:Q797476;    #seleziona l'evento del "lancio del razzo vettore"
           pq:P585 ?launchdate    #estrae il qualificatore con la "data" dell'evento di lancio
          ].
  }
    
  # Docking date
  OPTIONAL {
  ?item  p:P793 [                  #riferimento alla dichiarazione "evento chiave"
           ps:P793 wd:Q557450 ;    #seleziona l'evento del docking
           pq:P580 ?dockdate       #data di inizio del docking, i.e. dell'arrivo sulla ISS
          ].
  }
  
  BIND(?dockdate-?launchdate AS ?flyingtime)
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY ?launchdate
Try it!

Composizione della ISS[edit]

Albero del prodotto della Stazione Spaziale Internazionale 

# Product Tree of the ISS
#defaultView:Tree
SELECT
  ?class1 ?class1Label
  ?class2 ?class2Label
  ?class3 ?class3Label
  ?class4 ?class4Label
  ?class5 ?class5Label
WHERE
{
  VALUES ?class1 { wd:Q25271 }
  ?class1 ^wdt:P361 ?class2 .
  OPTIONAL { ?class2 ^wdt:P361 ?class3 .
    OPTIONAL { ?class3 ^wdt:P361 ?class4 .
      OPTIONAL { ?class4 ^wdt:P361 ?class5 . }
    }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO LANGUAGE],en" . }
}
Try it!

Missioni cubesats[edit]

#Cubesat missions
SELECT ?item ?itemLabel  ?countryLabel ?launchdate ?launchvehicleLabel ?sponsorLabel
WHERE 
{
  ?item wdt:P31 wd:Q1142930.
  OPTIONAL {?item wdt:P619 ?launchdate}
  OPTIONAL {?item wdt:P17 ?country}
  OPTIONAL {?item wdt:P375 ?launchvehicle}
  OPTIONAL {?item wdt:P859 ?sponsor}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC (?launchdate)
Try it!


Missioni dello Space Shuttle[edit]

# Space Shuttle missions
SELECT ?item ?itemLabel ?launchdate
WHERE 
{
  ?item wdt:P31 wd:Q752783.     # Instance of human spaceflight
  ?item wdt:P361 wd:Q1775296.   # Part of the Space Shutlle program
  ?item wdt:P619 ?launchdate.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # l'etichetta verrà preferibilmente nella tua lingua, e altrimenti in inglese
}
ORDER BY ?launchdate
Try it!

Satelliti artificiali italiani[edit]

# Italian artificial satellites
SELECT DISTINCT ?item ?itemLabel ?cospar ?perigeo ?apogeo ?launchdate ?inclin ?period
WHERE   
{
  ?item p:P31/ps:P31/wdt:P279* wd:Q26540  . # Istanza di satellite per radioamatori
  ?item wdt:P495 wd:Q38   
  OPTIONAL {?item wdt:P247 ?cospar. }
  OPTIONAL {?item wdt:P377 ?scn. }  
  OPTIONAL {?item wdt:P619 ?launchdate. }   

  OPTIONAL {?item wdt:P2243 ?apogeo. }   
  OPTIONAL {?item wdt:P2244 ?perigeo. }   
  OPTIONAL {?item wdt:P2045 ?inclin. }    
  
  OPTIONAL {?item wdt:P2146 ?period. }   
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en ". } # l'etichetta verrà preferibilmente nella tua lingua, e altrimenti in inglese
}
ORDER BY ?launchdate
Try it!

Wikiproject:Italy[edit]

Wikidata:Wikiproject Italy

Sottoprogetto Divisioni Amministrative italiane e Sandbox per la descrizione e accesso ai dati delle divisioni amministrative

Scientific publications[edit]

All the scholarly articles (pubblicazioni scientifiche) with a short name of an author[edit]

#Author name strings
SELECT ?item ?identificativo_DOI ?titolo WHERE {
  ?item wdt:P2093 "John Doe".
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  ?item wdt:P31 wd:Q13442814.
  OPTIONAL { ?item wdt:P356 ?identificativo_DOI. }
  OPTIONAL { ?item wdt:P1476 ?titolo. }
}
Try it!

All scholarly articles (articoli scientifici) with a keyword[edit]

SELECT ?Articolo ?ArticoloLabel WHERE {
  ?Articolo wdt:P31 wd:Q13442814.       # Scholarly articles
  ?Articolo rdfs:label ?ArticoloLabel.  # Get label   
  ?Articolo wdt:P921 wd:Q48655.         # With microgravity keyword
  FILTER((LANG(?ArticoloLabel)) = "en").
}
LIMIT 100
Try it!


General queries[edit]

Books and ISBN[edit]

#Books in italian language - ISBN
SELECT ?book ?bookLabel ?ISBN
WHERE 
{
  ?book wdt:P31 wd:Q47461344.  # Opera scritta
  ?book wdt:P212 ?ISBN.
  ?book wdt:P407 wd:Q652.      # Italian language
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 1000
Try it!

Geomap of items[edit]

Map of items without an image (P18) declaration in the Livorno (Q6761) area: 

#defaultView:Map
SELECT ?item ?itemLabel ?coord WHERE {
  ?item wdt:P131 ?sub1.
  ?sub1 wdt:P131* wd:Q6761. # Livorno (Q6761)
  ?item wdt:P625 ?coord.
  OPTIONAL { ?item wdt:P18 ?dummy0. }
  FILTER(!BOUND(?dummy0))
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!

Map of churches in Italy[edit]

#Mappa delle chiese in Italia (max 500)
#added 2017-08
#defaultView:Map
SELECT * WHERE {
  ?item wdt:P17 wd:Q38 .
  ?item wdt:P31*/wdt:P279* wd:Q16970;
        wdt:P625 ?geo .
}
LIMIT 500
Try it!

Map of churches in Livorno[edit]

#defaultView:Map
# Select the ItemId, label and coordinate location
SELECT ?place ?placeLabel ?location WHERE {
  
       
  # Select the coordinate location(P625) of Livorno(Q6761) as the centeral coordinate ?mainLoc
  wd:Q6761 wdt:P625 ?mainLoc . 
  
  # Use the around service
  SERVICE wikibase:around { 
  # Looking for items with coordinate locations(P625)
    ?place wdt:P625 ?location . 
    # That are in a circle with a centre of ?mainLoc(The coordinate location of Berlin)
    bd:serviceParam wikibase:center ?mainLoc . 
    # Where the circle has a radius of 10km
    bd:serviceParam wikibase:radius "10" . 
  }
  
  # Use the label service to get the English label
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .  }
  
  ?place wdt:P31*/wdt:P279* wd:Q16970 .  # Instance of churches

}
LIMIT 200
Try it!

Occupazioni dei personaggi livornesi[edit]

#Occupazioni dei personaggi livornesi
SELECT ?jobLabel (COUNT(?jobLabel) as ?Conteggio)
WHERE 
{
  ?item wdt:P19 wd:Q6761 .
  ?item wdt:P734 ?cognome.
  OPTIONAL { ?item wdt:P106 ?job .}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?jobLabel ORDER BY DESC(?Conteggio)
Try it!

Enti amministrativi[edit]

Classi degli enti amministrativi italiani[edit]

La classe administrative territorial entity of Italy (Q2824645) è composta da diverse divisioni amministrative:

Divisione Sottoclasse della divisione amministrativa Esempio
first-level administrative division (Q10864048) region of Italy (Q16110) Tuscany (Q1273) è una instance of (P31) region of Italy (Q16110)
second-level administrative division (Q13220204) province of Italy (Q15089) Province of Livorno (Q16200)
third-level administrative division (Q13221722) commune of Italy (Q747074) Comune di Florence (Q2044)
fourth-level administrative division (Q14757767) circoscrizione di decentramento comunale in Italy (Q13582281) borough of Bologna (Q3927244)


Composizione della giunta comunale di Montecatini Terme[edit]

#Composizione della giunta comunale di Montecatini Terme
SELECT ?caricaricopertaLabel ?itemLabel  ?assessoratoLabel ?item
WHERE 
{
  { ?item wdt:P39 wd:Q3625593 }  #carica ricoperta = assessori
  UNION
  { ?item wdt:P39 wd:Q4657217 }
  UNION
  { ?item wdt:P39 wd:Q4011172 }  # vicesindaco 
  UNION 
  { ?item wdt:P39 wd:Q30185 }.   # sindaco 
  
  ?item wdt:P39 ?caricaricoperta.
  
  ?item p:P39 [                  # Qualificatori di 'carica ricoperta'
    pq:P642 wd:Q49605;           # di = Montecatini Terme
  ].
  
  # Occorre validare la carica tramite l'eventuale data di fine mandato
  
  MINUS {
    ?item p:P39 [               # Rimuovi gli assessori che hanno 'carica ricoperta' (P39)
      pq:P582 ?datadifine       # con una data di fine mandato (P582)
    ].
  }.
  
  OPTIONAL {
    ?item p:P39 [                
      pq:P101 ?assessorato       # Estrai assessorato dal qualificatore 'campo di lavoro'
    ].
  }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!

Sport[edit]

Calciatori italiani in attività[edit]

#Calciatori italiani in attività, ordinati per presunta età anagrafica

SELECT ?item ?itemLabel ?ruoloLabel ?datafinecarriera ?age
WHERE 
{
  ?item wdt:P27 wd:Q38.                               # Cittadino italiano
  ?item wdt:P106 wd:Q937857.                          # Occupazione calciatore
  
  MINUS {?item p:P106 [pq:P582 ?datafinecarriera]}.   # Elimina quelli che hanno il qualificatore di data di fine carriera
  MINUS { ?item wdt:P570 ?deathdate }                 # Elimina i deceduti

  OPTIONAL {?item wdt:P569 ?born. }                   # Calcola età 
  BIND(FLOOR((NOW() - ?born)/365.2425) AS ?age). 
  
  OPTIONAL { ?item wdt:P413 ?ruolo}.                  # Estrai il ruolo
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?age)
Try it!

Giocatori dell' Inter FC[edit]

# Actual players of the Inter FC
SELECT ?player ?playerLabel ?age ?startyear
{
    ?player wdt:P31 wd:Q5.          # Human
    ?player wdt:P106 wd:Q937857 .   # Soccer player
    ?player wdt:P54 wd:Q631.        # Member of Inter F.C

    ?player p:P54 [                 # Pointer to statement "Member of.."
      ps:P54 wd:Q631;               # Pointer to the statement object "Inter"
      pq:P580 ?start                # Get the property qualifier "Start date" 
    ].

    # Filter out all the players that are not member anymore
    MINUS {
      ?player p:P54 [               # Pointer to statement "Member of.."
            ps:P54 wd:Q631;         # Pointer to the statement object "Inter"
            pq:P582 ?end            # Get the property qualifier "End date"
      ].
    }
  
    # Year of enrollment
    BIND (YEAR(?start) AS ?startyear)
  
    # Age
    ?player wdt:P569 ?birthdate.
    BIND(FLOOR((NOW() - ?birthdate)/365.2425) AS ?age). 
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],it" }  
}
ORDER BY ?startyear
Try it!

Radiantismo[edit]

Notable amateur radio operators[edit]

# Notable amateur radio operators
#defaultView:Tree
SELECT ?occupation ?occupationLabel ?item ?itemLabel  ?callsign
WHERE 
{
  ?item wdt:P5143 ?callsign;
        wdt:P106 ?occupation.
  FILTER(?occupation != wd:Q1939892).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
order by ?occupationLabel
Try it!

Italian radio amateur satellites[edit]

#Satelliti radioamatoriali italiani
SELECT ?item ?itemLabel ?cospar ?perigeo ?apogeo ?launchdate ?inclin ?period
WHERE 
{
  ?item wdt:P31 wd:Q455647. # Istanza di satellite per radioamatori
  ?item wdt:P495 wd:Q38
  OPTIONAL {?item wdt:P247 ?cospar. }
  OPTIONAL {?item wdt:P377 ?scn. }  
  OPTIONAL {?item wdt:P619 ?launchdate. }   

  OPTIONAL {?item wdt:P2243 ?apogeo. }   
  OPTIONAL {?item wdt:P2244 ?perigeo. }   
  OPTIONAL {?item wdt:P2045 ?inclin. }    
  
  OPTIONAL {?item wdt:P2146 ?period. }   
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en ". } # l'etichetta verrà preferibilmente nella tua lingua, e altrimenti in inglese
}
ORDER BY ?launchdate
Try it!

Geopolitica[edit]

# Membri della comunità europea
select ?item ?itemLabel where {
  
 ?item p:P463 ?stm.          # Members of something
 ?stm ps:P463 wd:Q458.       # Reference to the membership of EU
 MINUS { ?stm pq:P582 [] . } # Exclude members with and end date qualifier
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
 
} order by (?itemLabel)
Try it!

Contact[edit]

Retrieved from "https://www.wikidata.org/w/index.php?title=User:FabC&oldid=1976255164"