protected function deleteLinked($product_id)
    {
        $conditions = array('product_id' => $product_id);
        $conditions2 = array('entity' => 'product', 'entity_id' => $product_id);

        $this->db->delete('cart', $conditions);
        $this->db->delete('review', $conditions);
        $this->db->delete('rating', $conditions);
        $this->db->delete('wishlist', $conditions);
        $this->db->delete('rating_user', $conditions);

        $this->db->delete('product_sku', $conditions);
        $this->db->delete('product_field', $conditions);
        $this->db->delete('product_translation', $conditions);
        $this->db->delete('product_view', $conditions);

        $this->db->delete('product_related', $conditions);
        $this->db->delete('product_related', array('item_product_id' => $product_id));
        $this->db->delete('product_bundle', $conditions);

        $this->db->delete('file', $conditions2);
        $this->db->delete('alias', $conditions2);
        $this->db->delete('search_index', $conditions2);

        $sql = 'DELETE ci
                FROM collection_item ci
                INNER JOIN collection c ON(ci.collection_id = c.collection_id)
                WHERE c.type = ? AND ci.entity_id = ?';

        $this->db->run($sql, array('product', $product_id));
    }