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 301 to 325
< 1 211 12 13 14 1548 49 >
Title Summary Date
Canada Post Plays Santa Claus … For the seventh consecutive year, Canada Post will present T… Mon 24th Dec 2007
Families And Homelessness Canadian study examines the relationship between the homeles… Fri 21st Dec 2007
Local Jeweller's Charity Angel… Prince Rupert,B.C. - Cook's Jewellers is entering its sixth … Fri 21st Dec 2007
Salvation Army Broadcast Two Christmas broadcasts will be held on FM 98.5 ckwr Decemb… Thu 20th Dec 2007
Wrestlers Clash To Send Christ… Welland, Ont. - Knuckle sandwiches will help feed the less f… Thu 20th Dec 2007
'Tis The Season Toronto - Police officers from 51 Division have partnered wi… Wed 19th Dec 2007
Christmas, Upsize or Downsize? “Would you like to upsize your order?” If you ha… Tue 18th Dec 2007
Historic Streetcar Restoration… New Westminster, B.C. - The Salvation Army thrift store has … Tue 18th Dec 2007
Little Church On The Prairie A newcomer to Canada shares how one congregation’s en… Mon 17th Dec 2007
Shelter Given The Go-ahead Langley, B.C. - Last week Langley City council voted in favo… Mon 17th Dec 2007
Man pays it back by paying it … More than six decades after receiving help from the Salvatio… Fri 14th Dec 2007
Toy Donors Are Asked To Check … Many charities are asking people to check Health Canada's re… Fri 14th Dec 2007
Reasons why holiday volunteers… I. "Some people feel the more you buy, the better off they a… Thu 13th Dec 2007
Salvation Army Allowed To Jing… Vancouver - After five years of being silenced at several Va… Thu 13th Dec 2007
Advent Conspiracy Restores 'Sc… PORTLAND, Ore. - The Advent Conspiracy (www.AdventConspiracy… Wed 12th Dec 2007
Bring Faith And Friends To The… Planning a Super Bowl party? Consider ordering copies of the… Wed 12th Dec 2007
Caption Competition Winner Thank you for the great response to the request to send in c… Tue 11th Dec 2007
New President At The Salvation… The Board of Trustees of The Salvation Army Toronto Grace He… Tue 11th Dec 2007
What’s Your Spiritual T… WORSHIP. What does it mean to you? Singing a few songs on a … Tue 11th Dec 2007
48 Angels Will be released on DVD December 11, 2007. When a boy needs … Mon 10th Dec 2007
First Impressions What Does Christmas Mean To Newcomers To Canada? Zhen Li imm… Mon 10th Dec 2007
Fraudulent Door To Door Canvas… Toronto - Individuals have been reported canvassing door to … Mon 10th Dec 2007
Salvation Army Positive Lifest… Manitoba - At least 30 Manitoba poker players charged after … Fri 7th Dec 2007
The General's Pastoral Letter … December 2007 - From the Office of the General to Salvationi… Thu 6th Dec 2007
Top Ten Most Visited Articles … Salvationist.ca had 44% new visitors in the month of Novembe… Wed 5th Dec 2007