"Ну и запросы у вас" - сказала база данных и повисла. (ц)
На самом деле, она не повисла, тьфу-тьфу.
И запрос работает. Но блин...
Многабукаф.SELECT otd_name1,sotr_fio,dolg_name
FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
LEFT JOIN `otdel` ON operation.otd_id = otdel.otd_id
LEFT JOIN `dolgnost` ON operation.dolg_id = dolgnost.dolg_id
LEFT JOIN `name_operation` ON operation.id_name_oper = name_operation.id_name_oper
WHERE operation.sotr_id NOT IN (SELECT operation.sotr_id
FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
LEFT JOIN `name_operation` ON operation.id_name_oper = name_operation.id_name_oper
WHERE operation.id_name_oper =3) AND operation.oper_id NOT IN (SELECT oper_id FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
WHERE operation.sotr_id IN (SELECT operation.sotr_id FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
WHERE operation.sotr_id NOT IN (SELECT operation.sotr_id
FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
LEFT JOIN `name_operation` ON operation.id_name_oper = name_operation.id_name_oper
WHERE operation.id_name_oper =3)
GROUP BY operation.sotr_id HAVING COUNT(*) > 1) AND oper_data NOT IN (SELECT MAX(oper_data) AS oper_data FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
WHERE operation.sotr_id IN (SELECT operation.sotr_id FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
WHERE operation.sotr_id IN (SELECT operation.sotr_id FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
WHERE operation.sotr_id NOT IN (SELECT operation.sotr_id
FROM `operation`
LEFT JOIN `sotrudnik` ON operation.sotr_id = sotrudnik.sotr_id
LEFT JOIN `name_operation` ON operation.id_name_oper = name_operation.id_name_oper
WHERE operation.id_name_oper =3)
GROUP BY operation.sotr_id HAVING COUNT(*) > 1))
GROUP BY sotr_fio))О, да, хорошо быть программистом.
