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 1126 to 1150
< 1 2 3 4 5 6 … 44 45 46 47 48 49 >
Title Summary Date
New appointment for territoria… Effective May 1, 2006, R. Paul Goodyear, territorial financi… Fri 16th Jun 2006
World Cup defender tells of hi… What do Brazil, Germany, Italy, Argentina, Uruguay, France a… Thu 15th Jun 2006
Penny's from Heaven FOR YEARS Derek Sullivan didn't know he had a sister. But wi… Wed 14th Jun 2006
Cadets summer assignments The following is a list of the 'Heralds of the Good News' su… Tue 13th Jun 2006
Charlottetown, Nfld., enrolmen… Pictured is Kim Tucker, newly enrolled soldier along with Cp… Tue 13th Jun 2006
Episode 189: The Salvation Arm… The Salvation Army Connection: Ep… Tue 13th Jun 2006
Update No. 1 from Canada and B… Friday, June 9, 2006 The first day of the FIFA world cup was… Tue 13th Jun 2006
Identity Crisis Music, uniform and terminology shape our sense of who we are… Mon 12th Jun 2006
Toronto celebrates World Refug… The Salvation Army, other faith-based groups, several refuge… Mon 12th Jun 2006
General honours Granny Brigade As a young girl, Gladys Osmond dreamed of becoming a mission… Sat 10th Jun 2006
Campbellford Salvation Army th… On June 3, 2006, the Campbellford, Ont., thrift store celebr… Fri 9th Jun 2006
Salvationists from Canada and … Last night a team of seven passionate Salvationists from acr… Thu 8th Jun 2006
St. John's Citadel corps anniv… ST. JOHN'S, NL. On Christmas Day 1888, St. John's Citadel wa… Thu 8th Jun 2006
St. Thomas Corps welcomes new … Both junior and senior soldiers were recently enrolled at th… Wed 7th Jun 2006
A Gift That Will Keep On Givin… Long after retirement from a remarkable career as a public s… Mon 5th Jun 2006
British Columbia Harbour Light… The Harbour Light women, who pray each meeting for the downt… Mon 5th Jun 2006
New candidates accepted into C… Major Beverly Ivany, Secretary for Candidates, is pleased to… Mon 5th Jun 2006
The Christian Channel secures … The Christian Channel is Canada's first all-Christian nation… Mon 5th Jun 2006
Mississauga Temple Star Search… In the spring of 2005, the congregation of Mississauga Templ… Fri 2nd Jun 2006
More Information about Single … The following are additional communication tools in regard t… Fri 2nd Jun 2006
Promotion to Glory of Major Al… The Territorial Commander would like to share with you the … Fri 2nd Jun 2006
Sacramental Living William Booth's decision to stop practising the sacraments h… Fri 2nd Jun 2006
Episode 188: The Salvation Arm… The Salvation Army Connect… Thu 1st Jun 2006
Maximizing our Mission Potenti… In May 2005 Salvation Army leaders from various levels of ad… Thu 1st Jun 2006
Administrative Restructuring P… The Territorial Leaders met for the past few days, May 23-26… Tue 30th May 2006