<?php
    public function get_relinks_logs()
    {
        $query = $this->db->placehold("SELECT
    s_relinks_logs.id,
    s_relinks.search_key AS relink_key,
    s_relinks.link AS link,
    (CASE
        WHEN
            s_relinks_logs.item_type = 'product'
        THEN
            (SELECT
                    name
                FROM
                    s_products
                WHERE
                    id = s_relinks_logs.item_id)
        WHEN
            s_relinks_logs.item_type = 'blog'
        THEN
            (SELECT
                    name
                FROM
                    s_blog
                WHERE
                    id = s_relinks_logs.item_id)
    END) AS name,
    s_relinks_logs.anchors,
    s_relinks_logs.date,
    s_relinks_logs.item_id,
    s_relinks_logs.item_type


FROM
    s_relinks_logs
        LEFT JOIN
    s_relinks ON s_relinks_logs.relink_id = s_relinks.id
                                        ORDER BY date DESC");

        $this->db->query($query);
        var_dump($this->db->results());
        return $this->db->results();
    }