SELECT counter FROM fuseguard_ip
			WHERE ip_list_id = ? 
				AND ip_version = 4
				AND ip_start <= ?
				AND ip_end >= ?

select	categoryid
			from	tblblogcategories
			where	categoryalias = ?
			and		blog = ?

select	
				 
					1, tblblogentries.id, tblblogentries.title, 
					tblblogentries.alias, 
					
					
						dateAdd(hh, 0, tblblogentries.posted) as posted, 
					
					tblusers.name, tblblogentries.allowcomments,
					tblblogentries.enclosure, tblblogentries.filesize, tblblogentries.mimetype, tblblogentries.released, tblblogentries.views
				, tblblogentries.body, tblblogentries.morebody
			from	tblblogentries, tblusers
			,tblblogentriescategories
			
			where		1=1
			
						and blog = ?
						and tblblogentries.username = tblusers.username
			
				and tblblogentriescategories.entryidfk = tblblogentries.id
				and tblblogentriescategories.categoryidfk = ? 
			and			posted <?
			and			released = 1
			
			
			order by 	tblblogentries.posted desc

select count(id) as commentCount, entryidfk
				from 	tblblogcomments
				where	entryidfk in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

				group by entryidfk

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select	categoryid,categoryname
						from	tblblogcategories, tblblogentriescategories
						where	tblblogentriescategories.entryidfk = ?
						and		tblblogentriescategories.categoryidfk = tblblogcategories.categoryid

select count(id) as trackbackCount, entryid
				from 	tblblogtrackbacks
				where	entryid in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
				group by entryid

select	categoryid
			from	tblblogcategories
			where	
				
				categoryid = ? 
				and blog = ?

select	categoryname, categoryalias
			from	tblblogcategories
			where	categoryid = ?
			and		blog = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	categoryalias
		from	tblblogcategories
		where	categoryid = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select 
                    top 5 
		e.id as entryID,
		e.title,
		c.id,
		c.entryidfk,
		c.name,
		c.comment,
		
		
		    dateAdd(hh, 0, c.posted) as posted
		
		from tblblogcomments c

		inner join tblblogentries e on c.entryidfk = e.id
		where	 blog = ?
		order by c.posted desc

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select	posted, alias
		from	tblblogentries
		where	id = ?

select distinct 
				
					datepart(dd, dateAdd(hh, 0, tblblogentries.posted)) 
				 as posted_day
			from tblblogentries
			where 
				dateAdd(hh, 0, tblblogentries.posted) >= ?
				and 
				dateAdd(hh, 0, tblblogentries.posted) <= ?
				and blog = ?
				and	dateAdd(hh, 0, tblblogentries.posted) <?
				and	released = 1

select datepart(yyyy, tblblogentries.posted) 
		as posted_year, datepart(MM, tblblogentries.posted) 
		as posted_month, count(*) as month_count
	from tblblogentries
	where 
		blog = ?
		and	released = 1
	group by datepart(yyyy, tblblogentries.posted), datepart(MONTH, tblblogentries.posted) 
	order by posted_year desc, posted_month desc

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R10
CERT_SERVER_SUBJECT=CN=cf411.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\clients\carehart.org\www\blog\client\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R10
HTTPS_SERVER_SUBJECT=CN=cf411.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.carehart.org
HTTP_REFERER=
HTTP_URL=/blog/client/index.cfm/troubleshooting
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=140.150.208.196
PATH_INFO=/troubleshooting
PATH_TRANSLATED=C:\inetpub\wwwroot\clients\carehart.org\www\blog\client\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.69.59.22
REMOTE_HOST=172.69.59.22
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/blog/client/index.cfm
SERVER_NAME=www.carehart.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

URL Parameters:
CATID=DD03C90C-C8AF-277C-BADE3D00FC077B5D
MODE=cat
STARTROW=1