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 451 to 475
< 1 2 … 17 18 19 20 21 … 48 49 >
Title Summary Date
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
Majors Bruce and Mildred Jenni…
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 Clarence and Linda Brad…
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 David and Marsha Jean B…
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 Lindsay and Lynette Row…
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 Norman and Lois Garcia
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 Robert and Dana Reid
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 Shane and Pauline Gruer…
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 Wendy Johnstone
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sat 25th Aug 2007
Majors Gary and Sharon Cooper
Add your greeting to the list below. These messages are accessible from any computer around the world that has internet service.
 Sat 25th Aug 2007
Canada's The Christian Channel… The Christian Channel is Canada's first all-Christian nation… Fri 24th Aug 2007
New Cabinet Appointments Commissioner William W. Francis, territorial commander, has … Fri 24th Aug 2007