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 between 2008-07-01 and 2008-07-31

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

Found 6 Pages:
Title Summary Date
Booth College Advertisement For more information visit www.boothcollege.ca. Email conta… Thu 31st Jul 2008
Urban Forum 2009 For more information visit www.theurbanforum.com Thu 31st Jul 2008
Sign Up Mon 21st Jul 2008
Careforce Devotional Here are some resources that can be used: July 2008 Wed 16th Jul 2008
Home Missions 2007 Ontario Great Lakes Division Raised: $61,639 100% of the H… Thu 3rd Jul 2008
Home Missions 2008 Projects by Division Free downloadable resources for Home M… Thu 3rd Jul 2008

Found 15 Articles:
Title Summary Date
Sowing Seeds of Faith I dig my hand into the seed bag and gently scatter its conte… Mon 28th Jul 2008
When God Says Go He continually reminds me that officership was his idea W… Mon 28th Jul 2008
By Faith - We Take Risks From its earliest days right up until the present, The Salva… Wed 23rd Jul 2008
Peaceable Evangelism In the first of a two-part interview, Rick Tobias, CEO of Yo… Mon 21st Jul 2008
Summer Evangelism With Faith &… How are churches using the free summer edition of Faith &… Mon 21st Jul 2008
The Salvation Army Helps - Tor… The Salvation Army Helps Those Affected by the East York Hig… Mon 21st Jul 2008
Dr. Paul Thistle - Honorary De… Dr. Paul Thistle receives honorary Doctorate, Photo © D… Thu 17th Jul 2008
The Red Serge and the Red Shie… The Red Serge of the Royal Canadian Mounted Police is r… Thu 17th Jul 2008
Mom, I’m Pregnant When my daughter told me the news I didn’t know how to… Mon 14th Jul 2008
VisionTV Looks at Christianity… With the Beijing Olympic Games set to begin on August 8, wor… Mon 14th Jul 2008
Charlottetown Celebrates 122nd… Highlights of the festivities included the enrolment of Stef… Tue 8th Jul 2008
God's Cheerleader As Christians, we are called to root for the winning team … Mon 7th Jul 2008
Captain Dr. Paul Thistle Recei… Photo copyright 2008 Doug MacLellan On Wednesday, June 11… Fri 4th Jul 2008
Healing for Native Peoples On June 17, 2008, Commissioner William Francis wrote to Prim… Fri 4th Jul 2008
VisionTV's Extreme Clergy ***NEW EPISODE*** Airing Friday, July 18, 10:30 p.m. ET / 7… Wed 2nd Jul 2008

Found one Event:
Title Summary Date
test test event great things go here Mon 7th Jul 2008