<?

include "db.class.php";

$db = new db();

$db->query("SELECT  *
FROM fuel_movement fm
JOIN (
    SELECT 
        MIN(record_id) AS keep_id,
        tank_id, amount, status, date_time_opened, date_time_closed,
        user_id, flow_rate, pulses, client_id,
        company_id, fuel_price, cash_type
    FROM fuel_movement
    GROUP BY 
        tank_id, amount, status, date_time_opened, date_time_closed,
        user_id, flow_rate, pulses, client_id, 
        company_id, fuel_price, cash_type
    HAVING COUNT(*) > 1
) dup 
    ON fm.tank_id = dup.tank_id
    AND fm.amount = dup.amount
    AND fm.status = dup.status
    AND fm.date_time_opened = dup.date_time_opened
    AND fm.date_time_closed = dup.date_time_closed
    AND fm.user_id = dup.user_id
    AND fm.flow_rate = dup.flow_rate
    AND fm.pulses = dup.pulses
    AND fm.client_id = dup.client_id
    AND fm.company_id = dup.company_id
    AND fm.fuel_price = dup.fuel_price
    AND fm.cash_type = dup.cash_type
WHERE fm.record_id <> dup.keep_id AND fm.status = 'RFID';");