DROP TABLE IF EXISTS `v_rss`;
DROP VIEW IF EXISTS `v_rss`;

CREATE OR REPLACE VIEW `_db_rss`.`v_rss` AS 
SELECT m_rss.id_rss, m_rss.id_account, m_rss.id_category, m_category.c_categoryName, m_category.c_categoryDisplayOrder, m_rss.c_title, m_rss.c_home_url, m_rss.c_rss_url, m_rss.c_displayOrder, m_rss.c_displayColor, m_rss.c_delete, m_rss.c_privacy, m_category.c_article_cnt
FROM m_rss
LEFT OUTER JOIN m_category ON m_rss.id_category = m_category.id_category
WHERE m_rss.c_delete = 0;
