0 Пользователей и 1 Гость просматривают эту тему.
user_id COUNT(visits) COUNT(order_id)
SELECT u.user_id, COUNT(v.visits) as visits, COUNT(o.order_id) as ordersFROM users uLEFT JOIN stats v ON u.user_id = v.user_idLEFT JOIN orders o ON u.user_id = o.user_idGROUP BY u.user_id