sqlite.sql

SELECT "posts".*,
Group_concat(tags.id, "↕")                          AS keyword_ids,
Group_concat(tags.NAME, "↕")                        AS keyword_names,
Group_concat(Ifnull(tags.description, "null"), "↕") AS keyword_descriptions,
FROM   "posts"
LEFT JOIN "post_tags"
       ON "post_tags"."post_id" = "posts"."id"
LEFT JOIN "tags"
       ON "post_tags"."keyword_id" = "tags"."id"
WHERE  "tags"."name" IN ( 'sometag' )
GROUP  BY "posts"."id"