<Cfquery name="geter" datasource="#ds#">
select id 
from columntext_cg
order by id desc
limit 0,1000
</Cfquery>

<cfoutput query="geter">

<Cfquery name="getid" datasource="#ds#">
select columntable.title 
from columntable 
where columntable.id = #geter.id#
</Cfquery>

<cfquery name="updater" datasource="#ds#">
update columntext_cg
set title = '#getid.title#'
where id = #geter.id#
</cfquery>
</cfoutput>




<cfif parameterexists(url.daily)>
<Cfquery name="Geter" dataSource="#ds#">
select id from columntext_cg
order by ID
</cfquery>

<Cfoutput query="geter">
<cfquery name="checker" dataSource="#ds#">
select id from columntable where id = #geter.id#
and mag = 1
</cfquery>

<Cfif #checker.recordcount# eq 0>
<cfquery name="Del" dataSource="#ds#">
delete from columntext_cg
where id = #geter.id#
</cfquery>

</Cfif>

</Cfoutput>

</cfif>


<Cfquery name="geter" datasource="#ds#">
select id
from columntext_cg
order by id desc
limit 0,1
</Cfquery>

<Cfset newid = #geter.id#>


<Cfset newid = #newid# - 5000>


<CFQUERY name="articles" datasource="#ds#">
select id,title,blurb,copy,region,dateposted from columntable
where columntable.mag = 1 and status=1 and columntable.columnnum <> 752 and columntable.columnnum <> 818  and columnnum <> 803
and columntable.id > #newid#
order by id
</CFQUERY>


<cfoutput query="articles">

<Cfif #title# does not contain 'things to do'>
a
<cfquery name="checker" datasource="#ds#">
select id from columntext_cg
where id = #articles.id#
</cfquery>

<Cfif #checker.recordcount# eq 0>
b
<Cftry>
	<cfset newhtml=reReplace(articles.copy, "[^\x20-\x7E]", " ", "ALL")>

<cfquery name=addphoto datasource="cg22">
INSERT INTO columntext_cg (id,title,blurb,copy,author,region,dateposted)
VALUES	(#articles.id#,'#articles.title#','#articles.blurb#','#newhtml#','','#articles.region#',#articles.dateposted#)
</cfquery>
<cfcatch>

		<cfquery name=addphoto datasource="cg22">
INSERT INTO columntext_cg (id,title,blurb,copy,author,region,dateposted)
VALUES	(#articles.id#,'#articles.title#','#articles.blurb#','#newhtml#','','#articles.region#',#articles.dateposted#)
</cfquery></cfcatch>
</Cftry>

</Cfif>
</Cfif>

</cfoutput>


<Cfquery name="geter" datasource="#ds#">
select id
from columntext_cg
where author = '' or seo_friendly = ''
order by id desc
limit 0,5000
</Cfquery>

<cfoutput query="geter">

<Cfquery name="getid" datasource="#ds#">
select columntable.columnnum,columnmaster.authorname,columntable.seo_friendly
from columntable inner join columnmaster on columntable.columnnum = columnmaster.id
where columntable.id = #geter.id#
</Cfquery>

<cfquery name="updater" datasource="#ds#">
update columntext_cg
set author = '#getid.authorname#',
seo_friendly = '#getid.seo_friendly#'
where id = #geter.id#
</cfquery>
</cfoutput>