Shadowhelix:Datenbank/Vorschläge

Shadowhelix:Datenbank

Erweiterung

INSERT INTO contributors(forename_first) VALUES('Liam.C');

INSERT INTO contributors(surname, forename_first) VALUES('Petrov', 'Miroslav');

INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Manold', 'Alyssa', 'Ann');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Thiesen', 'James', 'Joseph');

INSERT INTO contributors_weblink(id_contributor, url) VALUES(446, 'http://widulinskiart.carbonmade.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(446, 'https://www.artstation.com/artist/widulinski');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(532, 'http://hypersteve.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(717, 'http://jameswolfart.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(766, 'http://barelynormalactivity.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(830, 'http://www.facebook.com/chad.sergesketter');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(903, 'http://www.facebook.com/victormanuel.lezamoreno');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'http://www.artflakes.com/de/shop/kunrong-yap');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'https://www.artstation.com/artist/krypt');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'http://yapkunrong.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1156, 'http://dc-concept.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1156, 'http://danielmchavez.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1367, 'http://seanmcmurchy.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1588, 'http://www.facebook.com/groups/114658181901791');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'http://jasonbehnke.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'http://jasonbehnke.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'https://www.facebook.com/behnkestudio');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1997, 'http://www.alexstoneart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1997, 'http://alexstoneart.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(2002, 'https://www.artstation.com/artist/matthansenart');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(2310, 'http://smilout.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(2568, 'http://igorkieryluk.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(2620, 'http://www.rkpost.net');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3010, 'https://www.facebook.com/bOne77');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3034, 'http://ryanbarger.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3034, 'https://www.facebook.com/ryan.barger.923');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3237, 'http://bennewmanart.bigcartel.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3242, 'https://www.artstation.com/artist/bengiskhan');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3402, 'http://bgk-bengiskhan.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3536, 'http://larrymacdougallart.tumblr.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3557, 'http://www.facebook.com/razorfang');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'http://cargocollective.com/art-ly');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'https://www.facebook.com/Lydia-Schuchmann-234211253281512/');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'https://www.behance.net/LydiaSchuchmann');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(4180, 'http://www.facebook.com/jim.nelson.9');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(4232, 'http://nateabell.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(4302, 'http://mattwilsonprime.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5100, 'http://brisbaneillustrators.com/caleb-salisbury.html');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.cgsociety.org');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.artstation.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5170, 'http://blog.johngravato.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'http://arndtdrechsler.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'https://www.facebook.com/arndt.drechsler');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5252, 'http://www.woodillustration.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5252, 'http://stevethebunny.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5310, 'http://alradeck.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5310, 'http://alradeck.tumblr.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5618, 'https://twitter.com/emilyzeinner');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5618, 'https://www.artstation.com/artist/emilyzeinner');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5763, 'https://robertruffolo.carbonmade.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5763, 'https://twitter.com/rruffs');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5848, 'http://peterdora.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5848, 'http://peterman2070.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5880, 'http://kristenplescow.tumblr.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5880, 'http://kristenplescow.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5917, 'https://www.artstation.com/artist/ianllanas');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6077, 'https://www.facebook.com/brent.evans.735');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6100, 'http://envertigo.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6115, 'http://www.facebook.com/peter.bergting');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6244, 'http://www.artworksillustration.com/portfolio%20keithbirdsong.htm');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6244, 'http://www.keith-birdsong.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6343, 'http://davidsmit.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6357, 'http://ectmonster.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6550, 'http://www.artstation.com/artist/hounworks');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6550, 'http://hounworks.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6705, 'http://donatoarts.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6739, 'http://jasoncaffoe.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6880, 'http://takashitan2.wix.com/takashitanportfolio');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7071, 'http://www.davidnashart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7071, 'http://davidnashart.tumblr.com/');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7205, 'http://inkthinker.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7291, 'http://dougkovacs.com/dkblog');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.behance.net/gallery/Galefire-Portfolio/11389539');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'http://michael-galefire.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.facebook.com/MichaelRookardArt');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7842, 'http://www.mikesutfin.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8009, 'http://lucasdurham.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8027, 'http://www.gepart.com.au');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8046, 'https://www.facebook.com/derekgpoole');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8051, 'http://davidkeggillustration.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8051, 'http://david-kegg.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8545, 'http://davidroberthovey.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8577, 'http://mariusandrei.carbonmade.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8580, 'http://drewsil.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8621, 'http://bocetillos.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://bryansyme.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://www.bryansyme.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://fineartamerica.com/profiles/bryan-syme.html');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8703, 'http://runfreakrun.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8703, 'http://runfreakrun.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8964, 'https://www.artstation.com/artist/mauroperoni');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8964, 'http://mauroperoni.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9435, 'http://www.facebook.com/mark.zug');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9495, 'https://www.facebook.com/MichaelKomarckIllustration');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9785, 'http://www.baldegografix.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9854, 'https://www.artstation.com/artist/ryanportillo');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9854, 'http://ryanportillo.deviantart.com');

Chrome Flesh:

INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8545, 'cover art');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 2331, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8147, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 2310, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 3402, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 4485, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8102, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 903, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8964, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 5763, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 133, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 6880, 'illustration');

