Help writing an SQL query (where can I find the URL's)

[noesac]

I'm trying to write a query to extract the URL's for each of my products and the main images of each product.

However I can't seem to figure out where this data is kept in the DB. Does anyone know where I can find this?

[Martin Velikov]

I am afraid you cannot achieve that with a MySQL query. The info that you have in the database is the product IDs and the images IDs - you will have to map those with the actual products you have on your web site. You have those stored in the ps_image table (the ps_ prefix might vary depending on your prestashop installation).

[noesac]

hum that's disappointing, but thanks anyway. Looks like i'll have to do this manually:(

[muktadir]

or you can write a module for that! If you cannot, you can hire me at [email protected]

[noesac]

Thanks muktadir but I'll pass for now.

I figured out a compromise. I wrote an SQL script that gives me like 6 of the 8 fields that I need (i'm creating a data feed) so I only need to obtain the last 2 (the URL's) manually, which isn't too bad. Only takes me like 2 minutes if I keep the spreadsheet updated as I go.

[muktadir]

I am still thinking of such a module. It would be good because it would help people to advertise their products ...it will be a little one