Language
English
日本語
Administration Login
SELECT public_pages.*, public_user_group_page_map.*,public_user_group_map.*,public_pages.priKeyID as priKeyID FROM public_pages LEFT JOIN public_user_group_page_map ON public_user_group_page_map.pageID=public_pages.priKeyID LEFT JOIN public_user_group_map ON public_user_group_map.publicUserGroupID=public_user_group_page_map.publicUserGroupID WHERE `public_pages`.`priKeyID`=-11 AND `public_user_group_map`.`publicUserID`=0 AND ((livePriKeyID IS NULL AND draftPriKeyID>0 AND isDraft= true) OR(isDraft= false)) GROUP BY public_pages.priKeyID ORDER BY public_pages.ordinal
Dashboard
SELECT public_pages.*, public_user_group_page_map.*,public_user_group_map.*,public_pages.priKeyID as priKeyID FROM public_pages LEFT JOIN public_user_group_page_map ON public_user_group_page_map.pageID=public_pages.priKeyID LEFT JOIN public_user_group_map ON public_user_group_map.publicUserGroupID=public_user_group_page_map.publicUserGroupID WHERE `public_pages`.`priKeyID`=-101 AND `public_user_group_map`.`publicUserID`=0 AND ((livePriKeyID IS NULL AND draftPriKeyID>0 AND isDraft= true) OR(isDraft= false)) GROUP BY public_pages.priKeyID ORDER BY public_pages.ordinal
Pages
SELECT public_pages.*, public_user_group_page_map.*,public_user_group_map.*,public_pages.priKeyID as priKeyID FROM public_pages LEFT JOIN public_user_group_page_map ON public_user_group_page_map.pageID=public_pages.priKeyID LEFT JOIN public_user_group_map ON public_user_group_map.publicUserGroupID=public_user_group_page_map.publicUserGroupID WHERE `public_pages`.`priKeyID`=-167 AND `public_user_group_map`.`publicUserID`=0 AND ((livePriKeyID IS NULL AND draftPriKeyID>0 AND isDraft= true) OR(isDraft= false)) GROUP BY public_pages.priKeyID ORDER BY public_pages.ordinal
Image Gallery
SELECT public_pages.*, public_user_group_page_map.*,public_user_group_map.*,public_pages.priKeyID as priKeyID FROM public_pages LEFT JOIN public_user_group_page_map ON public_user_group_page_map.pageID=public_pages.priKeyID LEFT JOIN public_user_group_map ON public_user_group_map.publicUserGroupID=public_user_group_page_map.publicUserGroupID WHERE `public_pages`.`priKeyID`=-25 AND `public_user_group_map`.`publicUserID`=0 AND ((livePriKeyID IS NULL AND draftPriKeyID>0 AND isDraft= true) OR(isDraft= false)) GROUP BY public_pages.priKeyID ORDER BY public_pages.ordinal
Public Users
SELECT public_pages.*, public_user_group_page_map.*,public_user_group_map.*,public_pages.priKeyID as priKeyID FROM public_pages LEFT JOIN public_user_group_page_map ON public_user_group_page_map.pageID=public_pages.priKeyID LEFT JOIN public_user_group_map ON public_user_group_map.publicUserGroupID=public_user_group_page_map.publicUserGroupID WHERE `public_pages`.`priKeyID`=-35 AND `public_user_group_map`.`publicUserID`=0 AND ((livePriKeyID IS NULL AND draftPriKeyID>0 AND isDraft= true) OR(isDraft= false)) GROUP BY public_pages.priKeyID ORDER BY public_pages.ordinal
Public User Groups
Copyright © Stealth Interactive Inc. All Rights Reserved
