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

Search Results

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

Found 57 Pages: showing 1 to 25
< 1 2 3 >
Title Summary Date
Free Music The Saviour of Men (vocal solo, piano acc.) - Soloist's copy… March 2, 2011
Song Suggestions for Palm Sund…   (most songs can be purchased at musicnotes.com or pr… February 16, 2011
Spanish Christmas Music      Angels we have heard on high - lead… February 15, 2011
Children's Ministry Websites www.cathysmusic.com www.familyworship.org.uk www.childrena… February 11, 2011
Youth Ministry Websites www.youthministry.com  (click onto “freebies&rdqu… February 11, 2011
Links to great Prayer sites www.spirithome.com www.sacredspace.ie/ www.worldpr… February 9, 2011
Cool Weblinks Dance, Flags, Creative Movement - www.worshipdance.org &nbs… February 8, 2011
Free Scripts www.users.on.net/pole/drama http://bobsnook.org/ www.anast… February 8, 2011
The Best Worship Team Websites Sheet music praisecharts.com   musicnotes.com &… February 8, 2011
Persecuted Church       … January 31, 2011
Themed Services       … January 27, 2011
E-worship: Tabernacle       … January 20, 2011
E-worship: Tabernacle       … January 20, 2011
E-Worship Brass Band       … January 14, 2011
E-worship: Children's Ministry       … January 14, 2011
E-worship: Creative Scripture       … January 14, 2011
E-worship: Creative Worship       … January 14, 2011
E-worship: Drama       … January 14, 2011
E-Worship: Easter       … January 14, 2011
E-Worship: Father's Day       … January 14, 2011
E-worship: Good Friday       … January 14, 2011
E-worship: Mother's Day       … January 14, 2011
E-worship: Multimedia       … January 14, 2011
E-worship: Prayer       … January 14, 2011
E-worship: Quotes       … January 14, 2011