Belongs To Relationships
cardface ( see all )
| id | card_id | cardface_index | illustration_id | artist | color | color_identity | flavor_text | image_uri | mana_cost | cmc | name | oracle_text | power | toughness | type_line | border_color | image_uri_art_crop | image_hash_art_crop | image_uri_small | image_hash_small | image_uri_normal | image_hash_normal | image_uri_large | image_hash_large | image_uri_png | image_hash_png | image_uri_border_crop | image_hash_border_crop | is_foil | is_nonfoil | is_oversized | is_color_green | is_color_red | is_color_blue | is_color_black | is_color_white | is_colorless | color_count | is_color_identity_green | is_color_identity_red | is_color_identity_blue | is_color_identity_black | is_color_identity_white | color_identity_count | is_snow | has_phyrexian_mana | for_fulltext_search | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19190 | (18978) | 0 | (31e7d1e5-4cf6-4e13-88cc-141bccde1ad8) | Craig J Spearing | "I have no clan, but I still have purpose." | {5}{R} | 6.00 | Defiant Ogre | When Defiant Ogre enters the battlefield, choose one — • Put a +1/+1 counter on Defiant Ogre. • Destroy target artifact. | 3 | 5 | Creature — Ogre Warrior | black | https://c1.scryfall.com/file/scryfall-cards/art_crop/front/0/9/09cfd3d5-1b44-4dc7-b35d-703f3a75da88.jpg?1562822286 | NULL | https://c1.scryfall.com/file/scryfall-cards/small/front/0/9/09cfd3d5-1b44-4dc7-b35d-703f3a75da88.jpg?1562822286 | https://c1.scryfall.com/file/scryfall-cards/normal/front/0/9/09cfd3d5-1b44-4dc7-b35d-703f3a75da88.jpg?1562822286 | https://c1.scryfall.com/file/scryfall-cards/large/front/0/9/09cfd3d5-1b44-4dc7-b35d-703f3a75da88.jpg?1562822286 | https://c1.scryfall.com/file/scryfall-cards/png/front/0/9/09cfd3d5-1b44-4dc7-b35d-703f3a75da88.png?1562822286 | https://c1.scryfall.com/file/scryfall-cards/border_crop/front/0/9/09cfd3d5-1b44-4dc7-b35d-703f3a75da88.jpg?1562822286 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | Defiant Ogre When Defiant Ogre enters the battlefield choose one Put a 1 1 counter on Defiant Ogre Destroy target artifact I have no clan but I still have purpose Creature Ogre Warrior Craig J Spearing | 2020-06-09 12:45:56 | 2020-09-28 15:36:03 |