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 between 2009-01-01 and 2009-12-31

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

Found 24 Articles:
Title Summary Date
The Songster's Love Chapter A paraphrase of 1 Corinthians 13... If I could sing with … December 15, 2009
Don't be an instrument abuser! As you are reading this article, hundreds of brass instrumen… December 4, 2009
Singer returns from Uganda Country singer Cathy Harris and her missions team recently r… November 16, 2009
Seeking Lost Manuscripts Above: Bernard Verkaaik Jr, with Emil Soderstrom, circa 1950… November 9, 2009
View videos of National Camp o… Video highlights of this year's National Music & Gospel … October 29, 2009
Singer Organizes Missions Trip While attending Bible school some nine years ago I felt a ca… September 21, 2009
Christmas CDs for sale at amaz… (Click here to enlarge CD cover photo) For only $1.25 eac… September 9, 2009
Ministry Opportunity The Salvation Army Kitchener Community Church (Ontario, Cana… August 4, 2009
The Reason We Sing Ever wonder why we spend so much time singing in our church … July 27, 2009
On Keys, Choruses and Congrega… Occasionally, in working with worship teams, the subject of … July 13, 2009
Should Christians listen to se… This depends on several factors:    a) The matu… July 3, 2009
Praise is a Choice How many times have you joyfully sung the chorus “We b… June 11, 2009
Young Brass Player Competition PRIZES 1st   $1000.00    &nbs… June 10, 2009
The Great Canadian Christmas S… In the Fall of 2009 David C. Cook will be releasing the 5th … June 1, 2009
Canadian Soloist Impresses Dut… On Saturday May 16th the Dutch annual Music Congress was hel… May 19, 2009
Deconstructing Copyright May 6, 2009
WECC Gospel Arts Weekend Click here for a larger version of the picture. The weeke… April 15, 2009
Christmas Recordings Wanted! We are now accepting submissions for the 2009 Territorial Ch… March 25, 2009
Bass Trombone for sale  Shires bass trombone - independent, inline thayer va… March 10, 2009
Looking for a Band? Find web-links to all your favourite Salvation Army Bands fr… February 27, 2009
Singing for Watoto www.thepacket.ca Cathy Harris wears her faith on her … February 3, 2009
The Songster Leader's Almanac … It takes only one bad voice, or one very good one, to ruin a… February 2, 2009
Marching on Two Legs Written by Lt. Col. David Hammond (R) Reprinted from THEM… January 21, 2009
Confessions of a Corps Bandsma… - written by Steven Barrett (Corner Brook Temple Newfoundlan… January 13, 2009