SELECT
u.ID AS user_id,
u.user_login,
u.display_name,
COUNT(p.ID) AS lagoon_count
FROM wp_users u
Language: SQL
-
SQL
-
SQL
SELECT u.ID AS user_id, u.user_login, u.display_name, COUNT(p.ID) AS lagoon_count FROM wp_users u -
SQL
SELECT u.ID AS user_id, u.user_login, u.display_name, COUNT(p.ID) AS lagoon_count FROM wp_users u