@Martynas:
Thanks anyway, i will use your advice and do that, instead of those ugly OR
that i'm actually doing :D
I really don't know if i'm doing "a faceted search", it's a concept that
already see in some place but i didn't fully understand it. Maybe i'm, who
know's ! :D
@Andy:
Sorry andy for the format of the querys, i didn't want to alter the query
generated by my code in any way for been more exact at the moment of asking
question's here.
You are right, apparently some movies don't have a date and that was
stopping the query for finding more results.
I'm putting an "OPTIONAL{ }" clause around dc:date, for solving this issue.
I believe that i'm solving my problem doing this, so i don't understand
your last two lines in your answer.
Thanks to both!!
2014-03-09 6:44 GMT-03:00 Andy Seaborne <[email protected]>:
> On 09/03/14 02:07, José Luis Larroque wrote:
>
>> This query doesn't work:
>>
>
> Please make queries readable in email.
>
>
> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
>> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha
>> WHERE{
>> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
>> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
>> http://data.linkedmdb.org/resource/actor/30711> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31259> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29536> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30485> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31204> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29852>)}
>>
>
> Some movies don't have dc:date. Maybe the pattern fails in other ways as
> well.
>
>
>> But this one, does:
>>
>
> I get results for just one actor, actor/29512, who is in many films (~30)
> and no others. That's out of about 118.
>
> If I remove actor/29512 I get no matches.
>
> data.linkedmdb.org has internal usage limits after which it stops the
> query execution. Combined with a graph pattern that excludes possibilities
> on matching, maybe the limits are being triggered.
>
> You'll need to ask them about that.
>
> Andy
>
>
> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
>> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha
>> WHERE{
>> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
>> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
>> http://data.linkedmdb.org/resource/actor/68186> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/9547> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/570> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38579> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/9546> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31700> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/35706> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/42962> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/45825> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/35702> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30922> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37416> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/55943> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36078> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34357> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30535> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37983> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29961> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/9332> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30532> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29959> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30723> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36453> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30913> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31101> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38167> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31099> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33199> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30715> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/40456> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/46372> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38156> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/42356> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32996> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/62792> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37770> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/62790> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34712> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/41397> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/331> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37956> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37765> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/44446> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31454> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/55137> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/46350> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33169> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/44817> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31827> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34309> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37743> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29718> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/35257> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34492> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/301> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37927> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/10994> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30857> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31047> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31810> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31997> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/50332> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29512> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31421> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33712> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/859> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31790> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29689> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36564> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34270> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36752> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/50122> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36553> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37316> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32730> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29865> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/1215> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29864> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33492> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/39604> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31581> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/65000> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31193> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/64999> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/40168> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/45898> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/64998> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29851> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37681> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37680> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/51> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34430> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30610> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31565> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/41305> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/10362> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/10361> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/43399> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/43398> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/39> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/41867> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34989> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31932> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31549> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34222> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38614> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32501> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37650> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32108> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30769> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31914> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/43558> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38396> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32093> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30373> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33046> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/60548> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32661>)}
>>
>> The only difference between both, are the size, because both are almost
>> identical, with the exception that the second has a OR more bigger.
>>
>> Both are code-generated querys, and the second query can't be tested
>> against the sparql dbpedia endpoint, because it's too big. Using jena
>> framework against the dbpedia enpoint, works like a charm, but not the
>> first one. Any idea why?
>>
>> Jose
>>
>>
>
