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 2007-09-01 and 2007-09-30

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

Found 2 Pages:
Title Summary Date
Quality Hearing Aids Thu 27th Sep 2007
Territorial Music & Gospel Art… Mon 24th Sep 2007

Found 34 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
New Chapter In A Long Establis… Hamilton, Ont. - The Salvation Army Meadowlands Church (form… Fri 28th Sep 2007
Pakistan Territorial Commander… The following is a news release from International Headquart… Fri 28th Sep 2007
Dealing with Personal Burnout Whose heart has not been thrilled by Elijah’s exploit… Thu 27th Sep 2007
Moms and Kids Camp at Scotian … Nova Scotia - Mothers (most of them single parents) who face… Thu 27th Sep 2007
Pray For Myanmar Last year the Partners in Mission resource material highligh… Thu 27th Sep 2007
“Holiness - Revisitedâ… Culture is unavoidable. It is in the air we breathe. Whether… Wed 26th Sep 2007
Bikers Give Salvation Army A B… Langley, B.C. - The second annual Mercy Ride helped raise $2… Wed 26th Sep 2007
A Theology Of Immigration Major Ray Harris gleans guidance from Ruth When I stepped in… Tue 25th Sep 2007
Coats For Kids Campaign Is A C… Cobourg - The whole community is getting involved in their 1… Tue 25th Sep 2007
Salvation Army In Canada Launc… The Salvation Army in Canada has launched its first annual f… Tue 25th Sep 2007
Was It A Sign? Do you believe in signs and premonitions? I do. It was a … Tue 25th Sep 2007
First Daughter Jenna Bush Sits… In her first television interview, Jenna Bush speaks candidl… Mon 24th Sep 2007
What Did Jesus Say About Money… When I was a child, I attended a Good News Club at my school… Mon 24th Sep 2007
Canada Post Workers Stamp Out … B.C. - This Saturday, Sept. 22, in Dawson Creek and Fort St.… Fri 21st Sep 2007
Summer ESL Program Most Succes… Ontario Central-East Division- Volunteers with The Salvation… Fri 21st Sep 2007
International Day of Older Peo… We can all acknowledge that this business of aging is nothin… Thu 20th Sep 2007
The Face Of The Salvation Army… From September 6-9, 2007, open air meetings were held across… Thu 20th Sep 2007
Married Female Officer Is Inst… Major Susan van Duinen, the first female married officer to … Wed 19th Sep 2007
Canadian Idol Fans Support The… Drumheller, AB - On Tuesday September 11, more than 1,200 Dr… Tue 18th Sep 2007
When it’s time to say … Breaking the law with Vadim Khurin When was the last time yo… Tue 18th Sep 2007
Grand Opening Brantford, Ont. - The Salvation Army Wyndfield Community Chu… Mon 17th Sep 2007
Taking the Fear Out of Biblica… How do I know that the Bible is accurate? What difference do… Mon 17th Sep 2007
Sleep In The Park To Help Home… Dunnville, Ont. - "We want to make the public aware that hom… Fri 14th Sep 2007
Workers' Rites What happens when an employee's freedom of religion crosses … Fri 14th Sep 2007
School Breakfast Program Gets … Victoria, B.C. - This week Telus donated $20,000 to The Salv… Thu 13th Sep 2007