select
  u.*,

  ms.`font_size` `ms_font_size`,
  ms.`font_weight` `ms_font_weight`,
  ms.`font_style` `ms_font_style`,
  ms.`line_spacing` `ms_line_spacing`,
  ms.`border_color_left` `ms_border_color_left`,
  ms.`border_color_top` `ms_border_color_top`,
  ms.`border_color_right` `ms_border_color_right`,
  ms.`border_color_bottom` `ms_border_color_bottom`,
  ms.`border_width_left` `ms_border_width_left`,
  ms.`border_width_top` `ms_border_width_top`,
  ms.`border_width_right` `ms_border_width_right`,
  ms.`border_width_bottom` `ms_border_width_bottom`,
  ms.`left_top_radius` `ms_left_top_radius`,
  ms.`right_top_radius` `ms_right_top_radius`,
  ms.`right_bottom_radius` `ms_right_bottom_radius`,
  ms.`left_bottom_radius` `ms_left_bottom_radius`,
  ms.`border_style` `ms_border_style`,
  ms.`bg_color` `ms_bg_color`,
  ms.`padding_left` `ms_padding_left`,
  ms.`padding_top` `ms_padding_top`,
  ms.`padding_right` `ms_padding_right`,
  ms.`padding_bottom` `ms_padding_bottom`,
  ms.`margin_left` `ms_margin_left`,
  ms.`margin_top` `ms_margin_top`,
  ms.`margin_right` `ms_margin_right`,
  ms.`margin_bottom` `ms_margin_bottom`,

  mp.`font_size` `mp_font_size`,
  mp.`font_weight` `mp_font_weight`,
  mp.`font_style` `mp_font_style`,
  mp.`line_spacing` `mp_line_spacing`,
  mp.`border_color_left` `mp_border_color_left`,
  mp.`border_color_top` `mp_border_color_top`,
  mp.`border_color_right` `mp_border_color_right`,
  mp.`border_color_bottom` `mp_border_color_bottom`,
  mp.`border_width_left` `mp_border_width_left`,
  mp.`border_width_top` `mp_border_width_top`,
  mp.`border_width_right` `mp_border_width_right`,
  mp.`border_width_bottom` `mp_border_width_bottom`,
  mp.`left_top_radius` `mp_left_top_radius`,
  mp.`right_top_radius` `mp_right_top_radius`,
  mp.`right_bottom_radius` `mp_right_bottom_radius`,
  mp.`left_bottom_radius` `mp_left_bottom_radius`,
  mp.`border_style` `mp_border_style`,
  mp.`bg_color` `mp_bg_color`,
  mp.`padding_left` `mp_padding_left`,
  mp.`padding_top` `mp_padding_top`,
  mp.`padding_right` `mp_padding_right`,
  mp.`padding_bottom` `mp_padding_bottom`,
  mp.`margin_left` `mp_margin_left`,
  mp.`margin_top` `mp_margin_top`,
  mp.`margin_right` `mp_margin_right`,
  mp.`margin_bottom` `mp_margin_bottom`,
  mp.`text_color` `mp_text_color`

  from `user` u

  left join `marker_appearance` ms
  on (ms.user_id = u.id and ms.medium = 'screen')


  left join `marker_appearance` mp
  on (mp.user_id = u.id and mp.medium = 'print')