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/web77/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/web77/web/index.php line 4
Search Results
Skip to Content
 

Search


 
Find the Army near you

Territorial Photos


Ministry Resources Poll

If you were starting a new children's ministry program, which timeframe would you use?
Choices

Syndication

14 14 1199  RSS | What is this?

Search Results for tags Community-Care-Ministries, Mens-Ministries

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

Found 18 Pages:
Title Summary Date
Chemically Speaking - Careforc… Chemically Speaking is a single session video suitable for p… Jan 29, 2009
Door of Hope - Careforce Lifek… An encouraging and supportive program for women survivors of… Jan 29, 2009
Healthy Lifestyle - Careforce … Healthy Lifestyle is for women of any age who are seeking to… Jan 29, 2009
Kids With Courage - Careforce … Kids with Courage is a seven session program that aims to st… Jan 29, 2009
Making Marriage Better - Caref… This program is an opportunity to enhance or rebuild your ma… Jan 29, 2009
Man to Man - Careforce Lifekey… Men are designed for action, excitement and success, yet oft… Jan 29, 2009
New Beginnings - Careforce Lif… New Beginnings is a program assisting individuals struggling… Jan 29, 2009
Search for Intimacy - Careforc… Sex is part of life.  Managed rightly it is a profound … Jan 29, 2009
Search for Life - Careforce Li… People need to feel valued, accepted and have a sense of bel… Jan 29, 2009
Valiant Man - Careforce Lifeke… Developing and maintaining a healthy sexuality is every man'… Jan 29, 2009
Woman to Woman - Careforce Lif… Will show participants how to free themselves from the past … Jan 29, 2009
Youth Search For Life - Carefo… 'What do I have to do to be loved, accepted and valued aroun… Jan 29, 2009
Careforce Lifekeys Facilitator… NOTE: Police Checks - The Salvation Army policy that all lea… Feb 16, 2007
Careforce Lifekeys Happenings Trainings Tra… Feb 16, 2007
Careforce Lifekeys Materials PROGRAMS Use these links for more information about each … Feb 16, 2007
Careforce Lifekeys Testimonial… I have just finished the facilitators training for the Caref… Feb 16, 2007
Healing & Wholeness - Careforc… What is it? Through a system of small groups, participants … Feb 16, 2007
Community Care Ministries Community Care Ministries exists to provide spiritual and so… Apr 28, 2006

Found 15 Articles:
Title Summary Date
Community Care Ministries 2010 Here is a great encouragement for members of Community Care … Jan 12, 2011
Community Care Bring Christmas… The members of the Community Care in Penticton, BC spread lo… Dec 15, 2010
Careforce Lifekeys - Healing a… What is it? Through a system of small groups, participants … Jul 14, 2010
Community Care News - May 2010 Notes and news for the summer, from the Territorial Adult Mi… Jun 2, 2010
Community Care Sunday - June This year's theme, Love Will Build A Bridge provides a great… May 25, 2010
New Mentoring Resource Mentorship: A Guide for Developing Healthy Mentoring Relatio… Apr 22, 2009
Give Me A Passion Give Me A Passion!  (2009 CCM Sunday Resource Kit.) … Apr 14, 2009
Community Care Paws to Help Pet visitation therapy is a great way to reach out to senior… Feb 5, 2009
Careforce Lifekeys Resources This program was developed for small groups with trained lea… Jan 30, 2009
CCM Worker Appreciation In St. George's, Bermuda, the Community Care Sunday was enha… Jan 26, 2009
A Year of Reaching Out NEWFOUNDLAND & LABRADOR EAST DIVISION - providing meal… Jan 7, 2009
Red Deer Reach Out to Seniors As new relationships are built with others in the community,… Jan 6, 2009
Community Care Training in Bar… Community Care training in Barrie included both instruction … Dec 18, 2008
Halifax Citadel Pack Sunshine Halifax Citadel Community Care workers packed 1,133 Sunshine… Dec 10, 2008
Wiarton Community Care Reach O… Wiarton Community Care Ministries reach out to the community… Dec 9, 2008