Guest User

Untitled

a guest
Sep 13th, 2015
145
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select
  2. `mpe`.`m_page_fieldID` AS `m_page_elementID`,
  3. `mpe`.`m_pageID` AS `m_pageID`,
  4. `mp`.`m_maintable` AS `m_maintable`,
  5. `mig`.`mnemonic` AS `m_itemgroup_mnemonic`,
  6. `mf`.`name` AS `m_field_name`,
  7. `mpi`.`sequence` AS `m_itemgroup_sequence`,
  8. `mpi`.`m_itemgroupID` AS `m_itemgroupID`,
  9. `mpe`.`m_sequence` AS `m_sequence`,
  10. `mt1`.`name` AS `m_table_name`,
  11. `mf`.`m_fieldID` AS `m_fieldID`,
  12. `mf`.`mysql_type` AS `mysql_type`,
  13. `mf`.`default_value` AS `default_value`,
  14. `mf`.`is_required` AS `is_required`,
  15. `mlf`.`name` AS `logical_field_type`,
  16. `mlf`.`mask` AS `mask`,
  17. `mpe`.`m_content_translated` AS `m_content_translated`,
  18. `mpe`.`m_readonly` AS `m_readonly`,
  19. `mpe`.`m_initial_hidden` AS `initial_hidden`,
  20. `mpe`.`code_on_change` AS `code_on_change`,
  21. `mpe`.`m_remark` AS `_remark`,
  22. `mp`.`mnemonic` AS `page_mnemonic`,
  23. `mp`.`js_code` AS `mp_js_code`,
  24. `mw`.`m_widget_name` AS `m_widget`,
  25. `mt2`.`name` AS `m_coupletable`,
  26. `mt2`.`m_tableID` AS `m_coupletableID`,
  27. `mt1`.`m_tableID` AS `m_tableID`,
  28. `mp`.`m_template` AS `m_template`,
  29. `mig`.`open_at_page_load` AS `ig_open_at_page_load`,
  30. `mpe`.`code` AS `code`,
  31. `mstt`.`translation` as `tooltip`
  32. from
  33. `m_page_element` `mpe`
  34. inner join `m_page` `mp` ON `mpe`.`m_pageID` = `mp`.`m_pageID`
  35.  
  36. left outer join `m_string_usedat` `msutt` on `mpe`.`m_page_elementID` = `msutt`.`targetID`
  37. left outer join m_string mstt on mstt.m_stringID = msutt.m_stringID and mstt.type like '%m_page_element_tooltip%'
  38. left outer join m_language ml on ml.m_languageID = mstt.m_languageID
RAW Paste Data