Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 join `m_string_usedat` `msutt` on `mpe`.`m_page_elementID` = `msutt`.`targetID`
- left join m_string mstt on mstt.m_stringID = msutt.m_stringID and mstt.type like '%m_page_element_tooltip%'
- inner join m_lnaguage ml on ml.m_languageID = mstt.m_languageID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement