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 2006-04-01 and 2006-04-30

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

Found 23 Pages:
Title Summary Date
37th Anniversary Fri 28th Apr 2006
Be Thou My Vision Fri 28th Apr 2006
Privacy Policy This website's policy is to respect and protect the privacy … Fri 28th Apr 2006
To God be the Glory Fri 28th Apr 2006
Magazines For more information about our magazines, please visit the f… Thu 27th Apr 2006
PrayerZone and Prayer Resource… For more information or to receive your copy by e-mail, cont… Thu 27th Apr 2006
Promotional Material Please find below material you can use in your church/corps … Thu 27th Apr 2006
Annual Change 2007 The following is information regarding the annual officer ap… Wed 26th Apr 2006
Family Tracing Services OUR TASK The Family Tracing Services of The Salvation Army … Wed 26th Apr 2006
Gazette and Calendar Updated January 29, 2009   GAZETTE INTERNAT… Wed 26th Apr 2006
Contact Us Thank you for visiting Salvationist.ca. If you have any ques… Tue 25th Apr 2006
Correctional and Justice Servi… Statistics may indicate that crime is decreasing, but its ef… Tue 25th Apr 2006
Emergency and Disaster Service… Disasters can occur at any time and in any place. They often… Tue 25th Apr 2006
Family Services Statistics Canada confirms that there are more than one mill… Tue 25th Apr 2006
Our churches The Salvation Army's 352 community churches are the nerve ce… Tue 25th Apr 2006
Child Sponsorship What is sponsorship? A sponsor is a person who provides fina… Mon 24th Apr 2006
Homelessness Despite the fact that we live in a country rich in resources… Mon 24th Apr 2006
Human Resources Mon 24th Apr 2006
Ministry Resources The Corps Ministries department at Territorial Headquarters,… Mon 24th Apr 2006
Volunteering To be effective in today's society, The Salvation Army needs… Mon 24th Apr 2006
Daily Blog Thu 20th Apr 2006
Human Sexual Trafficking Definition Human Sexual Trafficking is a form of slavery. I… Thu 13th Apr 2006
About Us The Salvation Army in Canada and Bermuda has 1,250 active of… Wed 12th Apr 2006

Found 12 Articles:
Title Summary Date
Preserving the Past Heritage plaque marks historic site for future generations I… Fri 28th Apr 2006
Episode 183: The Salvation Arm… The Salvation Army Connect… Thu 27th Apr 2006
Growing 'Douglas Fir' Disciple… The terrain is rough, rivers overflow and coyotes lurk in th… Thu 27th Apr 2006
Century-long mission to help l… Stella Cross has never had much, in terms of worldly wealth,… Wed 26th Apr 2006
Tillsonburg Salvation Army to … A new Salvation Army food co-op hopes not only to help peopl… Wed 26th Apr 2006
Traveling Soup Service in Berm… On February 2, 2006, the inaugural run of the traveling Soup… Wed 26th Apr 2006
Canada's Largest Christian Wri… Has God called you to be a writer? Write! Canada is a three … Thu 20th Apr 2006
Ontario Great Lakes Presents..… Liz Curtis Higgs at the London Convention Centre May 26-28, … Thu 20th Apr 2006
Ruth's Epic Story Experience Ruth's adventure at the Sight and Sound Theatre i… Thu 20th Apr 2006
Toronto Homestead's Family Sup… This five-week program offers support and education for fami… Thu 20th Apr 2006
Enrolments Across the Territor… "Praise God in His Sanctuary." Exciting new enrolments take … Wed 19th Apr 2006
Women's Ministries Victoria, B.C. High Point Community Church Women's Ministrie… Wed 19th Apr 2006