query-e745a92b0a545e568d06e3e7b59a4cfe
Actors with a least 5 Top 250 movies
Use at
- https://query.wikidata.org/sparql
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