Database error: Invalid SQL: SELECT name, filename FROM neoseeker.j_cpucoolers jc, neoseeker.entities e WHERE e.pid = jc.productid AND e.type='Hardware' AND FIND_IN_SET('WaterBased',jc.casing)>0 AND e.lastresource > DATE_SUB(NOW(), INTERVAL 240 DAY) AND type='Socket 478,Socket 754,Socket 939,Socket 940' ORDER BY name
MySQL Error: 1052 (Column 'type' in where clause is ambiguous)
Session halted.