gistfile1.txt

select gil_wiki, count(*) from globalimagelinks where gil_to in (select img_name from image where img_user = 642738) group by gil_wiki;
+-------------------+----------+
| gil_wiki          | count(*) |
+-------------------+----------+
| afwiki            |        1 |
| arwiki            |        5 |
| arzwiki           |        1 |
| azwiki            |        1 |
| bgwiki            |        2 |
| cawiki            |        4 |
| cawikinews        |        1 |
| cswiki            |        3 |
| cswikinews        |        1 |
| dawiki            |        1 |
| dewiki            |       16 |
| dewiktionary      |        4 |
| elwiki            |        1 |
| enwiki            |     1564 |
| enwikinews        |       43 |
| enwikiquote       |        1 |
| enwikisource      |       28 |
| enwikiversity     |        1 |
| enwikivoyage      |        7 |
| enwiktionary      |       21 |
| eowiki            |        1 |
| eowikinews        |        1 |
| eswiki            |       17 |
| eswiktionary      |        1 |
| etwiki            |        1 |
| etwiktionary      |        6 |
| fawiki            |        2 |
| fawikinews        |        1 |
| frwiki            |       24 |
| frwikibooks       |        3 |
| frwiktionary      |        5 |
| fywiki            |        1 |
| glwiki            |        1 |
| hewiki            |        6 |
| hewikivoyage      |        2 |
| hiwiki            |        1 |
| hrwiki            |        1 |
| huwiki            |        7 |
| idwiki            |        3 |
| incubatorwiki     |        1 |
| iswiki            |        1 |
| itwiki            |        7 |
| jawiki            |        6 |
| kawiki            |        1 |
| kmwiki            |        1 |
| kowiki            |        1 |
| kowiktionary      |        1 |
| ltwiki            |        1 |
| metawiki          |       88 |
| mlwiki            |        2 |
| mywiktionary      |        1 |
| nlwiki            |       27 |
| nowiki            |        2 |
| pawiki            |        1 |
| plwiki            |        9 |
| plwikinews        |        2 |
| plwiktionary      |        8 |
| pnbwiki           |        1 |
| ptwiki            |        8 |
| ptwikinews        |        1 |
| rowiki            |        1 |
| ruwiki            |        3 |
| ruwikinews        |        1 |
| scowiki           |        1 |
| simplewiki        |        3 |
| simplewiktionary  |        1 |
| sowiki            |        3 |
| srwiki            |        4 |
| svwiki            |        7 |
| tawikinews        |        1 |
| thwiki            |        2 |
| tlwiki            |        1 |
| trwiki            |        1 |
| ukwiki            |        2 |
| urwiki            |        1 |
| wikimania2014wiki |       13 |
| zhwiki            |        5 |
+-------------------+----------+
78 rows in set (5 min 7.31 sec)