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 Missions, Womens-Ministries

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

Found 5 Pages:
Title Summary Date
Olympic Ministry Resources DownloadsContact UsPromotional Resources LINKS What … Apr 29, 2009
Women's Ministries Logos Downl… Small Logo - 288 w x 288 h Great for Website or… Apr 21, 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
Woman to Woman - Careforce Lif… Will show participants how to free themselves from the past … Jan 29, 2009

Found 16 Articles:
Title Summary Date
Territorial Project Women's Ministries groups in The Salvation Army Canada and B… Feb 16, 2011
Promote Gifts of Hope Gifts of Hope is a great way to teach your teens about a bet… Dec 1, 2010
Women's Ministry Promotion Wee… Download the program outline and resources at www.MinistryHe… Oct 6, 2010
Women's Ministry Program Ideas If you are looking for new ideas to entertain, educate or ch… Sep 8, 2010
Fast For Change Canadian Foodgrains Bank and its members are encouraging Can… Aug 23, 2010
Support the Pakistan Relief Ef… Read the latest news from www.SalvationArmy.ca on the Army's… Aug 23, 2010
Olympic Mission Opportunities Here is a great opportunity for Salvation Army youth to get … Oct 20, 2009
Women's Ministry Sunday A special Sunday to draw attention to ministry by and for wo… Sep 24, 2009
Women's Ministries Logos If you are looking for logos for Women's Ministries to suit … Apr 27, 2009
Partners In Mission Weekly Cha… This resource idea will help your church families become inv… Apr 16, 2009
Practical Help for a World In … Did you know that The Salvation Army has offered a child spo… Mar 18, 2009
Praying for the World Have you ever been browsing in a gadget type store and thoug… Mar 6, 2009
Mexico Women Visit Canada Partners in Mission took on a whole new meaning when the Can… Mar 3, 2009
Unfolding Grace Unfolding Grace - Promotion Week Material 2009 Women's … Feb 9, 2009
Get Engaged in Stamping Out Wo… www.freerice.com The UN World Food Program (WFP) has create… Jan 14, 2009
While Women Weep - Pin The territorial women’s ministries department is pleas… Apr 10, 2008