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

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

Found 1208 Articles: showing 801 to 825
< 1 2 … 31 32 33 34 35 … 48 49 >
Title Summary Date
When Worship Styles Clash As any pastor knows, musical style is perhaps the biggest fo… Thu 18th Jan 2007
Episode 220: The Salvation Arm… Human trafficking is a scourge of… Wed 17th Jan 2007
MissionFest Toronto 2007 March 1 to 3 - “Celebrating the world-wide impact of C… Tue 16th Jan 2007
Sweetest sound for the sweetes… Spanning our spectacular country from Vancouver Island to Bo… Tue 16th Jan 2007
The Salvation Army sells prope… Montreal, QB - January 15, 2007 - The Salvation Army in Mont… Tue 16th Jan 2007
Integrated Mission-the how to'… Rochelle McAlister currently serves in Zimbabwe with her hus… Mon 15th Jan 2007
Integrated Mission: a context … The following is a document prepared by Rochelle McAlister a… Mon 15th Jan 2007
Overflowing With Love When we allow God’s compassion to spill over into our… Mon 15th Jan 2007
Booth college graduates may be… At Booth College we are entering the second semester of our … Fri 12th Jan 2007
Channel/Port aux Basques corps… Channel/Port aux Basques, Nfld. & Lab. div. - Senior soldier… Fri 12th Jan 2007
Inner-City Dreams If we want to see change in the inner city, we need to move … Fri 12th Jan 2007
Through His eyes My fading eyesight left me bitter and my marriage in jeopard… Fri 12th Jan 2007
Canadian Staff Band-Tour of So… Following months of planning and preparation, the CSB depart… Thu 11th Jan 2007
Storm scams The recent series of storms hitting B.C. has prompted the Be… Thu 11th Jan 2007
White Bread, Doughnuts or Whol… Author and activist Brian D. McLaren craves a Christian fait… Wed 10th Jan 2007
Integrated Mission Unpacked If the Church in the West is to survive, we must stop believ… Tue 9th Jan 2007
Prayer on Parliament Hill Canada is in need of prayer as we enter the New Year. There … Tue 9th Jan 2007
Episode 219: The Salvation Arm… Feature: Commissioner Robert Wats… Mon 8th Jan 2007
The Five Dysfunctions of a Tea… The model outlined in the book, The Five Dysfunctions of a T… Mon 8th Jan 2007
Celebration OneTwoFive kicks o… Yesterday, Territorial Headquarters kicked off Celebration 1… Fri 5th Jan 2007
Church growth through communit… The Evangelcial Fellowship of Canada is sponsoring a confere… Fri 5th Jan 2007
Officers saved by a doorbell Pembroke,Ont. - Early this past Sunday morning, Cpts Robert … Fri 5th Jan 2007
A Christmas party at the Hard … On December 23rd, 180 children and their parents celebrated … Thu 4th Jan 2007
Freedom from addiction Michael Jack was hooked on cheap booze and was on the fast t… Thu 4th Jan 2007
War College Board of Reference… Vancouver, B.C - The War College is pleased to announce the … Wed 3rd Jan 2007