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`,
    `mstt`.`translation` as `tooltip`
from
    `m_page_element` `mpe`
    inner join `m_page` `mp` ON `mpe`.`m_pageID` = `mp`.`m_pageID`

 left outer join `m_string_usedat` `msutt` on `mpe`.`m_page_elementID` = `msutt`.`targetID`
 left outer join m_string mstt on mstt.m_stringID = msutt.m_stringID and mstt.type like '%m_page_element_tooltip%'
 left outer join m_language ml on ml.m_languageID = mstt.m_languageID