# Queries per cmsdam per vedere tutte le sezioni abilitate per publishing.
SELECT b.section_name,
       b.id
FROM cmsdam_publishing_sections AS a,
     cmsdam_sections AS b
WHERE a.section_id = b.id;

SELECT DISTINCT sections.section_name
FROM cmsdam_sections AS sections,
     cmsdam_publishing_sections AS pubsect
WHERE sections.id = pubsect.section_id;

# Query per cmsdam per vedere gli ID per l'associazione sezione/attributo dati sezione e attributo
SELECT DISTINCT sections.id,
                attributes.id
FROM cmsdam_sections AS sections,
     cmsdam_publishing_attrsectrel AS attrsectrel,
     cmsdam_publishing_attribute AS attributes,
     cmsdam_publishing_attrtypes AS attrtypes
WHERE sections.id = attrsectrel.section_id AND
      attributes.id = attrsectrel.attribute_id AND
      attrtypes.id = attributes.type AND
      sections.section_name = "testpub" AND
      attributes.attribute = "image";

# Query per cmsdam per vedere tutte le info necessarie per la gestione di sezioni in publishing
SELECT DISTINCT sections.section_name,
                attributes.attribute,
		attributes.text_publish,
		attrtypes.type
FROM cmsdam_sections AS sections,
     cmsdam_publishing_attrsectrel AS attrsectrel,
     cmsdam_publishing_attribute AS attributes,
     cmsdam_publishing_attrtypes AS attrtypes
WHERE sections.id = attrsectrel.section_id AND
      attributes.id = attrsectrel.attribute_id AND
      attrtypes.id = attributes.type AND
      sections.section_name LIKE "%" ORDER BY section_name,
                                              attribute ASC;

# Queries per selezionare il numero di history massimo per la data sezione
SELECT versions.history_level
FROM cmsdam_publishing_sections_versions AS versions,
     cmsdam_sections AS sections
WHERE versions.section_id = sections.id AND
      sections.section_name = "test";

SELECT sections.section_name,
       versions.history_level
FROM cmsdam_sections AS sections,
     cmsdam_publishing_sections_versions AS versions
WHERE sections.id = versions.section_id AND
      sections.section_name = "testpub";

# Query per selezionare tutti i valori versionati per la data sezione
SELECT sections.section_name,
       attributes.attribute,
       value.text_value,
       value.history,
       attrtypes.type
FROM cmsdam_sections as sections,
     cmsdam_publishing_attribute as attributes,
     cmsdam_publishing_sections_values as value,
     cmsdam_publishing_attrsectrel sectrel,
     cmsdam_publishing_attrtypes attrtypes
WHERE sectrel.id = value.attrsectrel_id AND
      sectrel.section_id = sections.id AND
      sectrel.attribute_id = attributes.id AND
      attrtypes.id = attributes.type AND
      sections.section_name = "testpub";

# Query per selezionare tutti i valori versionati per la data sezione e history pari a 1
SELECT sections.section_name,
       attributes.attribute,
       value.text_value,
       value.history,
       attrtypes.type
FROM cmsdam_sections as sections,
     cmsdam_publishing_attribute as attributes,
     cmsdam_publishing_sections_values as value,
     cmsdam_publishing_attrsectrel sectrel,
     cmsdam_publishing_attrtypes attrtypes
WHERE sectrel.id = value.attrsectrel_id AND
      sectrel.section_id = sections.id AND
      sectrel.attribute_id = attributes.id AND
      attrtypes.id = attributes.type AND
      sections.section_name = "testpub" AND
      value.history = 1;

# Query per visualizzare l'ultima versione del dato contenuto, attributo / sezione (non affidabile
# in quanto potrebbero esserci buchi di record!
SELECT max(value.history)
FROM cmsdam_sections as sections,
     cmsdam_publishing_attribute as attributes,
     cmsdam_publishing_sections_values as value,
     cmsdam_publishing_attrsectrel sectrel,
     cmsdam_publishing_attrtypes attrtypes
WHERE sectrel.id = value.attrsectrel_id AND
      sectrel.section_id = sections.id AND
      sectrel.attribute_id = attributes.id AND
      attrtypes.id = attributes.type AND
      sections.section_name = "testpub";

# Query per visualizzare il numero delle versioni committate per la sezione specificata
SELECT count(distinct value.history)
FROM cmsdam_sections as sections,
     cmsdam_publishing_attribute as attributes,
     cmsdam_publishing_sections_values as value,
     cmsdam_publishing_attrsectrel sectrel,
     cmsdam_publishing_attrtypes attrtypes
WHERE sectrel.id = value.attrsectrel_id AND
      sectrel.section_id = sections.id AND
      sectrel.attribute_id = attributes.id AND
      attrtypes.id = attributes.type AND
      sections.section_name = "testpub";

# Query per visualizzare il numero massimo del buffer delle versioni per la data sezione
SELECT history_level
FROM cmsdam_publishing_sections_versions
WHERE section_id = 28;