SQL Statement Debugger

Record::get_records_for_sql()

SELECT
  COALESCE(MIN(DATE(`history_created_date`)),'0000-00-00') `min`,
  COALESCE(MAX(DATE(`history_created_date`)),'0000-00-00') `max`
FROM
  `pages`
WHERE
  `history_created_date`>'1000-00-00' AND
  `systemID` IN()

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 8

Call stack trace:
[12] Record::get_record_for_sql() via /var/www/2380/classes/class.system.php line 769
[11] System::get_global_date_range() via /var/www/2380/classes/class.search.php line 101
[10] Search::_draw_controls() via /var/www/2380/classes/class.search.php line 297
[09] Search::_draw_results() via /var/www/2380/classes/class.search.php line 90
[08] Search::draw() via /var/www/2380/codebase.php(982) : eval()'d code line 3
[07] eval() via /var/www/2380/codebase.php line 982
[06] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[05] convert_safe_to_php() via /var/www/2380/codebase.php line 982
[04] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[03] convert_safe_to_php() via /var/www/2380/classes/class.layout.php line 133
[02] Layout::prepare() via /var/www/2380/system.php line 189
[01] main() via /var/www/2380/functions.php line 151
[00] include() via /var/www/clients/client5/web76/web/index.php line 4

SQL Statement Debugger

Record::get_records_for_sql()

SELECT
  COALESCE(MIN(DATE(IF(`type`='event',`effective_date_start`,`date`))),'0000-00-00') `min`,
  COALESCE(MAX(DATE(IF(`type`='event',`effective_date_start`,`date`))),'0000-00-00') `max`
FROM
  `postings`
WHERE
  IF(`type`='event',`effective_date_start`,`date`)>'1000-00-00' AND
  `systemID` IN()

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 8

Call stack trace:
[12] Record::get_record_for_sql() via /var/www/2380/classes/class.system.php line 779
[11] System::get_global_date_range() via /var/www/2380/classes/class.search.php line 101
[10] Search::_draw_controls() via /var/www/2380/classes/class.search.php line 297
[09] Search::_draw_results() via /var/www/2380/classes/class.search.php line 90
[08] Search::draw() via /var/www/2380/codebase.php(982) : eval()'d code line 3
[07] eval() via /var/www/2380/codebase.php line 982
[06] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[05] convert_safe_to_php() via /var/www/2380/codebase.php line 982
[04] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[03] convert_safe_to_php() via /var/www/2380/classes/class.layout.php line 133
[02] Layout::prepare() via /var/www/2380/system.php line 189
[01] main() via /var/www/2380/functions.php line 151
[00] include() via /var/www/clients/client5/web76/web/index.php line 4
Search Results
Skip to Content
Click to print

Search Results for tags South-America, Sports, Testimony

Text:
Categories:
Tags:
Date Range:
- to -
Items:
Sites:

Found 29 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Olympic Fever Hits Belleville Right across the country, Canadians are following their Olym… Thu 21st Aug 2008
Shooting for Success Sports ministry is an exciting new outreach opportunity for … Wed 6th Aug 2008
Sports Ministry in North Vanco… More than 20 children meet each week at the John Braithwaite… Wed 6th Aug 2008
God's Cheerleader As Christians, we are called to root for the winning team … Mon 7th Jul 2008
The Joys of Service How a surprise appointment turned into a welcome opportunity… Tue 19th Feb 2008
Hockey Fans Handed Salvation A… Edmonton - Oiler fans were handed 17,000 Salvation Army bell… Mon 26th Nov 2007
Toronto Marlies and The Salvat… Join us Saturday December 8 for Salvation Army Day at Ricoh … Tue 20th Nov 2007
Toronto Marlies - Great Hockey… The Toronto Marlies Hockey Club and The Salvation Army have … Wed 31st Oct 2007
Peru Earthquake (Update 1) Salvation Army relief teams continue to bring urgently neede… Tue 21st Aug 2007
The Salvation Army Sends Finan… Friday August 17, 2007 - After a 7.9 magnitude earthquake hi… Mon 20th Aug 2007
The Winning Goal In Georgetown, hockey is a major part of many families' live… Fri 10th Aug 2007
Contact Sports Eighty percent of the people in your community watched or pa… Mon 6th Aug 2007
Annual Salvation Army Fundrais… Nanaimo, B.C. - The third annual Salvation Army charity golf… Wed 1st Aug 2007
BC Mayor Visits Divisional Hea… The Government Relations portfolio continues to be a priorit… Fri 29th Jun 2007
Blue Jay Fans Celebrate The Sa… On Wednesday, May 16, Toronto Blue Jay fans celebrated the o… Thu 7th Jun 2007
"Jump Start" invests… In 2005 The Salvation Army in Cobourg, Ont. joined with Cana… Thu 24th May 2007
Salvation Army participates in… The Vancouver Sun Run is Canada's biggest 10k run and the se… Wed 4th Apr 2007
Sandra’s story Nearly 40 years ago, in beautiful Kenya in a little mission … Fri 2nd Mar 2007
New Game Plan for Sports Minis… As Jack O’Halloran explains, organized sports is a cr… Thu 15th Feb 2007
Free kicks for kids North Vancouver - A free Salvation Army soccer program helps… Thu 16th Nov 2006
The Salvation Army begins recy… El Ropero - For many years The Salvation Army has been plann… Tue 14th Nov 2006
Medal Winner! Congratulations to Zachary Brown of Agincourt corps, Toronto… Tue 24th Oct 2006
In All Things Give Thanks to G… On January 3, 2005, I thought my world had come to and end. … Fri 20th Oct 2006
Sports ministry desk to be est… Following consultation with senior International Headquarter… Fri 13th Oct 2006
Women prisoners won for Christ South America West Territory receives several reports from E… Wed 6th Sep 2006