email      | symbol_short
-----------+-------------
 j@doe.com | Bitcoin
 j@doe.com | XBY
 j@doe.com | XBY
 j@doe.com | XBY
 j@doe.com | XBY
 j@doe.com | XVG
 s@doe.com | XBY
 s@doe.com | XBY
 s@doe.com | XBY
 s@doe.com | XBY

email     | symbol_short
-----------+-------------
 j@doe.com | Bitcoin
 j@doe.com | XBY
 j@doe.com | XBY
 j@doe.com | XBY
 j@doe.com | XVG
 s@doe.com | XBY
 s@doe.com | XBY
 s@doe.com | XBY

SELECT
c_connection.email, c_alert.exchange, c_alert.symbol_short, c_alert.price_usd,
c_history.alert_price, c_history.current_price, c_history.dynamic,
c_history.positive_change, c_history.negative_change, c_history.created, c_connection.username
FROM
c_alert INNER JOIN c_history ON c_alert.id = c_history.id_alert INNER JOIN c_connection ON c_alert.login_key = c_connection.login_key
ORDER BY c_connection.email, c_alert.symbol_short, c_history.created DESC