Talk:Q18517638

Identifiers on Toy Story 3, but not on Toy Story 4 edit

SELECT ?p ?pLabel ?pDescription ?value3 ?f ?main ?searchurl
{
    VALUES ?item4 { wd:Q18517638 }
    VALUES ?item3 { wd:Q187278 }

    ?item3 ?wdt ?value3 .
    ?p wikibase:directClaim ?wdt ; wikibase:propertyType wikibase:ExternalId .
    MINUS   { ?item4 ?wdt [] }
    OPTIONAL { ?p wdt:P1630 ?f }  
    OPTIONAL { ?p wdt:P1896 ?main }  
    OPTIONAL { ?p wdt:P4354 ?searchf .
               ?item4 wdt:P1476 ?title . 
               BIND(URI(REPLACE(?searchf, "\\$1", ENCODE_FOR_URI(str(?title))) ) as ?searchurl) 
             }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Identifiers on 1, 2 or 3 edit

SELECT DISTINCT
  ?p ?pLabel ?pDescription 
  (SAMPLE( ?value1 ) as ?value1) 
  (SAMPLE( ?value2 ) as ?value2) 
  (SAMPLE( ?value3 ) as ?value3) 
  (SAMPLE( ?f ) as ?f) 
  (SAMPLE( ?main ) as ?main) 
  (SAMPLE( ?searchurl ) as ?searchurl)
WHERE
{
    VALUES ?item4 { wd:Q18517638 }
    VALUES ?item3 { wd:Q187278 }
    VALUES ?item2 { wd:Q187266 }
    VALUES ?item1 { wd:Q171048 }

    { ?item3 ?wdt ?value3 } UNION { ?item2 ?wdt ?value2 } UNION { ?item1 ?wdt ?value1 } 
    ?p wikibase:directClaim ?wdt ; wikibase:propertyType wikibase:ExternalId .
    MINUS   { ?item4 ?wdt [] }
    OPTIONAL { ?p wdt:P1630 ?f }  
    OPTIONAL { ?p wdt:P1896 ?main }  
    OPTIONAL { ?p wdt:P4354 ?searchf .
               ?item4 wdt:P1476 ?title . 
               BIND(URI(REPLACE(?searchf, "\\$1", ENCODE_FOR_URI(str(?title))) ) as ?searchurl) 
             }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY   ?p ?pLabel ?pDescription

Try it!

Return to "Q18517638" page.