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 Award, Dedication

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

Found 25 Articles:
Title Summary Date
Dr. Paul Thistle - Honorary De… Dr. Paul Thistle receives honorary Doctorate, Photo © D… Thu 17th Jul 2008
Captain Dr. Paul Thistle Recei… Photo copyright 2008 Doug MacLellan On Wednesday, June 11… Fri 4th Jul 2008
YMCA Recognizes Peacemakers Kitchener,ON - On November 23, peace medallions for 2007 wer… Tue 27th Nov 2007
Chief Secretary Receives Honor… On October 20, 2007, in Langley BC, Colonel Glen Shepherd wa… Thu 25th Oct 2007
Grace Hospital Auxiliary Youth… Winnipeg - The Grace Hospital Youth Volunteer Program celebr… Tue 2nd Oct 2007
Newmarket Salvation Army Reach… Newmarket, Ont. - The Salvation Army Northridge Community Ch… Tue 2nd Oct 2007
Did You Know? Ron Zima, Public Relations and Major Gift Representative in … Wed 30th May 2007
A Woman of Distinction Winnipeg - Congratulations to Laurie Read who recently was a… Fri 11th May 2007
Canadian Church Press Awards o… Congratulations go out to the THQ Editorial Department on aw… Mon 7th May 2007
Making a difference in their c… Majors Ethel Richardson & Deborah Bungay of Ontario Great La… Wed 14th Mar 2007
Toronto Star editor-in-chief h… Toronto Star editor-in-chief Fred Kuntz was honoured for com… Fri 23rd Feb 2007
Action in Ottawa The following pictures display highlights in 2006 from the O… Mon 12th Feb 2007
Medicine Hat, Alberta, honours… March 16, 2006, is a day Sarah Smith, daughter of officer's … Fri 17th Nov 2006
Recognition given to those hel… Pasadena, NF - The community service award for an organizati… Fri 17th Nov 2006
Salvation Army volunteer award… Anne Cepukas, a volunteer at The Salvation Army Thrift store… Tue 3rd Oct 2006
Salvation Army parade float wi… St. Marys, Ont. - The theme of the St. Marys fall fair parad… Mon 2nd Oct 2006
A new little life is celebrate… Kentville, N.S. - Damian Bladen, born Feb. 4, 2006, lies pea… Wed 30th Aug 2006
Newfoundland Salvationist Reci… Dr. Otto Tucker, a Salvationist from St. John’s Templ… Thu 24th Aug 2006
New life celebrated/new soldie… Napanee, Ont. - New members of the corps, Shawn and Sandra H… Fri 11th Aug 2006
Captain Steve Manuel is City's… Salvation Army Captain Steve Manuel receives Summerside, N.S… Mon 7th Aug 2006
Change Islands celebrates Change Islands Citadel corps in the Newfoundland West divisi… Tue 25th Jul 2006
Dedicated back to God On July 9, 2006, Robert Frances Oldford was dedicated back t… Thu 20th Jul 2006
Collingwood community church h… Collingwood community church YPSM Gail Synnott honours new t… Wed 21st Jun 2006
General honours Granny Brigade As a young girl, Gladys Osmond dreamed of becoming a mission… Sat 10th Jun 2006
Deer Lake graduates Nfld. - Matthew Feltham is presented with his graduate certi… Fri 19th May 2006