joomla-articles-meta.sql

[fititnt]

-- ID:             joomla-articles-meta
-- DESCRIPTION:    This query focus on return relationships from articles with
--                 users, categories and tags. But, despite title of article,
--                 will not load article content.
-- 
-- AUTHOR:         Emerson Rocha <emerson[at]alligo.com.br>
-- COMPANY:        Alligo
-- LICENSE:        "SPDX-License-Identifier: MIT"
-- CREATED:        2021-01-18 22:44 BRT
-- REVISION:       ---

---

The joomla-articles-meta.sql is meant to be used for data mining. Some fields, like content_title and category_title are commented out because tools, in special Weka, will complaint about commas and other strange characters.

Also, because of Weka, the last exported field is content_hits. If user does not explicitly change, it will assume as the field that is the class/target.