Database error: Column 'kll_id' in SELECT is ambiguous<br />SQL: REPLACE INTO kb3_sum_alliance (asm_all_id, asm_shp_id, asm_kill_count, asm_kill_isk, asm_loss_count, asm_loss_isk)
		SELECT 3189, losses.asm_shp_id, ifnull(kills.knb,0), ifnull(kills.kisk,0), ifnull(losses.lnb,0), ifnull(losses.lisk,0)
		FROM (SELECT shp_class as asm_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_all_id = 3189
					AND EXISTS (SELECT 1
							FROM kb3_inv_all
							WHERE kll.kll_id = ina_kll_id
							AND ina_all_id <> 3189 limit 0,1)
			GROUP BY shp_class) losses left join (SELECT 3189 as asm_all_id, shp_class as asm_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_all ina ON (ina.ina_kll_id = kll.kll_id)
			WHERE ina.ina_all_id = 3189
				AND kll.kll_all_id <> 3189
			GROUP BY shp_class) kills ON (kills.asm_shp_id = losses.asm_shp_id)
		UNION
		SELECT 3189, kills.asm_shp_id, ifnull(kills.knb,0), ifnull(kills.kisk,0), ifnull(losses.lnb,0), ifnull(losses.lisk,0)
		FROM (SELECT shp_class as asm_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_all_id = 3189
					AND EXISTS (SELECT 1
							FROM kb3_inv_all
							WHERE kll.kll_id = ina_kll_id
							AND ina_all_id <> 3189 limit 0,1)
			GROUP BY shp_class) losses right join (SELECT 3189 as asm_all_id, shp_class as asm_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_all ina ON (ina.ina_kll_id = kll.kll_id)
			WHERE ina.ina_all_id = 3189
				AND kll.kll_all_id <> 3189
			GROUP BY shp_class) kills on (kills.asm_shp_id = losses.asm_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.alliancesummary.php, line: 129, class: DBNormalQuery, function: execute<br />
File: /var/www/html/common/includes/class.alliancesummary.php, line: 46, class: allianceSummary, function: buildSummary<br />
File: /var/www/html/common/includes/class.statsummary.php, line: 28, class: allianceSummary, function: execute<br />
File: /var/www/html/common/includes/class.killsummarytable.php, line: 272, 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/alliance_detail.php, line: 212, 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/alliance_detail.php, line: 1022, 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 />