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 1176 to 1200
< 1 2 3 4 5 6 … 44 45 46 47 48 49 >
Title Summary Date
What Google Can't Teach You Four things to look for in a spiritual mentor Do you Google?… Mon 15th May 2006
Salvation Army night with the … On Monday May 8, 2006, the Toronto Blue Jays once again put … Fri 12th May 2006
Episode 185: The Salvation Arm… The Salvation Army Connect… Thu 11th May 2006
United 93: How Faith Triumphed… Paul Greengrass' new film is not easy to watch. But we all c… Thu 11th May 2006
20 ways to touch lives with th… 1. Place Faith & Friends or Edge for Kids in mailboxes in yo… Wed 10th May 2006
Free summer issues of Faith & … Orders for the special summer evangelism issue of Faith & Fr… Wed 10th May 2006
Introducing Women Alive magazi… Women Alive magazine informs, entertains and inspires women … Wed 10th May 2006
Investing in our youth Thunder Bay Community Church hosts a recent Sunday School le… Wed 10th May 2006
Passing the torch! Gloverton Corps, Nfld. - Mjr Marvin Youden, CO, commissions … Wed 10th May 2006
Kidney transplant is give and … WHAT to give your brother for his birthday? Some people take… Tue 9th May 2006
Play the Music, Play! Brampton Citadel dedicates a Bb base to the band. Pictured f… Tue 9th May 2006
What's Your Spiritual Gift? As a member of Christ's body, being spiritually gifted isn't… Mon 8th May 2006
A new library opens in Winnipe… With the snip of six pairs of scissors The Salvation Army Wi… Fri 5th May 2006
Growing God's Army On Easter Sunday, 2006, seven new adherents are welcomed to … Thu 4th May 2006
New College for Officer Traini… To the snappy sounds of a small brass band the new Salvation… Thu 4th May 2006
Ninety-year-old still blows hi… At 90, Fred Johnston, retired Salvation Army bandmaster of t… Wed 3rd May 2006
Thrift store reopens in Sherbr… On April 18, 2006, the Thrift store in Sherbrooke, Quebec, r… Wed 3rd May 2006
Who's religious? Adult Canadians attach a higher degree of importance to reli… Wed 3rd May 2006
Episode 184: The Salvation Arm… The Salvation Army Connect… Tue 2nd May 2006
Thrift Store Supervisor Honour… Collingwood Thrift Store Supervisor, Helen Ford, retires aft… Mon 1st May 2006
Volunteer Recognition Lynda Rathburn, from Vancouver's Kate Booth House, is recogn… Mon 1st May 2006
Preserving the Past Heritage plaque marks historic site for future generations I… Fri 28th Apr 2006
Episode 183: The Salvation Arm… The Salvation Army Connect… Thu 27th Apr 2006
Growing 'Douglas Fir' Disciple… The terrain is rough, rivers overflow and coyotes lurk in th… Thu 27th Apr 2006
Century-long mission to help l… Stella Cross has never had much, in terms of worldly wealth,… Wed 26th Apr 2006