Data Trails:

INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 6698, 'cover art');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5140, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2331, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8123, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8147, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2310, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 4662, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 3402, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 3904, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8545, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2568, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 903, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8964, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5880, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5763, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 40, 'illustration');

Rigger 5.0:

INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8227, 'cover art');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 4662, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 3402, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8545, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 4485, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 5837, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 903, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8964, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 6880, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 446, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 458, 'illustration');

Shadowrun TCG:

INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5699, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4080, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5475, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 13, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6666, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6131, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1009, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5790, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1588, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7645, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4180, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3557, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8123, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3963, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 9243, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4845, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1212, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3536, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 2820, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 9435, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7832, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4302, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7842, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1628, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 2792, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6115, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8207, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6937, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4962, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3862, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4305, 'illustration', 'Color');

Folgende Contributors fehlen (aus Chrome Flesh, Rigger 5.0, Data Trails und Shadowrun TCG, müssen dann auch alle noch in contributions eingetragen werden). Mit Ausnahme des TCGs (erster Block), wo die Namen direkt von den Karten kommen, habe ich die Namen direkt aus den CGL-Credits und nicht aus dem Internet, kann also sein, dass die noch falsch sind (CGL ist da sehr nachlässig):

INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Hudson', 'Heather');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Ho', 'Patrick');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Fischer', 'Scott');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Nielsen', 'Terese');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gianni', 'Tom');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gregory', 'Barry');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Goleash', 'Grant');

INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Petersen', 'John');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Sintes', 'Marc');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Grierson', 'Katy');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Sondered', 'David');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Vasburg', 'Erich');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Garcia', 'Andre');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Mizzoni', 'Marco');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Peuler', 'Chris');
INSERT INTO contributors(id_contributor, surname, forename_second, forename_first) VALUES(+[ID], 'Webster', 'Cory', 'James');

Und hier mal ein erster Schwung für contributions_illustration (Shadow Spells, Street Grimoire, Data Trails):

Shadow Spells:
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 326075);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 934215);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 63948);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5790, 962138);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 297816);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(7645, 207986);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(3862, 918235);

Street Grimoire:
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 271835);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 824173);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 917520);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 693025);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 745098);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 102698);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8545, 450739);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8545, 412756);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5763, 624135);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8051, 983270);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 384560);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 74281);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6346, 596048);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6131, 715824);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 437956);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 602948);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 980342);

Data Trails:
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6698, 816904);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6698, 491302);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 712869);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 265013);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 27319);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 618974);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5763, 410625);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5880, 562419);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(4662, 970358);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8964, 481253);

Update vom 02.03.2016:

