http://kb.ds-alliance.com/?a=home&kb=wtDatabase error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE kll.kll_crp_id <> 433 AND scl.scl_id NOT IN (2, 3, 11)) x1 ON (x1.' at line 21
SQL: SELECT c.date, y1.losses, y2.kills FROM kb3_calendar c LEFT JOIN (SELECT c.date, COUNT(kll.kll_id) AS 'losses' FROM kb3_kills kll INNER JOIN kb3_ships shp ON (shp.shp_id = kll.kll_ship_id) INNER JOIN kb3_ship_classes scl ON (scl.scl_id = shp.shp_class) INNER JOIN kb3_calendar c ON c.date = kll.date_kill WHERE kll.kll_crp_id = 433 AND scl.scl_id NOT IN (2, 3, 11) AND c.date > '2010-08-27' AND c.date <= '2010-09-21' GROUP BY c.date) y1 ON c.`date` = y1.date LEFT JOIN (SELECT c.date, COUNT(kll.kll_id) AS 'kills' FROM kb3_kills kll INNER JOIN kb3_inv_all ina ON (ina.ina_all_id = 269 AND kll.kll_id = ina.ina_kll_id AND ina.ina_all_id != kll.kll_all_id) INNER JOIN kb3_ships shp ON (shp.shp_id = kll.kll_ship_id) INNER JOIN kb3_ship_classes scl ON (scl.scl_id = shp.shp_class) INNER JOIN kb3_calendar c ON c.`date` = kll.date_kill INNER JOIN kb3_inv_crp inc ON (inc.inc_crp_id = 433 AND kll.kll_id = inc.inc_kll_id AND inc.inc_crp_id != kll.kll_crp_id) INNER JOIN WHERE kll.kll_crp_id <> 433 AND scl.scl_id NOT IN (2, 3, 11)) x1 ON (x1.date_kill = c.`date`) WHERE c.date > '2010-08-27' AND c.date <= '2010-09-21' GROUP BY c.date) y2 ON c.`date` = y2.date WHERE c.date > '2010-08-27' AND c.date <= '2010-09-21'
Stack backtrace:
QueryResultCheck in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.db_mysqli.php 269
execute in ?
call_user_func_array in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.db_mysqli.php 82
__call in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.killgraph.php 176
execute in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.killgraph.php 176
update in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.killgraph.php 20
prepare in ?
call_user_func in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.cache.php 338
fetchCached in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.killgraph.php 30
generate in /var/www/kb.ds-alliance.com/htdocs/common/home.php 120
killgraph in ?
call_user_func in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.pageAssembly.php 59
call in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.pageAssembly.php 28
assemble in /var/www/kb.ds-alliance.com/htdocs/common/includes/class.pageAssembly.php 148
generate in /var/www/kb.ds-alliance.com/htdocs/common/home.php 212
include in /var/www/kb.ds-alliance.com/htdocs/common/index.php 167
include in /var/www/kb.ds-alliance.com/htdocs/index.php 15