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 for tags Award, Faith-and-Friends, Salvationist

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

Found 95 Articles: showing 1 to 25
< 1 2 3 4 >
Title Summary Date
Dr. Paul Thistle - Honorary De… Dr. Paul Thistle receives honorary Doctorate, Photo © D… Thu 17th Jul 2008
Captain Dr. Paul Thistle Recei… Photo copyright 2008 Doug MacLellan On Wednesday, June 11… Fri 4th Jul 2008
Summer Outreach Have you forgotten to order your copies of the summer evange… Tue 27th May 2008
Dress for Success They say the clothes make the man-or woman! Why do we worry … Mon 28th Jan 2008
Hungry for God Why more and more Christians are fasting for revival Before … Mon 21st Jan 2008
Confession: Is It Really Good … Spiritual disclosure can bring a new awareness of God  Mon 14th Jan 2008
Covenant, Rainbow and the Call The power of the Holy Spirit is moving the hearts of Godâ… Mon 7th Jan 2008
Assumptions Jesus said we’re to treat all people equally, but tha… Mon 31st Dec 2007
Christmas Memories General Shaw Clifton reflects on Christmases past and the jo… Tue 25th Dec 2007
Bethlehem How the “House of Bread” became the birthplace o… Mon 24th Dec 2007
Little Church On The Prairie A newcomer to Canada shares how one congregation’s en… Mon 17th Dec 2007
Bring Faith And Friends To The… Planning a Super Bowl party? Consider ordering copies of the… Wed 12th Dec 2007
First Impressions What Does Christmas Mean To Newcomers To Canada? Zhen Li imm… Mon 10th Dec 2007
The Great Exchange Unwrapping the mystery and meaning of Christ’s coming… Mon 3rd Dec 2007
On the Rocks? Or Will That Be … Why it’s important to teach your kids about the dange… Thu 29th Nov 2007
YMCA Recognizes Peacemakers Kitchener,ON - On November 23, peace medallions for 2007 wer… Tue 27th Nov 2007
Bonsai Tree Sacred Cow Small churches have the potential for explosive growth if nu… Mon 26th Nov 2007
Priestly Pastors Are officers control freaks or are congregations abdicating … Mon 19th Nov 2007
Magic Mirror Sacred Cow Mirror, mirror, on the wall … who’s the fairest… Mon 12th Nov 2007
Old Sweater Sacred Cow Choosing Kingdom values over sentimentality. We all have an … Mon 5th Nov 2007
The Greening Of The Army A new report shows that The Salvation Army has a long way to… Mon 29th Oct 2007
Chief Secretary Receives Honor… On October 20, 2007, in Langley BC, Colonel Glen Shepherd wa… Thu 25th Oct 2007
What Did Jesus Say About Salva… This Salvationist series takes a closer look at the teaching… Mon 22nd Oct 2007
I Am Blessed God has placed great gifts in my hands expecting me to use t… Mon 15th Oct 2007
Giving Hope at Howard Hospital In November and December 2006, photographer Doug MacLellan t… Mon 8th Oct 2007