FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc

FieldSource Error: Field 'cagencyname' is unknown in the query context.
Please mention the url to site support at Red Snapper.
SQL Query:select campaignname as brandname,'' as awinner,if(entrymonth > 200500,'YES','NO') as gotowinner,if(mod(@counter-2,3)='0','Y','N') as endofline,@counter-2 as stilltogo,@counter:=@counter-1 as taken, if(entrymonth < 200000,date_format(concat(entrymonth+100101,'01'),'Winner %Y'),date_format(concat(entrymonth,'01'),'%M %Y')) as themonth,id,position,entrymonth as themonthshort, if(entrymonth < 200000,concat(entrymonth+100104,'1'),concat(entrymonth,'2')) as theorder from PMentry where active='on' and position=1 and left(entrymonth,4)='2005' group by entrymonth order by theorder desc