Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement