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-01-01 and 2007-12-31

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

Found 76 Pages: showing 1 to 25
< 1 2 3 4 >
Title Summary Date
Deeks Insurance www.deeksinsurance.ca Thu 20th Dec 2007
dropdown test Go To: TopBritish Columbia     Red … Thu 20th Dec 2007
Ignite More about Ignite Thu 20th Dec 2007
National Social Services Confe… For more information contact Joanne Tilley Thu 20th Dec 2007
Symposium 2008 For detailed information visit the Symposium 2008 website. … Thu 20th Dec 2007
The Flame Thu 20th Dec 2007
Checkout Checkout Mon 17th Dec 2007
All Events All Events Mon 3rd Dec 2007
All News All News Thu 29th Nov 2007
RBC Banking and the Salvation … Royal Bank of Canada In July 2007, the Salvation Army in Ca… Wed 28th Nov 2007
Online Christmas Kettle Tue 27th Nov 2007
Scarborough Citadel Reunion Tue 27th Nov 2007
Magazine Outreach Ways Your Church Can Share Faith & Friends Faith & F… Mon 26th Nov 2007
(Untitled) Wed 21st Nov 2007
Chatham Corps Tue 30th Oct 2007
Christmas With The Salvation A… Tue 30th Oct 2007
Williams Lake Tue 30th Oct 2007
Music In Their Souls Mon 29th Oct 2007
Forgotten Password Forgotten Password Tue 23rd Oct 2007
Salvationist.ca - Communicatin… Welcome to the website that communicates mission and news to… Tue 23rd Oct 2007
Free Songster Christmas Resour… Hear and Singharmony(TM) really is "the world's easiest… Thu 18th Oct 2007
Playing On The Edge - Deryck D… To listen to the sample tracks below, click twice on the blu… Wed 3rd Oct 2007
International Day of Older Per… We can all acknowledge that this business of aging is nothin… Mon 1st Oct 2007
Quality Hearing Aids Thu 27th Sep 2007
Territorial Music & Gospel Art… Mon 24th Sep 2007

Found 533 Articles: showing 1 to 25
< 1 2 3 4 5 6 … 17 18 19 20 21 22 >
Title Summary Date
Assumptions Jesus said we’re to treat all people equally, but tha… Mon 31st Dec 2007
The Golden Compass December 17, 2007 - I watched The Golden Compass the other n… Thu 27th Dec 2007
Christmas Memories General Shaw Clifton reflects on Christmases past and the jo… Tue 25th Dec 2007
Peel Regional Police And The S… The Crime Prevention Academy of 2008, a breakthrough concept… Tue 25th Dec 2007
Bethlehem How the “House of Bread” became the birthplace o… Mon 24th Dec 2007
Canada Post Plays Santa Claus … For the seventh consecutive year, Canada Post will present T… Mon 24th Dec 2007
Families And Homelessness Canadian study examines the relationship between the homeles… Fri 21st Dec 2007
Local Jeweller's Charity Angel… Prince Rupert,B.C. - Cook's Jewellers is entering its sixth … Fri 21st Dec 2007
Salvation Army Broadcast Two Christmas broadcasts will be held on FM 98.5 ckwr Decemb… Thu 20th Dec 2007
Wrestlers Clash To Send Christ… Welland, Ont. - Knuckle sandwiches will help feed the less f… Thu 20th Dec 2007
'Tis The Season Toronto - Police officers from 51 Division have partnered wi… Wed 19th Dec 2007
Christmas, Upsize or Downsize? “Would you like to upsize your order?” If you ha… Tue 18th Dec 2007
Historic Streetcar Restoration… New Westminster, B.C. - The Salvation Army thrift store has … Tue 18th Dec 2007
Little Church On The Prairie A newcomer to Canada shares how one congregation’s en… Mon 17th Dec 2007
Shelter Given The Go-ahead Langley, B.C. - Last week Langley City council voted in favo… Mon 17th Dec 2007
Man pays it back by paying it … More than six decades after receiving help from the Salvatio… Fri 14th Dec 2007
Toy Donors Are Asked To Check … Many charities are asking people to check Health Canada's re… Fri 14th Dec 2007
Reasons why holiday volunteers… I. "Some people feel the more you buy, the better off they a… Thu 13th Dec 2007
Salvation Army Allowed To Jing… Vancouver - After five years of being silenced at several Va… Thu 13th Dec 2007
Advent Conspiracy Restores 'Sc… PORTLAND, Ore. - The Advent Conspiracy (www.AdventConspiracy… Wed 12th Dec 2007
Bring Faith And Friends To The… Planning a Super Bowl party? Consider ordering copies of the… Wed 12th Dec 2007
Caption Competition Winner Thank you for the great response to the request to send in c… Tue 11th Dec 2007
New President At The Salvation… The Board of Trustees of The Salvation Army Toronto Grace He… Tue 11th Dec 2007
What’s Your Spiritual T… WORSHIP. What does it mean to you? Singing a few songs on a … Tue 11th Dec 2007
48 Angels Will be released on DVD December 11, 2007. When a boy needs … Mon 10th Dec 2007