the query is: ```CREATE VIEW peopleWithLanguageAnd...

# squarelibraries

[myanmarking]

the query is:

CREATE VIEW peopleWithLanguageAndVehicles AS
SELECT peopleEntity.id, peopleEntity.name, specieEntity.language, peopleEntity.isFavourite, ifnull(GROUP_CONCAT(pname), '') vehicles FROM peopleEntity
LEFT JOIN specieEntity ON peopleEntity.specieId == specieEntity.id
LEFT JOIN (vehiclesByUser) ON peopleEntity.id == pdi
GROUP BY peopleEntity.id;