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 between 2006-12-01 and 2006-12-31

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

Found 4 Pages:
Title Summary Date
Agincourt Community Church Fri 8th Dec 2006
Booth College 25th Anniversary… Fri 8th Dec 2006
Camp Rainbow Fri 8th Dec 2006
Winterberry Heights Church Fri 8th Dec 2006

Found 49 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Manitoba most generous provinc… When it comes to charitable donations, Manitoba ranks first … Fri 29th Dec 2006
The Cattle Were What? While listening to "Away in a Manger" at a Christmas program… Fri 29th Dec 2006
New homelessness partnering st… OTTAWA - Canada’s government has committed $526 milli… Thu 28th Dec 2006
Christmas memories When I was young, we were very poor. I was the baby in a fam… Wed 27th Dec 2006
Episode 217: The Salvation Arm… Feature: Commissioner Christine M… Tue 26th Dec 2006
Ontario North Divisional Semin… Leadership 360°, ‘Developing the Leader Within  Tue 26th Dec 2006
Salvation Army helps single mo… A few days ago, I was on the bus, when a lady sat beside me.… Tue 26th Dec 2006
Words and Songs to Greet the S… General Shaw Clifton challenges Salvationists to lift up the… Mon 25th Dec 2006
Vancouver 614 corps brings an … 1. Kettle coordinator Darren Hailes (614 Vancouver) drops th… Sun 24th Dec 2006
Dream comes true Calgary - Tiny faces lit up Calgary last week as Santa's hel… Fri 22nd Dec 2006
Episode 216: The Salvation Arm… Feature: Retired Vancouver busine… Fri 22nd Dec 2006
Good Samaritan saves kettle fr… Port Alberni, BC - A Christmas Grinch attempted to steal a S… Fri 22nd Dec 2006
Sally Ann really is centre of … Christine Elias wears an enormous pair of musical, red and g… Fri 22nd Dec 2006
Salvation Army helper shot in … New Waterford, NS - It was a sad payback for a teenager dona… Fri 22nd Dec 2006
God behind new online initiati… The Anglican Church in Australia has fully embraced the far-… Thu 21st Dec 2006
Salvation Army gets huge shoe … Saskatoon - Less fortunate families will get an extra specia… Thu 21st Dec 2006
Christmas spirit Hamilton, Ont. - The following letter was received at the Ha… Wed 20th Dec 2006
Salvation Army seniors' band b… British Columbia - Every Wednesday evening, the sounds of Th… Wed 20th Dec 2006
An unusual enrolment Jeni Parsons and Regan Lipsett are enrolled under the colour… Tue 19th Dec 2006
Canada's Christian Channel wel… TORONTO, Dec 18, 2006 - The Christian Channel is adding musi… Tue 19th Dec 2006
Authors eager to help Sally An… Two Nanaimo, B.C., authors hope to raise $100,000 for The Sa… Mon 18th Dec 2006
Canadian Staff Band Website Re… The Canadian Staff Band is happy to be back online with our … Mon 18th Dec 2006
Con artist posing as Sally Ann Calgary - Posing as a Salation Army volunteer, a scam artist… Mon 18th Dec 2006
God With Us-To the End of the … In the Gospel of Matthew, Jesus urges his followers to embra… Mon 18th Dec 2006
Homeless shelter in the works Salmon Arm, B.C.- The Salvation Army is planning a 10-bed em… Fri 15th Dec 2006