USP_DATALIST_LOGINPARTSITECONTENTID
Returns SiteContentID from Login page.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CLIENTSITESID | int | IN | Client Sites ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_LOGINPARTSITECONTENTID
(
@CLIENTSITESID int
)
as
set nocount on;
SELECT P.SITECONTENTID, C.VALUE FROM dbo.PAGECONTENT P
INNER JOIN dbo.CMSSITESETTING C
ON P.SITEPAGESID=C.VALUE
INNER JOIN dbo.SiteContent SC ON P.SiteContentID = SC.ID
WHERE C.CLIENTSITESID = @CLIENTSITESID AND ENUMID = 3 AND SC.ContentTypesID = 33