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 for tags Education, Soldiership

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

Found 25 Articles:
Title Summary Date
The Future Looks Bright The moment of revelation came unexpectedly. It was summer 20… Fri 24th Oct 2008
Captain Dr. Paul Thistle Recei… Photo copyright 2008 Doug MacLellan On Wednesday, June 11… Fri 4th Jul 2008
2008 Soldier and Adherent Enro… Charlottetown, PEI (L-R) Nancy Wood - New Adherent, Jane … Fri 30th May 2008
2008 Soldier and Adherent Enro…   Brampton, Ontario (L-R) Boyd Cooper, Lynn Coope… Fri 2nd May 2008
Responding to God’s Cal… The decision I made to become a soldier of The Salvation Arm… Wed 30th Apr 2008
Privilege or Pledge? In an age of customer loyalty cards and rewards programs, ha… Thu 24th Apr 2008
We Need Heroes Rescuing the Army’s military metaphor from a quaint h… Mon 21st Apr 2008
Booth College admissions@boothcollege.ca or phone 1.877.942.6684 ext 850 V… Sat 1st Mar 2008
Recent Graduates Of Booth Coll… Congratulations to recent extended learning students who hav… Mon 22nd Oct 2007
Tyndale Seminary Has New Chair Toronto - Dr. Howard Snyder will be installed to The Donald … Mon 15th Oct 2007
Tips For Christians Who Want T… Canadian Members of Parliament receive thousands of messages… Thu 19th Jul 2007
SAROOTS The SAROOTS weekend is fast approaching and will be held on … Thu 14th Jun 2007
Sex trade fears: Families are … Prince Rupert, B.C. - Human trafficking and sexual exploitat… Fri 27th Apr 2007
How to Procrastinate Effective… Oh no! I forgot to do my homework!” Nathan cried. Now … Thu 22nd Mar 2007
Cadet Lieutenant training In September 2006, the Chief Secretary, on behalf of The Ter… Wed 21st Feb 2007
Salvation Army starts financia… London, Ont. - A charitable arm of a financial giant, Citigr… Thu 8th Feb 2007
Integrated Mission-the how to'… Rochelle McAlister currently serves in Zimbabwe with her hus… Mon 15th Jan 2007
Integrated Mission: a context … The following is a document prepared by Rochelle McAlister a… Mon 15th Jan 2007
Storm scams The recent series of storms hitting B.C. has prompted the Be… Thu 11th Jan 2007
Emergency preparation essentia… Government officials and organizations such as the Salvation… Tue 2nd Jan 2007
Inauguration ceremony marks ne… Langley BC - The triumphant music of Beethoven’s â… Tue 24th Oct 2006
Convocation on higher educatio… The Canada and Bermuda Territory hosted the Convocation on H… Fri 6th Oct 2006
Announcement from the Secretar… The Canada and Bermuda Territory announces its plan to launc… Mon 18th Sep 2006
Sally Ann and RCMP educate vul… Congratulations! You've won a trip to Cancun through one of … Fri 28th Jul 2006
Booth College, President's E-M… JUNE 2006 www.boothcollege.ca Canada and Bermuda Territory E… Thu 29th Jun 2006