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

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

Found 1208 Articles: showing 376 to 400
< 1 2 … 14 15 16 17 18 … 48 49 >
Title Summary Date
Sally Ann mobile food service … Prince George, B.C. - Last weekend The Salvation Army's mobi… Mon 22nd Oct 2007
What Did Jesus Say About Salva… This Salvationist series takes a closer look at the teaching… Mon 22nd Oct 2007
Good Without God, But Better W… Canadians who believe in God are more likely than non-believ… Fri 19th Oct 2007
Supporting Our Troops Quebec - The women of 3 Wing Bagotville’s Emmanuel Ch… Fri 19th Oct 2007
The Salvation Army Launches Mo… Prince George, B.C. - This past weekend The Salvation Army i… Thu 18th Oct 2007
"Sally Ann" Attends … Northwest Territories - The Salvation Army resource centre i… Wed 17th Oct 2007
Running Sober Campaign Brings … Maritimes - It's Oct 17 and Rick MacDonald, a former addict,… Wed 17th Oct 2007
A Birthday Party Westsong Community Church, a local church of The Salvation … Tue 16th Oct 2007
Instrument Drive Will Help Pov… Hamilton, Ont. - The Salvation Army in Hamilton has begun a … Tue 16th Oct 2007
Former Addict Runs To Raise Aw… Halifax - Rick MacDonald is someone who, three years ago, wa… Mon 15th Oct 2007
I Am Blessed God has placed great gifts in my hands expecting me to use t… Mon 15th Oct 2007
Tyndale Seminary Has New Chair Toronto - Dr. Howard Snyder will be installed to The Donald … Mon 15th Oct 2007
Community Outreach Newmarket, Ont. - The Salvation Army Northridge Community Ch… Fri 12th Oct 2007
Leading Mission Divisional Str… From the office of the chief secretary: I am writing on beha… Fri 12th Oct 2007
Church Members Donate Food To … Penticton, B.C. - Members of The Salvation Army church cong… Thu 11th Oct 2007
Is Our Uniform A Bother? “Isn’t that uniform a bother to you, with peopl… Thu 11th Oct 2007
The General Conducts Colonel B… ‘WELCOME in the name of the risen Christ!’ With… Thu 11th Oct 2007
Women's Mission Team Heads to … From October 17-31, 2007, 10 women from the Canada and Bermu… Wed 10th Oct 2007
Murungu or Mwanangu Imagine you’re black, and you’re walking down … Tue 9th Oct 2007
New Chair of the Board of Trus… William and Catherine Booth College Dr. Rook is the CEO of T… Tue 9th Oct 2007
Giving Hope at Howard Hospital In November and December 2006, photographer Doug MacLellan t… Mon 8th Oct 2007
Journey Out of Darkness Today we live in a world of darkness in which even our secul… Fri 5th Oct 2007
Care For The Dying In 2003, my wife, Laurie, and I had the privilege of present… Thu 4th Oct 2007
The Salvation Army Celebrates … On Tuesday, September 25, The Salvation Army joined with the… Wed 3rd Oct 2007
Grace Hospital Auxiliary Youth… Winnipeg - The Grace Hospital Youth Volunteer Program celebr… Tue 2nd Oct 2007