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 International-News, Sports

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

Found 46 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Seeking Justice Together General Shaw Clifton officially dedicated to God the work of… Thu 4th Sep 2008
Olympic Fever Hits Belleville Right across the country, Canadians are following their Olym… Thu 21st Aug 2008
Salvation Army Officers Appoin… International Headquarters announces that The Salvation Army… Fri 15th Aug 2008
Salvation Army Delegates Gain … The Salvation Army was represented by 45 delegates from 20 t… Thu 14th 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 Salvation Army Commences W… The Salvation Army’s International Headquarters in Lo… Thu 22nd 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
The General Conducts Colonel B… ‘WELCOME in the name of the risen Christ!’ With… Thu 11th Oct 2007
Pakistan Territorial Commander… The following is a news release from International Headquart… Fri 28th Sep 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
UK Territory Leader Inducted a… COMMISSIONER Betty Matear (Territorial President of Women's … Wed 2nd May 2007
Meeting of Enlarged Internatio… THE first meeting of the enlarged International Doctrine Cou… Mon 23rd Apr 2007
Salvation Army participates in… The Vancouver Sun Run is Canada's biggest 10k run and the se… Wed 4th Apr 2007
Stories from The Salvation Arm… THE Salvation Army recently finished a project in Pakistan t… Thu 8th Mar 2007
New Game Plan for Sports Minis… As Jack O’Halloran explains, organized sports is a cr… Thu 15th Feb 2007
Missing daughter of SA officer… Makarena, daughter of Cpts Mauricio and Erika Urzua in Ecuad… Wed 7th Feb 2007