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 category THEME Articles

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

Found 45 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
The Marks of Professionalism A friend of mine who is a high school band director sent me … February 8, 2011
Looking for Accompaniment CDs? Are you in a situation where there are no musicians availabl… January 10, 2011
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
Breath Control for Brass Playe… Part One – Without the Instrument   When one th… June 16, 2010
Why Can't I Play in Tune Who would believe that by making a Bronx cheer into a metal … May 27, 2010
Regarding Anchors and Sails I was reading an article a few years ago with a title that h… April 12, 2010
Catch Those Clams! Modern Technology has been unable to devise the horn player&… February 10, 2010
saguitarsongs: A valuable reso… saguitarsongs is a website that offers downloads for mo… February 3, 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
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
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
Deconstructing Copyright May 6, 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
The Salvation Army's 'Secular'… (This article was originally published in the Jan-Feb-Mar 20… December 29, 2008
New Christmas Song Ideas For Y… There are a lot of congregational-friendly Christmas songs o… December 2, 2008
When the Staff Band rode Bicyc… Click here for a larger picture In the 1890s, The Canadia… November 11, 2008
The Power of Music: Part Two - written by David Robinson-Cooke (Reprinted from the Apr… October 1, 2008