Shadowhelix:Datenbank/Vorschläge

Aus Shadowhelix
< Shadowhelix:Datenbank
Version vom 1. März 2016, 12:25 Uhr von Greadle (Diskussion | Beiträge) (Anmerkung zu fehlenden Contributors)
Zur Navigation springen Zur Suche springen

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');

Korrektur

Dopplungen?

  • 3077 - Joshua Howell
  • 7157 - Joshua Rowell
  • 7468 - Larry Almore
  • 8047 - Larry Elmore
  • 5665 - Jacob Glaser
  • 8919 - Jason Glaser
Abgerufen von „https://shadowhelix.de/index.php?title=Shadowhelix:Datenbank/Vorschläge&oldid=216811“