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/web75/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/web75/web/index.php line 4
Search Results
Skip to Content
Enlarge TextClick to print16 16 2611 Sign In

Search Results between 2006-01-01 and 2006-12-31

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

Found 53 Pages: showing 1 to 25
< 1 2 3 >
Title Summary Date
Abus d'alcool ou d'autres drog… Position de principe sur l’abus d’alcool ou d&rs…
Avortement Position de Principe sur L'Avortment L’Armée d…
Current News January 15, 2007? Over 3000 surveys have been distributed t…
Diversité humaine Position de principe sur la diversité humaine L&rsqu…
Environnement Position de principe sur la responsabilité en mati&eg…
Euthanasie Position de principe sur l’euthanasie, le suicide assi…
Famille Position de principe sur la famille L’Armée du…
Insémination artificielle et … L'INSÉMINATION ARTIFICIELLE ET LA FÉCONDATION …
Jeu Position de principe sur le jeu L’Armée du Sal…
Literature Barrett, R. (1998). Liberating the corporate soul: Building …
Mariage Position de principe sur le mariage L’Armée du…
Observance du dimanche Position de principe sur l’observance du dimanche Pou…
Paix mondiale Position de principe sur la paix dans le monde L’Arm&…
Pauvreté et justice économiq… Position de principe sur la pauvreté et la justice &e…
Peine Capitale Position de Principe sur la Peine Capitale Du fait qu'elle …
Pilot project The initial survey was delivered to two pilot sites in June …
Pornographie Position de principe sur la pornographie L'Armée du …
Project Rationale In its origin, The Salvation Army was known for soup, soap a…
Timeline Task/Timeline Meeting with territorial social services leade…
- Core values of The Salvation… Click on the link below to view a PDF document of the core v…
Position Statement on Abortion The Salvation Army believes in the sanctity of human life be…
Position Statement on Capital … Because Salvationists believe in the sanctity of all human l…
Position Statement on Euthanas… Human life is a sacred gift from God. The Salvation Army bel…
Position Statement on Family The Salvation Army believes the family, as the basic communi…
Position Statement on Gambling The Salvation Army takes a stand against gambling that invol…

Found one Article:
Title Summary Date
Welcome Every day we make hundreds, even thousands of decisions. The…