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 143 Articles: showing 126 to 143
< 1 2 3 4 5 6 >
Title Summary Date
Oshawa Temple Concert On Saturday, November 3, 2006, the CSB took the opportunity … November 15, 2006
For The Aspiring Soloist - byDonna Colley Donna is currently the Songster Leader for… November 13, 2006
Music And Gospel Arts Personne… Beginning November 3rd, Majors Len and Heather Ballantine wi… November 10, 2006
Don't Forget Your Home Practic… - by Steve Brown (originally published in Volume IV, issue … November 7, 2006
Melbourne Staff Band Visit Check out these pictures of the Melbourne Staff Band visit b… November 3, 2006
Why Territorial Camp Should Be… For anyone age 16-30, this is an annual event that should be… October 26, 2006
Melbourne Staff Band Concert -… The Melbourne and Canadian Staff Bands have developed a clos… October 16, 2006
Welcome THEMEonline.ca Welcome to THEME online! With the inauguration of this new w… October 6, 2006
Boosting Your Brass Band's Ski…   One of my music dictionaries provides the following … September 25, 2006
New Resources For Brass Scripture-Based Songs Volume 7 Songs include: Above All … September 25, 2006
Singing In Excelsis Choose your music. Only you can do that. You must be c… September 25, 2006
CSB Anniversary Concert A capacity crowd greeted Bandmaster Kevin Hayward and the Ca… September 14, 2006
Georgina Band The Georgina Corps Band began its summer ministry on June 25… September 14, 2006
North Toronto Band Peering through his glasses, the bandmaster was satisfied th… September 14, 2006
Territorial School of Music an… Approximately 130 students, 16-30, are at Jackson's point, O… August 31, 2006
Stewardship August 2, 2006
Innovations in Music Ministry … In September, Ontario will host the last six days of a three… July 14, 2006
Interdivisional musicians coun… In connection with the visit of the Melbourne Staff Band to … June 12, 2006