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/web76/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/web76/web/index.php line 4
Search Results
Skip to Content
Click to print

Search Results

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

Found 1208 Articles: showing 476 to 500
< 1 2 … 18 19 20 21 22 … 48 49 >
Title Summary Date
Atheists Remain a Small Minori… Vast Majority of People Believe, Identify, Attend Services. … Thu 23rd Aug 2007
Salvation Army Broadcast - Aug… The next S.A. broadcast is sponsored by the Derle Family in … Thu 23rd Aug 2007
Salvation Army Responds To Nee… Salvation Army emergency disaster personnel in Jamaica are r… Wed 22nd Aug 2007
Peru Earthquake (Update 1) Salvation Army relief teams continue to bring urgently neede… Tue 21st Aug 2007
Praise With Pipes From Govan, Scotland to London, Ontario, Jack Bernard emerge… Tue 21st Aug 2007
Salvation Army Checking Shelve… The Salvation Army has issued a Canada-wide directive to rem… Tue 21st Aug 2007
The General's Pastoral Letters It is the General's wish that as many soldiers as possible, … Tue 21st Aug 2007
Chief Secretary's Quarterly Re… The following is the Chief Secretary’s 2nd quarter re… Mon 20th Aug 2007
The New Brass Band Why it will always have an important place in our ministry. … Mon 20th Aug 2007
The Salvation Army Sends Finan… Friday August 17, 2007 - After a 7.9 magnitude earthquake hi… Mon 20th Aug 2007
Twenty Years In The Alley About 100 years ago, British Egyptologist, Sir Flinders Petr… Fri 17th Aug 2007
From the desk of Major Eric Bo… August 2007 - Donna and I arrived in the office on Tuesday J… Thu 16th Aug 2007
Tragedy Strikes Home - A Paren… On the front page of the Washington Post was the story of fo… Thu 16th Aug 2007
International Days of Prayer a… For three days this fall, Friday, September 28 - Sunday, Sep… Wed 15th Aug 2007
The Ongoing Popularity of Marr… Marriage continues to be highly valued by most Canadians. So… Tue 14th Aug 2007
God and Your Bod Forget the latest fitness craze or diet fad. Getting in shap… Mon 13th Aug 2007
Salvation Army Co-hosts Camp F… CANGRANDS is a not-for-profit organization devoted to povidi… Mon 13th Aug 2007
EMS to Release Tunes from Dece… A Christian singer/songwriter is about to have a comeback de… Fri 10th Aug 2007
The Winning Goal In Georgetown, hockey is a major part of many families' live… Fri 10th Aug 2007
God's Merciful Irony Only God could choose a killer to lead others into new life,… Thu 9th Aug 2007
The Salvation Army Offers Aid … Wednesday August 8, 2007 - As fears of epidemic rise followi… Thu 9th Aug 2007
Sleep Country Ensures Students… The store's third annual Backpacks for Kids campaign runs fr… Wed 8th Aug 2007
Salvation Army Brass Bands The Salvation Army has used the brass band as an instrument … Tue 7th Aug 2007
Amy Grant to Release Memoir The memoir of Christian music artist Amy Grant will release … Mon 6th Aug 2007
Contact Sports Eighty percent of the people in your community watched or pa… Mon 6th Aug 2007