DELETE t1
FROM kvartiri t1
JOIN kvartiri t2 ON t1.yaid = t2.yaid
AND t1.url_id < t2.url_id
WHERE `t1`.`yaid` = 2287072SELECT yaid FROM `kvartiri` GROUP BY yaid
DELETE
FROM kvartiri
WHERE
url_id = (SELECT MIN(url_id) FROM kvartiri WHERE `yaid` = 1947831 )

ls -vplaer $(ls -v /home/video )
файл нет