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 tag Canadian-Staff-Band

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

Found 51 Articles: showing 1 to 25
< 1 2 3 >
Title Summary Date
Older CSB Albums Now Available… For your listening pleasure, the Canadian Staff Band is happ… December 17, 2010
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
Personnel Update - December 20… The CSB is pleased to announce the addition of two new membe… December 1, 2010
Visit to Mountain Citadel To kick of its 2010-11 season, the Canadian Staff Band was p… October 25, 2010
A New Season Begins As the Canadian Staff Band commences its 42nd anniversary se… September 13, 2010
Personnel Update - September 2… As the Canadian Staff Band commences another busy season, we… September 13, 2010
Great American Brass Band Fest… The weekend of June 11-13, the CSB was privileged to partici… June 21, 2010
Tribute - Stanley Dean The CSB is saddened to announce the loss of one of its origi… June 15, 2010
41st Anniversary Festival An air of excitement and anticipation swept through the … June 3, 2010
CSB Alumni President Appointed During the reception following the recent anniversary f… June 3, 2010
ISB 120th Anniversary - June 3… As followers of The Salvation Army’s International Sta… May 21, 2010
Visit to Midland The CSB was privileged to support the Midland Corps, Ontario… May 3, 2010
Personnel Update - April 2010 The Canadian Staff Band is pleased to welcome Sherie Keogh i… April 21, 2010
'A Day in the Life' Staff Bandsman Craig Lewis has posted a photo journal - &quo… April 13, 2010
CD Update The CSB has now recorded the tracks for our upcoming CD,&nbs… April 12, 2010
HSSB Festival of Brass Following a busy three days of recording, the CSB was the fe… April 12, 2010
New CD in the works The CSB will once again be going under the mics April 7, 9-1… March 16, 2010
Visit to Hamilton Meadowlands The CSB was pleased to visit the Meadowlands Corps in Hamilt… March 16, 2010
Personnel Update - February 20… The Canadian Staff Band is pleased to welcome Jeremy Smith i… February 25, 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
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

Found 5 Events:
Title Summary Date
Retirement of Territorial Lead… Retirement of Commissioners William and Marilyn Francis Met… June 26, 2011
Commissioning Commissioning of New Officers Metro Toronto Convention Cent… June 25, 2011
ISB 120 Tour Tour of The Netherlands and Germany/ISB 120 Weekend Friday,… May 27, 2011
Corps Weekend - Listowel, Onta… Saturday-Sunday, April 30-May 2, 2011 The Salvation Army 6… April 30, 2011
Concert with New York Staff Ba… Friday, March 4, 2011 Dinner and Fellowship with CSB Sat… March 5, 2011