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

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

Found 1208 Articles: showing 951 to 975
< 1 237 38 39 40 4148 49 >
Title Summary Date
The Salvation Army participate… Saskatoon - This winter 100 families will have warmer homes … Wed 18th Oct 2006
Backstreet Boy returns to his … With the spring 2006 release of his first-ever Christian sol… Tue 17th Oct 2006
Community care in Whitehorse Members of the Whitehorse Corps recently travelled the Demps… Tue 17th Oct 2006
A Place of Miracles Wiarton experiences a rebirth of Salvation Army ministry. Wi… Mon 16th Oct 2006
Camp Newport rejoices Camp Newport, Ontario North - Five holiday camps held this s… Fri 13th Oct 2006
Episode 207: The Salvation Arm… Feature: To mark the Internation… Fri 13th Oct 2006
Raising awareness of abandoned… GuluWalk is a one-day worldwide event focused on raising awa… Fri 13th Oct 2006
Sports ministry desk to be est… Following consultation with senior International Headquarter… Fri 13th Oct 2006
Hespeler corps celebrates 120 … A well attended 120th anniversary ceremony took place at the… Thu 12th Oct 2006
Music ministry for community k… The Salvation Army Rideau Heights Corps in Kingston, Ont. is… Thu 12th Oct 2006
Despite kitchen fire, Thanksgi… Toronto, Ont. - The Regent Park community in downtown Toront… Wed 11th Oct 2006
Kingston citadel reaches out t… Kingston, Ont. - The Gathering Place day services ministry p… Wed 11th Oct 2006
Thunder Bay firefighters carve… Thunder Bay firefighters responded to a call this past weeke… Wed 11th Oct 2006
Northern Lights Steel Orchestr… Owen Sound, Ont. - On Saturday, September 9, 400 people visi… Tue 10th Oct 2006
Realtors prepare Thanksgiving … Maple Ridge, B.C. - Real estate agents who usually spend the… Tue 10th Oct 2006
Sally Ann a bright light About 13 years ago Francois Garneau went through the doors o… Tue 10th Oct 2006
Senior soldier enrolment London, Ont. - In June three new senior soldiers were enroll… Tue 10th Oct 2006
Citywide week of prayer in Nia… Niagara Falls - From September 24 to October 21,2006 Mayor T… Mon 9th Oct 2006
The Church at the end of moder… Modernism is breaking down, and many Christians are now chur… Mon 9th Oct 2006
Convocation on higher educatio… The Canada and Bermuda Territory hosted the Convocation on H… Fri 6th Oct 2006
Episode 206: The Salvation Arm… Feature: Majors David and Elaine … Fri 6th Oct 2006
Orillia Community Church celeb… Junior Soldier enrolment - Congratulations to five young peo… Fri 6th Oct 2006
A young life puts her future i… Winnipeg, M.B. - Emily Moulton was enrolled October 1, 2006 … Thu 5th Oct 2006
Huntsville corps celebrates 12… Huntsville, Ont. - The Salvation Army came to Huntsville in … Thu 5th Oct 2006
Love's Abiding Joy (foxfaithmovies.com) On October 6 Love's Abiding Joy will be… Thu 5th Oct 2006