select * from tcontentfeeds
where siteID=
and Type=
and isPublic=1
and isactive=1
order by name
select * from tcontentfeeds
where siteID=
and isDefault=1
order by name
select * from (
select top #arguments.feedBean.getMaxItems()#
tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups,
tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
tcontent.contentID, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
tcontent.releaseDate, tcontent.lastupdate,tcontent.summary,
tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
tcontent.tags,tcontent.credits,tcontent.audience,
tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
tcontentstats.comments, tparent.type parentType, qKids.kids 0 as kids
from tcontent
left Join tfiles on (tcontent.fileid=tfiles.fileid)
left Join tcontentstats on (tcontent.contentid=tcontentstats.contentid
and tcontent.siteid=tcontentstats.siteid)
Left Join tcontent tparent on (tcontent.parentid=tparent.contentid
and tcontent.siteid=tparent.siteid
and tparent.active=1)
Left Join (select
tcontent.contentID,
Count(TKids.contentID) as kids
from tcontent
inner join tcontent TKids
on (tcontent.contentID=TKids.parentID
and tcontent.siteID=TKids.siteID)
Inner Join tcontenttags on (tcontent.contentHistID=tcontenttags.contentHistID)
where tcontent.siteid='#arguments.feedBean.getsiteid()#'
AND tcontent.Approved = 1
AND tcontent.active = 1
AND TKids.Approved = 1
AND TKids.active = 1
AND TKids.isNav = 1
AND tcontent.moduleid = '00000000000000000000000000000000000'
and (#param.getRelationship()#
#param.getField()# #param.getCondition()# ()
)
and tcontent.Tags=
AND (
(
tcontent.isFeature = 1
OR
( tcontent.isFeature = 2
AND tcontent.FeatureStart <= #createodbcdatetime(now())#
AND (tcontent.FeatureStop >= #createodbcdatetime(now())# or tcontent.FeatureStop is null)
)
)
OR tcontent.contentHistID in (
AND tcontent.contentHistID in (
select distinct tcontentcategoryassign.contentHistID from tcontentcategoryassign
inner join tcontentcategories
ON (tcontentcategoryassign.categoryID=tcontentcategories.categoryID)
where (
tcontentcategories.path like
or
)
AND
(
tcontentcategoryassign.isFeature = 1
OR
( tcontentcategoryassign.isFeature = 2
AND tcontentcategoryassign.FeatureStart <= #createodbcdatetime(now())#
AND (tcontentcategoryassign.FeatureStop >= #createodbcdatetime(now())# or tcontentcategoryassign.FeatureStop is null)
)
)
and tcontentcategoryassign.siteID='#arguments.feedBean.getSiteID()#')
)
AND tcontent.contentHistID in (
select distinct tcontentcategoryassign.contentHistID from tcontentcategoryassign
inner join tcontentcategories
ON (tcontentcategoryassign.categoryID=tcontentcategories.categoryID)
where (
tcontentcategories.path like
or
)
)
and (
tcontent.parentid='#listGetAt(arguments.feedBean.getcontentID(),c)#' or
)
AND
(
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tcontent.DisplayStart <= #createodbcdatetime(now())#
AND (tcontent.DisplayStop >= #createodbcdatetime(now())# or tcontent.DisplayStop is null)
)
OR
tcontent.parentID in (select contentID from tcontent
where type='Calendar'
and active=1
and siteid=
)
)
)
)
AND
(
TKids.Display = 1
OR
(
TKids.Display = 2
AND
(
(
TKids.DisplayStart <= #createodbcdatetime(now())#
AND (TKids.DisplayStop >= #createodbcdatetime(now())# or TKids.DisplayStop is null)
)
OR
TKids.parentID in (select contentID from tcontent
where type='Calendar'
and active=1
and siteid=
)
)
)
)
group by tcontent.contentID
) qKids
on (tcontent.contentID=qKids.contentID)
Inner Join tcontentTags on (tcontent.contentHistID=tcontentTags.contentHistID)
where tcontent.active=1
AND tcontent.isNav = 1
AND tcontent.Approved = 1
AND tcontent.moduleid = '00000000000000000000000000000000000'
and tcontent.type !='Module'
AND tcontent.siteid =
and (#param.getRelationship()#
#param.getField()# #param.getCondition()# ()
)
and tcontentTags.tag=
AND (
(
tcontent.isFeature = 1
OR
( tcontent.isFeature = 2
AND tcontent.FeatureStart <= #createodbcdatetime(now())#
AND (tcontent.FeatureStop >= #createodbcdatetime(now())# or tcontent.FeatureStop is null)
)
)
OR tcontent.contenthistID in (
select distinct tcontentcategoryassign.contentHistID from tcontentcategoryassign
inner join tcontentcategories
ON (tcontentcategoryassign.categoryID=tcontentcategories.categoryID)
where (
tcontentcategories.path like
or
)
AND
(
tcontentcategoryassign.isFeature = 1
OR
( tcontentcategoryassign.isFeature = 2
AND tcontentcategoryassign.FeatureStart <= #createodbcdatetime(now())#
AND (tcontentcategoryassign.FeatureStop >= #createodbcdatetime(now())# or tcontentcategoryassign.FeatureStop is null)
)
)
and tcontentcategoryassign.siteID=
)
)
AND tcontent.contenthistID in (
select distinct tcontentcategoryassign.contentHistID from tcontentcategoryassign
inner join tcontentcategories
ON (tcontentcategoryassign.categoryID=tcontentcategories.categoryID)
where (
tcontentcategories.path like
or
)
)
and tcontent.parentid in (
,
'')
AND
(
tcontent.Display = 1
OR
(
tcontent.Display = 2
AND
(
(
tcontent.DisplayStart <= #createodbcdatetime(now())#
AND (tcontent.DisplayStop >= #createodbcdatetime(now())# or tcontent.DisplayStop is null)
)
OR tparent.type='Calendar'
)
)
)
order by
tcontent.#arguments.feedBean.getSortBy()# #arguments.feedBean.getSortDirection()#
tcontentstats.rating #arguments.feedBean.getSortDirection()#, tcontentstats.totalVotes #arguments.feedBean.getSortDirection()#
tcontentstats.comments #arguments.feedBean.getSortDirection()#
tcontent.releaseDate desc,tcontent.lastUpdate desc,tcontent.menutitle
limit
) where ROWNUM <=
select contentID, menutitle, type from tcontent where
active=1 and
(
contentID=
or
)
0=1
SELECT name, channelLink, type
FROM tcontentfeeds
where feedID in
(select feedID from tcontentfeeditems where itemID
in (select categoryID from tcontentcategories where siteid=)
=
and type = 'categoryID')
and siteID =
select count(*) as Total from tcontentfeeds
where isactive=1
and siteid=
and type=