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, Maritimes

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

Found 50 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
OK Kids I wish there had been something like the OK Kids support gro… Wed 19th Nov 2008
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
"Running Sober" Run … October 20, Halifax -  Rick MacDonald’s Running So… Tue 23rd Oct 2007
Running Sober Campaign Brings … Maritimes - It's Oct 17 and Rick MacDonald, a former addict,… Wed 17th Oct 2007
Former Addict Runs To Raise Aw… Halifax - Rick MacDonald is someone who, three years ago, wa… Mon 15th Oct 2007
Grace Hospital Auxiliary Youth… Winnipeg - The Grace Hospital Youth Volunteer Program celebr… Tue 2nd Oct 2007
Moms and Kids Camp at Scotian … Nova Scotia - Mothers (most of them single parents) who face… Thu 27th Sep 2007
Homeless Needs Are Met By City… St. John, N.B. - Recently The Salvation Army Booth Residenti… Mon 23rd Jul 2007
God's Army Grows P.E.I. - Charlottetown Community Church recently welcomed it… Wed 4th Jul 2007
Did You Know? Ron Zima, Public Relations and Major Gift Representative in … Wed 30th May 2007
SA volunteer helps others for … Truro, N.S. - At 24, Sharon Hughes underwent her first of fo… Mon 28th May 2007
New French Ministry in Edmunds… The Maritime Division has expanded its ministry to Edmundsto… Mon 21st 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
Partners in Mission Project an… Westville, N.S. - Partners in Mission - Shields have been m… Tue 17th Apr 2007
Maritime news New Brunswick - Major Shirley King, executive director of La… Mon 16th Apr 2007
Episode 233: The Salvation Arm… The week of April 15 is National … Fri 13th Apr 2007
Touching Lives Behind Bars Moncton, N.B.- The Salvation Army Correctional & Justice Ser… Mon 9th Apr 2007
Dealing with 'whole life' a wo… It's been a rough two months, but Robert Simmons is determin… Tue 27th Mar 2007
Happy 70th anniversary Dartmouth, N.S. Community Church - Retired CSM, Frank Banfie… Mon 19th Mar 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