Consulta SQL

[Libras]

este...pues haces un update a tu tabla

algo asi:

Código MySQL:

update virtuemart_product_medias
set ordering=t1.ordering
from
(
SELECT l.virtuemart_product_id, l.virtuemart_media_id, COUNT( * ) AS ordering
FROM `virtuemart_product_medias` AS l
LEFT OUTER JOIN `virtuemart_product_medias` AS r ON l.virtuemart_product_id = r.virtuemart_product_id
AND l.virtuemart_media_id >= r.virtuemart_media_id
GROUP BY l.virtuemart_product_id, l.virtuemart_media_id
) as t1 where virtuemart_product_medias.id=t1.id