select car_id,align_lexique_id,car_align_id, align_libelle_fr, align_libelle_us, car_castcosttotal, car_codecouleur, car_number, car_printednumber, car_nomus, car_nomfr, car_cote, REPLACE(car_texte_printed_us,CHAR(13),' ') as car_texte_printed_us, REPLACE(car_texte_printed_fr,CHAR(13),' ') as car_texte_printed_fr, REPLACE(car_texte_regle_us,CHAR(13),' ') as car_texte_regle_us, REPLACE(car_texte,CHAR(13),' ') as car_texte, car_texte_flavor_us, car_texte_flavor_fr, car_force, car_endurance, car_invocation, ext_libelle_fr, ext_libelle_us, car_idedition, ext_idcycle, mws, online, ext_total_cards, cyc_id, car_code_rarete, rar_libelle_fr, rar_libelle_us, car_idartist, car_codecouleur, spl.spl_libelle_fr, spl.spl_libelle_us, spl_pr.spl_libelle_fr as spl_libelle_fr_printed, spl_pr.spl_libelle_us as spl_libelle_us_printed, ext_idlanguage, ext_date_release, car_idspelltype, car_idclasscreature, car_printedidspelltype, car_printedidclasscreature, crea.cre_libelle_fr, crea.cre_libelle_us, crea_pr.cre_libelle_fr as cre_libelle_fr_printed, crea_pr.cre_libelle_us as cre_libelle_us_printed, libre, nb_votes, nb_points, car_idtournoistype1, car_idtournoistype1_5, car_idtournoistype2, car_idtournoisduelcommander, car_idtournoispauper, car_idtournoiscommander, car_idTournoisModern, car_idTournoisPioneer, car_idCarteRetournee, car_reservedList, car_colors, car_colorIdentity, car_isonline, car_source, car_image, car_insert_date, car_isoutofset, car_termId, car_modifiedBy, car_checkedBy, car_validatedBy, car_buzz, car_buzz_refresh, car_refresh, car_mcid, car_imagedescription, ext_code_name, splgroup_id, splgroup_libelle, splgroup_libelle_us,car_secondary_nomus, car_secondary_nomfr, car_isSMF , dataTitle from cartes LEFT JOIN cartes_extension ON (car_idedition=ext_id) LEFT JOIN cartes_rarete ON (car_code_rarete=rar_code) LEFT JOIN cartes_spelltype spl ON (car_idspelltype=spl.spl_id) LEFT JOIN cartes_spelltypegroup spl_gr ON (spl.spl_idgroup = spl_gr.splgroup_id) LEFT JOIN cartes_typecreature crea ON (car_idclasscreature=crea.cre_id) LEFT JOIN cartes_spelltype spl_pr ON (car_printedidspelltype=spl_pr.spl_id) LEFT JOIN cartes_typecreature crea_pr ON (car_printedidclasscreature=crea_pr.cre_id) LEFT JOIN allData dt ON (car_idartist=dt.dataId) LEFT JOIN allDataText dtext ON (dtext.dataRefId=dt.dataId and dataLanguage = 'FR') LEFT JOIN cartes_extensions_cycle ON (ext_idcycle=cyc_id) LEFT JOIN cartes_alignements ON (car_align_id=align_id) WHERE car_id = 42269
 Lantern Kami - Magic the Gathering card

Lantern Kami
(Kami de lanterne)

CMC: 1


Type / Sub-type
Creature — Spirit

Common

Flying

"Snuffing the light of a lantern without saying a small prayer is bad luck. Though its flame can only singe, its soul can repeatedly visit misery on one's house."
—Teachings of Eight-and-a-Half-Tails

Power / Toughness: 1/1

#32/306


External links:  


Informations