Database error: Column 'kll_id' in SELECT is ambiguous<br />SQL: REPLACE INTO kb3_sum_corp (csm_crp_id, csm_shp_id, csm_kill_count, csm_kill_isk, csm_loss_count, csm_loss_isk)
		SELECT losses.csm_crp_id, losses.csm_shp_id, ifnull(kills.knb,0), ifnull(kills.kisk,0), ifnull(losses.lnb,0), ifnull(losses.lisk,0)
		FROM (SELECT 44701 as csm_crp_id, shp_class as csm_shp_id, 0 as knb,0 as kisk ,count(kll_id) AS lnb, sum(av.archive_isk) AS lisk
			FROM kb3_kills kll
				INNER JOIN kb3_ships shp ON ( shp.shp_id = kll.kll_ship_id )
                            INNER JOIN kb3_archive_kill_values av
                                    ON (av.kll_id = kll.kll_id
                                        AND av.valuation_source <> 'duplicate_excluded')
			WHERE  kll.kll_crp_id = 44701
					AND EXISTS (SELECT 1
							FROM kb3_inv_crp
							WHERE kll.kll_id = inc_kll_id
							AND inc_crp_id <> 44701 limit 0,1)
			GROUP BY shp_class) losses left join (SELECT 44701 as csm_crp_id, shp_class as csm_shp_id, COUNT(kll.kll_id) AS knb,
				sum(av.archive_isk) AS kisk,0 as lnb,0 as lisk
			FROM kb3_kills kll
				INNER JOIN kb3_ships shp ON ( shp.shp_id = kll.kll_ship_id )
                            INNER JOIN kb3_archive_kill_values av
                                    ON (av.kll_id = kll.kll_id
                                        AND av.valuation_source <> 'duplicate_excluded')
				INNER JOIN kb3_inv_crp ina ON (ina.inc_kll_id = kll.kll_id)
			WHERE ina.inc_crp_id = 44701
				AND kll.kll_crp_id <> 44701
			GROUP BY shp_class) kills ON (kills.csm_shp_id = losses.csm_shp_id)
		UNION
		SELECT kills.csm_crp_id, kills.csm_shp_id, ifnull(kills.knb,0), ifnull(kills.kisk,0), ifnull(losses.lnb,0), ifnull(losses.lisk,0)
		FROM (SELECT 44701 as csm_crp_id, shp_class as csm_shp_id, 0 as knb,0 as kisk ,count(kll_id) AS lnb, sum(av.archive_isk) AS lisk
			FROM kb3_kills kll
				INNER JOIN kb3_ships shp ON ( shp.shp_id = kll.kll_ship_id )
                            INNER JOIN kb3_archive_kill_values av
                                    ON (av.kll_id = kll.kll_id
                                        AND av.valuation_source <> 'duplicate_excluded')
			WHERE  kll.kll_crp_id = 44701
					AND EXISTS (SELECT 1
							FROM kb3_inv_crp
							WHERE kll.kll_id = inc_kll_id
							AND inc_crp_id <> 44701 limit 0,1)
			GROUP BY shp_class) losses right join (SELECT 44701 as csm_crp_id, shp_class as csm_shp_id, COUNT(kll.kll_id) AS knb,
				sum(av.archive_isk) AS kisk,0 as lnb,0 as lisk
			FROM kb3_kills kll
				INNER JOIN kb3_ships shp ON ( shp.shp_id = kll.kll_ship_id )
                            INNER JOIN kb3_archive_kill_values av
                                    ON (av.kll_id = kll.kll_id
                                        AND av.valuation_source <> 'duplicate_excluded')
				INNER JOIN kb3_inv_crp ina ON (ina.inc_kll_id = kll.kll_id)
			WHERE ina.inc_crp_id = 44701
				AND kll.kll_crp_id <> 44701
			GROUP BY shp_class) kills ON (kills.csm_shp_id = losses.csm_shp_id) <br /><b>ERROR</b> [256] SQL error (Column 'kll_id' in SELECT is ambiguous<br />
Error on line 46 in file /var/www/html/common/includes/class.dbnormalquery.php<br />
PHP 5.6.40 (Linux), EDK 4.2.21.0 (YC-118-3 1.0)<br />
File: /var/www/html/common/includes/class.dbnormalquery.php, line: 46, function: trigger_error<br />
File: /var/www/html/common/includes/class.corpsummary.php, line: 127, class: DBNormalQuery, function: execute<br />
File: /var/www/html/common/includes/class.corpsummary.php, line: 45, class: corpSummary, function: buildSummary<br />
File: /var/www/html/common/includes/class.statsummary.php, line: 28, class: corpSummary, function: execute<br />
File: /var/www/html/common/includes/class.killsummarytable.php, line: 290, class: statSummary, function: getSummary<br />
File: /var/www/html/common/includes/class.killsummarytable.php, line: 602, class: KillSummaryTable, function: getkills<br />
File: /var/www/html/common/corp_detail.php, line: 233, class: KillSummaryTable, function: generate<br />
File: /var/www/html/common/includes/class.pageassembly.php, line: 70, function: call_user_func_array<br />
File: /var/www/html/common/includes/class.pageassembly.php, line: 37, class: pageAssembly, function: call<br />
File: /var/www/html/common/corp_detail.php, line: 898, class: pageAssembly, function: assemble<br />
File: /var/www/html/common/index.php, line: 323, function: include<br />
File: /var/www/html/index.php, line: 25, function: include<br />
<br />