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 Prairies, Sports

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

Found 24 Articles:
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
Hockey Fans Handed Salvation A… Edmonton - Oiler fans were handed 17,000 Salvation Army bell… Mon 26th Nov 2007
The Prairie and Northern Terri… Click here to view a copy of the latest Divisional Commander… Fri 23rd 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
25th Annual Motorcycle Toy Run Regina, SK - The 25th annual motorcycle toy run was held und… Fri 26th Oct 2007
From the desk of Major Eric Bo… August 2007 - Donna and I arrived in the office on Tuesday J… Thu 16th 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
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
Medal Winner! Congratulations to Zachary Brown of Agincourt corps, Toronto… Tue 24th Oct 2006
Sports ministry desk to be est… Following consultation with senior International Headquarter… Fri 13th Oct 2006
Episode 199: The Salvation Arm… The Salvation Army Connection: Ep… Fri 18th Aug 2006
World Cup defender tells of hi… What do Brazil, Germany, Italy, Argentina, Uruguay, France a… Thu 15th Jun 2006
Vancouver Sun Run This year's Vancouver Sun Run took place on April 23, 2006. … Fri 26th May 2006