<?php
$sql="
SELECT
    t.id,
    t.name,
    t.date_of_publishing,
    s.status,
    TRIM(GROUP_CONCAT(DISTINCT ' ',g.genre)) AS genre,
    TRIM(GROUP_CONCAT(DISTINCT ' ',a.author)) AS author,
    d.description,
    i.name AS src,
    p.panels,
    i.score
FROM
manga_title t
    LEFT JOIN 
        manga_status s
        ON t.status_id=s.id
    LEFT JOIN 
        manga_description d
        ON t.description_id=d.id
    LEFT JOIN
        manga_image i
        ON t.id=i.manga_id
    LEFT JOIN 
        manga_panels p
        ON p.id=t.panel_id
    LEFT JOIN 
        manga_title_author ta
        ON t.author_id=ta.title_id
    LEFT JOIN 
        manga_author a
        ON a.id=ta.author_id
    LEFT JOIN 
        manga_title_genre tg
        ON t.genre_id=tg.title_id
    LEFT JOIN 
        manga_genre g
        ON g.id=tg.genre_id
GROUP BY 
t.id
order BY 
t.id";
?>