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 for tags Donation, Hunger

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

Found 41 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
City Shares Money From Parking… Penticton, B.C. - The City of Penticton donated $2,299 to Th… Wed 23rd Jan 2008
Salvation Army Shelter Receive… Yellowknife - The Salvation Army shelter received 20 brand n… Mon 14th Jan 2008
Canada Post Plays Santa Claus … For the seventh consecutive year, Canada Post will present T… Mon 24th Dec 2007
History Of The Salvation Army … The Salvation Army's kettles have been used for more than a … Thu 15th Nov 2007
Students Deliver Leftover Cafe… Kingston, ON - A group of Queen's University students is rai… Mon 29th Oct 2007
Sally Ann mobile food service … Prince George, B.C. - Last weekend The Salvation Army's mobi… Mon 22nd Oct 2007
The Salvation Army Launches Mo… Prince George, B.C. - This past weekend The Salvation Army i… Thu 18th Oct 2007
Church Members Donate Food To … Penticton, B.C. - Members of The Salvation Army church cong… Thu 11th Oct 2007
The Salvation Army Celebrates … On Tuesday, September 25, The Salvation Army joined with the… Wed 3rd Oct 2007
Canada Post Workers Stamp Out … B.C. - This Saturday, Sept. 22, in Dawson Creek and Fort St.… Fri 21st Sep 2007
Canadian Idol Fans Support The… Drumheller, AB - On Tuesday September 11, more than 1,200 Dr… Tue 18th Sep 2007
School Breakfast Program Gets … Victoria, B.C. - This week Telus donated $20,000 to The Salv… Thu 13th Sep 2007
Wal-Mart, USA, Donates $150,00… Wal-Mart Stores, Inc., has donated $150,000 to assist in The… Thu 30th Aug 2007
Kirkland Lake Businessman Dona… Kirkland Lake, Ont. - Mark Simpson, owner and operator of Sq… Thu 2nd Aug 2007
The Salvation Army Partners Wi… "Having enough food to feed your family is a huge concern fo… Wed 1st Aug 2007
Food For Fares Program Prince George, B.C. - The Food For Fares program will take p… Wed 25th Jul 2007
Dedication of new kitchen At last food can be prepared without the interference of bir… Tue 22nd May 2007
Innovative food bank fundraise… New Liskeard, ON - On June 29 The Salvation Army Family Serv… Fri 27th Apr 2007
Salvation Army assists Red Ear… Saskatoon-Leaving their homes for the second time in as many… Tue 24th Apr 2007
Sleep Country Canada stores su… Local Sleep Country Canada stores are part of a nation-wide … Tue 3rd Apr 2007
Hunters are thanked for their … Kenora, B.C. - The following letter to the Editor was receiv… Fri 30th Mar 2007
Salvation Army food banks get … B.C. - Salvation Army food banks will get a boost this month… Thu 15th Mar 2007
Don’t expect to see ATM… Offerings of plastic could be the next big thing for churchg… Mon 26th Feb 2007
Back to Basics Surviving on a budget of $2 a day helped my family appreciat… Mon 5th Feb 2007
Toronto councillor has cost-fr… "Don't give them money," says Case Ootes. This would drive d… Tue 30th Jan 2007