select
    `mpe`.`m_page_fieldID` AS `m_page_elementID`,
    `mpe`.`m_pageID` AS `m_pageID`,
    `mp`.`m_maintable` AS `m_maintable`,
    `mig`.`mnemonic` AS `m_itemgroup_mnemonic`,
    `mf`.`name` AS `m_field_name`,
    `mpi`.`sequence` AS `m_itemgroup_sequence`,
    `mpi`.`m_itemgroupID` AS `m_itemgroupID`,
    `mpe`.`m_sequence` AS `m_sequence`,
    `mt1`.`name` AS `m_table_name`,
    `mf`.`m_fieldID` AS `m_fieldID`,
    `mf`.`mysql_type` AS `mysql_type`,
    `mf`.`default_value` AS `default_value`,
    `mf`.`is_required` AS `is_required`,
    `mlf`.`name` AS `logical_field_type`,
    `mlf`.`mask` AS `mask`,
    `mpe`.`m_content_translated` AS `m_content_translated`,
    `mpe`.`m_readonly` AS `m_readonly`,
    `mpe`.`m_initial_hidden` AS `initial_hidden`,
    `mpe`.`code_on_change` AS `code_on_change`,
    `mpe`.`m_remark` AS `_remark`,
    `mp`.`mnemonic` AS `page_mnemonic`,
    `mp`.`js_code` AS `mp_js_code`,
    `mw`.`m_widget_name` AS `m_widget`,
    `mt2`.`name` AS `m_coupletable`,
    `mt2`.`m_tableID` AS `m_coupletableID`,
    `mt1`.`m_tableID` AS `m_tableID`,
    `mp`.`m_template` AS `m_template`,
    `mig`.`open_at_page_load` AS `ig_open_at_page_load`,
    `mpe`.`code` AS `code`,
    `tooltip`.`translation` as `tooltip`,
    `tooltip`.`m_languageID` as `languageID`
from
    `m_page_element` `mpe`
    inner join `m_page` `mp` ON `mpe`.`m_pageID` = `mp`.`m_pageID`

    join `m_field` `mf` ON `mpe`.`m_fieldID` = `mf`.`m_fieldID`
    join `m_itemgroup` `mig` ON `mpe`.`m_itemgroupID` = `mig`.`m_itemgroupID`
    join `m_page_itemgroup` `mpi` ON `mpe`.`m_pageID` = `mpi`.`m_pageID`
        and `mpe`.`m_itemgroupID` = `mpi`.`m_itemgroupID`
    join `m_table` `mt1` ON `mpe`.`m_tableID` = `mt1`.`m_tableID`
    left join `m_table` `mt2` ON `mpe`.`m_coupletableID` = `mt2`.`m_tableID`
    left join `m_widget` `mw` ON `mpe`.`m_widget_typeID` = `mw`.`m_widgetID`
    left join `m_logical_fieldtype` `mlf` ON `mlf`.`m_logical_fieldtypeID` = `mf`.`m_logical_fieldtypeID`

    left outer  join `m_string_usedat` `msutt` on `msutt`.`targetID` = `mpe`.`m_page_elementID`
    left outer join (
      select `ml`.`m_languageID`, `ms`.`m_stringID`,`ms`.`translation` from `m_string` `ms`
         inner join `m_language` as `ml` on `ml`.`m_languageID` = `ms`.`m_languageID`
              and `ms`.`type` like '%m_page_element_tooltip%'
    ) `tooltip` on `tooltip`.`m_stringID`= `msutt`.`m_stringID`
order by `mpe`.`m_pageID` , `mpi`.`sequence` , `mpe`.`m_sequence`