SELECT ss_log.timestamp AS ss_logtimestamp, ss_log.id AS ss_logid, SUM(ss_fdffiv.field_farm_inventory_value_numerator / ss_fdffiv.field_farm_inventory_value_denominator) AS inventory 
FROM log AS ss_log 
INNER JOIN field_data_field_farm_inventory AS ss_fdffi 
ON ss_fdffi.entity_type = 'log' AND ss_fdffi.entity_id = ss_log.id AND ss_fdffi.deleted = 0 

INNER JOIN field_data_field_farm_inventory_asset AS ss_fdffia 
ON ss_fdffia.entity_id = ss_fdffi.field_farm_inventory_value AND ss_fdffia.deleted = 0
 
INNER JOIN field_data_field_farm_inventory_value AS ss_fdffiv 
ON ss_fdffiv.entity_id = ss_fdffi.field_farm_inventory_value AND ss_fdffiv.deleted = 0 
WHERE (ss_log.timestamp <= 1558788724) AND (ss_log.done = 1) AND (ss_fdffia.field_farm_inventory_asset_target_id = 3) 
ORDER BY ss_log.timestamp 
DESC, ss_log.id DESC LIMIT 1 OFFSET 0;
This is the offending SQL query, but I've not poked around in it enough to see where it is tripping up