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 Announcement, Public-Relations, Quebec

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

Found 50 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Help in the Heart of Quebec Ci… Luc arrived at the Hôtellerie without a penny in his p… Mon 29th Sep 2008
Celebrating Service in Quebec The Salvation Army in Quebec recently held a retirement cele… Wed 3rd Sep 2008
Wake the Sleeping Giant Youth and children’s ministry in Quebec is like a slee… Mon 18th Aug 2008
Montreal’s Evangelistic… With its magic festival, block party and continental breakfa… Thu 7th Aug 2008
SARoots.ca In recent years hundreds of Salvationists from across the te… Tue 8th Jan 2008
Announcement From The Office O… Lt-Colonels Donald and Ann Copple, currently serving as divi… Mon 3rd Dec 2007
Toys From the Worlds Largest C… Toronto - On Thursday, November 8, the Guinness World Record… Mon 12th Nov 2007
Salvation Army Christmas Cards Etobicoke, Ont. - The Salvation Army Lakeshore Community Chu… Thu 8th Nov 2007
Supporting Our Troops Quebec - The women of 3 Wing Bagotville’s Emmanuel Ch… Fri 19th Oct 2007
Tyndale Seminary Has New Chair Toronto - Dr. Howard Snyder will be installed to The Donald … Mon 15th Oct 2007
Leading Mission Divisional Str… From the office of the chief secretary: I am writing on beha… Fri 12th Oct 2007
Personnel Services Announcemen… IHQ has given approval for  personnel services to institu… Fri 7th Sep 2007
New Cabinet Appointments Commissioner William W. Francis, territorial commander, has … Fri 24th Aug 2007
Press Conference in Quebec Montreal - The Salvation Army is seeking to adapt to best fi… Fri 8th Jun 2007
CSB Visits Montreal The morning of Saturday, May 5, dawned bright and early as t… Mon 7th May 2007
A Blast of Brass The Montreal Citadel Corps is alive and well. One evidence o… Tue 1st May 2007
Winds of Hope Blow Through Mon… Montreal is a city-paradox. It is one of the most postmodern… Tue 10th Apr 2007
Territorial appointment announ… In light of the visit of General Shaw Clifton and Commission… Thu 5th Apr 2007
Sleep Country Canada stores su… Local Sleep Country Canada stores are part of a nation-wide … Tue 3rd Apr 2007
Announcement from the Office o… March 26, 2007 -  Dear Friends: On behalf of the Territor… Mon 26th Mar 2007
Announcement from the Chief Se… March 23, 2007 - Dear Friends: On behalf of the territorial… Fri 23rd Mar 2007
New president at Booth College The Board of Trustees of The Salvation Army William and Cath… Mon 19th Mar 2007
Public Relations: A huge chall… Photo: Mrs. Titcombe-Volet and former hockey player Yvan Cou… Thu 15th Mar 2007
A new officer in Québec On February 8th, cadet Désiré Mounanga was ordained as… Fri 16th Feb 2007
CIDA Update International development work is based on partnerships that… Fri 16th Feb 2007