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 tag Public-Relations

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

Found 15 Articles:
Title Summary Date
Toys From the Worlds Largest C… Toronto - On Thursday, November 8, the Guinness World Record… Mon 12th Nov 2007
Sleep Country Canada stores su… Local Sleep Country Canada stores are part of a nation-wide … Tue 3rd Apr 2007
Public Relations: A huge chall… Photo: Mrs. Titcombe-Volet and former hockey player Yvan Cou… Thu 15th Mar 2007
CIDA Update International development work is based on partnerships that… Fri 16th Feb 2007
"While Women Weep" c… As we approach the end of the fiscal year the World Services… Thu 8th Feb 2007
French national website launch… I am pleased to announce that we have launched the French Na… Thu 1st Feb 2007
Ottawa celebrates Christmas wi… The Ottawa Salvation Army presented the 21st Annual Festival… Thu 14th Dec 2006
West 49 store collects coats f… Canada's leading skateboard retailer collected over 7,700 wi… Thu 30th Nov 2006
Giving Hope at the Toronto San… A 128-member Salvation Army contingent participated in the 1… Mon 20th Nov 2006
Episode 209: The Salvation Arm… Feature: Ron Zima joined The Salv… Mon 30th Oct 2006
Special mission to the Caribbe… Majors Woody and Sharon Hale (Ret.) recently returned from a… Wed 26th Jul 2006
Winnipeg teens bring sweat and… A group of Salvationists from Winnipeg recently discovered t… Mon 24th Jul 2006
The Salvation Army, Regina, br… On June 8, 2006, The Salvation Army in Regina launched 'It's… Mon 19th Jun 2006
A Gift That Will Keep On Givin… Long after retirement from a remarkable career as a public s… Mon 5th Jun 2006
Fundraising results-2005/06 The National Red Shield Appeal reached $37.9 million, surpas… Mon 15th May 2006