SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE generals ( id int ); CREATE TABLE users ( id int, name varchar(64), u_status int ); CREATE TABLE users_country ( id int, country varchar(64) ); INSERT INTO generals VALUES (1); INSERT INTO users VALUES (1, 'Ivan', 1), (2, 'Natasha', 1), (3, 'Putin', 1); INSERT INTO users_country VALUES (1, 'Russia'), (1, 'Germany'), (2, 'Poland'), (3, 'Italy'), (3, 'Austria'); SELECT * FROM generals INNER JOIN users ON users.u_status = 1 LEFT JOIN users_country ON users_country.id = users.id GROUP BY users.id DESC ORDER BY users.id DESC