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 1101 to 1125
< 1 2 3 4 5 6 … 44 45 46 47 48 49 >
Title Summary Date
World refugee day update Immigrant & Refugee Services in Ontario Central Division rec… Tue 4th Jul 2006
How to make a camper connectio… 10 easy steps to bridge the gap between camps and year-round… Mon 3rd Jul 2006
Episode 192: The Salvation Arm… The Salvation Army Connection: Ep… Fri 30th Jun 2006
Targeting the Army Brand The public appreciates what we do in a disaster, but sometim… Fri 30th Jun 2006
Booth College, President's E-M… JUNE 2006 www.boothcollege.ca Canada and Bermuda Territory E… Thu 29th Jun 2006
New Candidates Accepted Three new candidates have been accepted to the 2006-2008 ses… Thu 29th Jun 2006
The Second Chance - Christian … On July 18th, 2006, Sony Pictures Home Entertainment (sonypi… Thu 29th Jun 2006
Canada and Bermuda's mission t… Monday, June 19 On Monday morning the team spent time in dif… Wed 28th Jun 2006
Manitoba and NW Ontario Divisi… Extreme Makeover - Inside Edition Ecclesiastes 3:1 (KJV) tel… Wed 28th Jun 2006
Shaved heads in Prince George,… Prince George Community Church, B.C. set a goal to raise $4,… Wed 28th Jun 2006
Are We the Church of the Poor? The body of Christ is more than the sum of its parts. All Ch… Tue 27th Jun 2006
New officers prepare for minis… This month the Canada and Bermuda Territory welcomes 13 new … Fri 23rd Jun 2006
St. John's CFOT - A Lasting Le… 116 years of officer training comes to an end in Newfoundlan… Fri 23rd Jun 2006
Episode 191: The Salvation Arm… The Salvation Army Connection: Ep… Thu 22nd Jun 2006
New Centre brings hope to Nana… Officially underway is a new housing establishment aimed at … Thu 22nd Jun 2006
The How-to Handbook for Effect… Contact: International Christian Ministries 19978-72 Ave, La… Thu 22nd Jun 2006
Collingwood community church h… Collingwood community church YPSM Gail Synnott honours new t… Wed 21st Jun 2006
DVD-Doctrine Series (audio MP3… WE BELIEVE ' is a DVD set containing the eleven Salvation Ar… Wed 21st Jun 2006
Update No. 2 from Canada and B… Tuesday, June 13, 2006 Tuesday evening brought soccer traini… Tue 20th Jun 2006
Women Connected 2006 On May 26-28, 2006, the London, Ont., Convention Centre buzz… Tue 20th Jun 2006
Episode 190: The Salvation Arm… The Salvation Army Connection: Ep… Mon 19th Jun 2006
Shopping for faith What has the church ever done for me? A critique of "consume… Mon 19th Jun 2006
The Salvation Army, Regina, br… On June 8, 2006, The Salvation Army in Regina launched 'It's… Mon 19th Jun 2006
Edmonton West rotary club help… The Rotary Club of Edmonton West donated a 15-passenger vehi… Sun 18th Jun 2006
Bandmaster Returns to Lead CSB Brian Burditt, who led the Canadian Staff Band from 1985 to … Fri 16th Jun 2006