Magazine - Covers

SELECT
    d.entry_id,
    d.site_id,
    d.channel_id,
    d.field_id_16 as content,
    d.field_id_26 as image,
    d.field_id_27 as magazine,
    d.field_id_29 as leader,
    d.field_id_30 as content,
    d.field_id_31 as cbrne_news,
    d.field_id_116 as category_title,

    t.title,
    t.url_title,
    FROM_UNIXTIME(t.entry_date, "%Y-%m-%d %H:%i:%s") as entry_date,
    FROM_UNIXTIME(t.entry_date, "%Y-%m") as category_code,
    CONCAT_WS(" ", CONCAT_WS('-',t.year,t.month,t.day), " 00:00:00") as publish_date,

    str_to_date(t.edit_date, "%Y%m%d%H%i%s") as edit_date

    FROM exp_channel_data d
    LEFT JOIN exp_channel_titles t on t.entry_id = d.entry_id
    WHERE d.channel_id = 5