struct
CACHED false
COLUMNLIST APPROVED,ASSOCFILENAME,AUDIENCE,COMMENTS,CONTENTHISTID,CONTENTID,CREATED,CREDITS,DISPLAY,DISPLAYINTERVAL,DISPLAYSTART,DISPLAYSTOP,DOWNVOTES,EXPIRES,FILEALTTEXT,FILEEXT,FILEID,FILENAME,FILESIZE,ISLOCKED,KEYPOINTS,KIDS,LASTUPDATE,LOCKID,LOCKTYPE,MAJORVERSION,MENUTITLE,MINORVERSION,NEXTN,ORDERNO,PARENTID,PARENTTYPE,PATH,RATING,RELEASEDATE,REMOTESOURCE,REMOTESOURCEURL,REMOTEURL,RESTRICTED,RESTRICTGROUPS,SITEID,SUBTYPE,SUMMARY,TAGS,TARGET,TARGETPARAMS,TITLE,TOTALVOTES,TYPE,UPVOTES
EXECUTIONTIME 1
RECORDCOUNT 0
SQL select * from ( select 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.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams, tcontent.releaseDate, tcontent.lastupdate,tcontent.summary, tfiles.fileSize,tfiles.fileExt,tcontent.fileid, tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo, tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes, tcontentstats.comments, tparent.type parentType, null as kids, tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires, tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText 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 tcontentfilemetadata on (tcontent.fileid=tcontentfilemetadata.fileid and tcontent.contenthistid=tcontentfilemetadata.contenthistid) where tcontent.siteid = ? and tcontent.active = 1 and tcontent.Approved = 1 AND tcontent.moduleid = '00000000000000000000000000000000000' AND tcontent.type <>'Module' and tcontent.parentid in ( ?, '') AND ( tcontent.Display = 1 OR ( tcontent.Display = 2 AND ( ( tparent.type!='Calendar' and tcontent.DisplayStart <= ? and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null) ) OR ( tparent.type='Calendar' and tcontent.DisplayStart <= ? and (tcontent.DisplayStop >= ? or tcontent.DisplayStop is null) ) ) ) ) and (tcontent.mobileExclude is null OR tcontent.mobileExclude in (0,2) ) order by tcontent.orderno asc NULLS FIRST ) where ROWNUM <= ?
SQLPARAMETERS
array
1 cityofcincinnati
2 4B9BB80A-35E7-4052-A3F2EE162A63AC1A
3 2015-01-27 09:19:00.0
4 2015-01-27 09:19:00.0
5 2015-02-27 09:19:00.0
6 2015-01-27 09:19:00.0
7 20
Bookmark and Share
Office Of The Mayor

Mayor John CranleyMayor John Cranley

Cincinnati's 69th Mayor

On Dec. 1, 2013, John Cranley became the City of Cincinnati's 69th Mayor.

Raised in Price Hill, Mayor John Cranley was infused with a deep faith and commitment to giving back at a young age. Now John and his wife Dena are raising their son Joseph in the city, committed to the same ideals of hard work, service and faith.

About Mayor Cranley

State Of The City

Mayor John Cranley delivered the 2014 State of the City Address on Sept. 18, 2014, at Music Hall.

Download The Text

Latest News
1/22/15
Mayor Cranley Appears On TV Game Show For Non-Profit Group

Cincinnati Mayor John Cranley will compete today on an episode of "Let's Ask America," a TV game show. Mayor Cranley's episode features well-known figures from Greater Cincinnati as contestants. Each person's winnings will benefit a non-profit group of his or her choice.

1/21/15
Mayor Cranley Attends U.S. Conference Of Mayors Meeting

Cincinnati Mayor John Cranley is attending the U.S. Conference of Mayors' winter meeting in Washington, D.C. While there, Mayor Cranley has several important appointments scheduled with federal officials, many of which involve discussions about local transportation projects.

1/20/15
Mayor Cranley Offers Condolences After I-75 Overpass Collapse

Cincinnati Mayor John Cranley issued the following statement today in response to Monday night's collapse of a highway overpass near the Hopple Street exit on Interstate 75.

1/13/15
Major Crime Categories Drop In 2014

Final 2014 numbers show a significant drop in several key crime indicators. Leaders credit targeted, intelligent policing, community collaboration and a commitment to the Cincinnati Initiative to Reduce Violence (CIRV) program, which emphasizes close partnership between community and governmental agencies.

12/30/14
City Reaches Deal With Employees, Retirees For Long-Term Pension System Solvency

Earlier this evening, the parties involved in the City of Cincinnati pension negotiations reached a wide-ranging agreement on a plan that will ensure pension benefits will be sustained for current and future retirees, as well as shoring up the City’s financial position for years to come.


View All News