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-02-01 and 2008-02-29

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

Found 4 Pages:
Title Summary Date
Booth Campus Visit Days More Booth College Info Email: admissions@boothcollege.ca W… Wed 20th Feb 2008
Imagine She Is Your Child How committed would you be to her safety? The Salvation Army… Wed 20th Feb 2008
Visit the Holy Land 2008 Visit the Holy Land in 2008 October 22 - November 5 15 Days … Wed 20th Feb 2008
testing rss Fri 8th Feb 2008

Found 16 Articles:
Title Summary Date
Colour Blind Imagine you’re black, and you’re walking down … Fri 29th Feb 2008
His Land Has Gripped My Heart! Why does my heart yearn to visit the Land of the Book? Woody… Wed 27th Feb 2008
Headquarters to Participate in… To help bring attention to the environmental cause, The Salv… Tue 26th Feb 2008
Commissioner Linda Bond Fri 22nd Feb 2008
National Council on Welfare The National Council of Welfare, which was created in 1969, … Fri 22nd Feb 2008
The Joys of Service How a surprise appointment turned into a welcome opportunity… Tue 19th Feb 2008
Entering Into Covenant “I have chosen you out of the world” - Jesus (Jo… Fri 15th Feb 2008
Hooked On A Feeling Two teenagers offer words of advice on dating, relationships… Mon 11th Feb 2008
The General's Pastoral Letter … February 2008 - From the Office of the General to Salvationi… Mon 11th Feb 2008
Spirit of the West Email: Paula Marshall Sun 10th Feb 2008
Jubilee Brass Takes Part In Ne… Brantford, ON - On Sunday, October 14, 2007, Jubilee Brass o… Fri 8th Feb 2008
Manitoba Morphosis Frigid Manitoba temperatures didn’t hold back sixty f… Fri 8th Feb 2008
Canada’s Parliament Bui… Every day and every hour the bells peal out the message of o… Thu 7th Feb 2008
Calvary Covenant Good Friday and Easter Sunday stand at the zenith of the Chr… Wed 6th Feb 2008
A Deadly Duo Two drunken men in a truck spelled disaster In 1993, a devas… Tue 5th Feb 2008
10 Ways to Support Partners i… Looking for new ideas to spark your creative interest? Tired… Mon 4th Feb 2008