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 between 2007-01-01 and 2007-12-31

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

Found 2 Pages:
Title Summary Date
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

Found 19 Articles:
Title Summary Date
CSB Wraps Up Another Busy Chri… Once again the Canadian Staff Band has completed another bus… December 17, 2007
New Staff Bandmaster Appointed Colonel Glen Shepherd, chief secretary, has announced that D… November 19, 2007
CSB Personnel Update - October… The Canadian Staff Band is pleased to welcome Cameron Rawlin… October 25, 2007
CSB Visits Kitchener To kick off the 2007/08 season, the Canadian Staff Band was … October 22, 2007
Happy 75th - The Salvation Arm… On Tuesday, September 25, 2007, The Salvation Army joined wi… September 27, 2007
CSB Personnel Update - Sept. 2… As the CSB once again looks forward to another busy year of … September 11, 2007
Welcome Welcome to the official website for the Canadian Staff Band.… September 11, 2007
CSB Present to Welcome New Ter… On Thursday, July 12, the Canadian Staff Band joined Salvati… July 16, 2007
CSB Beats the Army Drum in Win… by Staff Bandsman Major Ken Smith In June 2004, the Canadian… June 21, 2007
CSB Personnel Changes - June 2… At the end of another busy season, the CSB is bidding farewe… June 21, 2007
CSB Beginners’ Band Sup… Shown above are grateful recipients from Wiarton Community C… April 10, 2007
CSB Personnel April 2007 Updat… Personnel Update The CSB is once again undergoing some chang… March 26, 2007
CSB Weekend in Toronto and Lon… The Canadian Staff Band was involved in an interesting event… March 14, 2007
Promotion To Glory - Arthur De… A tribute by Staff Bandsman Stan Ewing Salvation Army bandin… March 14, 2007
Canadian Staff Band Anniversar… larger view "Back to the Future" - 38th Anniver… February 20, 2007
CSB Retreat On the weekend of February 2-4, the Canadian Staff Band came… February 18, 2007
International Recording Projec… On March 28 and 30, the CSB will be recording several tracks… February 18, 2007
Tour of Southern California Following months of planning and preparation, the CSB depart… January 9, 2007
Tour of Southern California The Canadian Staff Band has now returned from its tour of So… January 5, 2007