Location of pictures (thickbox)

[ph0enix993]

I have a SQL query which selects data from products and writes them in XML file. But the problem I have is with writing image location path. 

 

Sample location:

 http://www.website.com/2520-thickbox_default/computer-lenovo-thinkcentre-m93p-sff.jpg

 

Numbers before thickbox text seems to be generated randomly and I can't use something like this:

replace(concat('http://', ifnull(conf.value,'domain/'),'/',*random numbers*, '-' 'thickbox_default', '/', pl.name, '.html'),' ','-') AS 'image_link',

What are those numbers? The product ID and that number are not the same so I don't know how to generate them with SQL query. Anyone knows where those numbers come from?

[hakeryk2]

It means that this photo is stored in your server at your-domain/img/p/2/5/2/0 folder.

Edited June 20, 2016 by hakeryk2 (see edit history)

[ph0enix993]

Ah, thank you. So I just have to get basic image path and modify text to fit my url format.