MODX 2.x to 3.x Resource Select

revo2x_to_3x_resource_select.sql

# Run on 2.x MODX

SELECT
    id,
    type,
    pagetitle,
    longtitle,
    description,
    alias,
    link_attributes,
    published,
    pub_date,
    unpub_date,
    parent,
    isfolder,
    introtext,
    content,
    richtext,
    template,
    menuindex,
    searchable,
    cacheable,
    createdby,
    createdon,
    editedby,
    editedon,
    deleted,
    deletedon,
    deletedby,
    publishedon,
    publishedby,
    menutitle,
    donthit,
    privateweb,
    privatemgr,
    content_dispo,
    hidemenu,
    'MODX\\Revolution\\modDocument' as class_key,
    context_key,
    content_type,
    uri,
    uri_override,
    hide_children_in_tree,
    show_in_tree,
    properties,
    alias_visible
FROM modx_site_content