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/web75/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/web75/web/index.php line 4
Search Results
Skip to Content
Enlarge TextClick to print16 16 2611 Sign In

Search Results between 2009-01-01 and 2009-12-31

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

Found 55 Articles: showing 1 to 25
< 1 2 3 >
Title Summary Date
Respect There is something I would like to share with you, - it…
Whither the Weather.... Well, it's been a drizzly and cool Spring up here in Winnipe…
Txt Cmmndmnts The 10 Commandments, in TXT Spk: #3: No OMGs BY Cliff KuangF…
Even the Pope is FB savvy! As part of the Vatican's World Communications Day, the organ…
A Great Friend has Moved On Booth College and the Salvation Army Ethics Centre said good…
40th Anniversary of the CANADI… Knowing their March 20, 1969 marriage would be a huge press …
God's Chisel Here is a beautiful video shared with me by a friend on Face…
Earl Robinson article Click here to view: http://www.mediafire.com/?xnbtnztjdi3&qu…
The New Urbanism There’s a movement afoot called ‘The New Urbanis…
I wonder if you wonder Yes, our current site is always oddly formatted - yes, I rea…
To the Struggle Against World …   The artist, Zurab Tsereteli, w…
By My God I Leap Over Walls By my God I leap over walls (Psalm 18:29) A theological re…
A Grandmother's Tribe Set between a tiny village and the largest slum in Africa, c…
Hope and Beauty BUENOS AIRES, Argentina (CNN) -- It is the most popular phot…
Poverty and Corruption Poverty and Corruption By Colleen Marshall Originally publ…
(Untitled) Rodney Stark wrote a great book called The Rise of Christian…
Ethics and Pandemics   In the flurry of activity and worry around the new &…
Commuter Challenge 2009 Join us for the 10th anniversary of Commuter Challenge in Ma…
Starbucks Shared Planet Starbucks reports on their commitment to Ethical Sourcing, E…
The Slave Next Door
SEXTING?!?! Sexting and Our Moral Future Posted By editor On April 20…
Street Folk of Old? We were reminded of a delightful old song this week.  T…
Vote for Hannah! Hi everyone! Canadian Living Magazine & Free the Childr…
The Good Chocolate Guide THE STOP THE TRAFFIK GOOD CHOCOLATE GUIDE TO CANADA  …
Earth Keeping We missed Earth Hour here in the EC - did you know about Ear…