/* the original table */
 create table product_to_resources (
   pr_id int autoincrement; /* primary key */
   prod_id int;
   resource_id int;
   date_added datetime;
 );
 
 /* the temporary table */
 create table TMP_product_to_resources (
   pr_id int autoincrement;
   prod_id int;
   resource_id int;
   date_added datetime;
 );
 
 /* get only unique rows */
 delete from TMP_product_to_resources;
 
 insert into TMP_product_to_resources
 (prod_id, resource_id, date_added)
 select distinct prod_id, resource_id, date_added
 from product_to_resources;
 
 /* now disable your triggers, constraints.. */
 
 delete from product_to_resources;
 
 /* insert them back */
 insert into product_to_resources
 (prod_id, resource_id, date_added)
 select distinct prod_id, resource_id, date_added
 from TMP_product_to_resources;
 
 /* now enable your triggers, constraints again. Done. */