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 between 2008-03-01 and 2008-03-31

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

Found 2 Pages:
Title Summary Date
Evangelism and Witness Newfoundland and Labrador Provincial Congress June 27 - 29, … Thu 20th Mar 2008
Emergency Disaster Services Tr… Wed 5th Mar 2008

Found 22 Articles:
Title Summary Date
Wounded Warriors Every day, they arrive by the busload -- broken, bandaged an… Mon 31st Mar 2008
International Appointments for… Commissioner Barry C Swanson, International Secretary for th… Fri 28th Mar 2008
Getting People Back On Their F… The Salvation Army’s transitional employment program … Wed 26th Mar 2008
Salvation Army Broadcast This is a reminder of the next 2 hour S.A. broadcast. It i… Tue 25th Mar 2008
The Warehouse Mission What to understand more about “The Warehouse Missionâ… Tue 25th Mar 2008
The Easter Streets It is not the crucifixion itself but the Crucified One who r… Mon 24th Mar 2008
Jesus' Last Words As he hung dying on the cross, Christ had a final message fo… Thu 20th Mar 2008
Launch of New Website for Comm… The Salvation Army in Canada and Bermuda has launched a new … Mon 17th Mar 2008
Emergency Disaster Services - … On March 7 and 8, 2008, 18 representatives including officer… Thu 13th Mar 2008
Welcome & Installation of the … Click on the arrow in the center of the screen below to view… Tue 11th Mar 2008
Keeping Our Kids Safe There are countless tragic stories of children who have been… Mon 10th Mar 2008
New Chief Secretary Appointed Effective March 1, Lt-Colonels Donald and Ann Copple have be… Fri 7th Mar 2008
VisionTV Easter Programming VisionTV honours Holy Week, Easter with special presentation… Wed 5th Mar 2008
Living in a Fantasy World Are books like The Golden Compass a dangerous influence on o… Tue 4th Mar 2008
Mexico - Not Just a Vacation D… Resident children at the Salvation Army children's home in C… Mon 3rd Mar 2008
Barrie Corps 125th Anniversary… JUNE 6 - 8, 2008 With Lt-Colonels John and Audrey Wilder For… Sat 1st Mar 2008
Booth College admissions@boothcollege.ca or phone 1.877.942.6684 ext 850 V… Sat 1st Mar 2008
Booth College Graduation 2008 BOOTH COLLEGE invites you to attend the events of GRADUATION… Sat 1st Mar 2008
Brass 125 - A Celebration 125 Years of Brass Banding in Canada The Salvation Army's tw… Sat 1st Mar 2008
Evangelism and Witness - NLFD/… Newfoundland and Labrador Provincial Congress June 27 - 29, … Sat 1st Mar 2008
Ordination and Commissioning -… June 13 - 14, 2008 With Commissioners William W. and Marilyn… Sat 1st Mar 2008
The New Suburbia An Integrated Mission Institute by the Christian Community D… Sat 1st Mar 2008