query-e745a92b0a545e568d06e3e7b59a4cfe

rq turtle/ttl

Actors with a least 5 Top 250 movies

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?actor (COUNT(DISTINCT(?film)) AS ?films) (GROUP_CONCAT(?film) AS ?filmography) WHERE 
{
    VALUES ?film {wd:Q172241 wd:Q47703 wd:Q184768 wd:Q163872 wd:Q104123 wd:Q483941 wd:Q2345 wd:Q131074 wd:Q41483 wd:Q190050 wd:Q127367 wd:Q181795 wd:Q134773 wd:Q25188 wd:Q171669 wd:Q164963 wd:Q42047 wd:Q83495 wd:Q189540 wd:Q17738 wd:Q220741 wd:Q190908 wd:Q133654 wd:Q204191 wd:Q132351 wd:Q19355 wd:Q484675 wd:Q168154 wd:Q13417189 wd:Q155653 wd:Q165817 wd:Q132689 wd:Q208572 wd:Q238211 wd:Q163038 wd:Q174284 wd:Q34414 wd:Q595 wd:Q45602 wd:Q208263 wd:Q170564 wd:Q150804 wd:Q172975 wd:Q15648198 wd:Q91540 wd:Q190525 wd:Q128518 wd:Q182692 wd:Q105702 wd:Q193570 wd:Q46551 wd:Q36479 wd:Q103569 wd:Q109116 wd:Q153882 wd:Q464032 wd:Q571032 wd:Q186341 wd:Q747936 wd:Q189330 wd:Q104905 wd:Q274520 wd:Q25139 wd:Q104814 wd:Q6074 wd:Q24815 wd:Q186572 wd:Q475693 wd:Q223139 wd:Q202548 wd:Q62730 wd:Q206388 wd:Q127021 wd:Q181803 wd:Q196977 wd:Q484048 wd:Q72962 wd:Q162729 wd:Q181086 wd:Q487181 wd:Q187278 wd:Q47221 wd:Q478209 wd:Q177922 wd:Q228186 wd:Q208269 wd:Q243439 wd:Q190956 wd:Q62665 wd:Q309153 wd:Q172837 wd:Q103474 wd:Q335160 wd:Q25043 wd:Q374172 wd:Q171048 wd:Q153723 wd:Q6144664 wd:Q135465 wd:Q339876 wd:Q270510 wd:Q153677 wd:Q200299 wd:Q640561 wd:Q185658 wd:Q151599 wd:Q251559 wd:Q47075 wd:Q20475 wd:Q166262 wd:Q190086 wd:Q271830 wd:Q104137 wd:Q229633 wd:Q174811 wd:Q32303 wd:Q220780 wd:Q193835 wd:Q152857 wd:Q105598 wd:Q644987 wd:Q110354 wd:Q42198 wd:Q211372 wd:Q431093 wd:Q216006 wd:Q18002795 wd:Q866120 wd:Q39571 wd:Q188718 wd:Q214723 wd:Q152105 wd:Q565231 wd:Q217189 wd:Q184843 wd:Q748851 wd:Q851095 wd:Q239756 wd:Q850159 wd:Q272860 wd:Q220910 wd:Q29011 wd:Q1415964 wd:Q1392744 wd:Q5890 wd:Q126699 wd:Q309545 wd:Q164103 wd:Q337078 wd:Q949228 wd:Q204212 wd:Q201674 wd:Q2875 wd:Q684150 wd:Q373096 wd:Q222720 wd:Q109135 wd:Q1212650 wd:Q1757288 wd:Q496255 wd:Q183063 wd:Q269912 wd:Q208632 wd:Q132863 wd:Q183081 wd:Q14920425 wd:Q210756 wd:Q1128756 wd:Q1768437 wd:Q221462 wd:Q165325 wd:Q24953 wd:Q223884 wd:Q465773 wd:Q190643 wd:Q244315 wd:Q232000 wd:Q572165 wd:Q162331 wd:Q695255 wd:Q494722 wd:Q778161 wd:Q3023357 wd:Q506418 wd:Q304074 wd:Q3521099 wd:Q474098 wd:Q184255 wd:Q18547944 wd:Q210364 wd:Q233464 wd:Q180098 wd:Q676039 wd:Q16672466 wd:Q59249 wd:Q8885676 wd:Q739046 wd:Q200437 wd:Q202211 wd:Q167726 wd:Q12018 wd:Q107226 wd:Q426828 wd:Q193695 wd:Q645094 wd:Q192115 wd:Q659609 wd:Q499639 wd:Q162255 wd:Q175038 wd:Q488169 wd:Q488655 wd:Q214801 wd:Q188652 wd:Q187726 wd:Q232009 wd:Q784812 wd:Q714057 wd:Q189505 wd:Q182218 wd:Q471716 wd:Q165651 wd:Q466101 wd:Q458656 wd:Q257818 wd:Q14918344 wd:Q5887360 wd:Q573743 wd:Q160060 wd:Q3404003 wd:Q245208 wd:Q46717 wd:Q76479 wd:Q204374 wd:Q498577 wd:Q201293 wd:Q587419 wd:Q325643 wd:Q494871 wd:Q179673 wd:Q156516 wd:Q208108 wd:Q488376 wd:Q1132629 wd:Q652186 wd:Q592072 wd:Q952142 wd:Q1056853 wd:Q18402 wd:Q555687} .
    ?film wdt:P161 ?actor
} 
GROUP BY ?actor 
HAVING (?films >= 5)
ORDER BY DESC(?films)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?actor"):::projected v2("?film"):::projected v4("?filmography") v4("?films") f0[["?films >= '5^^xsd:integer'"]] f0 --> v4 bind1[/VALUES ?film/] bind1-->v2 bind10(["wd:Q172241"]) bind10 --> bind1 bind11(["wd:Q47703"]) bind11 --> bind1 bind12(["wd:Q184768"]) bind12 --> bind1 bind13(["wd:Q163872"]) bind13 --> bind1 bind14(["wd:Q104123"]) bind14 --> bind1 bind15(["wd:Q483941"]) bind15 --> bind1 bind16(["wd:Q2345"]) bind16 --> bind1 bind17(["wd:Q131074"]) bind17 --> bind1 bind18(["wd:Q41483"]) bind18 --> bind1 bind19(["wd:Q190050"]) bind19 --> bind1 bind110(["wd:Q127367"]) bind110 --> bind1 bind111(["wd:Q181795"]) bind111 --> bind1 bind112(["wd:Q134773"]) bind112 --> bind1 bind113(["wd:Q25188"]) bind113 --> bind1 bind114(["wd:Q171669"]) bind114 --> bind1 bind115(["wd:Q164963"]) bind115 --> bind1 bind116(["wd:Q42047"]) bind116 --> bind1 bind117(["wd:Q83495"]) bind117 --> bind1 bind118(["wd:Q189540"]) bind118 --> bind1 bind119(["wd:Q17738"]) bind119 --> bind1 bind120(["wd:Q220741"]) bind120 --> bind1 bind121(["wd:Q190908"]) bind121 --> bind1 bind122(["wd:Q133654"]) bind122 --> bind1 bind123(["wd:Q204191"]) bind123 --> bind1 bind124(["wd:Q132351"]) bind124 --> bind1 bind125(["wd:Q19355"]) bind125 --> bind1 bind126(["wd:Q484675"]) bind126 --> bind1 bind127(["wd:Q168154"]) bind127 --> bind1 bind128(["wd:Q13417189"]) bind128 --> bind1 bind129(["wd:Q155653"]) bind129 --> bind1 bind130(["wd:Q165817"]) bind130 --> bind1 bind131(["wd:Q132689"]) bind131 --> bind1 bind132(["wd:Q208572"]) bind132 --> bind1 bind133(["wd:Q238211"]) bind133 --> bind1 bind134(["wd:Q163038"]) bind134 --> bind1 bind135(["wd:Q174284"]) bind135 --> bind1 bind136(["wd:Q34414"]) bind136 --> bind1 bind137(["wd:Q595"]) bind137 --> bind1 bind138(["wd:Q45602"]) bind138 --> bind1 bind139(["wd:Q208263"]) bind139 --> bind1 bind140(["wd:Q170564"]) bind140 --> bind1 bind141(["wd:Q150804"]) bind141 --> bind1 bind142(["wd:Q172975"]) bind142 --> bind1 bind143(["wd:Q15648198"]) bind143 --> bind1 bind144(["wd:Q91540"]) bind144 --> bind1 bind145(["wd:Q190525"]) bind145 --> bind1 bind146(["wd:Q128518"]) bind146 --> bind1 bind147(["wd:Q182692"]) bind147 --> bind1 bind148(["wd:Q105702"]) bind148 --> bind1 bind149(["wd:Q193570"]) bind149 --> bind1 bind150(["wd:Q46551"]) bind150 --> bind1 bind151(["wd:Q36479"]) bind151 --> bind1 bind152(["wd:Q103569"]) bind152 --> bind1 bind153(["wd:Q109116"]) bind153 --> bind1 bind154(["wd:Q153882"]) bind154 --> bind1 bind155(["wd:Q464032"]) bind155 --> bind1 bind156(["wd:Q571032"]) bind156 --> bind1 bind157(["wd:Q186341"]) bind157 --> bind1 bind158(["wd:Q747936"]) bind158 --> bind1 bind159(["wd:Q189330"]) bind159 --> bind1 bind160(["wd:Q104905"]) bind160 --> bind1 bind161(["wd:Q274520"]) bind161 --> bind1 bind162(["wd:Q25139"]) bind162 --> bind1 bind163(["wd:Q104814"]) bind163 --> bind1 bind164(["wd:Q6074"]) bind164 --> bind1 bind165(["wd:Q24815"]) bind165 --> bind1 bind166(["wd:Q186572"]) bind166 --> bind1 bind167(["wd:Q475693"]) bind167 --> bind1 bind168(["wd:Q223139"]) bind168 --> bind1 bind169(["wd:Q202548"]) bind169 --> bind1 bind170(["wd:Q62730"]) bind170 --> bind1 bind171(["wd:Q206388"]) bind171 --> bind1 bind172(["wd:Q127021"]) bind172 --> bind1 bind173(["wd:Q181803"]) bind173 --> bind1 bind174(["wd:Q196977"]) bind174 --> bind1 bind175(["wd:Q484048"]) bind175 --> bind1 bind176(["wd:Q72962"]) bind176 --> bind1 bind177(["wd:Q162729"]) bind177 --> bind1 bind178(["wd:Q181086"]) bind178 --> bind1 bind179(["wd:Q487181"]) bind179 --> bind1 bind180(["wd:Q187278"]) bind180 --> bind1 bind181(["wd:Q47221"]) bind181 --> bind1 bind182(["wd:Q478209"]) bind182 --> bind1 bind183(["wd:Q177922"]) bind183 --> bind1 bind184(["wd:Q228186"]) bind184 --> bind1 bind185(["wd:Q208269"]) bind185 --> bind1 bind186(["wd:Q243439"]) bind186 --> bind1 bind187(["wd:Q190956"]) bind187 --> bind1 bind188(["wd:Q62665"]) bind188 --> bind1 bind189(["wd:Q309153"]) bind189 --> bind1 bind190(["wd:Q172837"]) bind190 --> bind1 bind191(["wd:Q103474"]) bind191 --> bind1 bind192(["wd:Q335160"]) bind192 --> bind1 bind193(["wd:Q25043"]) bind193 --> bind1 bind194(["wd:Q374172"]) bind194 --> bind1 bind195(["wd:Q171048"]) bind195 --> bind1 bind196(["wd:Q153723"]) bind196 --> bind1 bind197(["wd:Q6144664"]) bind197 --> bind1 bind198(["wd:Q135465"]) bind198 --> bind1 bind199(["wd:Q339876"]) bind199 --> bind1 bind1100(["wd:Q270510"]) bind1100 --> bind1 bind1101(["wd:Q153677"]) bind1101 --> bind1 bind1102(["wd:Q200299"]) bind1102 --> bind1 bind1103(["wd:Q640561"]) bind1103 --> bind1 bind1104(["wd:Q185658"]) bind1104 --> bind1 bind1105(["wd:Q151599"]) bind1105 --> bind1 bind1106(["wd:Q251559"]) bind1106 --> bind1 bind1107(["wd:Q47075"]) bind1107 --> bind1 bind1108(["wd:Q20475"]) bind1108 --> bind1 bind1109(["wd:Q166262"]) bind1109 --> bind1 bind1110(["wd:Q190086"]) bind1110 --> bind1 bind1111(["wd:Q271830"]) bind1111 --> bind1 bind1112(["wd:Q104137"]) bind1112 --> bind1 bind1113(["wd:Q229633"]) bind1113 --> bind1 bind1114(["wd:Q174811"]) bind1114 --> bind1 bind1115(["wd:Q32303"]) bind1115 --> bind1 bind1116(["wd:Q220780"]) bind1116 --> bind1 bind1117(["wd:Q193835"]) bind1117 --> bind1 bind1118(["wd:Q152857"]) bind1118 --> bind1 bind1119(["wd:Q105598"]) bind1119 --> bind1 bind1120(["wd:Q644987"]) bind1120 --> bind1 bind1121(["wd:Q110354"]) bind1121 --> bind1 bind1122(["wd:Q42198"]) bind1122 --> bind1 bind1123(["wd:Q211372"]) bind1123 --> bind1 bind1124(["wd:Q431093"]) bind1124 --> bind1 bind1125(["wd:Q216006"]) bind1125 --> bind1 bind1126(["wd:Q18002795"]) bind1126 --> bind1 bind1127(["wd:Q866120"]) bind1127 --> bind1 bind1128(["wd:Q39571"]) bind1128 --> bind1 bind1129(["wd:Q188718"]) bind1129 --> bind1 bind1130(["wd:Q214723"]) bind1130 --> bind1 bind1131(["wd:Q152105"]) bind1131 --> bind1 bind1132(["wd:Q565231"]) bind1132 --> bind1 bind1133(["wd:Q217189"]) bind1133 --> bind1 bind1134(["wd:Q184843"]) bind1134 --> bind1 bind1135(["wd:Q748851"]) bind1135 --> bind1 bind1136(["wd:Q851095"]) bind1136 --> bind1 bind1137(["wd:Q239756"]) bind1137 --> bind1 bind1138(["wd:Q850159"]) bind1138 --> bind1 bind1139(["wd:Q272860"]) bind1139 --> bind1 bind1140(["wd:Q220910"]) bind1140 --> bind1 bind1141(["wd:Q29011"]) bind1141 --> bind1 bind1142(["wd:Q1415964"]) bind1142 --> bind1 bind1143(["wd:Q1392744"]) bind1143 --> bind1 bind1144(["wd:Q5890"]) bind1144 --> bind1 bind1145(["wd:Q126699"]) bind1145 --> bind1 bind1146(["wd:Q309545"]) bind1146 --> bind1 bind1147(["wd:Q164103"]) bind1147 --> bind1 bind1148(["wd:Q337078"]) bind1148 --> bind1 bind1149(["wd:Q949228"]) bind1149 --> bind1 bind1150(["wd:Q204212"]) bind1150 --> bind1 bind1151(["wd:Q201674"]) bind1151 --> bind1 bind1152(["wd:Q2875"]) bind1152 --> bind1 bind1153(["wd:Q684150"]) bind1153 --> bind1 bind1154(["wd:Q373096"]) bind1154 --> bind1 bind1155(["wd:Q222720"]) bind1155 --> bind1 bind1156(["wd:Q109135"]) bind1156 --> bind1 bind1157(["wd:Q1212650"]) bind1157 --> bind1 bind1158(["wd:Q1757288"]) bind1158 --> bind1 bind1159(["wd:Q496255"]) bind1159 --> bind1 bind1160(["wd:Q183063"]) bind1160 --> bind1 bind1161(["wd:Q269912"]) bind1161 --> bind1 bind1162(["wd:Q208632"]) bind1162 --> bind1 bind1163(["wd:Q132863"]) bind1163 --> bind1 bind1164(["wd:Q183081"]) bind1164 --> bind1 bind1165(["wd:Q14920425"]) bind1165 --> bind1 bind1166(["wd:Q210756"]) bind1166 --> bind1 bind1167(["wd:Q1128756"]) bind1167 --> bind1 bind1168(["wd:Q1768437"]) bind1168 --> bind1 bind1169(["wd:Q221462"]) bind1169 --> bind1 bind1170(["wd:Q165325"]) bind1170 --> bind1 bind1171(["wd:Q24953"]) bind1171 --> bind1 bind1172(["wd:Q223884"]) bind1172 --> bind1 bind1173(["wd:Q465773"]) bind1173 --> bind1 bind1174(["wd:Q190643"]) bind1174 --> bind1 bind1175(["wd:Q244315"]) bind1175 --> bind1 bind1176(["wd:Q232000"]) bind1176 --> bind1 bind1177(["wd:Q572165"]) bind1177 --> bind1 bind1178(["wd:Q162331"]) bind1178 --> bind1 bind1179(["wd:Q695255"]) bind1179 --> bind1 bind1180(["wd:Q494722"]) bind1180 --> bind1 bind1181(["wd:Q778161"]) bind1181 --> bind1 bind1182(["wd:Q3023357"]) bind1182 --> bind1 bind1183(["wd:Q506418"]) bind1183 --> bind1 bind1184(["wd:Q304074"]) bind1184 --> bind1 bind1185(["wd:Q3521099"]) bind1185 --> bind1 bind1186(["wd:Q474098"]) bind1186 --> bind1 bind1187(["wd:Q184255"]) bind1187 --> bind1 bind1188(["wd:Q18547944"]) bind1188 --> bind1 bind1189(["wd:Q210364"]) bind1189 --> bind1 bind1190(["wd:Q233464"]) bind1190 --> bind1 bind1191(["wd:Q180098"]) bind1191 --> bind1 bind1192(["wd:Q676039"]) bind1192 --> bind1 bind1193(["wd:Q16672466"]) bind1193 --> bind1 bind1194(["wd:Q59249"]) bind1194 --> bind1 bind1195(["wd:Q8885676"]) bind1195 --> bind1 bind1196(["wd:Q739046"]) bind1196 --> bind1 bind1197(["wd:Q200437"]) bind1197 --> bind1 bind1198(["wd:Q202211"]) bind1198 --> bind1 bind1199(["wd:Q167726"]) bind1199 --> bind1 bind1200(["wd:Q12018"]) bind1200 --> bind1 bind1201(["wd:Q107226"]) bind1201 --> bind1 bind1202(["wd:Q426828"]) bind1202 --> bind1 bind1203(["wd:Q193695"]) bind1203 --> bind1 bind1204(["wd:Q645094"]) bind1204 --> bind1 bind1205(["wd:Q192115"]) bind1205 --> bind1 bind1206(["wd:Q659609"]) bind1206 --> bind1 bind1207(["wd:Q499639"]) bind1207 --> bind1 bind1208(["wd:Q162255"]) bind1208 --> bind1 bind1209(["wd:Q175038"]) bind1209 --> bind1 bind1210(["wd:Q488169"]) bind1210 --> bind1 bind1211(["wd:Q488655"]) bind1211 --> bind1 bind1212(["wd:Q214801"]) bind1212 --> bind1 bind1213(["wd:Q188652"]) bind1213 --> bind1 bind1214(["wd:Q187726"]) bind1214 --> bind1 bind1215(["wd:Q232009"]) bind1215 --> bind1 bind1216(["wd:Q784812"]) bind1216 --> bind1 bind1217(["wd:Q714057"]) bind1217 --> bind1 bind1218(["wd:Q189505"]) bind1218 --> bind1 bind1219(["wd:Q182218"]) bind1219 --> bind1 bind1220(["wd:Q471716"]) bind1220 --> bind1 bind1221(["wd:Q165651"]) bind1221 --> bind1 bind1222(["wd:Q466101"]) bind1222 --> bind1 bind1223(["wd:Q458656"]) bind1223 --> bind1 bind1224(["wd:Q257818"]) bind1224 --> bind1 bind1225(["wd:Q14918344"]) bind1225 --> bind1 bind1226(["wd:Q5887360"]) bind1226 --> bind1 bind1227(["wd:Q573743"]) bind1227 --> bind1 bind1228(["wd:Q160060"]) bind1228 --> bind1 bind1229(["wd:Q3404003"]) bind1229 --> bind1 bind1230(["wd:Q245208"]) bind1230 --> bind1 bind1231(["wd:Q46717"]) bind1231 --> bind1 bind1232(["wd:Q76479"]) bind1232 --> bind1 bind1233(["wd:Q204374"]) bind1233 --> bind1 bind1234(["wd:Q498577"]) bind1234 --> bind1 bind1235(["wd:Q201293"]) bind1235 --> bind1 bind1236(["wd:Q587419"]) bind1236 --> bind1 bind1237(["wd:Q325643"]) bind1237 --> bind1 bind1238(["wd:Q494871"]) bind1238 --> bind1 bind1239(["wd:Q179673"]) bind1239 --> bind1 bind1240(["wd:Q156516"]) bind1240 --> bind1 bind1241(["wd:Q208108"]) bind1241 --> bind1 bind1242(["wd:Q488376"]) bind1242 --> bind1 bind1243(["wd:Q1132629"]) bind1243 --> bind1 bind1244(["wd:Q652186"]) bind1244 --> bind1 bind1245(["wd:Q592072"]) bind1245 --> bind1 bind1246(["wd:Q952142"]) bind1246 --> bind1 bind1247(["wd:Q1056853"]) bind1247 --> bind1 bind1248(["wd:Q18402"]) bind1248 --> bind1 bind1249(["wd:Q555687"]) bind1249 --> bind1 v2 --"wdt:P161"--> v3 bind4[/"count(?film)"/] v2 --o bind4 bind4 --as--o v4 bind5[/"?film"/] v2 --o bind5 bind5 --as--o v4