CREATE TABLE `temp_phone_duplicate` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)

SELECT COUNT(*), * FROM log_session_<mid>_<yyyyMM> WHERE source_id=<sourceId>
GROUP BY source_id, hour, cid, item_id, session_start, session_time, from_number
HAVING COUNT(*)>1

INSERT INTO temp_phone_duplicate
(
SELECT MAX(id) FROM log_session_<mid>_<yyyyMM> WHERE source_id=<sourceId>
GROUP BY source_id, hour, cid, item_id, session_start, session_time, from_number
HAVING COUNT(*)>1
)

SELECT COUNT(*) FROM temp_phone_duplicate

DELETE FROM log_session_<mid>_<yyyyMM> WHERE id IN ( SELECT id FROM temp_phone_duplicate )