Untitled

SELECT
        COUNT(mv.member_vehicle_id),
        mv.*,
        m.user_name,
        m.last_page_load_date
FROM
        member_vehicle mv
INNER JOIN
        member m
        ON
                m.member_id = mv.member_id
INNER JOIN
        car_combat cc
        ON
                mv.member_vehicle_id IN (cc.challenger_vehicle_id OR cc.defender_vehicle_id)
WHERE
        mv.active = "true"
        AND
        mv.manufacturer = "Acura"
        AND
        mv.member_vehicle_id IN
GROUP BY
        mv.member_vehicle_id