SELECT c.name, 
       c.uuid, 
       c.setCode, 
       c.number,
       cp.tcgplayer, 
       cp.tcgplayerFoil, 
       cp.cardmarket, 
       cp.cardmarketFoil, 
       cp.cardkingdom, 
       cp.cardkingdomFoil, 
       cp.cardsphere, 
       cp.cardsphereFoil,
       ci.cardKingdomEtchedId,
       ci.cardKingdomFoilId,
       ci.cardKingdomId,
       ci.tcgplayerProductId,
       ci.tcgplayerEtchedProductId,
       ci.mcmId,
       ci.mcmMetaId
FROM cards c
INNER JOIN cardPrices cp 
    ON c.uuid COLLATE utf8mb4_unicode_ci = cp.uuid COLLATE utf8mb4_unicode_ci
INNER JOIN cardIdentifiers ci
    ON c.uuid COLLATE utf8mb4_unicode_ci = ci.uuid COLLATE utf8mb4_unicode_ci
WHERE c.name LIKE '%Ketramose%';