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`,
- `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`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement