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

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

Found 7 Pages:
Title Summary Date
Joshua Bailey    Part: … September 15, 2009
Kevin Wilson   Part Per… August 19, 2009
Repertoire The CSB currently contains the following pieces in its conce… June 10, 2009
Archives Here you can search our archives of pages and posts since ou… June 8, 2009
Poll June 8, 2009
Recordings Available Now: All CDs available through The Salvation A… June 8, 2009
Upcoming June 4, 2009

Found 21 Articles:
Title Summary Date
Christmas in Toronto 2009 December was a busy month for the CSB as we were on duty for… December 14, 2009
Personnel Update - December 20… Following our recent Christmas activities, CSB members took … December 14, 2009
Tribute - Marvin Kitney The Canadian Staff Band is saddened to announce the loss of … December 8, 2009
Fall Festival and Parade Weeke… On the weekend of November 14-15, 2009, Salvationists in Tor… November 27, 2009
Tribute - William Burditt William (Bill) Burditt, one of the founding members of … October 28, 2009
Visit to Cobourg On October 3-4, 2009, the CSB was privileged to participate … October 5, 2009
A New Season Begins The Canadian Staff Band has kicked off its 41st season … September 15, 2009
Blasts from the Past Long-time followers of the CSB will appreciate a brand new c… August 18, 2009
Personnel Update At the end of another busy season, the CSB is bidding farewe… June 22, 2009
Commissioning 2009 Once again the CSB was privileged to support … June 21, 2009
Visit to Simcoe On the weekend of June 6-7, the Canadian Staff Band visited … June 9, 2009
International Visitors Attend … On Wednesday, June 3, the CSB was privileged to have two vis… June 5, 2009
CSB Alumni Gather for Annivers… On Saturday, May 31, former members of the Canadian Staff Ba… June 4, 2009
95th Memorial Service for Empr… On Sunday, May 31, 2009, a large crowd of Salvation Army off… June 2, 2009
40th Anniversary Festival Just over 40 years ago, on January 18, 1969, members of the … June 1, 2009
CSB Hosts Notre Dame Concert B… The Canadian Staff Band joined forces with the University of… May 19, 2009
New Additions to CSB Family Congratations to the following staff bandsmen and their… May 11, 2009
Canadian Composer Visits CSB R… On Wednesday, May 6, composer William Gordon dropped in as a… May 8, 2009
Visit to Collingwood On the weekend of May 2-3, 2009, the Canadian Staff Band was… May 8, 2009
New CD Recorded in Guelph Under the technical expertise of recording engineer Ted… April 8, 2009
Visit to Barrie On the weekend of February 28-March 1, the CSB was privilege… March 2, 2009