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

Search Results for tag Band

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

Found 50 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
SA Radio The next Salvation Army Broadcast will be Monday, March… March 7, 2011
Mississauga Temple Band presen… "Music Extravaganza!" features cornet soloist… March 1, 2011
The Marks of Professionalism A friend of mine who is a high school band director sent me … February 8, 2011
Spirit of the Season Inspirational Christmas music, dessert and coffee, held at T… November 16, 2010
Christmas Coffee House Come join the Mountain Citadel Band and musical soloists in … November 8, 2010
New Book Release "Ever Heard the Sound?" is all about the life… October 18, 2010
Bermuda Fall Festival The Salvation Army West End Community Church is hosting a Fa… October 13, 2010
Christmas Concert Spectacular A spectacular evening of Christmas music with a cast of over… October 1, 2010
The 2010 Territorial Christmas… Click here to see a larger version of the cover. At onl… September 22, 2010
Breath Control: The Embouchur… Most of the people reading this will already have developed … August 9, 2010
Breath Control: Part Two For part one, click here. Part Two: With the Instrument … July 7, 2010
Instruments Wanted A fourth year music student at McMaster University (Ontario)… July 7, 2010
Breath Control for Brass Playe… Part One – Without the Instrument   When one th… June 16, 2010
The Next SA Radio Broadcast The next Salvation Army radio broadcast will be Mo… May 27, 2010
Why Can't I Play in Tune Who would believe that by making a Bronx cheer into a metal … May 27, 2010
Enjoy a spring concert in Hami… Featuring The Vernon Festival Praise and Worship Team, The M… May 3, 2010
Looking for Christmas recordin… We are now accepting submissions for the 2010 Territorial Ch… May 3, 2010
Concert at Mississauga Temple The Mississauga Temple Band (bandmaster Derrick Fishwick) pr… April 1, 2010
Norridge Band & Songsters at N… FREE concert at The Salvation Army North York Temple on Satu… March 29, 2010
Listen to The Salvation Army o… The next Salvation Army broadcast will be Monday March 29th … March 25, 2010
Easter Concert Featuring Canada's premiere vocal ensemble, The Elmer Iseler… March 15, 2010
Catch Those Clams! Modern Technology has been unable to devise the horn player&… February 10, 2010
Sounding Brass: The Discipline… “I appeal to you, brothers, in the name of our Lord Je… February 3, 2010
Don't Forget your Home Practic… “Don’t forget your home practice!”  H… January 11, 2010
Don't be an instrument abuser! As you are reading this article, hundreds of brass instrumen… December 4, 2009