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 Music-and-Gospel-Arts

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 15 Articles:
Title Summary Date
The Marks of Professionalism A friend of mine who is a high school band director sent me … February 8, 2011
Christmas Concert Spectacular A spectacular evening of Christmas music with a cast of over… October 1, 2010
It was a hot time at National … (To view a larger version, click picture) Even record hot… September 17, 2010
Regarding Anchors and Sails I was reading an article a few years ago with a title that h… April 12, 2010
National Music and Gospel Arts… Dates:  August 28 - September 4, 2010 Location: Jackso… March 17, 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
View videos of National Camp o… Video highlights of this year's National Music & Gospel … October 29, 2009
Praise is a Choice How many times have you joyfully sung the chorus “We b… June 11, 2009
The Great Canadian Christmas S… In the Fall of 2009 David C. Cook will be releasing the 5th … June 1, 2009
Deconstructing Copyright May 6, 2009
WECC Gospel Arts Weekend Click here for a larger version of the picture. The weeke… April 15, 2009
There's a new website in town The Salvation Army Music and Gospel Arts Department has offi… October 28, 2008
How’s Your Stage Presen… - Kim Garreffa Whether singing, speaking, or playing an ins… May 29, 2008
Territorial School of Music an… Approximately 130 students, 16-30, are at Jackson's point, O… August 31, 2006