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 326 to 350
< 1 2 … 12 13 14 15 16 … 48 49 >
Title Summary Date
Caption Competition We are looking for your best captions for this Christmas ket… Tue 4th Dec 2007
Embrace The Season Of Peace, J… The sights and signs of Christmas approaching are all around… Tue 4th Dec 2007
Announcement From The Office O… Lt-Colonels Donald and Ann Copple, currently serving as divi… Mon 3rd Dec 2007
The Great Exchange Unwrapping the mystery and meaning of Christ’s coming… Mon 3rd Dec 2007
There’s A Butterfly On … Summer has ended, days are shorter, but the sun still shines… Fri 30th Nov 2007
On the Rocks? Or Will That Be … Why it’s important to teach your kids about the dange… Thu 29th Nov 2007
How Can I Deal With Tragedy An… How can I keep my family strong in the midst of it? The olde… Tue 27th Nov 2007
YMCA Recognizes Peacemakers Kitchener,ON - On November 23, peace medallions for 2007 wer… Tue 27th Nov 2007
Bonsai Tree Sacred Cow Small churches have the potential for explosive growth if nu… Mon 26th Nov 2007
Hockey Fans Handed Salvation A… Edmonton - Oiler fans were handed 17,000 Salvation Army bell… Mon 26th Nov 2007
Ten Ways To Have A Great Chris… 1. Before heading to the shops, decide how much to spend on … Fri 23rd Nov 2007
The Prairie and Northern Terri… Click here to view a copy of the latest Divisional Commander… Fri 23rd Nov 2007
Ancestors In The Attic The program 'ANCESTORS IN THE ATTIC'  focuses on the life… Thu 22nd Nov 2007
The Salvation Army Commences W… The Salvation Army’s International Headquarters in Lo… Thu 22nd Nov 2007
Christmas With The Salvation A… The Christmas season is upon us and we want to remind you of… Wed 21st Nov 2007
‘Naughty or Nice’… This Christmas season, whether a store greets you with   Tue 20th Nov 2007
Toronto Marlies and The Salvat… Join us Saturday December 8 for Salvation Army Day at Ricoh … Tue 20th Nov 2007
Children's Movie Described As … The children's movie "The Golden Compass" (Nicole Kidman) is… Mon 19th Nov 2007
Priestly Pastors Are officers control freaks or are congregations abdicating … Mon 19th Nov 2007
History Of The Salvation Army … The Salvation Army's kettles have been used for more than a … Thu 15th Nov 2007
Display Your Christian Faith P… Wearing a Christian T-Shirt or Christian jewelry is a great … Wed 14th Nov 2007
The Salvation Army Builds 205 … Following the completion of 100 homes in Galagodawatte durin… Wed 14th Nov 2007
Magic Mirror Sacred Cow Mirror, mirror, on the wall … who’s the fairest… Mon 12th Nov 2007
Toys From the Worlds Largest C… Toronto - On Thursday, November 8, the Guinness World Record… Mon 12th Nov 2007
Salvation Army Christmas Cards Etobicoke, Ont. - The Salvation Army Lakeshore Community Chu… Thu 8th Nov 2007