SELECT
dct.id,
dct.title,
dct.url,
dct.no_of_pages,
dct.bookmark,
dctg.tag AS 'type',
dct.dir,
dct.read,
dct.rating,
dct.date_released,
dct.date_archive,
sub1.tags,
sub2.series,
sub3.artist,
sub4.translator
FROM doujin_col_title AS dct
LEFT JOIN (SELECT dctt.title_id, GROUP_CONCAT(CONCAT("[",dctg.tag,"]")) AS 'tags'
FROM doujin_col_title_tags AS dctt
INNER JOIN doujin_col_tags AS dctg
ON dctg.id = dctt.tag_id
GROUP BY dctt.title_id) AS sub1
ON sub1.title_id = dct.id