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 for category CSB Events

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

Found 42 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
2010 Christmas in Toronto December has been a busy month for the CSB as we were once a… December 15, 2010
2010 Fall Festival and Parade … On the weekend of November 20-21, 2010, Salvationists in Tor… December 1, 2010
Visit to Mountain Citadel To kick of its 2010-11 season, the Canadian Staff Band was p… October 25, 2010
Great American Brass Band Fest… The weekend of June 11-13, the CSB was privileged to partici… June 21, 2010
41st Anniversary Festival An air of excitement and anticipation swept through the … June 3, 2010
Visit to Midland The CSB was privileged to support the Midland Corps, Ontario… May 3, 2010
'A Day in the Life' Staff Bandsman Craig Lewis has posted a photo journal - &quo… April 13, 2010
HSSB Festival of Brass Following a busy three days of recording, the CSB was the fe… April 12, 2010
Visit to Hamilton Meadowlands The CSB was pleased to visit the Meadowlands Corps in Hamilt… March 16, 2010
Visit to Guelph For our first engagement of 2010, the Canadian Staff Band wa… February 19, 2010
Christmas in Toronto 2009 December was a busy month for the CSB as we were on duty for… December 14, 2009
Fall Festival and Parade Weeke… On the weekend of November 14-15, 2009, Salvationists in Tor… November 27, 2009
Visit to Cobourg On October 3-4, 2009, the CSB was privileged to participate … October 5, 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
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
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
Christmas in Toronto 2008 Once again the Canadian Staff Band has completed another bus… December 14, 2008
Benefits in Brass On Saturday, November 15, the Canadian Staff Band was privil… November 29, 2008
Visit to Ontario's Bruce Penin… On the weekend of October 4-5, the Canadian Staff Band launc… October 23, 2008
Commissioning Weekend 2008 Once again this year the Canadian Staff Band was privileged … June 30, 2008
Spirit of the West On Saturday, May 31, a packed hall at Scarborough Citadel, T… June 1, 2008