jylopez

$currency_array = array(
   array('currency' => 'Afghan Afghani', 'code' => 'AFN'),
   array('currency' => 'Albanian Lek', 'code' => 'ALL'),
   array('currency' => 'Algerian Dinar', 'code' => 'DZD'),
   array('currency' => 'Angolan Kwanza', 'code' => 'AOA'),
   array('currency' => 'Argentine Peso', 'code' => 'ARS'),
   array('currency' => 'Armenian Dram', 'code' => 'AMD'),
   array('currency' => 'Aruban Florin', 'code' => 'AWG'),
   array('currency' => 'Australian Dollar', 'code' => 'AUD'),
   array('currency' => 'Azerbaijani Manat', 'code' => 'AZN'),

jylopez

[
  { code: 'AU', name: 'Australia' },
  { code: 'AT', name: 'Austria' },
  { code: 'BE', name: 'Belgium' },
  { code: 'BR', name: 'Brazil' },
  { code: 'BG', name: 'Bulgaria' },
  { code: 'CA', name: 'Canada' },
  { code: 'HR', name: 'Croatia' },
  { code: 'CY', name: 'Cyprus' },
  { code: 'CZ', name: 'Czech Republic' },

jylopez

[
  {currency: 'Afghan Afghani', code: 'AFN'},
  {currency: 'Albanian Lek', code: 'ALL'},
  {currency: 'Algerian Dinar', code: 'DZD'},
  {currency: 'Angolan Kwanza', code: 'AOA'},
  {currency: 'Argentine Peso', code: 'ARS'},
  {currency: 'Armenian Dram', code: 'AMD'},
  {currency: 'Aruban Florin', code: 'AWG'},
  {currency: 'Australian Dollar', code: 'AUD'},
  {currency: 'Azerbaijani Manat', code: 'AZN'},

jylopez

WITH cohorts_join AS (SELECT 
  cohorts.id, 
  cohorts.name, 
  cohorts.settings, 
  cohorts.created_at, 
  cohorts.updated_at, 
  registrations.product_id, 
  products.type AS product_type
FROM cohorts, cohorts_registrations, registrations, products 
WHERE