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 676 to 700
< 1 2 … 26 27 28 29 30 … 48 49 >
Title Summary Date
Just 4 Laughs No Excuse Sunday! To make it possible for everyone to attend… Mon 2nd Apr 2007
Resurrection Glory The bodily resurrection of Jesus Christ from the dead is the… Mon 2nd Apr 2007
Episode 231: The Salvation Arm… To mark Refugee Rights Day on Apr… Fri 30th Mar 2007
Hunters are thanked for their … Kenora, B.C. - The following letter to the Editor was receiv… Fri 30th Mar 2007
NL Provincial Congress Will be held in Corner Brook at the Pepsi Centre June 22-24,… Fri 30th Mar 2007
Rethinking Thin Christian women are not immune from body image issues. Scien… Thu 29th Mar 2007
Dealing with 'whole life' a wo… It's been a rough two months, but Robert Simmons is determin… Tue 27th Mar 2007
Thine is the Glory! Toronto - On Good Friday, the North York Temple Corps will b… Tue 27th Mar 2007
Announcement from the Office o… March 26, 2007 -  Dear Friends: On behalf of the Territor… Mon 26th Mar 2007
“Under the Big Top  Ladies and gentleman, boys and girls, children of all ages, … Mon 26th Mar 2007
Episode 230: The Salvation Arm… Generations is a Salvation Army p… Mon 26th Mar 2007
Installation and Welcome Meeti… The above meeting will be held at the ONC Divisional Camp au… Mon 26th Mar 2007
Prayers to Celebrate Diversity In 1980, Kool and the Gang released a song called “Cel… Mon 26th Mar 2007
Sight For My Blindness May God help us see what others don’t.During this pas… Mon 26th Mar 2007
Announcement from the Chief Se… March 23, 2007 - Dear Friends: On behalf of the territorial… Fri 23rd Mar 2007
Canada's top 25 worship songs Different styles of music help us interpret and express diff… Fri 23rd Mar 2007
Come On and Celebrate! Join in a birthday bash marking 125 years of Salvation Army … Thu 22nd Mar 2007
How to Procrastinate Effective… Oh no! I forgot to do my homework!” Nathan cried. Now … Thu 22nd Mar 2007
The Toronto Passion Play Queensway Cathedral presents The Toronto Passion Play, a dra… Thu 22nd Mar 2007
The Gateway looks to expansion The Salvaton Army Gateway has been around since 1980 providi… Wed 21st Mar 2007
HELPS On-Line (Helping Every L… H.E.L.P.S. On-Line is a new resource from the corps ministri… Tue 20th Mar 2007
Happy 70th anniversary Dartmouth, N.S. Community Church - Retired CSM, Frank Banfie… Mon 19th Mar 2007
New president at Booth College The Board of Trustees of The Salvation Army William and Cath… Mon 19th Mar 2007
Episode 229: The Salvation Arm… Brian Burditt is Director of Worl… Fri 16th Mar 2007
Jabulani ministers at Celebrat… “Jabulani” means “Rejoice” in the Af… Fri 16th Mar 2007