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 tags Music, Music-and-Gospel-Arts, Worship, Youth

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

Found one Page:
Title Summary Date
Kim Garreffa A third generation Salvationist, Kim was born in Oakville, b… April 28, 2006

Found 63 Articles: showing 1 to 25
< 1 2 3 >
Title Summary Date
SA Radio The next Salvation Army Broadcast will be Monday, March… March 7, 2011
The Marks of Professionalism A friend of mine who is a high school band director sent me … February 8, 2011
Babysong CDs now available "Boom Chicka Boom" is a 2 CD set that gives you a … February 3, 2011
S.A. Meadowlands Corps present… The Salvation Army Meadowlands Band is Holding it's 41st. Yo… January 12, 2011
Worship Team Resources Anchors and Sails January 11, 2011
Looking for Accompaniment CDs? Are you in a situation where there are no musicians availabl… January 10, 2011
Spirit of the Season Inspirational Christmas music, dessert and coffee, held at T… November 16, 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
It was a hot time at National … (To view a larger version, click picture) Even record hot… September 17, 2010
Instruments Wanted A fourth year music student at McMaster University (Ontario)… July 7, 2010
The Next SA Radio Broadcast The next Salvation Army radio broadcast will be Mo… 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
Cameron Rawlins releases his f… Cameron Rawlins debuts on the music scene with a self-titled… April 14, 2010
Regarding Anchors and Sails I was reading an article a few years ago with a title that h… April 12, 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
Good Friday service at Yorkmin… 8 p.m. Friday April 2nd, 2010, at The Salvation Army Yorkmin… March 25, 2010
Listen to The Salvation Army o… The next Salvation Army broadcast will be Monday March 29th … March 25, 2010
National Music and Gospel Arts… Dates:  August 28 - September 4, 2010 Location: Jackso… March 17, 2010
Easter Concert Featuring Canada's premiere vocal ensemble, The Elmer Iseler… March 15, 2010
Singer Donates CD income to SA… For the next two weeks, all sale proceeeds from country sing… March 2, 2010
saguitarsongs: A valuable reso… saguitarsongs is a website that offers downloads for mo… February 3, 2010