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 351 to 375
< 1 2 … 13 14 15 16 17 … 48 49 >
Title Summary Date
Brantford Salvation Army Dedic… The Salvation Army Wyndfield Community Church is one of the … Wed 7th Nov 2007
Arrested Poker Players Offered… Winnipeg - Poker players who were arrested during raids at t… Tue 6th Nov 2007
Old Sweater Sacred Cow Choosing Kingdom values over sentimentality. We all have an … Mon 5th Nov 2007
Salvationist.ca Top Ten Mosted… 1. Home page 2. CFOT 3. CSB 4. HELPS 5. Catalogue 6. THEME 7… Mon 5th Nov 2007
Christian Singer/Songwriter In… Steve Bell is an award-winning Canadian folk singer known fo… Thu 1st Nov 2007
Happily Ever After: Without th… With wisdom gleaned from their careers as single, globe-trot… Thu 1st Nov 2007
Toronto Marlies - Great Hockey… The Toronto Marlies Hockey Club and The Salvation Army have … Wed 31st Oct 2007
Faith leaders bring peace, lov… Toronto - Today, Habitat for Humanity is holding its fifth a… Tue 30th Oct 2007
God's Army Is Growing In Newfo… N.L. W Div -A Good News Report from Dover Corps - This past … Tue 30th Oct 2007
How I Met The Salvation Army I had it all. At the age of 31, I was an international bank… Tue 30th Oct 2007
Students Deliver Leftover Cafe… Kingston, ON - A group of Queen's University students is rai… Mon 29th Oct 2007
The Greening Of The Army A new report shows that The Salvation Army has a long way to… Mon 29th Oct 2007
25th Annual Motorcycle Toy Run Regina, SK - The 25th annual motorcycle toy run was held und… Fri 26th Oct 2007
A Call To Downward Mobility Books, tapes, CDs and DVDs on leadership cram modern booksto… Thu 25th Oct 2007
Chief Secretary Receives Honor… On October 20, 2007, in Langley BC, Colonel Glen Shepherd wa… Thu 25th Oct 2007
The Gift Of Christmas The Salvation Army in Mississauga, Ont. presents "The Gift o… Thu 25th Oct 2007
U.S. Social Services Conferenc… Canadian officers or employees who plan to attend the U.S. N… Thu 25th Oct 2007
Cadets Winter Assignments Christmas is coming, and so are Winter assignments. We thoug… Wed 24th Oct 2007
The Salvation Army Responds to… ALEXANDRIA, VA (October 23, 2007) - Having completed recover… Wed 24th Oct 2007
Upcoming Salvation Army Broadc… The next Salvation Army broadcast is sponsored by the Stratf… Wed 24th Oct 2007
"Running Sober" Run … October 20, Halifax -  Rick MacDonald’s Running So… Tue 23rd Oct 2007
Actress Who Played in "Ma… Deborah Kerr died last Tuesday in Suffolk England at the age… Tue 23rd Oct 2007
Built To Last? Over the last century, rapid change in technology has seen t… Tue 23rd Oct 2007
Canadian Officer Appointed to … EFFECTIVE 1 FEBRUARY 2008 LT. COLONELS ROBERT AND MARGUERITE… Mon 22nd Oct 2007
Recent Graduates Of Booth Coll… Congratulations to recent extended learning students who hav… Mon 22nd Oct 2007