forked from GwentAPI/data
-
Notifications
You must be signed in to change notification settings - Fork 0
/
GwentAPI_INSERT.sql
923 lines (796 loc) · 77.6 KB
/
GwentAPI_INSERT.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
USE `gwentapi`;
#Types
INSERT INTO Types
(id, name)
VALUES
('special', 'Special'),
('leader', 'Leader'),
('troop', 'Troop'),
('character', 'Character'),
('hero', 'Hero'),
('loyal', 'Loyal'),
('disloyal', 'Disloyal');
#Factions
INSERT INTO Factions
(id, name)
VALUES
('neutral', 'Neutral'),
('northern-realms', 'Northern Realms'),
('scoiatael', 'Scoia\'tael'),
('monsters', 'Monsters'),
('skellige', 'Skellige');
#Rarities
INSERT INTO Rarities
(id, name)
VALUES
('common','Common'),
('rare','Rare'),
('epic','Epic'),
('legendary','Legendary');
#Rows
INSERT INTO Rows
(id, name)
VALUES
('melee','Melee'),
('ranged','Ranged'),
('siege','Siege');
#Categories
INSERT INTO Categories
(name)
VALUES
('normal'),
('full'),
('small');
#Glyphs
INSERT INTO Glyphs
(id, name, isWeatherGlyph, text)
VALUES
('spores', 'Spores', false, 'This glyph adds +4 to the Strength of all non-Hero Units.'),
('fog', 'Fog', true, 'This glyph reduces the base Strength of non-Hero Units to 1.'),
('inspire', 'Inspire', false, 'This glyph doubles the Strength of all non-Hero Units.'),
('frost', 'Frost', true, 'This glyph reduces the base Strength of all non-Hero Units to 1.'),
('rain', 'Rain', true, 'This glyph reduces the base Strength of non-Hero Units to 1.');
#Abilities
INSERT INTO Abilities
(id, name, description)
VALUES
('inspire','Inspire', null),
('swap','Swap', null),
('fogwalker-legion','Fogwalker Legion', null),
('spy','Spy', null),
('frost','Frost', null),
('muster','Muster', null),
('encourage','Encourage', null),
('summon','Summon', null),
('faithful-servant','Faithful Servant', null),
('horde','Horde', null),
('resurrection','Resurrection', null),
('withdrawal','Withdrawal', null),
('empower','Empower', null),
('fair-weather','Fair Weather', null),
('shaman','Shaman', null),
('ambush','Ambush', null),
('plague','Plague', null),
('weatherbound','Weatherbound', null),
('commander-of-the-north','Commander of the North', null),
('igni','Igni', null),
('deathwish','Deathwish', null),
('the-frosts-harbingers','The Frost\'s Harbingers', null),
('fog','Fog', null),
('resilient','Resilient', null),
('spores','Spores', null),
('incinerate','Incinerate', null),
('ill-be-there-for-you','I\'ll be there for you', null),
('choice','Choice', null),
('rain','Rain', null),
('discourage','Discourage', null),
('frostwalker-legion','Frostwalker Legion', null);
#Cards
INSERT INTO Cards
(id, name, idRarity, idFaction, idType, idAbility, strength, text, flavor)
VALUES
('alchemist', 'Alchemist', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Inspire'), 2,
'Inspire: Fresh Recruits
Passive: 2x Strength of all Units without any Ability on row, unless another card with Inspire: Fresh Recruits is already on row.' , null),
('ancient-foglet', 'Ancient Foglet', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Fogwalker Legion'), 3,
'Fogwalker Legion
When Played: Play every copy of this card from your Deck and Hand.
Passive: Double its Strength when a Fog glyph is on the Battlefield.' , null),
('avallach-mysterious-elf', 'Avallac\'h: Mysterious Elf', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 12,
'Spy: False Prophecy
Played: Draw 2 cards from your Deck. Place one in your Hand, the other in your Graveyard.' , null),
('avallach-the-sage', 'Avallac\'h: The Sage', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 10,
'Spy: Emissary
Played: Draw 2 cards from your Deck to your Hand. Your opponent Draws 1 card from their Deck to their Hand. This card is revealed to you.' , null),
('biting-frost', 'Biting Frost', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Frost'), null,
'Frost
When Played: Place a Frost Glyph on both players\' Melee rows. Reduces base Strength of all cards on row to 1.' , null),
('blue-mountain-commando', 'Blue Mountain Commando', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 3,
'Muster: All For One
When Played: Play every copy of this card, from your Deck, Hand and Graveyard.' , null),
('blue-stripes-commando', 'Blue Stripes Commando', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 2,
'Muster: Unity
When Played: Play a copy of this card from your Deck or Hand.
Passive: Double the Strength of any copies of this card on the same row.' , null),
('blue-stripes-scout', 'Blue Stripes Scout', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Encourage'), 4,
'Encourage
Passive: Increase the Strength of every non-Hero Unit on its row (except this card) by +2.' , null),
('blueboy-lugos', 'Blueboy Lugos', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Summon'), 4,
'Summon: Leviathan
When Played: Spawn and play a Whale which changes rows randomly after each turn and reduces the Strength of any non-Hero Units on its row by -2.' , null),
('brouver-hoog', 'Brouver Hoog', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Leader'), (SELECT idAbility FROM Abilities WHERE name = 'Faithful Servant'), null,
'Faithful Servant
Use Once: Pick 1 Character from your Deck and play it instantly.' , null),
('caranthir', 'Caranthir', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Horde'), 2,
'Horde: Wild Hunt
When Played: Copy every Wild Hunt Unit on row.',
'A favorite son who chose a life of villainy.'),
('caretaker', 'Caretaker', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Resurrection'), 8,
'Resurrection: Graverobber
When Played: Take any non-Hero Unit from your opponent\'s Graveyard. Play it instantly.' , null),
('cerys', 'Cerys', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 6,
'Muster: Royal Retinue
When Played: Play all Queensguards from your Deck, Hand, or Graveyard.' , null),
('ciri-blink', 'Ciri: Blink', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Withdrawal'), 10,
'Withdrawal
Passive: Returns to your Hand if you lose the round.' , null),
('clan-an-craite-warrior', 'Clan an Craite Warrior', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Empower'), 6,
'Empower: Revenge
Passive: Increase its Strength by +6 when it is played from the Graveyard.' , null),
('clan-dimun-pirate-captain', 'Clan Dimun Pirate Captain', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Empower'), 6,
'Empower: Revenge
Passive: Increases its Strength by +6 when it is played from the Graveyard.' , null),
('clan-tordarroch-armorsmith', 'Clan Tordarroch Armorsmith', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Encourage'), 4,
'Encourage
Passive: Increase the Strength of every non-Hero Unit on its row (except this card) by +2.' , null),
('clear-skies', 'Clear Skies', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Fair Weather'), null,
'Fair Weather
When Played: Remove all weather glyphs from the Battlefield.' , null),
('commanders-horn', 'Commander\'s Horn', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Inspire'), null,
'Inspire
When Played: Place an Inspire glyph on its row. This glyph doubles the Strength of all non-Hero Units.' , null),
('coral', 'Coral', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Resurrection'), 8,
'Resurrection:Decompression
When Played: Take any non-Hero Unit or Special Card from your Graveyard. Play it instantly.
Discarded when removed from the Battlefield.' , null),
('crash-an-craite', 'Crach An Craite', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Leader'), (SELECT idAbility FROM Abilities WHERE name = 'Summon'), null,
'Summon: An Craite Clansmen
Use Once: Spawn and play 2 An Craite Clansmen.' , null),
('crone-brewess', 'Crone: Brewess', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 7,
'Muster: Crones
When Played: Play all other Crones from your Deck or Hand.' , null),
('crone-weavess', 'Crone: Weavess', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 7,
'Muster: Crones
When Played: Play all other Crones from your Deck or Hand.' , null),
('crone-whispess', 'Crone: Whispess', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 7,
'Muster: Crones
When Played: Play all other Crones from your Deck or Hand.' , null),
('dagon', 'Dagon', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Leader'), (SELECT idAbility FROM Abilities WHERE name = 'Shaman'), null,
'Shaman
Use Once: Spawn and play a Weather Card of your choice.' , null),
('dandelion', 'Dandelion', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Inspire'), 1,
'Inspire
When Played: Place an Inspire glyph on its row. This glyph doubles the Strength of all non-hero Units.' , null),
('decoy', 'Decoy', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Swap'), null,
'Swap
When Played: Return a loyal, non-Hero Unit on the Battlefield to your Hand and play this in its place. Cannot replace Units which have the Swap ability.' , null),
('dijkstra', 'Dijkstra', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 8,
'Spy
When Played: Draw 2 cards from your Deck, one face up and once face down. Pick one card and put it in your Hand. Return the other to your Deck.',
'Gwent\'s like politics, just more honest.'),
('dol-blathanna-marksman', 'Dol Blathanna Marksman', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 3,
'Muster: All For One
When Played: Play every copy of this card, from your Deck, Hand and Graveyard.' , null),
('donar-an-hindar', 'Donar an Hindar', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 8,
'Spy: Diplomat
Played: Draw 1 card from your Deck to your Hand and 1 card from your Deck to your Graveyard.' , null),
('dun-banner-light-cavalry', 'Dun Banner Light Cavalry', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 2,
'Muster: Unity
When Played: Play a copy of this card from your Deck or Hand.
Passive: Double the Strength of any copies of this card on the same row.' , null),
('eithne', 'Eithne', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Leader'), (SELECT idAbility FROM Abilities WHERE name = 'Ambush'), null,
'Ambush
Use Once: Transform all loyal cards with Swap into Dol Blathanna Archers',
'"The dryad queen has eyes of molten silver, and heart of cold-forged steel."'),
('epidemic', 'Epidemic', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Plague'), null,
'Plague
When Played: Remove weakest Unit(s) on Battlefield' , null),
('eredin-hero', 'Eredin (Hero)', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Leader'), (SELECT idAbility FROM Abilities WHERE name = 'Summon'), null,
'Summon: Auberon\'s Assassin
Use Once: Eredin steps onto the Battlefield' , null),
('foglet', 'Foglet', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Weatherbound'), 1,
'Weatherbound: Fog
Passive: Whenever a Fog glyph is placed, play this card from your Deck, Hand or Graveyard and double its Strength. Send this card to the Graveyard when the Fog glyph is removed.' , null),
('foltest', 'Foltest', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Leader'), (SELECT idAbility FROM Abilities WHERE name = 'Commander of the North'), null,
'Commander of the North
Use Once: Choose a loyal Troop on the battlefield and spawn and play a copy of it',
'Don\'t need advisors and their schemes. I place my trust in my soldiers\' blades.'),
('frightener', 'Frightener', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 8,
'Spy: Carcass Eater
Played: Draw 1 card and banish 1 Unit from opponent\'s Graveyard.',
'"What have I done?" the mage cried out, frightened of his own creation.'),
('geralt-igni', 'Geralt: Igni', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Igni'), 10,
'Igni
When Played: If the opponent\'s Melee row\'s total Strength is equal to or greater than 15, send the strongest card(s) from that row to the Graveyard.
Also remove all Frost glpyphs from the battlfield',
'A twist of a witcher\'s fingers can light a lamp... or incinerate a foe.'),
('geralt-swordmaster', 'Geralt: Swordmaster', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), null, 15, null , null),
('giant-toad', 'Giant Toad', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Empower'), 8,
'Empower: Rainwalker
Passive: Rain grants 2x Strength',
'Big, bad, ugly. Squats in the sewers.'),
('golem', 'Golem', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Deathwish'), 4,
'Deathwish: Lesser Golems
When Removed: Spawn 2 Lesser Golems' , null),
('griffin', 'Griffin', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Troop'), null, 8, null , null),
('havcaaren-healer', 'Hav\'caaren Healer', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Resurrection'), 0,
'Resurrection
When Played: Take any non-Hero Unit from your Graveyard. Play it instantly.', null),
('hjalmar', 'Hjalmar', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Hero'), null, 15, null , null),
('ice-giant', 'Ice Giant', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Empower'), 8,
'Empower: Frostwalker
Passive: Double its Strength when a Frost glyph is on the Battlefield.' , null),
('imlerith', 'Imlerith', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'The Frost\'s Harbingers'), 6,
'The Frost\'s Harbingers
When Played: Cast Frost and spawn and play 2 Wild Hunt Hounds with the Frostbound ability.',
'Ladd nahw! Kill them! Litter the earth with their entrails!'),
('impenetrable-fog', 'Impenetrable Fog', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Fog'), null,
'Fog
When Played: Place a Fog glyph on both players\' Ranged rows. This glyph reduces the base Strength of non-Hero Units to 1.' , null),
('ithlinne-aegli', 'Ithlinne Aegli', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 4,
'Spy: Prophetic Powers
When Played: Draw a random Special Card from your Deck to your Hand.' , null),
('jade-golem', 'Jade Golem', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Deathwish'), 4,
'Deathwish: Lesser Jade Golems
When Removed: Spawn 2 Lesser Jade Golems' , null),
('kaedweni-siege-support', 'Kaedweni Siege Support', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Encourage'), 4,
'Encourage
Passive: Increase the Strength of every non-Hero Unit on its row (except this card) by +2.' , null),
('katakan', 'Katakan', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 8,
'Spy: Carcass Eater
Played: Draw 1 card and banish 1 Unit from opponent\'s Graveyard',
'Drinking the blood of the Continent since the Conjunction.'),
('lambert', 'Lambert', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 8,
'Muster: Witchers
When Played: Play all Witchers from Deck & Hand' , null),
('leshen', 'Leshen', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Summon'), 5,
'Summon: Beastly Companions
When Played: Spawn and play 3 Wolves and 1 Bear.' , null),
('mahakaman-guard', 'Mahakaman Guard', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Resilient'), 6,
'Resilient
Passive: Keep on the Battlefield after each round.' , null),
('morenn', 'Morenn', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Encourage'), 8,
'Encourage
Passive: Increase the Strength of every non-Hero Unit on its row (except this card) by +2.' , null),
('morkvarg', 'Morkvarg', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Resilient'), 8,
'Resilient: Revenant
When Removed: Return to the Battlefield. Reduce its Strength by -2.',
'The vilest man Skellige\'s ever known'),
('mushrooms', 'Mushrooms', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Spores'), null,
'Spores
When Played: Place a Spores glyph on a row, adding +4 to the Strength of all non-Hero Units' , null),
('myrgtabrakke', 'Myrgtabrakke', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Incinerate'), 6,
'Incinerate: Siege
When Played: if your opponent\'s Siege row\'s total Strength is equal to or greater than 15, send the strongest non-Hero Unit(s) on that row to the Graveyard.' , null),
('nithral', 'Nithral', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 2,
'Muster: Wild Hunt Warrior
When Played: Play a Wild Hunt Warrior from your deck.' , null),
('olaf-the-bear', 'Olaf the Bear', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 9,
'Muster: Vabjorn
When Played: Play Vabjorn from your Deck or Hand.' , null),
('operator', 'Operator', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 8,
'Muster: Hero
When Played: Play random hero from Deck
When Removed: Discard.' , null),
('priestess-of-freya', 'Priestess of Freya', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Resurrection'), 0,
'Resurrection
When Played: Take any non-Hero Unit from your Graveyard. Play it instantly.' , null),
('prize-winning-cow', 'Prize Winning Cow', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Deathwish'), 0,
'Deathwish: Bovine Defense Force
When Removed: Spawn a Chort',
'"Mooooooo."'),
('queensguard', 'Queensguard', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 4,
'Muster
When Played: Play every copy of this card from your Deck and Hand.' , null),
('redanian-elite', 'Redanian Elite', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 4,
'Muster: Fearless
When Played: Play a copy of this card from your Deck or Hand.
Passive: If there are 3 or more copies of this card on the same row, promote all of them to Heroes.' , null),
('riordain', 'Riordain', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Deathwish'), 4,
'Deathwish: Vrihedd Brigade
When Removed: Spawn and play a Vrihedd Brigade.' , null),
('roach', 'Roach', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'I\'ll be there for you'), 4,
'I\'ll be there for you
Passive: Play this card from your Deck, Hand or Graveyard on a random row whenever anyone plays a hero',
'Geralt, we gotta have a man-to-horse talk. No offense, but your riding skills? They leave a bit to be desired, buddy.'),
('sarah', 'Sarah', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Fair Weather'), 4,
'Fair Weather
When Played: Remove all Weather glyphs from the battlefield.' , null),
('saskia', 'Saskia', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Choice'), 6,
'Choice: Incinerate or Inspire
When Played: Either Incinerate (remove strongest Unit(s) in play) or Inspire (double the Strength of Units on a row).' , null),
('scorch', 'Scorch', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Incinerate'), null,
'Incinerate
When Played: Send the strongest non-Hero Unit(s) on the battlefield to the Graveyard.' , null),
('shani', 'Shani', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Resurrection'), 6,
'Resurrection: Oxenfurt Expertise
When Played: Take any non-Hero Unit from your Graveyard. Play and promote it to a Hero instantly.' , null),
('sheldon-skaggs', 'Sheldon Skaggs', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 4,
'Muster: Mahakaman Guard
When Played: Play a Mahakaman Guard from your Deck.' , null),
('sigfrida', 'Sigfrida', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Resurrection'), 2,
'Resurrection: Freya\'s Grace
When Played: Take any non-Hero Unit from your Graveyard. Play it instantly.
Passive: Increase its Strength by +1 whenever anyone plays a card from the Graveyard.' , null),
('skellige-storm', 'Skellige Storm', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Choice'), null,
'Choice: Fog or Rain
When Played: Spawn and play either Impenetrable Fog or Torrential Rain.' , null),
('thaler', 'Thaler', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 8,
'Spy
When Played: Draw 2 cards from your Deck, one face up and one face down. Pick ne card and put it in your hand. Return the other to your Deck.' , null),
('tordarroch-shieldsmith', 'Tordarroch Shieldsmith', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Encourage'), 4,
'Encourage
Passive: Increase the Strength of every non-Hero Unit on its row (except this card) by +2.' , null),
('torrential-rain', 'Torrential Rain', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Rain'), null,
'Rain
When Played: Place a Rain glyph on both players\' Siege rows. This glyph reduces the base Strength of non-Hero Units to 1.' , null),
('triss-butterfly-spell', 'Triss: Butterfly Spell', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Fog'), 11,
'Fog
When Played: Place a Fog Glyph on both player\'s Ranged rows. This glyph reduces the base Strength of non-Hero Units to 1.' , null),
('triss-mistress-of-magic', 'Triss: Mistress of Magic', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Choice'), 4,
'Choice: Incinerate or Fair Weather
When Played: Either Incinerate (remove the strongest Unit(s) in play) or Fair Weather (remove all Weather glyphs)' , null),
('trololo', 'Trololo', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Character'), null, 12, null, null),
('vabjorn', 'Vabjorn', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 9,
'Muster: Olaf the Bear
When Played: Play Olaf the Bear from your Deck or Hand.' , null),
('vernon-roche', 'Vernon Roche', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Hero'), null, 15, null , null),
('ves', 'Ves', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Northern Realms'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 4,
'Muster: Blue Stripes
When Played: Play a Blue Stripes Scout from your Deck.' , null),
('vesemir', 'Vesemir', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Muster'), 8,
'Muster: Witchers
When Played: Play all Witchers from Deck & Hand' , null),
('vrihedd-vanguard', 'Vrihedd Vanguard', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Encourage'), 4,
'Encourage
Passive: Increase the Strength of every non-Hero Unit on its row (except this card) by +2.' , null),
('whale-from-the-cave-of-dreams', 'Whale from the Cave of Dreams', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Skellige'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Discourage'), 0,
'Discourage: Curse Bringer
Passive: Move to random row at start of opponent\'s turn. -2 Strength to all on row (except self).' , null),
('white-frost', 'White Frost', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Special'), (SELECT idAbility FROM Abilities WHERE name = 'Choice'), null,
'Choice: Frost or Fog
When Played: Spawn Biting Frost or Impenetrable Fog card.' , null),
('wild-hunt-rider', 'Wild Hunt Rider', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Frostwalker Legion'), 3,
'Frostwalker Legion
When Played: Play every copy of this card from your Deck and Hand.
Passive: Double its Strength when a Frost glyph is on the Battlefield.',
'The White Frost is coming.'),
('wild-hunt-warrior', 'Wild Hunt Warrior', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Empower'), 6,
'Empower: Frostwalker
Passive: Double its Strength when a Frost glyph is on the Battlefield.' , null),
('wyvern', 'Wyvern', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Troop'), null, 8, null, null),
('yaevinn', 'Yaevinn', (SELECT idRarity FROM Rarities WHERE name = 'Rare'), (SELECT idFaction FROM Factions WHERE name = 'Scoia\'tael'), (SELECT idType FROM Types WHERE name = 'Character'), (SELECT idAbility FROM Abilities WHERE name = 'Spy'), 8,
'Spy: Commando
When Played: Draw a card from your Deck to your Hand.
Passive: -2 Strength to all other Units its row.' , null),
('zoltan-animal-tamer', 'Zoltan: Animal Tamer', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Choice'), 6,
'Choice: Bring on the Field Marshal!
When Played: Spawn Field Marshal Duda, who either grants +2 Strength or -2 Strength to all on row.' , null),
('zoltan-the-brawler', 'Zoltan: The Brawler', (SELECT idRarity FROM Rarities WHERE name = 'Epic'), (SELECT idFaction FROM Factions WHERE name = 'Neutral'), (SELECT idType FROM Types WHERE name = 'Hero'), (SELECT idAbility FROM Abilities WHERE name = 'Resilient'), 6,
'Resilient
Passive: Keep on the Battlefield after each round.',
'Drinkin\' alone\'s like crappin\' with company.'),
('wild-hunt-hound', 'Wild Hunt Hound', (SELECT idRarity FROM Rarities WHERE name = 'Common'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Troop'), (SELECT idAbility FROM Abilities WHERE name = 'Weatherbound'), 2,
'Weatherbound: Frost
Passive: Whenever a Frost glyph is placed, play this card from your Deck, Hand, or Graveyard and double its Strength. Send this card to the Graveyard when the Frost glyph is removed.' , null),
('eredin', 'Eredin', (SELECT idRarity FROM Rarities WHERE name = 'Legendary'), (SELECT idFaction FROM Factions WHERE name = 'Monsters'), (SELECT idType FROM Types WHERE name = 'Hero'), null, 15, null,
'Have some dignity. You know how this will end.');
INSERT INTO CardsSubTypes
(idCard, idType)
VALUES
((SELECT idCard FROM Cards WHERE name = 'Alchemist') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Ancient Foglet') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Avallac\'h: Mysterious Elf') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Avallac\'h: The Sage') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Biting Frost') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Biting Frost') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Blue Mountain Commando') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Blue Stripes Commando') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Blue Stripes Scout') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Blueboy Lugos') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Caranthir') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Caretaker') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Cerys') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Ciri: Blink') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Clan an Craite Warrior') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Clan Dimun Pirate Captain') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Clan Tordarroch Armorsmith') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Commander\'s Horn') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Coral') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Brewess') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Weavess') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Whispess') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Dandelion') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Decoy') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Dijkstra') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Dol Blathanna Marksman') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Donar an Hindar') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Dun Banner Light Cavalry') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Foglet') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Frightener') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Geralt: Igni') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Geralt: Swordmaster') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Giant Toad') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Golem') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Griffin') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Hav\'caaren Healer') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Hjalmar') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Ice Giant') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Imlerith') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Impenetrable Fog') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Impenetrable Fog') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Ithlinne Aegli') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Jade Golem') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Kaedweni Siege Support') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Katakan') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Lambert') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Leshen') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Mahakaman Guard') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Morenn') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Morkvarg') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Mushrooms') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Myrgtabrakke') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Nithral') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Olaf the Bear') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Operator') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Priestess of Freya') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Prize Winning Cow') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Queensguard') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Redanian Elite') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Riordain') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Roach') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Sarah') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Saskia') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Shani') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Sheldon Skaggs') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Sigfrida') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Skellige Storm') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Skellige Storm') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Thaler') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Tordarroch Shieldsmith') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Torrential Rain') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Torrential Rain') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Triss: Butterfly Spell') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Triss: Mistress of Magic') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Trololo') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Vabjorn') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Vernon Roche') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Ves') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Vesemir') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Vrihedd Vanguard') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Whale from the Cave of Dreams') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'White Frost') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'White Frost') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Rider') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Warrior') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Wyvern') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Yaevinn') , (SELECT idType FROM Types WHERE name = 'Disloyal')),
((SELECT idCard FROM Cards WHERE name = 'Zoltan: Animal Tamer') , (SELECT idType FROM Types WHERE name = 'Loyal')),
((SELECT idCard FROM Cards WHERE name = 'Zoltan: The Brawler') , (SELECT idType FROM Types WHERE name = 'Loyal'));
INSERT INTO CardsRows
(idCard, idRow)
VALUES
((SELECT idCard FROM Cards WHERE name = 'Alchemist') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Alchemist') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Alchemist') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Ancient Foglet') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Avallac\'h: Mysterious Elf') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Avallac\'h: The Sage') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Biting Frost') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Blue Mountain Commando') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Blue Stripes Commando') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Blue Stripes Scout') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Blueboy Lugos') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Caranthir') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Caretaker') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Cerys') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Ciri: Blink') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Clan an Craite Warrior') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Clan Dimun Pirate Captain') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Clan Tordarroch Armorsmith') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Commander\'s Horn') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Commander\'s Horn') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Commander\'s Horn') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Coral') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Brewess') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Weavess') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Whispess') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Dandelion') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Decoy') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Decoy') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Decoy') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Dijkstra') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Dol Blathanna Marksman') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Donar an Hindar') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Dun Banner Light Cavalry') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Foglet') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Frightener') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Geralt: Igni') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Geralt: Swordmaster') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Giant Toad') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Golem') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Griffin') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Hav\'caaren Healer') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Hav\'caaren Healer') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Hjalmar') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Ice Giant') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Imlerith') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Impenetrable Fog') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Ithlinne Aegli') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Jade Golem') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Kaedweni Siege Support') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Katakan') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Lambert') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Leshen') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Mahakaman Guard') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Morenn') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Morenn') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Morkvarg') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Mushrooms') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Mushrooms') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Mushrooms') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Myrgtabrakke') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Nithral') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Olaf the Bear') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Operator') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Priestess of Freya') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Prize Winning Cow') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Queensguard') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Redanian Elite') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Riordain') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Roach') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Roach') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Roach') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Sarah') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Saskia') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Saskia') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Saskia') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Shani') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Sheldon Skaggs') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Sigfrida') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Skellige Storm') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Skellige Storm') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Thaler') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Tordarroch Shieldsmith') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Torrential Rain') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Triss: Butterfly Spell') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Triss: Mistress of Magic') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Trololo') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Vabjorn') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Vernon Roche') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Ves') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Vesemir') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Vrihedd Vanguard') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Vrihedd Vanguard') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Whale from the Cave of Dreams') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Whale from the Cave of Dreams') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Whale from the Cave of Dreams') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'White Frost') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'White Frost') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Rider') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Warrior') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Wyvern') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Yaevinn') , (SELECT idRow FROM Rows WHERE name = 'Ranged')),
((SELECT idCard FROM Cards WHERE name = 'Yaevinn') , (SELECT idRow FROM Rows WHERE name = 'Siege')),
((SELECT idCard FROM Cards WHERE name = 'Zoltan: Animal Tamer') , (SELECT idRow FROM Rows WHERE name = 'Melee')),
((SELECT idCard FROM Cards WHERE name = 'Zoltan: The Brawler') , (SELECT idRow FROM Rows WHERE name = 'Siege'));
INSERT INTO Artworks
(idCard, idCategory, idArtist, filename)
VALUES
((SELECT idCard FROM Cards WHERE name = 'Alchemist') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Alchemist'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Ancient Foglet') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Ancient Foglet'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Avallac\'h: Mysterious Elf') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Avallac\'h: Mysterious Elf'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Avallac\'h: The Sage') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Avallac\'h: The Sage'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Biting Frost') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Biting Frost'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Blueboy Lugos') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Blueboy Lugos'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Blue Mountain Commando') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Blue Mountain Commando'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Blue Stripes Commando') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Blue Stripes Commando'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Blue Stripes Scout') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Blue Stripes Scout'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Brouver Hoog') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Brouver Hoog'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Caranthir') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Caranthir'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Caretaker') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Caretaker'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Cerys') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Cerys'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Ciri: Blink') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Ciri: Blink'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Clan an Craite Warrior') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Clan an Craite Warrior'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Clan Dimun Pirate Captain') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Clan Dimun Pirate Captain'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Clan Tordarroch Armorsmith') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Clan Tordarroch Armorsmith'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Clear Skies') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Clear Skies'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Commander\'s Horn') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Commander\'s Horn'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Coral') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Coral'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Crach an Craite') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Crach an Craite'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Brewess') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Crone: Brewess'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Weavess') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Crone: Weavess'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Crone: Whispess') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Crone: Whispess'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Dagon') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Dagon'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Dandelion') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Dandelion'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Decoy') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Decoy'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Dijkstra') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Dijkstra'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Dol Blathanna Marksman') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Dol Blathanna Marksman'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Donar an Hindar') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Donar an Hindar'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Dun Banner Light Cavalry') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Dun Banner Light Cavalry'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Eithne') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Eithne'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Epidemic') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Epidemic'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Eredin') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Eredin'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Eredin (Hero)') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Eredin (Hero)'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Foglet') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Foglet'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Foltest') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Foltest'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Frightener') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Frightener'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Geralt: Igni') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Geralt: Igni'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Geralt: Swordmaster') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Geralt: Swordmaster'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Giant Toad') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Giant Toad'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Golem') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Golem'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Griffin') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Griffin'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Hav\'caaren Healer') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Hav\'caaren Healer'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Hjalmar') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Hjalmar'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Ice Giant') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Ice Giant'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Imlerith') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Imlerith'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Impenetrable Fog') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Impenetrable Fog'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Ithlinne Aegli') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Ithlinne Aegli'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Jade Golem') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Jade Golem'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Kaedweni Siege Support') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Kaedweni Siege Support'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Katakan') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Katakan'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Lambert') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Lambert'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Leshen') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Leshen'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Mahakaman Guard') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Mahakaman Guard'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Morenn') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Morenn'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Morkvarg') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Morkvarg'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Mushrooms') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Mushrooms'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Myrgtabrakke') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Myrgtabrakke'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Nithral') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Nithral'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Olaf the Bear') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Olaf the Bear'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Operator') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Operator'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Priestess of Freya') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Priestess of Freya'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Prize Winning Cow') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Prize Winning Cow'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Queensguard') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Queensguard'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Redanian Elite') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Redanian Elite'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Riordain') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Riordain'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Roach') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Roach'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Sarah') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Sarah'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Saskia') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Saskia'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Scorch') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Scorch'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Shani') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Shani'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Sheldon Skaggs') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Sheldon Skaggs'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Sigfrida') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Sigfrida'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Skellige Storm') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Skellige Storm'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Thaler') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Thaler'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Tordarroch Shieldsmith') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Tordarroch Shieldsmith'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Torrential Rain') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Torrential Rain'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Triss: Butterfly Spell') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Triss: Butterfly Spell'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Triss: Mistress of Magic') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Triss: Mistress of Magic'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Trololo') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Trololo'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Vabjorn') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Vabjorn'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Vernon Roche') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Vernon Roche'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Ves') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Ves'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Vesemir') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Vesemir'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Vrihedd Vanguard') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Vrihedd Vanguard'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Whale from the Cave of Dreams') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Whale from the Cave of Dreams'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'White Frost') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'White Frost'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Hound') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Wild Hunt Hound'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Rider') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Wild Hunt Rider'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Warrior') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Wild Hunt Warrior'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Wyvern') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Wyvern'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Yaevinn') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Yaevinn'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Zoltan: Animal Tamer') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Zoltan: Animal Tamer'), '_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Zoltan: The Brawler') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null,
CONCAT((SELECT id FROM Cards WHERE name = 'Zoltan: The Brawler')));
#Alternative artworks
INSERT INTO Artworks
(idCard, idCategory, idArtist, isAlternative, filename)
VALUES
((SELECT idCard FROM Cards WHERE name = 'Blue Stripes Commando') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null, true,
CONCAT((SELECT id FROM Cards WHERE name = 'Blue Stripes Commando'), '_alt_1_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Blue Stripes Commando') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null, true,
CONCAT((SELECT id FROM Cards WHERE name = 'Blue Stripes Commando'), '_alt_2_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Queensguard') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null, true,
CONCAT((SELECT id FROM Cards WHERE name = 'Queensguard'), '_alt_1_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Queensguard') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null, true,
CONCAT((SELECT id FROM Cards WHERE name = 'Queensguard'), '_alt_2_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Rider') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null, true,
CONCAT((SELECT id FROM Cards WHERE name = 'Wild Hunt Rider'), '_alt_1_small.png')),
((SELECT idCard FROM Cards WHERE name = 'Wild Hunt Rider') , (SELECT idCategory FROM Categories WHERE name = 'normal'), null, true,
CONCAT((SELECT id FROM Cards WHERE name = 'Wild Hunt Rider'), '_alt_2_small.png'));
COMMIT;