Does mysql use the ansi sql intersect?
No. MySQL does not support any kind of subquery functions except UNION in MySQL 4.0
use PostgreSQL instead.