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 976 to 1000
< 1 2 … 38 39 40 41 42 … 48 49 >
Title Summary Date
Maritimes response unit thanks… The Salvation Army Maritimes Community Resonse Unit will kee… Wed 4th Oct 2006
Motorcycle rider's donate to a… Langley, B.C. - This past weekend 62 bikes and riders left t… Wed 4th Oct 2006
Caption competition: winners Thank you for the great response to the request to send in c… Tue 3rd Oct 2006
Christian camping for seniors Thorburn, N.S. - From September 15 to 17 The Salvation Army … Tue 3rd Oct 2006
Salvation Army volunteer award… Anne Cepukas, a volunteer at The Salvation Army Thrift store… Tue 3rd Oct 2006
Faithful Through the Fire Persecution in the Middle East and How to Respond “For… Mon 2nd Oct 2006
Salvation Army parade float wi… St. Marys, Ont. - The theme of the St. Marys fall fair parad… Mon 2nd Oct 2006
Giving Hope Today What is The Salvation Army? Many people associate us with th… Fri 29th Sep 2006
Administrative Restructuring U… I am writing further to my letter of May 29 regarding the re… Thu 28th Sep 2006
Caption Competition Have a go at our second caption competition. Comment on this… Thu 28th Sep 2006
Episode 205: The Salvation Arm… The Salvation Army Connection: Ep… Thu 28th Sep 2006
Kite festival is a hit Ocean Crest Community Church in Campbell River, B.C. recentl… Thu 28th Sep 2006
Story in Conversation #6 Story in Conversation is a live recording of dialogue betwee… Thu 28th Sep 2006
Tell your story The Salvation Army's first International Weekend of Prayer a… Thu 28th Sep 2006
International doctrine council The General of The Salvation Army is pleased to announce tha… Wed 27th Sep 2006
Sleeping for hope Dunnville, Ont. - This Friday, September 29, The Salvation A… Wed 27th Sep 2006
Authentic Living Youth pastors are challenging young people to see how Christ… Tue 26th Sep 2006
Chilliwack Salvation Army make… Tim Bohr is the family pastor at the Salvation Army Church o… Tue 26th Sep 2006
Cyclists complete national bik… TORONTO, ON - It was a climactic finish to a summer-long, cr… Tue 26th Sep 2006
Episode 204: The Salvation Arm… The Salvation Army Connection: Ep… Fri 22nd Sep 2006
Pray for Peace… General … At the height of the Israel-Hezbollah conflict in August, Ge… Fri 22nd Sep 2006
Prayer for victims of human tr… Register here for the Salvation Army's first annual weekend … Fri 22nd Sep 2006
A seminar on developing emotio… "The Emotionally Healthy Church" seminar is a one-day semina… Thu 21st Sep 2006
A Yorkminster Christmas The Salvation Army Yorkminster Citadel Band and Songsters in… Thu 21st Sep 2006
Battling cancer, Salvation Arm… The divisional leader of the Salvation Army in western and c… Thu 21st Sep 2006