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 1151 to 1175
< 1 2 3 4 5 6 … 44 45 46 47 48 49 >
Title Summary Date
Indonesia Earthquake - Update … The Salvation Army in Indonesia is preparing to send more me… Tue 30th May 2006
The Salvation Army responds to… Saturday May 27, 2006 ' The Salvation Army has launched an i… Mon 29th May 2006
Indonesia Earthquake ' Update … As the reported death toll following the earthquake which hi… Mon 29th May 2006
Episode 187: The Salvation Arm… The Salvation Army Connect… Fri 26th May 2006
The great pacific congress 200… Salvationists and friends from across the Pacific Northwest … Fri 26th May 2006
Vancouver Sun Run This year's Vancouver Sun Run took place on April 23, 2006. … Fri 26th May 2006
Curves in Burnaby donates to T… The owner of several Curves in Burnaby, B.C., Susan Ruetz, i… Thu 25th May 2006
In the midst of a crisis' Steve (not his real name) was the kind of guy that was doing… Thu 25th May 2006
Making a difference for the ho… In February, 2006, Envoy Gary Johnson, Langley South, B.C., … Wed 24th May 2006
The Salvation Army's Response … The following is a document containing The Salvation Army's … Wed 24th May 2006
Embracing multiculturalism in … In Canadian cities, some of which are among the most multicu… Tue 23rd May 2006
Aboriginal Awareness Week May 23-26 is Aboriginal Awareness Week. It is held on the fo… Mon 22nd May 2006
Couples retreat Ocean Crest Community Church, BC, sponsors their second marr… Fri 19th May 2006
Deer Lake graduates Nfld. - Matthew Feltham is presented with his graduate certi… Fri 19th May 2006
What is "Story in Convers… Story in Conversation is a live recording of dialogue betwee… Fri 19th May 2006
A new site On April 23rd, 2006 a ground-breaking ceremony is held for t… Thu 18th May 2006
Booth College celebrates its l… WINNIPEG ' April 30, 2006, Booth College marked its 24th gra… Thu 18th May 2006
Canadian Christian Women in Le… Women from throughout Canada converged on Calgary March 2-4 … Thu 18th May 2006
Episode 186: The Salvation Arm… The Salvation Army Connect… Thu 18th May 2006
Salvation Army called to the s… On Friday, May 6, 2006, at approximately 2:30 p.m., Const. J… Thu 18th May 2006
Celebrating Ninety-Five Years Congratulations to St. Anthony, Nfld. corps who recently cel… Wed 17th May 2006
Interim President of Booth Col… The Booth College Board of Trustees is pleased to announce t… Tue 16th May 2006
Peel Family Shelter Benefits F… 'Deals for Wheels' puts a van into service in Mississauga fo… Tue 16th May 2006
Fundraising results-2005/06 The National Red Shield Appeal reached $37.9 million, surpas… Mon 15th May 2006
Much Loved Christian Author Hi… Beverly Lewis's The Englisher Debuts at #25 on the USA Today… Mon 15th May 2006