Advertisement
Guest User

Untitled

a guest
Sep 13th, 2015
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. from
  2. `m_page_element` `mpe`
  3. inner join `m_page` `mp` ON `mpe`.`m_pageID` = `mp`.`m_pageID`
  4.  
  5. join `m_field` `mf` ON `mpe`.`m_fieldID` = `mf`.`m_fieldID`
  6. join `m_itemgroup` `mig` ON `mpe`.`m_itemgroupID` = `mig`.`m_itemgroupID`
  7. join `m_page_itemgroup` `mpi` ON `mpe`.`m_pageID` = `mpi`.`m_pageID`
  8. and `mpe`.`m_itemgroupID` = `mpi`.`m_itemgroupID`
  9. join `m_table` `mt1` ON `mpe`.`m_tableID` = `mt1`.`m_tableID`
  10. left join `m_table` `mt2` ON `mpe`.`m_coupletableID` = `mt2`.`m_tableID`
  11. left join `m_widget` `mw` ON `mpe`.`m_widget_typeID` = `mw`.`m_widgetID`
  12. left join `m_logical_fieldtype` `mlf` ON `mlf`.`m_logical_fieldtypeID` = `mf`.`m_logical_fieldtypeID`
  13.  
  14. left join `m_string_usedat` `msutt` on `mpe`.`m_page_elementID` = `msutt`.`targetID`
  15. left join m_string mstt on mstt.m_stringID = msutt.m_stringID and mstt.type like '%m_page_element_tooltip%'
  16. inner join m_lnaguage ml on ml.m_languageID = mstt.m_languageID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement