Get Pricing from currency

[kanenses]

Hi all,

SELECT package_names.`name`,
       pricings.`price`,
       pricings.`price_renews`
FROM package_names
  LEFT JOIN pricings
     ON package_names.`package_id` = pricings.`id`

From the above table, I finally getting pricing from table to domain .com, I'am looling for: how can I only getting prices in EUR, as from table, I only getting the first prices, from others words:

.com have the two currencys, usd and eur,

.net the same, but on table I getting,:

.com - have the first currency, the

.net (get the price in USD) from .com

Buy filter by currency, getting:

 

What I have do wrong, or what missing to get only prices in EUR?

 

Thank you