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/web77/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/web77/web/index.php line 4
Search Results
Skip to Content
 

Search


 
Find the Army near you

Territorial Photos


Ministry Resources Poll

If you were starting a new children's ministry program, which timeframe would you use?
Choices

Syndication

14 14 1199  RSS | What is this?

Search Results between 2011-01-01 and 2011-01-31

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

Found 4 Pages:
Title Summary Date
Guide de Ressources Ressources en francais À l'intention des officiers… Jan 21, 2011
Ressources-en-Francais Promotional Slides in French Guides de Ressources Defi… Jan 21, 2011
Canada and Bermuda 24-7:52 Cha… Jan 19, 2011
Thanks Thankyou for committing to join in our year of prayer! Jan 19, 2011

Found 7 Articles:
Title Summary Date
Valentine's Program Ideas Looking for last minute Valentine's ministry ideas? You c… Jan 31, 2011
Commitment Sunday 2011 As you plan for the Territorial Candidates and Commitment Su… Jan 24, 2011
Global Call to 24-7 Prayer Res… In response to the General's Call to Global Prayer 24-7, the… Jan 21, 2011
Prayer Resources for Children … The Children and Youth Department at THQ have developed a ne… Jan 21, 2011
Community Care Ministries 2010 Here is a great encouragement for members of Community Care … Jan 12, 2011
Decision Materials This great resource tool that will help you lead children an… Jan 10, 2011
Junior Soldier Renewal The Junior Soldier Renewal and Junior Action Commitment Sund… Jan 10, 2011

Found one Event:
Title Summary Date
The Urban Forum 2011 DATE:  January 26 - 29th, 2011 COST:  $125 Booki… Jan 26, 2011

Found 8 Gallery Images:
Title Summary Date
Global Call to 24-7 Prayer Jan 24, 2011
Happenings Jan 24, 2011
saPray247.ca Jan 21, 2011
Send The Fire Jan 21, 2011
Advert: Global Call to 24-7 Pr… Jan 11, 2011
Advert: Imagine she is your ch… Jan 11, 2011
Advert: Join the Pioneer Clubs Jan 11, 2011
Advert: New Canadian Staff Ban… Jan 11, 2011