Cacher is the code snippet organizer for pro developers

SELECT citatum_text.id AS id, citatum_text.`text` AS `text`, citatum_text.author AS author, citatum_tag.tag AS tag
FROM citatum_text LEFT JOIN citatum_tag ON citatum_text.id = citatum_tag.citatum_id;