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 2007-08-01 and 2007-08-31

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

Found 3 Pages:
Title Summary Date
Boscombe Songsters Sept 29-30 - London Citadel Oct 1 - Sarnia Oct 2 - Hamilto… Fri 17th Aug 2007
Cadets Public Welcome Fri 17th Aug 2007
Sr. Music and Gospel Arts Camp Fri 17th Aug 2007

Found 65 Articles: showing 1 to 25
< 1 2 3 >
Title Summary Date
Wal-Mart, USA, Donates $150,00… Wal-Mart Stores, Inc., has donated $150,000 to assist in The… Thu 30th Aug 2007
Community Spirit When fire struck a Toronto neighbourhood, members of The War… Mon 27th Aug 2007
Captain Elizabeth Nelson
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captain Heather Richardson
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captain Karen Lemke
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captain Margaret McLeod
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captain Sharon and Cadet Jason…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains (Dr.) Paul and Pedrin…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains Keith and Joyce Warfo…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains Mark and Barbara Stan…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains Sheldon and Clare Fee…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Captains Stephen Court and Dan…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Colonels Robert and Marguerite…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Commissioner M Christine MacMi…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Commissioners Max and Lennie F…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Greg and Dawne Warkentin
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
John and Rochelle McAlister
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Lt.-Colonel Susan McMillan
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Lt.-Cols Wayne and Myra Pritch…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Lts. Gerald and Blanca Dueck
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Major (Dr.) Dawn Howse
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Major Heather Randell
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Major Joan Canning
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Majors Ariel and Joelle Westph…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007
Majors Brian and Rosalie Peddl…
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sun 26th Aug 2007