Need someone with SQL queries experience

[animuz1]

Hi,

 

I have created my shop a while ago and its all finished by now. I have about 1000 products with an unique EAN numer.

I made combinations with color, but during the combination process, something went wrong and some products with combinations have a different EAN code than the main product. This happened when I copied an existing product, edited the images, EAN etc, but forgot to edit the EAN in the combinations page.

 

What I need is a SQL query that exports the product name, EAN code and the EAN code in the combinations tab.

 

Without this query would mean that i have to manually check every product, wich would take me many many hours to accomplish.

 

Hope someone can help me.

 

Regards, Peter