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

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

Found 92 Pages: showing 1 to 25
< 1 2 3 4 >
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
Album Click a pictures to see a larger version. CSB Concer… Tue 28th Nov 2006
Homosexualité Position de principe sur la sexualité des gais … Mon 13th Nov 2006
- Current News Current News On Monday, 15 January 2007, a random sampling… Fri 10th Nov 2006
- Literature Literature Barrett, R. (1998). Liberating the corporate so… Fri 10th Nov 2006
- Pilot project Pilot project The initial survey was delivered to two pilot… Fri 10th Nov 2006
- Project Rationale Project rationale In its origin, The Salvation Army was kno… Fri 10th Nov 2006
- Timeline Timeline   Task Timeframe Meeting wit… Fri 10th Nov 2006
Position Statement on Poverty … The measure of any society is how well it cares for its weak… Fri 10th Nov 2006
Values at Work Fri 10th Nov 2006
Other News from the Finance De… New MSA Policy In July 2008 the Territorial Finance Council… Mon 6th Nov 2006
Cabinet The Salvation Army's leadership team in Canada and Bermuda p… Wed 1st Nov 2006
Consolidated Financial Stateme… Consolidated Financial Statements - MU Prep Guide - Part I, … Thu 5th Oct 2006
Role And Values Statements Role And Values Statements:  In the delivery of service… Wed 4th Oct 2006
Question 1 What is your biggest challenge as a conductor? Thu 28th Sep 2006
Finance Department Key Contact… Introduction:  The Territorial Finance Department is a … Wed 20th Sep 2006
Territorial Finance Department Welcome!... to the Territorial Headquarters (THQ) Finance De… Wed 20th Sep 2006
(DFL) Design for Life Candidates Pages: Welcome | CFOT Information | (DFL) Design … Wed 13th Sep 2006
Articles Candidates Pages: Welcome | CFOT Information | (DFL) Design … Wed 13th Sep 2006
Candidates "… The harvest is plentiful but the… Wed 13th Sep 2006
Christmas with The Salvation A… Wed 13th Sep 2006
Melbourne Staff Band Concert Wed 13th Sep 2006

Found 380 Articles: showing 1 to 25
< 1 2 3 4 5 6 … 11 12 13 14 15 16 >
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