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/web40/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/web40/web/index.php line 4
Search Results
Skip to Content
Enlarge TextClick to print16 16 2611 Sign In

Search Results

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

Found 60 Pages: showing 26 to 50
< 1 2 3 >
Title Summary Date
Leigh Rowney   Part Perc… October 23, 2008
Major Ken Smith   Part: Eb … October 23, 2008
Major Kevin Metcalf   Position: … October 23, 2008
Major Ted Kimmins   Position: … October 23, 2008
Nicole Downer   Part: Flu… October 23, 2008
Noel Samuels   Part: Eb … October 23, 2008
Rick Allington   Part: Sol… October 23, 2008
Ron Pearson   Part: 2nd… October 23, 2008
Scott Gross   Part: Bb … October 23, 2008
Serena Doars   Part: Sol… October 23, 2008
Stephen Mansfield   Part: 1st… October 23, 2008
Stephen Pavey   Part: Eup… October 23, 2008
Steve Brown   Part: Sol… October 23, 2008
Valerie Moreton   Part: 1st… October 23, 2008
Canadian Staff Band   Welcome to the official website of the Canadian… September 29, 2008
Forgotten Password Forgotten Password September 29, 2008
Privacy Policy This website's policy is to respect and protect the privacy … September 29, 2008
Search Results September 29, 2008
Sign In If you have forgotten your password, click here. September 29, 2008
Signed In Welcome , you are signed in with the following privileges: September 29, 2008
Burditt Years - Phase II (2006… From August 2006 until April 2008, former bandmaster Brian B… April 2, 2008
In Memoriam CSB Members Promoted to Glory (1969 to present)   (o… January 25, 2007
CSB Alumni (not including present members; officer ranks have been excl… January 22, 2007
Itinerary 2011 Apr 6, 8-9      &nb… December 4, 2006
Our Mission The mission of the Canadian Staff Band is to share the Gospe… December 4, 2006