select page.*,title.titleid,title.titletxt,title.language,content.textid,content.lastupdate,content.content,content.language,draft.draftid from page
join title on page.pageid=title.resourceid
join content on page.pageid=content.resourceid
left join draft on page.pageid=draft.resid
where
pkey='umr5229' AND title.restype='page' AND content.restype='page' AND title.language=content.language
select page.*,title.titleid,title.titletxt,title.language,content.textid,content.lastupdate,content.content,content.language,draft.draftid from page
join title on page.pageid=title.resourceid
join content on page.pageid=content.resourceid
left join draft on page.pageid=draft.resid
where
pkey='credits_and_legal_matters' AND title.restype='page' AND content.restype='page' AND title.language=content.language
select page.*,title.titleid,title.titletxt,title.language,content.textid,content.lastupdate,content.content,content.language,draft.draftid from page
join title on page.pageid=title.resourceid
join content on page.pageid=content.resourceid
left join draft on page.pageid=draft.resid
where
pkey='umr5229' AND title.restype='page' AND content.restype='page' AND title.language=content.language
select page.*,title.titleid,title.titletxt,title.language,content.textid,content.lastupdate,content.content,content.language,draft.draftid from page
join title on page.pageid=title.resourceid
join content on page.pageid=content.resourceid
left join draft on page.pageid=draft.resid
where
pkey='credits_and_legal_matters' AND title.restype='page' AND content.restype='page' AND title.language=content.language
Login Form