illustrations_source
+[ID]	4602		cv		
+[ID]	4602		back		
+[ID]	4602		1		
+[ID]	4602		5		
+[ID]	4602		5		
+[ID]	4602		5		
+[ID]	4602		6-7		
+[ID]	4602		14		
+[ID]	4602		17		
+[ID]	4602		18		
+[ID]	4602		21		
+[ID]	4602		22		
+[ID]	4602		22		
+[ID]	4602		23		
+[ID]	4602		25		
+[ID]	4602		27		
+[ID]	4602		28		
+[ID]	4602		29		
+[ID]	4602		30		
+[ID]	4602		30		
+[ID]	4602		31		
+[ID]	4602		31		
+[ID]	4602		32		
+[ID]	4602		32		
+[ID]	4602		33		
+[ID]	4602		33		
+[ID]	4602		34		
+[ID]	4602		34		
+[ID]	4602		35		
+[ID]	4602		35		
+[ID]	4602		36		
+[ID]	4602		36		
+[ID]	4602		37		
+[ID]	4602		37		
+[ID]	4602		38		
+[ID]	4602		38		
+[ID]	4602		39		
+[ID]	4602		40		
+[ID]	4602		40		
+[ID]	4602		41		
+[ID]	4602		41		
+[ID]	4602		42		
+[ID]	4602		42		
+[ID]	4602		43		
+[ID]	4602		43		
+[ID]	4602		44		
+[ID]	4602		44		
+[ID]	4602		45		
+[ID]	4602		45		
+[ID]	4602		46		
+[ID]	4602		46		
+[ID]	4602		47		
+[ID]	4602		48		
+[ID]	4602		48		
+[ID]	4602		49		
+[ID]	4602		50		
+[ID]	4602		62		
+[ID]	4602		64		
+[ID]	4602		66		
+[ID]	4602		67		
+[ID]	4602		67		
+[ID]	4602		68		
+[ID]	4602		69		
+[ID]	4602		71		
+[ID]	4602		73		
+[ID]	4602		74		
+[ID]	4602		76		
+[ID]	4602		77		
+[ID]	4602		80		
+[ID]	4602		82		
+[ID]	4602		86		
+[ID]	4602		92		
+[ID]	4602		101		
+[ID]	4602		103		
+[ID]	4602		109		
+[ID]	4602		119		
+[ID]	4602		131		
+[ID]	4602		138		
+[ID]	4602		151		
+[ID]	4602		165		
+[ID]	4602		168		
+[ID]	4602		173		
+[ID]	4602		181		
+[ID]	4602		185		
+[ID]	4602		198-199		
+[ID]	4602		216		
+[ID]	4160		cv		
+[ID]	4160		back		
+[ID]	4160		1		
+[ID]	4160		6-7		
+[ID]	4160		14		
+[ID]	4160		20		
+[ID]	4160		24		
+[ID]	4160		37		
+[ID]	4160		43		
+[ID]	4160		46		
+[ID]	4160		53		
+[ID]	4160		58-59		
+[ID]	4160		65		
+[ID]	4160		72		
+[ID]	4160		79		
+[ID]	4160		81		
+[ID]	4160		89		
+[ID]	4160		96		
+[ID]	4160		129		
+[ID]	4160		137		
+[ID]	4160		150		
+[ID]	4160		160		
+[ID]	4160		161		
+[ID]	4160		162		
+[ID]	4160		163		
+[ID]	4160		164		
+[ID]	4160		165		
+[ID]	4160		166		
+[ID]	4160		167		
+[ID]	4160		168-169		
+[ID]	4160		175		
+[ID]	4160		187		
+[ID]	4160		199		
+[ID]	4160		207		
+[ID]	4160		209		
+[ID]	4160		214		
+[ID]	4160		230		
+[ID]	4160		256		
+[ID]	6600		cv		
+[ID]	6600		6		
+[ID]	6600		10-11		
+[ID]	6600		16-17		
+[ID]	6600		22		
+[ID]	6600		26		
+[ID]	6600		36		
+[ID]	6600		37		
+[ID]	6600		40		
+[ID]	6600		36		
+[ID]	6600		42		
+[ID]	6600		46		
+[ID]	6600		55		
+[ID]	6600		57		
+[ID]	6600		58-59		
+[ID]	6600		71		
+[ID]	6600		87		
+[ID]	6600		91		
+[ID]	6600		93		
+[ID]	6600		95		
+[ID]	6600		100		
+[ID]	6600		103		
+[ID]	6600		111		
+[ID]	6600		112		
+[ID]	6600		113		
+[ID]	6600		114		
+[ID]	6600		115		
+[ID]	6600		116		
+[ID]	6600		117		
+[ID]	6600		118		
+[ID]	6600		119		
+[ID]	6600		120		
+[ID]	6600		121		
+[ID]	6600		122		
+[ID]	6600		123		
+[ID]	6600		124		
+[ID]	6600		125		
+[ID]	6600		126		
+[ID]	6600		127		
+[ID]	6600		132		
+[ID]	6600		138		
+[ID]	6600		148		
+[ID]	6600		152		
+[ID]	6600		153		
+[ID]	6600		154-155		
+[ID]	6600		166		
+[ID]	6600		171		
+[ID]	6600		186		
+[ID]	6600		200		
+[ID]	6600		206		
+[ID]	6600		209		
+[ID]	6600		210-211		
+[ID]	6600		230		
+[ID]	6600		237		
+[ID]	6600		243		
+[ID]	6600		255		
+[ID]	6600		258		
+[ID]	6600		260-261		
+[ID]	6600		263		
+[ID]	6600		268		
+[ID]	6600		270		
+[ID]	6600		272-273		
+[ID]	6600		280		
+[ID]	6600		289		
+[ID]	6600		299		
+[ID]	6600		308		
+[ID]	6600		311		
+[ID]	6600		325		
+[ID]	6600		327		
+[ID]	6600		337		
+[ID]	6600		346		
+[ID]	6600		355		
+[ID]	6600		373		
+[ID]	6600		374-375		
+[ID]	6600		381		
+[ID]	6600		386		
+[ID]	6600		393		
+[ID]	6600		402		
+[ID]	6600		405		
+[ID]	6600		415		
+[ID]	6600		424		
+[ID]	6600		425		
+[ID]	6600		425		
+[ID]	6600		426		
+[ID]	6600		426		
+[ID]	6600		427		
+[ID]	6600		427		
+[ID]	6600		428		
+[ID]	6600		429		
+[ID]	6600		429		
+[ID]	6600		431		
+[ID]	6600		439		
+[ID]	6600		447		
+[ID]	6600		462		
+[ID]	6600		464		
+[ID]	6600		466		
+[ID]	6600		467		

contributions
8051	6427	illustration	u	Color
6346	6427	illustration	u	Color
5790	7366	illustration	u	Color
7645	7366	illustration	u	Color
3862	7366	illustration	u	Color

contributions_illustration
2011	715623
8545	491375
2520	427653
3402	71492
773	386571
3402	602471
2331	38467
8545	156978
2331	879326

Korrektur

Dopplungen?

• 3077 - Joshua Howell
• 7157 - Joshua Rowell

• 7468 - Larry Almore
• 8047 - Larry Elmore

• 5665 - Jacob Glaser
• 8919 - Jason Glaser